D.4.51 Changes in release 3.23.9

• Fixed problem that affected queries that did arithmetic on group functions.
• Fixed problem with timestamps and INSERT DELAYED.
• Fixed that date_col BETWEEN const_date AND const_date works.
• Fixed problem when only changing a 0 to NULL in a table with BLOB/TEXT columns.
• Fixed bug in range optimiser when using many key parts and or on the middle key parts: WHERE K1=1 and K3=2 and (K2=2 and K4=4 or K2=3 and K4=5)
• Added source command to mysql to allow reading of batch files inside the mysql client. Original patch by Matthew Vanecek.
• Fixed critical problem with the WITH GRANT OPTION option.
• Don't give an unnecessary GRANT error when using tables from many databases in the same query.
• Added VIO wrapper (needed for SSL support; by Andrei Errapart and Tõnu Samuel).
• Fixed optimiser problem on SELECT when using many overlapping indexes. MySQL should now be able to choose keys even better when there are many keys to choose from.
• Changed optimiser to prefer a range key instead of a ref key when the range key can uses more columns than the ref key (which only can use columns with =). For example, the following type of queries should now be faster: SELECT * from key_part_1=const and key_part_2 > const2
• Fixed bug that a change of all VARCHAR columns to CHAR columns didn't change row type from dynamic to fixed.
• Disabled floating-point exceptions for FreeBSD to fix core dump when doing SELECT FLOOR(POW(2,63)).
• Renamed mysqld startup option from --delay-key-write to --delay-key-write-for-all-tables.
• Added read-next-on-key to HEAP tables. This should fix all problems with HEAP tables when using non-UNIQUE keys.
• Added option to print default arguments to all clients.
• Added --log-slow-queries option to mysqld to log all queries that take a long time to a separate log file with a time indicating how long the query took.
• Fixed core dump when doing WHERE key_col=RAND(...).
• Fixed optimisation bug in SELECT ... LEFT JOIN ... key_col IS NULL, when key_col could contain NULL values.
• Fixed problem with 8-bit characters as separators in LOAD DATA INFILE.

User Comments

Add your own comment.