Alterações na distribuição 3.22.2
Searching on multiple constant keys that matched more than 30% of the rows didn't always use the best possible key.
- New functions
<<,>>,RPAD()andLPAD(). - You can now save default options (like passwords) in a configuration file (
my.cnf). - Lots of small changes to get
ORDER BYto work when no records are found when using fields that are not inGROUP BY(MySQL extension). - Added
--chrootoption tomysqld, to startmysqldin a chroot environment (by Nikki Chumakov<nikkic@cityline.ru>). - Trailing spaces are now ignored when comparing case-sensitive strings; this should fix some problems with ODBC and flag 512!
- Fixed a core dump bug in the range optimiser.
- Added
--one-threadoption tomysqld, for debugging with LinuxThreads (orglibc). (This replaces the-T32flag) - Added
DROP TABLE IF EXISTSto prevent an error from occurring if the table doesn't exist. IFandEXISTSare now reserved words (they would have to be sooner or later).- Added lots of new options to
mysqldump. - Server error messages are now in
mysqld_error.h. - The server/client protocol now supports compression.
- All bug fixes from MariaDB Version 3.21.32.