Alterações na distribuição 4.0.10 (29 Jan 2003)
Functionality added or changed:
- Added option
--log-error[=file_name]
tomysqld_safe
andmysqld
. This option will force all error messages to be put in a log file if the option--console
is not given. On Windows--log-error
is enabled as default, with a default name ofhost_name.err
if the name is not specified. - Changed some things from
Warning:
toNote:
in the log files. - The mysqld server should now compile on NetWare.
- Added optimization that if one does
GROUP BY ... ORDER BY NULL
then result is not sorted. - New
--ft-stopword-file
command-line option formysqld
to replace/disable the built-in stopword list that is used in full-text searches. Leia "SHOW VARIABLES
". - Changed default stack size from 64K to 192K; This fixes a core dump problem on Red Hat 8.0 and other systems with a
glibc
that requires a stack size larger than 128K forgethostbyaddr()
to resolve a hostname. You can fix this for earlier MariaDB versions by startingmysqld
with--thread-stack=192K
. - Added
mysql_waitpid
to the binary distribution and theMySQL-client
RPM subpackage (required formysql-test-run
). - Renamed the main
MariaDB
RPM package toMySQL-server
. When updating from an older version,MySQL-server.rpm
will simply replaceMySQL.rpm
. - If a slave is configured with
replicate_wild_do_table=db.%
orreplicate_wild_ignore_table=db.%
, these rules will be applied toCREATE/DROP DATABASE
too. - Added timeout value for
MASTER_POS_WAIT()
.
Bugs fixed:
- Fixed initialisation of the random seed for newly created threads to give a better
rand()
distribution from the first call. - Fixed a bug that caused
mysqld
to hang when a table was opened with theHANDLER
command and then dropped without being closed. - Fixed bug in logging to binary log (which affects replication) a query that inserts a
NULL
in anAUTO_INCREMENT
column and also usesLAST_INSERT_ID()
. - Fixed an unlikely bug that could cause a memory overrun when using
ORDER BY constant_expression
. - Fixed a table corruption in
myisamchk
's parallel repair mode. - Fixed bug in query cache invalidation on simple table renaming.
- Fixed bug in
mysqladmin --relative
. - On some 64 bit systems,
show status
reported a strange number forOpen_files
andOpen_streams
. - Fixed incorrect number of columns in
EXPLAIN
on empty table. - Fixed bug in
LEFT JOIN
that caused zero rows to be returned in the case theWHERE
condition was evaluated asFALSE
after readingconst
tables. (Unlikely condition). FLUSH PRIVILEGES
didn't correctly flush table/column privileges whenmysql.tables_priv
is empty.- Fixed bug in replication when using
LOAD DATA INFILE
one a file that updated anAUTO_INCREMENT
column withNULL
or0
. This bug only affected MariaDB masters (not slaves or MariaDB 3.23 masters). Note: If you have a slave that has replicated a file with generatedAUTO_INCREMENT
columns then the slave data is corrupted and you should reinitialise the affected tables from the master. - Fixed possible memory overrun when sending a
BLOB
value larger than 16M to the client. - Fixed incorrect error message when setting a
NOT NULL
column to an expression that returnedNULL
. - Fixed core dump bug in
str LIKE '%other_str%'
wherestr
orother_str
contained characters >= 128. - Fixed bug: When executing on master
LOAD DATA
andInnoDB
failed withtable full
error the binary log was corrupted.