D.5.26 Changes in release 3.22.10

• mysql_install_db no longer starts the MySQL server! You should start mysqld with safe_mysqld after installing it! The MySQL RPM will, however, start the server as before.
• Added --bootstrap option to mysqld and recoded mysql_install_db to use it. This will make it easier to install MySQL with RPMs.
• Changed +, - (sign and minus), *, /, %, ABS() and MOD() to be BIGINT aware (64-bit safe).
• Fixed a bug in ALTER TABLE that caused mysqld to crash.
• MySQL now always reports the conflicting key values when a duplicate key entry occurs. (Before this was only reported for INSERT.)
• New syntax: INSERT INTO tbl_name SET col_name=value, col_name=value, ...
• Most errors in the `.err' log are now prefixed with a time stamp.
• Added option MYSQL_INIT_COMMAND to mysql_options() to make a query on connect or reconnect.
• Added option MYSQL_READ_DEFAULT_FILE and MYSQL_READ_DEFAULT_GROUP to mysql_options() to read the following parameters from the MySQL option files: port, socket, compress, password, pipe, timeout, user, init-command, host and database.
• Added maybe_null to the UDF structure.
• Added option IGNORE to INSERT statements with many rows.
• Fixed some problems with sorting of the koi8 character sets; users of koi8 must run isamchk -rq on each table that has an index on a CHAR or VARCHAR column.
• New script mysql_setpermission, by Luuk de Boer. It allows easy creation of new users with permissions for specific databases.
• Allow use of hexadecimal strings (0x...) when specifying a constant string (like in the column separators with LOAD DATA INFILE).
• Ported to OS/2 (thanks to Antony T. Curtis antony.curtis@olcs.net).
• Added more variables to SHOW STATUS and changed format of output to be like SHOW VARIABLES.
• Added extended-status command to mysqladmin which will show the new status variables.

User Comments

Add your own comment.