Functionality Added or Changed
Security Fix; Important Change; Partitioning:
It was possible, by creating a partitioned table using the
DATA DIRECTORY and
DIRECTORY options to gain privileges on other tables
having the same name as the partitioned table. As a result of
this fix, any table-level
DATA DIRECTORY or
INDEX DIRECTORY options are now ignored for
(Bug #32091, CVE-2007-5970)
References: See also Bug #29325, Bug #32111.
In MySQL 5.1.6, when log tables were implemented, the default
log destination for the general query and slow query log was
TABLE. This default has been changed to
FILE, which is compatible with MySQL 5.0, but
incompatible with earlier releases of MySQL 5.1 from 5.1.6 to
5.1.20. If you are upgrading from MySQL 5.0 to 5.1.21 or higher,
no logging option changes should be necessary. However, if you
are upgrading from 5.1.6 through 5.1.20 to 5.1.21 or higher and
TABLE logging, use the
explicitly to preserve your server's table-logging behavior.
The MySQL 5.1.23 fix is in addition to a fix in 5.1.21 because it turned out that the default was set in two places, only one of which was fixed the first time. (Bug #29993)
The parser accepted statements that contained
*/ that were not properly closed with
*/, such as
SELECT 1 /* +
2. Statements that contain unclosed
/*-comments now are rejected with a syntax
This fix has the potential to cause incompatibilities. Because
of Bug #26302, which caused the trailing
to be truncated from comments in views, stored routines,
triggers, and events, it is possible that objects of those types
may have been stored with definitions that now will be rejected
as syntactically invalid. Such objects should be dropped and
re-created so that their definitions do not contain truncated
NDB error codes to MySQL
storage engine error codes has been improved.
MySQL Cluster: The following improvements have been made in the ndb_size.pl utility:
The script can now be used with multiple databases; lists of databases and tables can also be excluded from analysis.
Schema name information has been added to index table calculations.
The database name is now an optional parameter, the exclusion of which causes all databases to be examined.
If selecting from
fails, the script now attempts to fall back to
--real_table_name option has been added;
this designates a table to handle unique index size
The report title has been amended to cover cases where more than one database is being analyzed.
Support for a
--socket option was also added.
For more information, see ndb_size.pl — NDBCLUSTER Size Requirement Estimator. (Bug #28683, Bug #28253)
MySQL Cluster: The output from the cluster management client showing the progress of data node starts has been improved. (Bug #23354)
The output of the ndb_mgm client
now indicates when the cluster is in single user mode.
Partitioning: Error messages for partitioning syntax errors have been made more descriptive. (Bug #29368)
Replication of the following SQL functions now switches to
row-based logging in
MIXED mode, and
generates a warning in
See Mixed Binary Logging Format, for more information. (Bug #12092, Bug #28086, Bug #30244)
Server parser performance was improved for identifier lists, expression lists, and UDF expression lists. (Bug #30333)
Server parser performance was improved for expression parsing by lowering the number of state transitions and reductions needed. (Bug #30625)
MyISAM table is created with no
DATA DIRECTORY option, the
.MYD file is created in the database
directory. By default, if
MyISAM finds an
.MYD file in this case, it
overwrites it. The same applies to
files for tables created with no
DIRECTORY option. To suppress this behavior, start the
server with the new
option, in which case
MyISAM will not
overwrite existing files and returns an error instead.
Server parser performance was improved for boolean expressions. (Bug #30237)
SHOW COLUMNS now returns
NULL instead of the empty string for the
Default value of columns that have no
DEFAULT clause specified.
mysqltest now has a
change_user command to change the user for
the current connection. (It invokes the
mysql_change_user() C API
The default value of the
connect_timeout system variable
was increased from 5 to 10 seconds. This might help in cases
where clients frequently encounter errors of the form
Lost connection to MySQL server at
XXX', system error:
mysql-test-run.pl now permits a suite name
prefix to be specified in command-line arguments that name test
cases. The test name syntax now is
For example, mysql-test-run.pl binlog.mytest
mytest.test test in the
binlog test suite.
mysqldump produces a
completed on comment
at the end of the dump if
--comments is given. The date
causes dump files for identical data take at different times to
appear to be different. The new options
control whether the date is added to the comment.
suppresses date printing. The default is
--dump-date (include the date
in the comment).
MySQL now can be compiled with gcc 4.2.x.
There was a problem involving a conflict with the
mysqldump information at the top of the
output now shows the same information as
mysqldump invoked with the
-V option, namely the
mysqldump version number, the MySQL server
version, and the distribution.
without a value disabled the event scheduler. Now it enables the
mysql_odbc_escape_string() C API
function has been removed. It has multibyte character escaping
issues, doesn't honor the
NO_BACKSLASH_ESCAPES SQL mode
and is not needed anymore by Connector/ODBC as of 3.51.17.
References: See also Bug #41728.
LAST_EXECUTED column of the
INFORMATION_SCHEMA.EVENTS table now
indicates when the event started executing rather than when it
finished executing. As a result, the
column is never less than
The argument for the mysql-test-run.pl
options is now interpreted as a Perl regular expression if there
is a pattern metacharacter in the argument value. This enables
more flexible specification of which tests to perform or skip.
mysql-test-run.pl now supports a
--combination option for specifying options to
the mysqld server. This option is similar to
--mysqld but should be given two or more times.
mysql-test-run.pl executes multiple test
runs, using the options for each instance of
--combination in successive runs.
For test runs specific to a given test suite, an alternative to
the use of
--combination is to create a
combinations file in the suite directory.
The file should contain a section of options for each test run.
Security Fix; Replication:
It was possible for any connected user to issue a
BINLOG statement, which could be
used to escalate privileges.
Security Fix: Three vulnerabilities in yaSSL versions 1.7.5 and earlier were discovered that could lead to a server crash or execution of unauthorized code. The exploit requires a server with yaSSL enabled and TCP/IP connections enabled, but does not require valid MySQL account credentials. The exploit does not apply to OpenSSL.
The proof-of-concept exploit is freely available on the Internet. Everyone with a vulnerable MySQL configuration is advised to upgrade immediately.
(Bug #33814, CVE-2008-0226, CVE-2008-0227)
RENAME TABLE against a
table with explicit
DATA DIRECTORY and
INDEX DIRECTORY options can be used to
overwrite system table information by replacing the symbolic
link points. the file to which the symlink points.
MySQL will now return an error when the file to which the symlink points already exists. (Bug #32111, CVE-2007-5969)
When using a
FEDERATED table, the local
server could be forced to crash if the remote server returned a
result with fewer columns than expected.
ALTER VIEW retained the original
DEFINER value, even when altered by another
user, which could enable that user to gain the access rights of
the view. Now
ALTER VIEW is
permitted only to the original definer or users with the
Security Enhancement: It was possible to force an error message of excessive length which could lead to a buffer overflow. This has been made no longer possible as a security precaution. (Bug #32707)
LIMIT clause was present, the server
could fail to consider indexes that could be used for
ORDER BY or
Incompatible Change: It was possible to create a view having a column whose name consisted of an empty string or space characters only.
One result of this bug fix is that aliases for columns in the
SELECT statement are checked to ensure
that they are legal column names. In particular, the length must
be within the maximum column length of 64 characters, not the
maximum alias length of 256 characters. This can cause problems
for replication or loading dump files. For additional
information and workarounds, see
Restrictions on Views.
References: See also Bug #31202.
containing ambiguous aliases could have unintended side effects
such as deleting rows from the wrong table. Examples:
DELETE FROM t1 AS a2 USING t1 AS a1 INNER JOIN t2 AS a2; DELETE t1 AS a2 FROM t1 AS a1 INNER JOIN t2 AS a2;
To avoid ambiguity, declaration of aliases other than in the
table_references part of the
statement should be avoided:
DELETE FROM t1 USING t1 AS a1 INNER JOIN t2 AS a2; DELETE t1 FROM t1 AS a1 INNER JOIN t2 AS a2;
USING variant of multiple-table
DELETE syntax, alias declarations
table_references part of
the statement now are disallowed. (In MySQL 5.5, alias
are disallowed for all multiple-table
DELETE statements.) Statements
containing aliases that are no longer permitted must be
References: See also Bug #27525.
Inserting a row with a
NULL value for a
DATETIME column results in a
CSV file that the storage engine cannot read.
CSV tables now need to be defined with
each column marked as
NOT NULL. An error is
raised if you try to create a
CSV table with
columns that are not defined with
(Bug #31473, Bug #32817)
Within a stored routine, it is no longer permissible to declare
a cursor for a
DESCRIBE statement. This happened
to work in some instances, but is no longer supported. In many
cases, a workaround for this change is to use the cursor with a
SELECT query to read from an
INFORMATION_SCHEMA table that produces the
same information as the
Several type-preserving functions and operators returned an
incorrect result type that does not match their argument types:
CASE. These now aggregate using the
precise SQL types of their arguments rather than the internal
type. In addition, the result type of the
STR_TO_DATE() function is now
DATETIME by default.
SET PASSWORD statements now cause
an implicit commit, and thus are prohibited within stored
functions and triggers.
mode enabled, queries such as
SELECT a FROM t1 HAVING
COUNT(*)>2 were not being rejected as they should
This fix results in the following behavior:
There is a check against mixing group and nongroup columns
This check is done both for the select list and for the
HAVING clause if there is one.
This behavior differs from previous versions as follows:
It is no longer possible to create
NULL columns. However, for backward
compatibility, you can continue to use such tables that were
created in previous MySQL releases.
A number of problems existed in the implementation of
MERGE tables that could cause
problems. The problems are summarized below:
A thread trying to lock a
MERGE table performs busy
waiting until all threads that did
REPAIR TABLE or similar
table administration tasks on one or more of its
MyISAM tables in
LOCK TABLES segments do
TABLES. The difference against problem #1 is
that the busy waiting takes place after the
administration task. It is terminated by
TABLES within a
TABLES segment can invalidate the lock. This
does not require a
table. The first
TABLES can be replaced by any statement that
requires other threads to reopen the table. In 5.0 and
5.1 a single
TABLES can provoke the problem.
Trying DML on a
which has a child locked and repaired by another thread,
made an infinite loop in the server.
MERGE table and its
children in parent-child order and flushing the child
deadlocked the server.
Bug #25038: Waiting
Flushing and optimizing locked
MERGE children crashed the
Bug #19627: temporary merge table locking
Use of a temporary
with nontemporary children could corrupt the children.
Temporary tables are never locked. Creation of tables with
nontemporary children of a temporary
MERGE table is now prohibited.
MERGE table possible
It was possible to create a
MERGE table with
MERGE tables: Can't
lock file (errno: 155)
This was a Windows-only bug. Table administration statements sometimes failed with "Can't lock file (errno: 155)".
The fix introduces the following changes in behavior:
This patch changes the behavior of temporary
MERGE tables. Temporary
MERGE must have temporary
children. The old behavior was wrong. A temporary table is
not locked. Hence even nontemporary children were not
locked. See Bug #19627.
CREATE TABLE m1 ... ENGINE=MRG_MYISAM ...; LOCK TABLES t1 WRITE, t2 WRITE, m1 WRITE; ALTER TABLE m1 ... UNION=(t1,t2) ...;
However, you can do this with a temporary
You cannot create a
CREATE ... SELECT, neither as a
MERGE table, nor as a
MERGE table. For
CREATE TABLE m1 ... ENGINE=MRG_MYISAM ...
SELECT ...; causes the error message:
table is not BASE TABLE.
(Bug #19627, Bug #25038, Bug #25700, Bug #26377, Bug #26379, Bug #26867, Bug #27660, Bug #30275, Bug #30491)
mysql_install_db script could fail to
locate some components (including resolveip)
during execution if the
--basedir option was
specified on the command-line or within the
my.cnf file. This was due to a conflict
when comparing the compiled-in values and the supplied values.
--source-install command-line option to the
script has been removed and replaced with the
mysql_install_db now locates components
either using the compiled-in options, the
--basedir option or
Incompatible Change: It was possible for option files to be read twice at program startup, if some of the standard option file locations turned out to be the same directory. Now duplicates are removed from the list of files to be read.
Also, users could not override system-wide settings using
was read last. The latter file now is read earlier so that
~/.my.cnf can override system-wide
The fix for this problem had a side effect such that on Unix,
MySQL programs looked for options in
~/my.cnf rather than the standard location
~/.my.cnf. That problem was addressed as
Important Change; MySQL Cluster:
AUTO_INCREMENT columns had the following
problems when used in
AUTO_INCREMENT counter was not
updated correctly when such a column was updated.
AUTO_INCREMENT values were not
prefetched beyond statement boundaries.
AUTO_INCREMENT values were not handled
After being set,
showed a value of 1, regardless of the value it had
actually been set to.
As part of this fix, the behavior of
has changed. Setting this to less than 32 no longer has any
effect on prefetching within statements (where IDs are now
always obtained in batches of 32 or more), but only between
statements. The default value for this variable has also
changed, and is now
(Bug #25176, Bug #31956, Bug #32055)
Important Note; Partitioning:
An apostrophe or single quote character
') used in the
INDEX DIRECTORY, or
COMMENT for a
clause caused the server to crash. When used as part of a
CREATE TABLE statement, the crash
was immediate. When used in an
TABLE statement, the crash did not occur until trying
to perform a
SELECT or DML
statement on the table. In either case, the server could not be
completely restarted until the
corresponding to the newly created or altered table was deleted.
Upgrading to the current (or later) release solves this
problem only for tables that are newly created or altered.
Tables created or altered in previous versions of the server
' characters in
PARTITION options must still be removed by
deleting the corresponding
.frm files and
re-creating them afterward.
RENAME DATABASE statement was removed and
db_name UPGRADE DATA DIRECTORY
RENAME DATABASE statement
was intended for upgrading database directory names to the
encoding format used in 5.1 for representing identifiers in the
file system (see Mapping of Identifiers to File Names). However,
the statement was found to be dangerous because it could result
in loss of database contents. See
RENAME DATABASE Syntax, and
ALTER DATABASE Syntax.
(Bug #17565, Bug #21741, Bug #28360)
MySQL Cluster; Replication:
Row-based replication from or to a big-endian machine where the
table used the
NDB storage engine
failed, if the same table on the other machine was either
NDB or the other machine was
(Bug #29549, Bug #30790)
References: See also Bug #24231, Bug #30024, Bug #30133, Bug #30134.
MySQL Cluster: Incorrectly handled parameters could lead to a crash in the Transaction Coordinator during a node failure, causing other data nodes to fail. (Bug #33168)
An improperly reset internal signal was observed as a hang when
using events in the
NDB API but
could result in various errors.
MySQL Cluster: The failure of a master node could lead to subsequent failures in local checkpointing. (Bug #32160)
MySQL Cluster: High numbers of API nodes on a slow or congested network could cause connection negotiation to time out prematurely, leading to the following issues:
Excessive CPU usage
Partially connected API nodes
MySQL Cluster: A restart of the cluster failed when more than 1 REDO phase was in use. (Bug #22696)
MySQL Cluster: A local checkpoint could sometimes be started before the previous LCP was restorable from a global checkpoint. (Bug #32519)
NDB storage engine code was not
safe for strict-alias optimization in gcc
after a data node had been shut down could lead to inconsistent
data following a restart of the node.
UPDATE IGNORE could sometimes fail on
NDB tables due to the use of
unitialized data when checking for duplicate keys to be ignored.
An error with an
if statement in
sql/ha_ndbcluster.cc could potentially lead
to an infinite loop in case of failure when working with
AUTO_INCREMENT columns in
When inserting a row into an
table with a duplicate value for a nonprimary unique key, the
error issued would reference the wrong key.
This improves on an initial fix for this issue made in MySQL 5.1.13. (Bug #21072)
BLOB columns were not
locked when they needed to be to guarantee consistency.
References: See also Bug #31482.
MySQL Cluster: It was possible in some cases for a node group to be “lost” due to missed local checkpoints following a system restart. (Bug #31525)
MySQL Cluster: An insufficiently descriptive and potentially misleading Error 4006 (Connect failure - out of connection objects...) was produced when either of the following two conditions occurred:
There were no more transaction records in the transaction coordinator
NDB object in the NDB API
was initialized with insufficient parallelism
Separate error messages are now generated for each of these two cases. (Bug #11313)
MySQL Cluster: A node failure during a local checkpoint could lead to a subsequent failure of the cluster during a system restart. (Bug #31257)
A query using joins between several large tables and requiring
unique index lookups failed to complete, eventually returning
Unknown Error after a very long period of
time. This occurred due to inadequate handling of instances
where the Transaction Coordinator ran out of
when the cluster should have returned NDB error code 4012
(Request ndbd time-out).
MySQL Cluster: An interpreted program of sufficient size and complexity could cause all cluster data nodes to shut down due to buffer overruns. (Bug #29390)
An invalid subselect on an
table could cause mysqld to crash.
BLOB columns, the
addition of read locks to the lock queue was not handled
--help did not
display any information about the
NDB tables having names containing
nonalphanumeric characters (such as
$”) were not discovered
NDB tables did not
work correctly with
A query against a table with
BLOB columns that would return
more than a certain amount of data failed with Got
error 4350 'Transaction already aborted' from
References: This bug was introduced by Bug #29102.
An attempt to perform a
SELECT ... FROM
INFORMATION_SCHEMA.TABLES whose result included
NDB tables for
which the user had no privileges crashed the MySQL Server on
which the query was performed.
MySQL Cluster: A file system close operation could fail during a node or system restart. (Bug #30646)
MySQL Cluster: A cluster restart could sometimes fail due to an issue with table IDs. (Bug #30975)
The description of the
MySQL Cluster: The cluster log was formatted inconsistently and contained extraneous newline characters. (Bug #25064)
ndb_size.pl failed on tables with
FLOAT columns whose definitions
included commas (for example,
MySQL Cluster: Attempting to restore a backup made on a cluster host using one endian to a machine using the other endian could cause the cluster to fail. (Bug #29674)
MySQL Cluster: Transaction timeouts were not handled well in some circumstances, leading to excessive number of transactions being aborted unnecessarily. (Bug #30379)
MySQL Cluster: In some cases, the cluster managment server logged entries multiple times following a restart of ndb_mgmd. (Bug #29565)
The management server was slow to respond when no data nodes
were connected to the cluster. This was most noticeable when
SHOW in the management
MySQL Cluster: The cluster management client could not connect, and would hang instead. This issue affected Mac OS X 64-bit only. (Bug #30366)
MySQL Cluster: A memory leak occurred if a subscription start request was received by the subscription manager before the node making the request was fully connected to the cluster. (Bug #32652)
MySQL Cluster: Log event requests to ndb_mgmd could time out, causing it to fail. (Bug #29621)
The error message for
code 275 (Out of transaction records for complete
phase) was missing.
MySQL Cluster: There was a short interval during the startup process prior to the beginning of heartbeat detection such that, were an API or management node to reboot or a network failure to occur, data nodes could not detect this, with the result that there could be a lingering connection. (Bug #28445)
When a mysqld acting as a cluster SQL node
engine, there is a delay during which some necessary data
structures cannot be initialized until after it has connected to
the cluster, and all MySQL Cluster tables should be opened as
read only. This worked correctly when the
NDB binlog thread was running, but
when it was not running, Cluster tables were not opened as read
only even when the data structures had not yet been set up.
(Bug #32275, Bug #33763)
A query of the form
table GROUP BY (SELECT
table LIMIT 1);
table having a
SET column crashed the server.
Partitioning: It was possible to partition a table to which a foreign key referred. (Bug #32948)
Repeated updates of a table that was partitioned by
KEY on a
TIMESTAMP column eventually
crashed the server.
ALTER TABLE to partition an
existing table having an
column could crash the server.
References: This bug was introduced by Bug #27405.
Partitioning: Changing the storage engine used by a table having subpartitions led to a server crash. (Bug #31893)
Selecting from a table partitioned by
VARCHAR column whose size was
greater than 65530 caused the server to crash.
INSERT DELAYED on a partitioned
table crashed the server. The server now rejects the statement
with an error.
An error in the internal function
mysql_unpack_partition() led to a fatal
error in subsequent calls to
ORDER BY ... DESC did not always work
correctly when selecting from partitioned tables.
References: See also Bug #31001.
SHOW CREATE TABLE misreported the
AUTO_INCREMENT for partitioned
tables using either of the
ARCHIVE storage engines.
partition management statements (for example,
TABLE ... ADD PARTITION) were executing caused the
server to crash.
ALTER TABLE ... COALESCE PARTITION on a table
[LINEAR] HASH or
[LINEAR] KEY caused the server to crash.
Partitioning: It was not possible to insert the greatest possible value for a given data type into a partitioned table. For example, consider a table defined as shown here:
CREATE TABLE t (c BIGINT UNSIGNED) PARTITION BY RANGE(c) ( PARTITION p0 VALUES LESS THAN MAXVALUE );
The largest possible value for a
UNSIGNED column is 18446744073709551615, but the
INSERT INTO t VALUES
(18446744073709551615); would fail, even though the
same statement succeeded were
t not a
In other words,
MAXVALUE was treated as being
equal to the greatest possible value, rather than as a least
LIKE queries on tables partitioned by
KEY and using third-party storage engines
could return incomplete results.
References: See also Bug #29320, Bug #29493, Bug #30563.
Replication; Cluster Replication: A node failure during replication could lead to buckets out of order; now active subscribers are checked for, rather than empty buckets. (Bug #31701)
SHOW SLAVE STATUS as
mysqld was shutting down could cause a crash.
Replication: If a temporary error occurred inside an event group on an event that was not the first event of the group, the slave could get caught in an endless loop because the retry counter was reset whenever an event was executed successfully. (Bug #24860)
References: See also Bug #12691, Bug #23171.
UPDATE statement using a
stored function that modified a nontransactional table was not
logged if it failed. This caused the copy of the
nontransactional table on the master have a row that the copy on
the slave did not.
In addition, when an
ON DUPLICATE KEY UPDATE statement encountered a
duplicate key constraint, but the
UPDATE did not actually change
any data, the statement was not logged. As a result of this fix,
such statements are now treated the same for logging purposes as
UPDATE statements, and so
are written to the binary log.
References: See also Bug #12713.
Replication: It was possible for the name of the relay log file to exceed the amount of memory reserved for it, possibly leading to a crash of the server. (Bug #31836)
References: See also Bug #28597.
Replication: One thread could read uninitialized memory from the stack of another thread. This issue was only known to occur in a mysqld process acting as both a master and a slave. (Bug #30752)
It was possible to set
such that the slave would jump into the middle of a transaction.
This fix improves on one made for this bug in MySQL 5.1.20; the
previous fix insured that the slave could not be made to jump
into the middle of an event group, but the slave failed to
statements could begin or end an event group.
References: See also Bug #12691.
Replication: Due a previous change in how the default name and location of the binary log file were determined, replication failed following some upgrades. (Bug #28597, Bug #28603)
References: See also Bug #31836. This bug was introduced by Bug #20166.
Stored procedures having
parameters were not replicated correctly.
A replication slave sometimes failed to reconnect because it was
unable to run
SHOW SLAVE HOSTS.
It was not necessary to run this statement on slaves (since the
master should track connection IDs), and the execution of this
statement by slaves was removed.
References: See also Bug #13963, Bug #21869.
Replication: Corruption of log events caused the server to crash on 64-bit Linux systems having 4 GB or more of memory. (Bug #31793)
When dropping a database containing a stored procedure while
using row-cased replication, the delete of the stored procedure
mysql.proc table was recorded in the
binary log following the
DATABASE statement. To correct this issue,
DROP DATABASE now uses
Replication: A replication slave sometimes stopped for changes that were idempotent (that is, such changes should have been considered “safe”), even though it should have simply noted that the change was already done, and continued operation. (Bug #19958)
Replication: Trying to replicate an update of a row that was missing on the slave led to a failure on the slave. (Bug #31702)
Replication: Table names were displayed as binary “garbage” characters in slave error messages. The issue was observed on 64-bit Windows but may have effected other platforms. (Bug #30854)
Replicating from a master table to a slave table where the size
VARCHAR column was a different
size would cause mysqld to crash. For more
information on replicating with different column definitions,
see Replication with Differing Table Definitions on Master and Slave.
Use of the
@@hostname system variable in
not replicate. The workaround is to select its value into a user
variable (which does replicate) and insert that.
A replication slave could return “garbage” data
that was not in recognizable row format due to a problem with
Memory was mistakenly freed for
NdbBlob objects when adding an
index while replicating the cluster, which could cause
mysqld to crash.
References: See also Bug #18106.
Cluster Replication: Under certain conditions, the slave stopped processing relay logs. This resulted in the logs never being cleared and the slave eventually running out of disk space. (Bug #31958)
When the master mysqld crashed or was
LOST_EVENTS entry was made in
References: See also Bug #21494.
An issue with the
table could cause
autodiscovery to fail in certain rare circumstances.
References: See also Bug #29549.
A call to
mgmapi.cpp should have been a call to
When the language option was not set correctly, API programs
crashed. This issue was observed only on Windows platforms.
The fix for Bug #11230 and Bug #26215 introduced a significant input-parsing slowdown for the mysql client. This has been corrected. (Bug #33057)
Corrected a typecast involving
bool on Mac OS
X 10.5 (Leopard), which evaluated differently from earlier Mac
OS X versions.
CREATE TABLE ...
SELECT created tables that for date columns used the
Field_date type instead of
Use of uninitialized memory for
filesort in a
subquery caused a server crash.
The correct data type for a
resulting from a
UNION could be
determined incorrectly in some cases: 1) Not correctly inferred
NULL depending on the number of selects;
2) Not inferred correctly as
NULL if one
select used a subquery.
For queries containing
, there was a
limitation that the
col_list ORDER BY
DISTINCT columns had to
be the same as
ORDER BY columns. Incorrect
results could be returned if this was not true.
could not be used as views due to incorrect column reference
ORDER BY UpdateXML(...) caused the server to
crash in queries where
UpdateXML() functions performed
extremely slowly for large amounts of XML data (greater than 64
KB). These functions now execute approximately 2000 times faster
When loading a dynamic plugin on FreeBSD, the plugin would fail to load. This was due to a build error where the required symbols would be not exported correctly. (Bug #30296)
ALTER SERVER statement
to update the settings for a
would cause the mysqld to crash.
DISABLE KEYS and
KEYS on a nonempty table would cause the size of the
index file for the table to grow considerable. This was because
DISABLE KEYS operation would only mark
the existing index, without deleting the index blocks. The
ENABLE KEYS operation would re-create the
index, adding new blocks, while the previous index blocks would
remain. Existing indexes are now dropped and recreated when the
ENABLE KEYS statement is executed.
Starting the server using
--read-only and with the Event
Scheduler enabled caused it to crash.
This issue occurred only when the server had been built with certain nonstandard combinations of configure options.
INFILE ran very slowly when reading large files into
SELECT COUNT(*) query on an
InnoDB table partitioned by
KEY that used a
DOUBLE column as the partitioning
key caused the server to crash.
A self-referencing trigger on a partitioned table caused the server to crash instead of failing with an error. (Bug #30484)
Fast-mutex locking was not thread-safe and optimization-safe on some platforms, which could cause program failures such as out-of-memory errors. (Bug #28284)
When mysqlslap was given a query to execute
from a file using a
--query= option, it executed the query one too many times.
mysql_upgrade could run binaries dynamically linked against incorrect versions of shared libraries. (Bug #28560)
TABLE a AS SELECT * FROM A would fail.
GROUP BY on
BIT columns produced incorrect
MySQL failed to generate or retrieve an
AUTO_INCREMENT primary key for
InnoDB tables with user-defined partitioning.
SELECT with more than 31 nested
dependent subqueries returned an incorrect result.
Killing an SSL connection on platforms where MySQL is compiled
-DSIGNAL_WITH_VIO_CLOSE (Windows, Mac OS
X, and some others) could crash the server.
DELETE statement having
ORDER BY clause and a
LIMIT clause could cause
mysqld to crash.
The mysqld_safe script contained a syntax error. (Bug #30624)
Statements within stored procedures ignored the value of the
References: See also Bug #26162.
Some character mappings in the
file were incorrect.
As a result of this bug fix, indexes must be rebuilt for columns
that use the
ascii_general_ci collation for
columns that contain any of these characters:
Checking Whether Tables or Indexes Must Be Rebuilt.
-lmtmalloc library was removed from the
output of mysql_config on Solaris, as it
caused problems when building
possibly other applications) on that platform that tried to use
dlopen() to access the client library.
It was possible when creating a partitioned table using
CREATE TABLE ...
SELECT to refer in the
clause to columns in the table being selected from, which could
cause the server to crash. An example of such a statement is:
CREATE TABLE t1 (b INT) PARTITION BY RANGE(t2.b) ( PARTITION p1 VALUES LESS THAN (10), PARTITION p2 VALUES LESS THAN (20) ) SELECT * FROM t2;
The fix is to disallow references in
BY clauses to columns not in the table being created.
For a prepared statement
changing the default database following
stmt to be recorded
incorrectly in the binary log.
With auto-reconnect enabled, row fetching for a prepared statement could crash after reconnect occurred because loss of the statement handler was not accounted for. (Bug #29948)
SHOW statements and
INFORMATION_SCHEMA queries could expose
information not permitted by the user's access privileges. An
implication of this change is that
TRIGGERS and the
UpdateXML() function did not
check for the validity of all its arguments; in some cases, this
could lead to a crash of the server.
HANDLER ... READ operation could
leave the table in a locked state.
HANDLER to open a table
having a storage engine not supported by
HANDLER properly returned an
error, but also improperly prevented the table from being
dropped by other connections.
The query cache does not support retrieval of statements for which column level access control applies, but the server was still caching such statements, thus wasting memory. (Bug #30269)
With recent versions of DBD::mysql, mysqlhotcopy generated table names that were doubly qualified with the database name. (Bug #27694)
Partition pruning was not used for queries having
WHERE clause on a table using
TO_DAYS() in the partitioning
STR_TO_DATE() displayed an error
message that referred to
SHOW STATUS LIKE 'Ssl_cipher_list' from a
MySQL client connected using SSL returned an empty string rather
than a list of available ciphers.
Transactions were committed prematurely when
SET autocommit = 0 were
LIMIT arguments greater than
232 did not work correctly.
On Windows, the
implementation was incorrect.
On Windows, the
implementation was incorrect. One symptom was that invalidating
the query cache could cause a server crash.
DELETE statements that remove
rows based on an index read could fail to remove all matching
A server crash could occur when a
DETERMINISTIC stored function was used in
GROUP BY clause.
Entries in the general query log were truncated at 1000 characters. (Bug #21557)
RENAME while tables were open for
HANDLER statements could
cause a server crash.
Clients were ignoring the TCP/IP port number specified as the
default port using the
Internal conversion routines could fail for several multibyte
character sets (
sjis) for empty
strings or during evaluation of
(Bug #31069, Bug #31070)
Allocation of an insufficiently large group-by buffer following creation of a temporary table could lead to a server crash. (Bug #31249)
Queries that had a
GROUP BY clause and
When mysqldump wrote
DROP DATABASE statements within
version-specific comments, it included the terminating semicolon
in the wrong place, causing following statements to fail when
the dump file was reloaded.
variable value can be computed accurately only for simple
“flat” queries, not complex queries such as those
with subqueries or
However, the value was not consistently being set to 0 for
The optimization that uses a unique index to remove
GROUP BY did not ensure that the index was
actually used, thus violating the
that is implied by
Failure to log to the
slow_log log tables were not logged to the
error log at all or were logged incorrectly.
returns column of the
mysql.proc table was
CHAR(64), which is not long enough to store
long data types such as
types. The column has been changed to
LONGBLOB and a warning is
generated if truncation occurs when storing a row into the
A memory leak occurred when
CREATE TEMPORARY TABLE ..
SELECT was invoked from a stored function that in turn
was called from
CREATE TABLE ...
References: See also Bug #40363.
The fix for Bug #24989 introduced a problem such that a
NULL thread handler could be used during a
rollback operation. This problem is unlikely to be seen in
The parser confused user-defined function (UDF) and stored
function creation for
FUNCTION and required that there be a default database
when creating UDFs, although there is no such requirement.
(Bug #28318, Bug #29816)
--without-geometry option for
configure caused server compilation to fail.
NDB libraries and include files were missing from some binary tar file distributions. (Bug #31414)
If a column selected by a view referred to a stored function,
the data type reported for the column in
INFORMATION_SCHEMA.COLUMNS could be
The server crashed if a thread was killed while locking the
general_log table at the
beginning of statement processing.
For a table that used different full-text parsers for different
CREATE TABLE displayed the first parser name for all
Values for the
incorrectly were treated as values for the
MEMORY tables, lookups for
NULL values in
indexes could return incorrect results.
Versions of mysqldump from MySQL 4.1 or
higher tried to use
START TRANSACTION WITH CONSISTENT
SNAPSHOT if the
--master-data options were
given, even with servers older than 4.1 that do not support
User-supplied names foreign key names might not be set to the right key, leading to foreign keys with no name. (Bug #30747)
CONVERT( would fail on invalid input, but processing
was not aborted for the
WHERE clause, leading
to a server crash.
The embedded server did not properly check column-level privileges. (Bug #30710)
mysqldump reversed the event name and program name in one of its error messages. (Bug #28535)
mysql-test-run.pl tried to create files in a
directory where it could not be expected to have write
permission. mysqltest created
.reject files in a directory other than the
one where test results go.
comp_err created files with permissions such that they might be inaccessible during make install operations. (Bug #27789)
GROUP_CONCAT() could cause a
mysql_change_user() C API
function did not correctly reset the character set variables to
the values they had just after initially connecting.
Values of types
ZEROFILL, were not zero-filled when converted to a
character representation in the C prepared statement API.
Several buffer-size system variables were either being handled incorrectly for large values (for settings larger than 4GB, they were truncated to values less than 4GB without a warning), or were limited unnecessarily to 4GB even on 64-bit systems. The following changes were made:
MAKEDATE() incorrectly moved year
values in the 100 to 200 range into the 1970 to 2069 range.
(This is legitimate for 00 to 99, but three-digit years should
be used unchanged.)
Short-format mysql commands embedded within
/*! ... */ comments were parsed incorrectly
by mysql, which discarded the rest of the
comment including the terminating
characters. The result was a malformed (unclosed) comment. Now
mysql does not discard the
The length of the result from
IFNULL() could be calculated
incorrectly because the sign of the result was not taken into
SELECT 1 REGEX NULL caused an assertion
failure for debug servers.
A buffer used when setting variables was not dimensioned to
accommodate the trailing
'\0' byte, so a
single-byte buffer overrun was possible.
Queries that include a comparison of an
INFORMATION_SCHEMA table column to
NULL caused a server crash.
A character set introducer followed by a hexadecimal or bit-value literal did not check its argument and could return an ill-formed result for invalid input. (Bug #30986)
CHAR( did not check its
argument and could return an ill-formed result for invalid
The result from
CHAR() did not add a leading 0x00 byte for input
strings with an odd number of bytes.
For a fatal error during a filesort in
find_all_keys(), the error was returned
without the necessary handler uninitialization, causing an
Worked around an icc problem with an incorrect machine instruction being generated in the context of software pre-fetching after a subroutine got in-lined. (Upgrading to icc 10.0.026 makes the workaround unnecessary.) (Bug #20803)
On Windows, writes to the debug log were using
freopen() instead of
fflush(), resulting in slower performance.
The result from
incorrectly assumed in some contexts to return a single-byte
After changing the SQL mode to a restrictive value that would make already inserted dates in a column be considered invalid, searches returned different results depending on whether the column was indexed. (Bug #28687)
SHOW VARIABLES did not display
relay_log_info_file system variables.
InnoDB tables with
READ COMMITTED isolation
level, semi-consistent reads used for
UPDATE statements skipped rows
locked by another transaction, rather than waiting for the locks
to be released. Consequently, rows that possibly should have
been updated were never examined.
returning incorrect information.
Selecting spatial types in a
UNION could cause a server crash.
The metadata in some
could be incorrect when a temporary table was used to evaluate a
The anonymous accounts were not being created during MySQL installation. (Bug #27692)
Expressions of the form
, where the same
column was named both times, could cause a server crash in the
col NOT IN
MyISAM tables could not exceed 4294967295
(232 – 1) rows on Windows.
INFORMATION_SCHEMA tables are intended
for internal use, but could be accessed by using
returning incorrect information.
TIMESTAMP with a nonzero
time part was converted to a
value, no warning was generated. This caused index lookups to
assume that this is a valid conversion and was returning rows
that match a comparison between a
TIMESTAMP value and a
DATE keypart. Now a warning is
generated so that
a nonzero time part will not match
An assertion designed to detect a bug in the
ROLLUP implementation would incorrectly be
triggered when used in a subquery context with noncacheable
On Windows, mysql_upgrade created temporary
C:\ and did not clean them up.
MOD() function and the
% operator crashed the server for a divisor
less than 1 with a very long fractional part.
GROUP BY on an expression of the form
caused a server
crash due to incorrect calculation of number of decimals.
When invoked with constant arguments,
STR_TO_DATE() could use a cached
value for the format string and return incorrect results.
For a spatial column with a regular
SPATIAL) index, queries failed if the
optimizer tried to use the index.
incorrect for views that were defined to select from other
NULL when used in an
BY that was evaluated using
filesort, a server crash could result.
When expanding a
* in a
NATURAL join, the
check for table access for both tables in the join was done
using only the grant information of the first table.
Setting certain values on a table using a spatial index could cause the server to crash. (Bug #30286)
Index hints specified in view definitions were ignored when using the view to select from the base table. (Bug #28702)
Views do not have indexes, so index hints do not apply. Use of index hints when selecting from a view is no longer permitted. (Bug #28701)
mysqlslap did not properly handle multiple result sets from stored procedures. (Bug #29985)
The mysqlbug script did not include the
correct values of
CXXFLAGS that were used to configure the
configure did not find
on some Linux platforms.
GROUP BY NULL WITH ROLLUP could cause a
References: See also Bug #32558.
Automatically allocated memory for string options associated with a plugin was not freed if the plugin did not get installed. (Bug #31382)
If a user-defined function was used in a
SELECT statement, and an error
occurred during UDF initialization, the error did not terminate
execution of the
rather was converted to a warning.
mysql_change_user() C API
function was subject to buffer overflow.
DROP USER caused an increase in
A server crash could occur if a stored function that contained a
DROP TEMPORARY TABLE statement was invoked by
TABLE statement that created a table of the same name.
Under some circumstances,
CREATE TABLE ...
SELECT could crash the server or incorrectly report
that the table row size was too large.
ALTER TABLE did
not cause the table to be rebuilt.
GeomFromText() function could
cause a server crash if the first argument was
NULL or the empty string.
LAST_INSERT_ID() execution could
be handled improperly in subqueries.
libmysqld applications, handling of
mysql_change_user() calls left
some pointers improperly updated, leading to server crashes.
nonconstant arguments triggered an assertion failure.
Nonconstant arguments are no longer permitted.
A different execution plan was displayed for
EXPLAIN than would actually have
been used for the
the test of sort keys for
ORDER BY did not
consider keys mentioned in
IGNORE KEYS FOR ORDER
A rule to prefer
filesort over an indexed
ORDER BY when accessing all rows of a table
was being used even if a
LIMIT clause was
For storage engines that do not redefine
handler::index_next_same() and are capable
of indexes, statements that include a
clause might select incorrect data.
SHOW CREATE TRIGGER caused a
ORDER BY with
ARCHIVE tables caused a server crash.
mysqldump failed to handle databases
containing a ‘
-’ character in the
The optimizer could ignore
ORDER BY in cases
when the result set is ordered by
resulting in rows being returned in incorrect order.
',' rather than an empty string when the
argument column contained only empty strings.
Threads that were calculating the estimated number of records
for a range scan did not respond to the
KILL statement. That is, if a
range join type is possible
(even if not selected by the optimizer as a join type of choice
and thus not shown by
the query in the
statistics state (shown by
SHOW PROCESSLIST) did not
respond to the
Under certain conditions, the presence of a
BY clause could cause an
clause to be ignored.
For an almost-full
MyISAM table, an insert
that failed could leave the table in a corrupt state.
On 64-bit platforms, assignments of values to enumeration-valued storage engine-specific system variables were not validated and could result in unexpected values. (Bug #32034)
The examined-rows count was not incremented for
variables were displayed by
VARIABLES but could not be accessed in expressions as
@@log_slow_queries. Also, attempting to set
produced an incorrect
Unknown system variable
message. Now these variables are treated as synonyms for
slow_query_log, which means
that they can be accessed in expressions and their values can be
HAVING could treat lettercase of table
aliases incorrectly if
Comparison results for
different from those for operators like
DATETIME-like values with
trailing extra characters such as
the values as
the other operators performed a binary-string comparison. Now
they all uniformly use a
comparison, but generate warnings for values with trailing
In debug builds, testing the result of an
NULL caused an assertion
User-defined functions are not loaded if the server is started
option, but the server did not properly handle this case and
issued an Out of memory error message
Some uses of user variables in a query could result in a server crash. (Bug #32260)
myisamchk --unpack could corrupt a table that when unpacked has static (fixed-length) row format. (Bug #31277)
It was not possible for client applications to distinguish
between auto-set and auto-updated
TIMESTAMP column values.
To rectify this problem, a new
ON_UPDATE_NOW_FLAG flag is set by
Field_timestamp constructors whenever a column should be set to
now reports whether a timestamp column is set to
In addition, such columns now display
CURRENT_TIMESTAMP in the
column in the output from
When running the MySQL Instance Configuration Wizard, a race condition could exist that would fail to connect to a newly configured instance. This was because mysqld had not completed the startup process before the next stage of the installation process. (Bug #28628)
When doing a
DELETE on a table
that involved a
MERGE tables and the
JOIN referred to the same table, the
operation could fail reporting
ERROR 1030 (HY000): Got
error 134 from storage engine. This was because scans
on the table contents would change because of rows that had
already been deleted.
Tables with a
GEOMETRY column could be marked
as corrupt if you added a non-
Many nested subqueries in a single query could led to excessive memory consumption and possibly a crash of the server. (Bug #31048)
Server variables could not be set to their current values on Linux platforms. (Bug #31177)
References: See also Bug #6958.
Repeated execution of a query containing a
CASE expression and numerous
OR relations could
crash the server. The root cause of the issue was determined to
be that the internal
SEL_ARG structure was
not properly initialized when created.
Memory corruption could occur due to large index map in
Range checked for each record status reported
SELECT. The problem was based in an incorrectly
calculated length of the buffer used to store a hexadecimal
representation of an index map, which could result in buffer
overrun and stack corruption under some circumstances.
Comparison of a
BIGINT NOT NULL column with a
constant arithmetic expression that evaluated to NULL mistakenly
caused the error Column '...' cannot be
null (error 1048).
ORDER BY query on a view created using a
FEDERATED table as a base table caused the
server to crash.
Referencing within a subquery an alias used in the
SELECT list of the outer query
was incorrectly permitted.
A query of the form
table GROUP BY
alias WITH ROLLUP
SELECT INTO OUTFILE with 8-bit
ENCLOSED BY characters led to corrupted data
when the data was reloaded using LOAD DATA INFILE. This was
SELECT INTO OUTFILE failed to escape
the 8-bit characters.
SELECT ... GROUP BY
with an assertion if the length of the
BIT column used for the
GROUP BY was not an integer multiple of 8.
A subquery using an
IS NULL check of a column
NOT NULL in a table used in the
FROM clause of the outer query produced an
Flushing a merge table between the time it was opened and its child table were actually attached caused the server to crash. (Bug #30273)
References: This bug was introduced by Bug #26379.
ORDER BY led to the wrong result when
ARCHIVE on a table with a
BLOB when the table cache was
full. The table could also be reported as crashed after the
query had completed, even though the table data was intact.
When casting a string value to an integer, cases where the input
string contained a decimal point and was long enough to overrun
unsigned long long type were not handled
correctly. The position of the decimal point was not taken into
account which resulted in miscalculated numbers and incorrect
truncation to appropriate SQL data type limits.
Some queries using the
NAME_CONST() function failed to
return either a result or an error to the client, causing it to
hang. This was due to the fact that there was no check to insure
that both arguments to this function were constant expressions.
(Bug #27545, Bug #32559)
mysqld sometimes miscalculated the number of
digits required when storing a floating-point number in a
CHAR column. This caused the
value to be truncated, or (when using a debug build) caused the
server to crash.
References: See also Bug #12860.
If the expected precision of an arithmetic expression exceeded the maximum precision supported by MySQL, the precision of the result was reduced by an unpredictable or arbitrary amount, rather than to the maximum precision. In some cases, exceeding the maximum supported precision could also lead to a crash of the server. (Bug #24907)
Issuing an SQL
KILL of the active
connection caused an error on Mac OS X.
The options available to the
TABLE statement were also permitted in
OPTIMIZE TABLE and
ANALYZE TABLE statements, but
caused corruption during their execution. These options were
never supported for these statements, and an error is now raised
if you try to apply these options to these statements.
readline library has been updated to
version 5.2. This addresses issues in the
mysql client where history and editing within
the client would fail to work as expected.
REGEXP operations could cause a
server crash for character sets such as
Now the arguments are converted to
possible, to permit correct results to be produced if the
resulting strings contain only 8-bit characters.
SELECT ... INTO
OUTFILE, if the
ENCLOSED BY string
is empty and the
FIELDS TERMINATED BY string
started with a special character (one of
N), every occurrence
of the character within field values would be duplicated.
On some 64-bit systems, inserting the largest negative value
BIGINT column resulted in
The server crashed after insertion of a negative value into an
AUTO_INCREMENT column of an
For mysql --show-warnings, warnings were in some cases not displayed. (Bug #25146)
euc-kr characters having the
second byte in the ranges
[0x61..0x7A] were rejected.
mysql stripped comments from statements sent
to the server. Now the
--skip-comments option can be
used to control whether to retain or strip comments. The default
(Bug #11230, Bug #26215)
InnoDB does not support
SPATIAL indexes, but could crash when asked
to handle one. Now an error is returned.
ssl-cipher values in option files were not
being read by
For an event with an
ON COMPLETION value of
EVENT statement that specified no
COMPLETION option caused the value to become
ALTER EVENT to rename a
disabled event caused it to become enabled.
mysql-test-run.pl could not run
QUERY statements to target a connection running
SELECT SLEEP() could freeze the server.
FLUSH TABLES WITH
READ LOCK, the server failed to properly detect
write-locked tables when running with low-priority updates,
resulting in a crash or deadlock.
Use of a
BY expression in conjunction with
ROLLUP could cause a server crash.
References: See also Bug #31095.
For transactional tables, an error during a multiple-table
DELETE statement did not roll
back the statement.
DELETE statement with a
subquery in the
WHERE clause would sometimes
ignore an error during subquery evaluation and proceed with the
Using dates in the range
'0000-00-99' range in the
WHERE clause could result in an incorrect
result set. (These dates are not in the supported range for
DATE, but different results for a
given query could occur depending on position of records
containing the dates within a table.)
NULL values in the value
CREATE TABLE LIKE did not work when the
source table was an
CREATE TABLE LIKE was treated
libmysqld than by the
Assigning a 65,536-byte string to a
TEXT column (which can hold a
maximum of 65,535 bytes) resulted in truncation without a
warning. Now a truncation warning is generated.
Changing the SQL mode to cause dates with “zero”
parts to be considered invalid (such as
'1000-00-00') could result in indexed and
nonindexed searches returning different results for a column
that contained such dates.
The parser treated the
function incorrectly, leading to situations where syntax errors
could result depending on which side of an arithmetic operator
the function appeared.
Killing a statement could lead to a race condition in the server. (Bug #32148)
ucs2 does not work as a client character set,
but attempts to use it as such were not rejected. Now
character_set_client cannot be
ucs2. This also affects statements
SET NAMES and
The mysql client program now ignores Unicode byte order mark (BOM) characters at the beginning of input files. Previously, it read them and sent them to the server, resulting in a syntax error.
Presence of a BOM does not cause mysql to
change its default character set. To do that, invoke
mysql with an option such as
For comparisons of the form
the comparison is done using
DATETIME values, per the fix for
Bug #27590. However that fix caused any index on
date_col not to be used and
compromised performance. Now the index is used again.
The server crashed in the parser when running out of memory. Memory handling in the parser has been improved to gracefully return an error when out-of-memory conditions occur in the parser. (Bug #31153)
The default grant tables on Windows contained information for
production.mysql.com, which should not
mysqlslap was missing from the MySQL 5.1.22 Linux RPM packages. (Bug #32077)
InnoDB now tracks locking and use of tables
by MySQL only after a table has been successfully locked on
behalf of a transaction. Previously, the locked flag was set and
the table in-use counter was updated before checking whether the
lock on the table succeeded. A subsequent failure in obtaining a
lock on the table led to an inconsistent state as the table was
neither locked nor in use.
Spurious duplicate-key errors could occur for multiple-row
inserts into an
InnoDB table that activate a
Symbolic links on Windows could fail to work. (Bug #26811)
Within a subquery,
handled differently than at the top level, which could result in
incorrect results or a server crash.
(Bug #32036, Bug #32051)
Improper calculation of
expression results could lead to value truncation.
Use of the
cp932 character set with
CAST() in an
BY clause could cause a server crash.
The rules for valid column names were being applied differently for base tables and views. (Bug #32496)
Various test program cleanups were made: 1)
were removed. 2) bug25714 displays an error
message when invoked with incorrect arguments or the
--help option. 3)
mysql_client_test exits cleanly with a proper
Specifying a nonexistent column for an
INSERT DELAYED statement caused a
server crash rather than producing an error.
libmysqld to crash.
Grant table checks failed in
mysqlslap failed to commit after the final record load. (Bug #31704)
MySQL declares a
UNIQUE key as a
PRIMARY key if it doesn't have
NULL columns and is not a partial key, and
PRIMARY key must alway be the first key.
However, in some cases, a nonfirst key could be reported as
PRIMARY, leading to an assert failure by
InnoDB. This is fixed by correcting the key
libmysqld, use of prepared statements
and the query cache at the same time caused problems.
The optimizer incorrectly optimized conditions out of the
WHERE clause in some queries involving
subqueries and indexed columns.
CREATE ... SELECT ... FROM, where the
resulting table contained indexes, adding
SQL_BUFFER_RESULT to the
SELECT part caused index
corruption in the table.
Denormalized double-precision numbers cannot be handled properly by old MIPS processors. For IRIX, this is now handled by enabling a mode to use a software workaround. (Bug #29085)
A race condition between killing a statement and the thread executing the statement could lead to a situation such that the binary log contained an event indicating that the statement was killed, whereas the statement actually executed to completion. (Bug #27571)
The optimizer made incorrect assumptions about the value of the
is_member value for user-defined functions,
sometimes resulting in incorrect ordering of UDF results.
BLACKHOLE tables caused 100%
CPU use due to locking problems.
If the server crashed during an
TABLE statement, leaving a temporary file in the
database directory, a subsequent
DATABASE statement failed due to the presence of the
mysql_insert_id() C API
function sometimes returned different results for
Name resolution for correlated subqueries and
HAVING clauses failed to distinguish which of
two was being performed when there was a reference to an outer
aliased field. This could result in error messages about a
HAVING clause for queries that had no such
Zero-padding of exponent values was not the same across platforms. (Bug #12860)
variable was treated as having a
value and as being settable at runtime. Now it has only a
GLOBAL read-only value.
An issue with the
sql_mode database can cause the
creation of stored routines to fail. If you are having problems
with creating stored routines while using this
sql_mode value, remove this
value from your
transactional and nontransactional tables caused an assertion
mysqld_safe looked for error messages in the wrong location. (Bug #32679)
It makes no sense to attempt to use
ALTER TABLE ...
ORDER BY to order an
if there is a user-defined clustered index, because rows are
always ordered by the clustered index. Such attempts now are
ignored and produce a warning.
Also, in some cases,
InnoDB incorrectly used
a secondary index when the clustered index would produce a
EXPLAIN output now
indicates use of the clustered index (for tables that have one)
as lines with a
type value of
key value of
Using index in the
References: See also Bug #35850.
MySQLInstanceConfig.exe failed to grant
certain privileges to the
For Vista installs, MySQLInstanceConfig.exe did not add the default MySQL port to the firewall exceptions. It now provides a check box that enables the user a choice of whether to do this. (Bug #24853)
For tables with certain definitions,
UPDATE statements could fail to
find the correct record to update and report an error when the
record did in fact exist.
GRANT statements with
grant tables from an old version of MySQL could cause a server
mysql-test-run.pl sometimes set up test scenarios in which the same port number was passed to multiple servers, causing one of them to be unable to start. (Bug #31880)