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.