MySQL 8.0.24 and 5.7.34 released
Today, Oracle released MySQL 8.0.24 (see release notes) and 5.7.34 (see release notes) maintenance releases. You could find more about the changes and improvements in official announcement. The interesting new features for developers in the server are:
- Transform correlated scalar subqueries (e.g.
SELECT * FROM t1 WHERE (SELECT a FROM t2 WHERE t2.a=t1.a) > 0can be rewritten as
SELECT t1.* FROM t1 LEFT OUTER JOIN (SELECT a, COUNT(*) AS ct FROM t2 GROUP BY a) AS derived ON t1.a = derived.a WHERE derived.a > 0);
- new functions ST_Collect(), ST_LineInterpolatePoint(linestring, fractional_distance), ST_LineInterpolatePoints(linestring, fractional_distance) and ST_PointAtDistance(linestring, distance);
- cast between geometry types with the CAST() and CONVERT() functions, which are extended to support casting geometry values from one spatial type to another (see more in Cast Functions and Operators chapter of the manual).
In MySQL 8.0.24 release the compilation problem I reported (see bug 102308) was fixed. Thanks to Tor Didriksen! There is also fix for MySQL Workbench 8.0.23 start failure on macOS (see release notes for 8.0.24), which I reported (see bug 102364) along with many others (see bugs 102284 and 102286 and their duplicates), but the resolution was unnecessarily delayed until the next release cycle, because you know all products need to have the same version...