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
isamlibrary should be relatively 64-bit clean. - New
isamchkwhich 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,8to 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 TABLEnow 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_nameinUPDATE. - Fixed
SELECT DISTINCTwhen using 'hidden group'. For example:mysql>
SELECT DISTINCT MOD(some_field,10) FROM test->GROUP BY some_field;Note:
some_fieldis normally in theSELECTpart. Standard SQL should require it.