Functionality added or changed:
Multiple-table UPDATE and
DELETE statements that do not affect any rows
are now written to the binary log and will replicate.
(Bug#13348, Bug#12844)
Range scans can now be performed for queries on VIEWs such as
column IN (<constants>) and
column BETWEEN ConstantA AND ConstantB.
(Bug#13317)
The limit of 255 characters on the input buffer for mysql on Windows has been lifted. The exact limit depends on what the system allows, but can be up to 64K characters. A typical limit is 16K characters. (Bug#12929)
Added the myisam_stats_method, which controls
whether NULL values in indexes are considered
the same or different when collecting statistics for
MyISAM tables. This influences the query
optimizer as described in
Section 7.4.7, “MyISAM Index Statistics Collection”.
(Bug#12232)
The CHAR() function now takes
into account the character set and collation given by the
character_set_connection and
collation_connection system variables. For an
argument n to
CHAR(), the result is
n mod 256 for single-byte character
sets. For multi-byte character sets,
n must be a valid code point in the
character set. Also, the result string from
CHAR() is checked for
well-formedness. For invalid arguments, or a result that is not
well-formed, MySQL generates a warning (or, in strict SQL mode,
an error).
(Bug#10504)
Re-enabled the --delayed-inserts option for
mysqldump, which now checks for each table
dumped whether its storage engine supports
DELAYED inserts.
(Bug#7815)
RENAME TABLE now works for views as well, as
long as you do not try to rename a view into a different
database.
(Bug#5508)
Configure-time checking for the availability of multi-byte
macros and functions in the bundled readline
library. This improves handling of multi-byte character sets in
the mysql client.
(Bug#3982)
When an InnoDB foreign key constraint is
violated, the error message now indicates which table, column,
and constraint names are involved.
(Bug#3443)
Bugs fixed:
MySQL Cluster:
A trigger updating the value of an
AUTO_INCREMENT column in an
NDB table would insert an error code rather
than the expected value into the column.
(Bug#13961)
MySQL Cluster: If ndb_restore could not find a free mysqld process, it crashed. (Bug#13512)
MySQL Cluster: Adding an index to a table with a large number of columns (more then 100) crashed the storage node. (Bug#13316)
MySQL Cluster:
BIT columns and following columns in
NDB tables were corrupt when dumped by
mysqldump.
(Bug#13152)
MySQL Cluster:
Queries on NDB tables that were executed
using index_merge could produce incorrect
results.
(Bug#13081)
MySQL Cluster:
Receipt of several ENTER SINGLE USER MODE
commands by multiple ndb_mgmd processes
within a short period of time resulted in cluster shutdown.
(Bug#13053)
MySQL Cluster: Multiple ndb_mgmd processes in a cluster did not know each other's IP addresses. (Bug#12037)
MySQL Cluster:
With two mgmd processes in a cluster,
ndb_mgm output for SHOW
would display the same IP address for both processes, even when
they were on different hosts.
(Bug#11595)
MySQL Cluster:
LOAD DATA INFILE with a large data file
failed.
(Bug#10694)
MySQL Cluster:
When deleting a great many (tens of thousands of) rows at once
from an NDB table, an improperly dereferenced
pointer could cause the mysqld process to
crash.
(Bug#9282)
Certain joins using Range checked for each
record in the query execution plan could cause the
server to crash.
(Bug#24776)
Joins nested under NATURAL or
USING joins were sometimes not initialized
properly, causing a server crash.
(Bug#13545)
After running configure with the
--with-embedded-privilege-control option, the
embedded server failed to build.
(Bug#13501)
The optimizer chose a less efficient execution plan for
than for col_name BETWEEN
const AND
const
, even though the two
expressions are logically equivalent. Now the optimizer can use
the col_name =
constref access method for both expressions.
(Bug#13455)
Locking a view with the query cache enabled and
query_cache_wlock_invalidate enabled could
cause a server crash.
(Bug#13424)
A HAVING clause that references an
unqualified view column name could crash the server.
(Bug#13411)
The --skip-innodb-doublewrite option disables
use of the InnoDB doublewrite buffer.
However, having this option in effect when creating a new MySQL
installation prevented the buffer from even being created,
resulting in a server crash later.
(Bug#13367)
Calling the FORMAT() function
with a DECIMAL column value caused a server
crash when the value was NULL.
(Bug#13361)
Comparisons involving row constructors containing constants could cause a server crash. (Bug#13356)
Aggregate functions sometimes incorrectly were allowed in the
WHERE clause of UPDATE and
DELETE statements.
(Bug#13180)
NATURAL joins and joins with
USING against a view could return
NULL rather than the correct value.
(Bug#13127)
For queries with DISTINCT and WITH
ROLLUP, the DISTINCT should be
applied after the rollup operation, but was not always.
(Bug#12887)
It was possible to create a view that executed a stored function
for which you did not have the EXECUTE
privilege.
(Bug#12812)
Shared-memory connections were not working on Windows. (Bug#12723)
The server was not rejecting
FLOAT(
or
M,D)DOUBLE(
columns specifications when M,D)M was
less than D.
(Bug#12694)
CHECKSUM TABLE locked
InnoDB tables and did not use a consistent
read.
(Bug#12669)
Incorrect creation of DECIMAL local variables
in a stored procedure could cause a server crash.
(Bug#12589)
For queries for which the optimizer determined a join type of
“Range checked for each record” (as shown by
EXPLAIN, the query sometimes could cause a
server crash, depending on the data distribution.
(Bug#12291)
After running configure with the
--without-server option, the distribution
failed to build.
(Bug#11680, Bug#13550)
Use of a user-defined function within the
HAVING clause of a query resulted in an
Unknown column error.
(Bug#11553)
The server crashed when processing a view that invoked the
CONVERT_TZ() function.
(Bug#11416)
When SELECT ... FOR UPDATE or SELECT
... LOCK IN SHARE MODE for an
InnoDB table were executed from within a
stored function or a trigger, they were converted to a
non-locking consistent read.
(Bug#11238)
The --replicate-rewrite-db and
--replicate-do-table options did not work for
statements in which tables were aliased to names other than
those listed by the options.
(Bug#11139)
Queries against a MERGE table that has a
composite index could produce incorrect results.
(Bug#9112)
MySQL programs in binary distributions for Solaris 8/9/10 x86 systems would not run on Pentium III machines. (Bug#6772)
Nested handlers within stored procedures didn't work. (Bug#6127)

User Comments
Add your own comment.