Alterações na distribuição 3.23.17
Fixed a bug in FIND_IN_SET() when the first argument was NULL.
- Added table locks to Berkeley DB.
- Fixed a bug with
LEFT JOINandORDER BYwhere the first table had only one matching row. - Added 4 sample
my.cnfexample files in thesupport-filesdirectory. - Fixed
duplicated keyproblem when doing bigGROUP BYoperations. (This bug was probably introduced in 3.23.15.) - Changed syntax for
INNER JOINto match SQL-99. - Added
NATURAL JOINsyntax. - A lot of fixes in the
BDBinterface. - Added handling of
--no-defaultsand--defaults-filetosafe_mysqld.shandmysql_install_db.sh. - Fixed bug in reading compressed tables with many threads.
- Fixed that
USE INDEXworks withPRIMARYkeys. - Added
BEGINstatement to start a transaction inAUTOCOMMITmode. - Added support for symbolic links for Windows.
- Changed protocol to let client know if the server is in
AUTOCOMMITmode and if there is a pending transaction. If there is a pending transaction, the client library will give an error before reconnecting to the server to let the client know that the server did a rollback. The protocol is still backward-compatible with old clients. KILLnow works on a thread that is locked on a 'write' to a dead client.- Fixed memory leak in the replication slave thread.
- Added new
log-slave-updatesoption tomysqld, to allow daisy-chaining the slaves. - Fixed compile error on FreeBSD and other systems where
pthread_tis not the same asint. - Fixed master shutdown aborting the slave thread.
- Fixed a race condition in
INSERT DELAYEDcode when doingALTER TABLE. - Added deadlock detection sanity checks to
INSERT DELAYED.