Alterações na distribuição 3.23.3
Added patches for MIT-pthreads on NetBSD.
- Fixed range bug in
MyISAM. ASCis now the default again forORDER BY.- Added
LIMITtoUPDATE. - Added
mysql_change_user()function to the MariaDB C API. - Added character set to
SHOW VARIABLES. - Added support of
--[whitespace]comments. - Allow
INSERT into tbl_name VALUES (), that is, you may now specify an empty value list to insert a row in which each column is set to its default value. - Changed
SUBSTRING(text FROM pos)to conform to SQL-99. (Before this construct returned the rightmostposcharacters.) SUM()withGROUP BYreturned 0 on some systems.- Changed output for
SHOW TABLE STATUS. - Added
DELAY_KEY_WRITEoption toCREATE TABLE. - Allow
AUTO_INCREMENTon any key part. - Fixed problem with
YEAR(NOW())andYEAR(CURDATE()). - Added
CASEconstruct. - New function
COALESCE().