MySQL 8.0.2 DMR发布，添加SQL window函数

MySQL 开发团队宣布 8.0.2 开发里程碑版本（DMR）发布，已可从 dev.mysql.com 下载。源代码可在GitHub 获得。

以下是亮点：

SQL Window Functions

• Add first batch of SQL window functions (WL#9236) 

• Add remaining non-aggregate window functions (WL#9603)
  

• Additional aggregate window functions (WL#9727)
  

JSON

• Ranges in JSON path expressions (WL#9831) 
  

• Add JSON_STORAGE_SIZE / JSON_STORAGE_FREE functions (WL#9192)
  

• Support for partial update of JSON in the optimizer (WL#8963) 
  

• Provide logical diffs for partial update of JSON values (WL#10570) 
  

GIS

• Ellipsoidal relational operations and R-tree support functions (WL#8685) 

Character Sets

• Add Japanese kana sensitive collation to utf8mb4 (WL#10480) 

• Add utf8mb4 accent sensitive and case insensitive collation (WL#10818) 
  

• Varlen keys for sorting multibyte String values (WL#9554) 
  

• Use utf8mb4 in libmysql and command tools (WL#10353) 
  

• Change MTR tests to run with new default charset (WL#10297, WL#10300, WL#10418, WL#10319, WL#10298, WL#10296) 
  

更多内容可查看发行说明