Alterações na distribuição 3.21.2
The range optimiser 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 domysqladmin 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 tomysqld
. - 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
inUPDATE
. - 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 theSELECT
part. Standard SQL should require it.