MySQL 8.0.2 DMR release, add SQL window function

Develop

MySQL development team announced 8.0.2 development milestone version (DMR) release, has been downloaded from dev.mysql.com. The source code is available on GitHub.

Change log

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

More info, visit here.

Leave a Reply

Your email address will not be published. Required fields are marked *