D.1.1 Modifications de la version 3.23.3

  • ASC is now again default for ORDER BY.
  • Added LIMIT to UPDATE.
  • New client function: mysql_change_user.
  • Added character set to SHOW VARIABLES
  • Added support of --[whitespace] comments.
  • Allow INSERT into table_name VALUES ()'
  • Changed SUBSTRING(text FROM pos) to conform to ANSI SQL. (Before this construct returned the rightmost 'pos' characters).
  • SUM(..) with GROUP BY returned 0 on some system.
  • Changed output for SHOW TABLE STATUS.
  • Added DELAY_KEY_WRITE option to CREATE TABLE.
  • Allow AUTO_INCREMENT on any key part.
  • Fixed problem with YEAR(NOW()) and YEAR(CURDATE()).
  • Added CASE construct.
  • New function COALESCE().