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-mysqldto work on Mac OS X. SHOW TABLE STATUSdisplayed incorrectRow_formatvalue 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
mysqlddidn't allow one toUPDATErows in a table even if one had a globalUPDATEprivilege and a databaseSELECTprivilege. - Fixed a security problem with
SELECTand wildcarded select list, when user only had partial columnSELECTprivileges on the table. - Fixed unlikely problem in optimising
WHEREclause with a constant expression such as inWHERE 1 AND (a=1 AND b=1). - Fixed problem on IA-64 with timestamps that caused
mysqlbinlogto fail. - The default option for
innodb_flush_log_at_trx_commitwas changed from 0 to 1 to makeInnoDBtables 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,mysqlbinlogand the replication code readREPLACEinstead ofIGNORE. This could make the slave's table become different from the master's table. (Bug#218) - Fixed overflow bug in
MyISAMwhen a row is inserted into a table with a large number of columns and at least oneBLOB/TEXTcolumn. Bug was caused by incorrect calculation of the needed buffer to pack data. - The binary log was not locked during
TRUNCATE table_nameorDELETE FROM table_namestatements, which could cause anINSERTtotable_nameto be written to the log before theTRUNCATEorDELETEstatements. - Fixed rare bug in
UPDATEofInnoDBtables where one row could be updated multiple times. - Produce an error for empty table and column names.
- Changed
PROCEDURE ANALYSE()to reportDATEinstead ofNEWDATE. - Changed
PROCEDURE ANALYSE(#)to restrict the number of values in anENUMcolumn to#also for string values. mysqldumpno longer silently deletes the binary logs when invoked with the--master-dataor--first-slaveoption; 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-logsoption.- Fixed a bug in
mysqldumpwhen it was invoked with the--master-dataoption: TheCHANGE MASTER TOstatements that were appended to the SQL dump had incorrect coordinates. (Bug#159)