New SHOW_ROUTINE privilegePreviously 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.