Alterações na distribuição 3.23.40
Fixed problem with --low-priority-updates and INSERT statements.
- Fixed bug in slave thread when under some rare circumstances it could get 22 bytes ahead on the offset in the master.
- Added
slave_net_timeoutfor replication. - Fixed problem with
UPDATEandBDBtables. - Fixed hard bug in
BDBtables when using key parts. - Fixed problem when using
GRANT FILE ON database.* ...; previously we added theDROPprivilege for the database. - Fixed
DELETE FROM tbl_name ... LIMIT 0andUPDATE FROM tbl_name ... LIMIT 0, which acted as though theLIMITclause was not present (they deleted or updated all selected rows). CHECK TABLEnow checks if anAUTO_INCREMENTcolumn contains the value 0.- Sending a
SIGHUPtomysqldwill now only flush the logs, not reset the replication. - Fixed parser to allow floats of type
1.0e1(no sign aftere). - Option
--forcetomyisamchknow also updates states. - Added option
--warningstomysqld. Nowmysqldprints the errorAborted connectiononly if this option is used. - Fixed problem with
SHOW CREATE TABLEwhen you didn't have aPRIMARY KEY. - Properly fixed the rename of
innodb_unix_file_flush_methodvariable toinnodb_flush_method. - Fixed bug when converting
BIGINT UNSIGNEDtoDOUBLE. This caused a problem when doing comparisons withBIGINTvalues outside of the signed range. - Fixed bug in
BDBtables when querying empty tables. - Fixed a bug when using
COUNT(DISTINCT)withLEFT JOINand there weren't any matching rows. - Removed all documentation referring to the
GEMINItable type.GEMINIis not released under anOpen Sourcelicense.