Some new functions, some more optimization on joins.
Should now compile clean on Linux (2.0.x).
LOG10() (needed for ODBC).
WHERE with an
ORDER BY on fields from only one table,
the table is now preferred as first table in a multi-join.
IS NULL or
IS NOT NULL now works.
A group on one column and a sort on a group function (
AVG()...) didn't work together. Fixed.
mysqldump: Didn't send password to server.
Fixed horrible locking bug when inserting in one thread and reading
in another thread.
Fixed one-off decimal bug. 1.00 was output as 1.0.
'Locked' to process list as info if a query is
locked by another query.
Fixed full magic timestamp. Timestamp length may now be 14, 12, 10, 8, 6, 4
or 2 bytes.
Sort on some numeric functions could sort incorrectly on last number.
BETWEEN to handle strings.
SELECT with grouping on
BLOB columns not to return
BLOB info. Grouping, sorting and distinct on
columns will not yet work as
expected (probably it will group/sort by the first 7 characters in the
BLOB). Grouping on formulas with a fixed string size (use
BLOB) should work.
When doing a full join (no direct keys) on multiple tables with
BLOB was garbage on output.
DISTINCT with calculated columns.