MySQL Manual | D.4.49 Changes in release 3.23.11

Allow the ALTER TABLE tbl_name ADD (field_list) syntax.
Fixed problem with optimiser that could sometimes use incorrect keys.
Fixed that GRANT/REVOKE ALL PRIVILEGES doesn't affect GRANT OPTION.
Removed extra `)' from the output of SHOW GRANTS.
Fixed problem when storing numbers in timestamps.
Fix problem with timezones that have half hour offsets.
Allow the syntax UNIQUE INDEX in CREATE statements.
mysqlhotcopy - fast online hot-backup utility for local MySQL databases. By Tim Bunce.
New more secure mysqlaccess. Thanks to Steve Harvey for this.
Added --i-am-a-dummy and --safe-updates options to mysql.
Added select_limit and max_join_size variables to mysql.
Added SQL_MAX_JOIN_SIZE and SQL_SAFE_UPDATES options.
Added READ LOCAL lock that doesn't lock the table for concurrent inserts. (This is used by mysqldump.)
Changed that LOCK TABLES ... READ doesn't anymore allow concurrent inserts.
Added --skip-delay-key-write option to mysqld.
Fixed security problem in the protocol regarding password checking.
_rowid can now be used as an alias for an integer type unique indexed column.
Added back blocking of SIGPIPE when compiling with --thread-safe-clients to make things safe for old clients.

User Comments