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) 更多内容可查看发行说明 MySQL 8.0.2 DMR 发布,添加 SQL window 函数下载地址