Alterações na distribuição 3.23.3
Added patches for MIT-pthreads on NetBSD.
- Fixed range bug in
MyISAM
. ASC
is now the default again forORDER BY
.- Added
LIMIT
toUPDATE
. - 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 rightmostpos
characters.) SUM()
withGROUP BY
returned 0 on some systems.- Changed output for
SHOW TABLE STATUS
. - Added
DELAY_KEY_WRITE
option toCREATE TABLE
. - Allow
AUTO_INCREMENT
on any key part. - Fixed problem with
YEAR(NOW())
andYEAR(CURDATE())
. - Added
CASE
construct. - New function
COALESCE()
.