D.3.34 Modifications de la version 3.21.2

  • The range optimizer is coded, but only 85% tested. It can be enabled with --new, but it crashes core a lot yet...
  • More portable. Should compile on AIX and alpha-digital. At least the isam library should be relatively 64-bit clean.
  • New isamchk which can detect and fix more problems.
  • New options for isamlog.
  • Using new version of Automake.
  • Many small portability changes (from the AIX and alpha-digital port) Better checking of pthread(s) library.
  • czech error messages by snajdr@pvt.net.
  • Decreased size of some buffers to get fewer problems on systems with little memory. Also added more checks to handle ``out of memory'' problems.
  • mysqladmin: you can now do mysqladmin kill 5,6,7,8 to kill multiple threads.
  • When the maximum connection limit is reached, one extra connection by a user with the PROCESS_ACL privilege is granted.
  • Added -O backlog=# option to mysqld.
  • Increased maximum packet size from 512K to 1024K for client.
  • Almost all of the function code is now tested in the internal test suite.
  • ALTER TABLE now returns warnings from field conversions.
  • Port changed to 3306 (got it reserved from ISI).
  • Added a fix for Visual FoxBase so that any schema name from a table specification is automatically removed.
  • New function ASCII().
  • Removed function BETWEEN(a,b,c). Use the standard ANSI synax instead: expr BETWEEN expr AND expr.
  • MySQL no longer has to use an extra temporary table when sorting on functions or SUM() functions.
  • Fixed bug that you couldn't use nom_table.field_name in UPDATE.
  • Fixed SELECT DISTINCT when using 'hidden group'. For example: 
    mysql> SELECT DISTINCT MOD(some_field,10) FROM test
           GROUP BY some_field;
    Note: some_field is normally in the SELECT part. ANSI SQL should require it.