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 optimizer 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 optimizer 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 optimizer 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 optimization 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.
This is a translation of the MySQL Reference Manual that can be found at dev.mysql.com. The original Reference Manual is in English, and this translation is not necessarily as up to date as the English version.
