D.3.20 Modifications de la version 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 ANSI SQL. 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 a SQL server. Tested with mSQL, PostgreSQL, Solid and MySQL.
  • Fixed bug in range-optimizer 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 nom_base_de_donnees and DROP DATABASE nom_base_de_donnees.
  • Added RENAME option to ALTER TABLE: ALTER TABLE name RENAME AS 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.