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 …
Showing entries 1 to 1
Apr
27
2020
Showing entries 1 to 1