Alterações na distribuição 3.23.25 (29 Sep 2000)
Fixed that databasename works as second argument to mysqlhotcopy.
- The values for the
UMASKandUMASK_DIRenvironment variables now can be specified in octal by beginning the value with a zero. - Added
RIGHT JOIN. This makesRIGHTa reserved word. - Added
@@IDENTITYas a synonym forLAST_INSERT_ID(). (This is for MSSQL compatibility.) - Fixed a bug in
myisamchkandREPAIRwhen usingFULLTEXTindex. LOAD DATA INFILEnow works with FIFOs. (Patch by Toni L. Harbaugh-Blackford.)FLUSH LOGSbroke replication if you specified a log name with an explicit extension as the value of thelog-binoption.- Fixed a bug in
MyISAMwith packed multi-part keys. - Fixed crash when using
CHECK TABLEon Windows. - Fixed a bug where
FULLTEXTindex always used thekoi8_ukrcharacter set. - Fixed privilege checking for
CHECK TABLE. - The
MyISAMrepair/reindex code didn't use the--tmpdiroption for its temporary files. - Added
BACKUP TABLEandRESTORE TABLE. - Fixed core dump on
CHANGE MASTER TOwhen the slave did not have the master to start with. - Fixed incorrect
Timein the processlist forConnectof the slave thread. - The slave now logs when it connects to the master.
- Fixed a core dump bug when doing
FLUSH MASTERif you didn't specify a filename argument to--log-bin. - Added missing
ha_berkeley.xfiles to the MariaDB Windows distribution. - Fixed some mutex bugs in the log code that could cause thread blocks if new log files couldn't be created.
- Added lock time and number of selected processed rows to slow query log.
- Added
--memlockoption tomysqldto lockmysqldin memory on systems with themlockall()call (as in Solaris). HEAPtables didn't use keys properly. (Bug from 3.23.23.)- Added better support for
MERGEtables (keys, mapping, creation, documentation...). Leia "TabelasMERGE". - Fixed bug in
mysqldumpfrom 3.23 which caused someCHARcolumns not to be quoted. - Merged
analyze,check,optimizeand repair code. OPTIMIZE TABLEis now mapped toREPAIRwith statistics and sorting of the index tree. This means that for the moment it only works onMyISAMtables.- Added a pre-alloced block to root_malloc to get fewer mallocs.
- Added a lot of new statistics variables.
- Fixed
ORDER BYbug withBDBtables. - Removed warning that
mysqldcouldn't remove the.pidfile under Windows. - Changed
--log-isamto logMyISAMtables instead of isam tables. - Fixed
CHECK TABLEto work on Windows. - Added file mutexes to make
pwrite()safe on Windows.