MySQL 8.0.20 was released April 27th. So what is new? The
details are in the release notes and I would like to point out a
few of the more interesting things, at least to me.
New SHOW_ROUTINE privilege Previously those using routines
had to had the SELECT privilege which in many cases was overly
broad. So for better granularity and control of resources.
Better JSON_TABLETo bring JSON_TABLE into compliance with the
specification, ON EMPTY must now come before ON ERROR where in
previous versions you could the two clauses in any way you
wanted.
Hash JoinsHash joins are now available as Inner non-equi-joins,
Semijoins, Antijoins, Left outer joins, and
Right outer joins.
Double Buffer ImprovementThe InnoDB storage engine area for the
doublewrite buffer was moved from the system …
Community journal
Follow the feed
The latest from the MySQL community
Ideas, releases, practical guides, and perspectives from the people building with MySQL.
Showing entries 1 to 1 of 1
« Previous |
Next »
Apr
27
2020