Alterações na distribuição 3.23.56 (13 Mar 2003)
Fixed mysqld
crash on extremely small values of sort_buffer
variable.
- Fixed a bug in privilege system for
GRANT UPDATE
on column level. - Fixed a rare bug when using a date in
HAVING
withGROUP BY
. - Fixed checking of random part of
WHERE
clause. (Bug#142) - Fixed MariaDB (and
myisamchk
) crash on artificially corrupted.MYI
files. - Security enhancement:
mysqld
no longer reads options from world-writeable config files. - Security enhancement:
mysqld
andsafe_mysqld
now only use the first--user
option specified on the command line. (Normally this comes from/etc/my.cnf
) - Security enhancement: Don't allow
BACKUP TABLE
to overwrite existing files. - Fixed unlikely deadlock bug when one thread did a
LOCK TABLE
and another thread did aDROP TABLE
. In this case one could do aKILL
on one of the threads to resolve the deadlock. LOAD DATA INFILE
was not replicated by slave ifreplicate_*_table
was set on the slave.- Fixed a bug in handling
CHAR(0)
columns that could cause incorrect results from the query. - Fixed a bug in
SHOW VARIABLES
on 64-bit platforms. The bug was caused by incorrect declaration of variableserver_id
. - The Comment column in
SHOW TABLE STATUS
now reports that it can containNULL
values (which is the case for a crashed.frm
file). - Fixed the
rpl_rotate_logs
test to not fail on certain platforms (e.g. Mac OS X) due to a too long file name (changedslave-master-info.opt
to.slave-mi
). - Fixed a problem with
BLOB NOT NULL
columns used withIS NULL
. - Fixed bug in
MAX()
optimization inMERGE
tables. - Better
RAND()
initialisation for new connections. - Fixed bug with connect timeout. This bug was manifested on OS's with
poll()
system call, which resulted in timeout the value specified as it was executed in bothselect()
andpoll()
. - Fixed bug in
SELECT * FROM table WHERE datetime1 IS NULL OR datetime2 IS NULL
. - Fixed bug in using aggregate functions as argument for
INTERVAL
,CASE
,FIELD
,CONCAT_WS
,ELT
andMAKE_SET
functions. - When running with
--lower-case-table-names
(default on Windows) and you had tables or databases with mixed case on disk, then executingSHOW TABLE STATUS
followed withDROP DATABASE
orDROP TABLE
could fail withErrcode 13
. - Fixed bug in logging to binary log (which affects replication) a query that inserts a
NULL
in anauto_increment
field and also usesLAST_INSERT_ID()
. - Fixed bug in
mysqladmin --relative
. - On some 64 bit systems,
show status
reported a strange number forOpen_files
andOpen_streams
.