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

更多内容可查看发行说明

Source: 

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