D.4.46 Changes in release 3.23.14

• Added mysql_real_escape_string() function to the MySQL C API.
• Fixed a bug in CONCAT() where one of the arguments was a function that returned a modified argument.
• Fixed a critical bug in myisamchk, where it updated the header in the index file when one only checked the table. This confused the mysqld daemon if it updated the same table at the same time. Now the status in the index file is only updated if one uses --update-state. With older myisamchk versions you should use --read-only when only checking tables, if there is the slightest chance that the mysqld server is working on the table at the same time!
• Fixed that DROP TABLE is logged in the update log.
• Fixed problem when searching on DECIMAL() key field where the column data contained leading zeros.
• Fix bug in myisamchk when the AUTO_INCREMENT column isn't the first key.
• Allow DATETIME in ISO8601 format: 2000-03-12T12:00:00
• Dynamic character sets. A mysqld binary can now handle many different character sets (you can choose which when starting mysqld).
• Added command REPAIR TABLE.
• Added mysql_thread_safe() function to the MySQL C API.
• Added the UMASK_DIR environment variable.
• Added CONNECTION_ID() function to return the client connection thread ID.
• When using = on BLOB or VARCHAR BINARY keys, where only a part of the column was indexed, the whole column of the result row wasn't compared.
• Fix for sjis character set and ORDER BY.
• When running in ANSI mode, don't allow columns to be used that aren't in the GROUP BY part.

User Comments

Add your own comment.