D.6.20 Changes in release 3.21.15

• Warning: Incompatible change! mysqlperl is now from Msql-Mysql-modules. This means that connect() now takes host, database, user, password arguments! The old version took host, database, password, user.
• Allow DATE '1997-01-01', TIME '12:10:10' and TIMESTAMP '1997-01-01 12:10:10' formats required by SQL-99. Warning: Incompatible change! This has the unfortunate side-effect that you no longer can have columns named DATE, TIME or TIMESTAMP. :( Old columns can still be accessed through tablename.columnname!)
• Changed Makefiles to hopefully work better with BSD systems. Also, `manual.dvi' is now included in the distribution to avoid having stupid make programs trying to rebuild it.
• readline library upgraded to version 2.1.
• A new sortorder german-1. That is a normal ISO-Latin1 with a german sort order.
• Perl DBI/DBD is now included in the distribution. DBI is now the recommended way to connect to MySQL from Perl.
• New portable benchmark suite with DBD, with test results from mSQL 2.0.3, MySQL, PostgreSQL 6.2.1 and Solid server 2.2.
• crash-me is now included with the benchmarks; this is a Perl program designed to find as many limits as possible in an SQL server. Tested with mSQL, PostgreSQL, Solid and MySQL.
• Fixed bug in range-optimiser that crashed MySQL on some queries.
• Table and column name completion for mysql command-line tool, by Zeev Suraski and Andi Gutmans.
• Added new command REPLACE that works like INSERT but replaces conflicting records with the new record. REPLACE INTO TABLE ... SELECT ... works also.
• Added new commands CREATE DATABASE db_name and DROP DATABASE db_name.
• Added RENAME option to ALTER TABLE: ALTER TABLE name RENAME TO new_name.
• make_binary_distribution now includes `libgcc.a' in `libmysqlclient.a'. This should make linking work for people who don't have gcc.
• Changed net_write() to my_net_write() because of a name conflict with Sybase.
• New function DAYOFWEEK() compatible with ODBC.
• Stack checking and bison memory overrun checking to make MySQL safer with weird queries.

User Comments

Add your own comment.