Alterações na distribuição 3.23.57 (06 Jun 2003)
Fixed problem in alarm handling that could cause problems when getting a packet that is too large.
- Fixed problem when installing MariaDB as a service on Windows when one gave 2 arguments (option file group name and service name) to
mysqld
. - Fixed
kill pid-of-mysqld
to work on Mac OS X. SHOW TABLE STATUS
displayed incorrectRow_format
value for tables that have been compressed withmyisampack
. (Bug#427)SHOW VARIABLES LIKE 'innodb_data_file_path'
displayed only the name of the first datafile. (Bug#468)- Fixed security problem where
mysqld
didn't allow one toUPDATE
rows in a table even if one had a globalUPDATE
privilege and a databaseSELECT
privilege. - Fixed a security problem with
SELECT
and wildcarded select list, when user only had partial columnSELECT
privileges on the table. - Fixed unlikely problem in optimising
WHERE
clause with a constant expression such as inWHERE 1 AND (a=1 AND b=1)
. - Fixed problem on IA-64 with timestamps that caused
mysqlbinlog
to fail. - The default option for
innodb_flush_log_at_trx_commit
was changed from 0 to 1 to makeInnoDB
tables ACID by default. Leia "Opções de Inicialização do InnoDB". - Fixed problem with too many allocated alarms on slave when connecting to master many times (normally not a very critical error).
- Fixed a bug in replication of temporary tables. (Bug#183)
- Fixed 64 bit bug that affected at least AMD hammer systems.
- Fixed a bug when doing
LOAD DATA INFILE IGNORE
: When reading the binary log,mysqlbinlog
and the replication code readREPLACE
instead ofIGNORE
. This could make the slave's table become different from the master's table. (Bug#218) - Fixed overflow bug in
MyISAM
when a row is inserted into a table with a large number of columns and at least oneBLOB/TEXT
column. Bug was caused by incorrect calculation of the needed buffer to pack data. - The binary log was not locked during
TRUNCATE table_name
orDELETE FROM table_name
statements, which could cause anINSERT
totable_name
to be written to the log before theTRUNCATE
orDELETE
statements. - Fixed rare bug in
UPDATE
ofInnoDB
tables where one row could be updated multiple times. - Produce an error for empty table and column names.
- Changed
PROCEDURE ANALYSE()
to reportDATE
instead ofNEWDATE
. - Changed
PROCEDURE ANALYSE(#)
to restrict the number of values in anENUM
column to#
also for string values. mysqldump
no longer silently deletes the binary logs when invoked with the--master-data
or--first-slave
option; while this behaviour was convenient for some users, others may suffer from it. Now one has to explicitly ask for binary logs to be deleted by using the new--delete-master-logs
option.- Fixed a bug in
mysqldump
when it was invoked with the--master-data
option: TheCHANGE MASTER TO
statements that were appended to the SQL dump had incorrect coordinates. (Bug#159)