Fixed a bug when using MATCH()
in
HAVING
clause.
Fixed a bug when using HEAP
tables with
LIKE
.
Added --mysql-version
option to
safe_mysqld
Changed INNOBASE
to
InnoDB
(because the
INNOBASE
name was already used). All
configure
options and
mysqld
start options now use
innodb
instead of
innobase
. This means that before
upgrading to this version, you have to change any
configuration files where you have used
innobase
options!
Fixed bug when using indexes on CHAR(255)
NULL
columns.
Slave thread will now be started even if
master-host
is not set, as long as
server-id
is set and valid
master.info
is present.
Partial updates (terminated with kill) are now logged with a
special error code to the binary log. Slave will refuse to
execute them if the error code indicates the update was
terminated abnormally, and will have to be recovered with
SET SQL_SLAVE_SKIP_COUNTER=1; SLAVE START
after a manual sanity check/correction of data integrity.
Fixed bug that erroneously logged a drop of internal temporary table on thread termination to the binary log --- this bug affected replication.
Fixed a bug in REGEXP
on 64-bit machines.
UPDATE
and DELETE
with
WHERE unique_key_part IS NULL
didn't
update/delete all rows.
Disabled INSERT DELAYED
for tables that
support transactions.
Fixed bug when using date functions on
TEXT
/BLOB
column with
wrong date format.
UDFs now also work on Windows. (Patch by Ralph Mason.)
Fixed bug in ALTER TABLE
and
LOAD DATA INFILE
that disabled
key-sorting. These commands should now be faster in most
cases.
Fixed performance bug where reopened tables (tables that had
been waiting for FLUSH
or
REPAIR
) would not use indexes for the
next query.
Fixed problem with ALTER TABLE
to
InnoDB
tables on FreeBSD.
Added mysqld
variables
myisam_max_sort_file_size
and
myisam_max_extra_sort_file_size
.
Initialise signals early to avoid problem with signals in
InnoDB
.
Applied patch for the tis620
character
set to make comparisons case-independent and to fix a bug in
LIKE
for this character set.
Note: All tables that uses
the tis620
character set must be fixed
with myisamchk -r
or REPAIR
TABLE
!
Added --skip-safemalloc
option to
mysqld
.
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.