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.