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 SQL syntax 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
tbl_name.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. Standard SQL should require
it.
This is a translation of the MySQL Reference Manual that can be found at dev.mysql.com. The original Reference Manual is in English, and this translation is not necessarily as up to date as the English version.