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 BY
to work when no records are found when using fields that are not inGROUP BY
(MySQL extension). - Added
--chroot
option tomysqld
, to startmysqld
in 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-thread
option tomysqld
, for debugging with LinuxThreads (orglibc
). (This replaces the-T32
flag) - Added
DROP TABLE IF EXISTS
to prevent an error from occurring if the table doesn't exist. IF
andEXISTS
are 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.