Fixed core dump with empty BLOB/TEXT
column argument to REVERSE()
.
Extended /*! */
with version numbers.
Changed SUBSTRING(text FROM pos)
to
conform to SQL-99. (Before this construct returned the
rightmost 'pos' characters.)
Fixed problem with LOCK TABLES
combined
with DELETE FROM table
Fixed problem that INSERT ... SELECT
didn't use BIG_TABLES
.
SET SQL_LOW_PRIORITY_UPDATES=#
didn't
work.
Password wasn't updated correctly if privileges didn't
change on: GRANT ... IDENTIFIED BY
Fixed range optimiser bug in SELECT * FROM
table_name WHERE key_part1 >= const AND (key_part2 =
const OR key_part2 = const)
.
Fixed bug in compression key handling in
ISAM
.
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.