D.4.19 Changes in release 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_timeout for replication.
• Fixed problem with UPDATE and BDB tables.
• Fixed hard bug in BDB tables when using key parts.
• Fixed problem when using GRANT FILE ON database.* ...; previously we added the DROP privilege for the database.
• Fixed DELETE FROM tbl_name ... LIMIT 0 and UPDATE FROM tbl_name ... LIMIT 0, which acted as though the LIMIT clause was not present (they deleted or updated all selected rows).
• CHECK TABLE now checks if an AUTO_INCREMENT column contains the value 0.
• Sending a SIGHUP to mysqld will now only flush the logs, not reset the replication.
• Fixed parser to allow floats of type 1.0e1 (no sign after e).
• Option --force to myisamchk now also updates states.
• Added option --warnings to mysqld. Now mysqld prints the error Aborted connection only if this option is used.
• Fixed problem with SHOW CREATE TABLE when you didn't have a PRIMARY KEY.
• Properly fixed the rename of innodb_unix_file_flush_method variable to innodb_flush_method.
• Fixed bug when converting BIGINT UNSIGNED to DOUBLE. This caused a problem when doing comparisons with BIGINT values outside of the signed range.
• Fixed bug in BDB tables when querying empty tables.
• Fixed a bug when using COUNT(DISTINCT) with LEFT JOIN and there weren't any matching rows.
• Removed all documentation referring to the GEMINI table type. GEMINI is not released under an Open Source license.

User Comments

Add your own comment.