MySQL Manual | D.7.1 Changes in release 3.20.18

Added -p# (remove # directories from path) to isamlog. All files are written with a relative path from the database directory Now mysqld shouldn't crash on shutdown when using the --log-isam option.
New mysqlperl version. It is now compatible with msqlperl-0.63.
New DBD module available.
Added group function STD() (standard deviation).
The mysqld server is now compiled by default without debugging information. This will make the daemon smaller and faster.
Now one usually only has to specify the --basedir option to mysqld. All other paths are relative in a normal installation.
BLOB columns sometimes contained garbage when used with a SELECT on more than one table and ORDER BY.
Fixed that calculations that are not in GROUP BY work as expected (SQL-99 extension). Example:
```
mysql> SELECT id,id+1 FROM table GROUP BY id;
```
The test of using MYSQL_PWD was reversed. Now MYSQL_PWD is enabled as default in the default release.
Fixed conversion bug which caused mysqld to core dump with Arithmetic error on SPARC-386.
Added --unbuffered option to mysql, for new mysqlaccess.
When using overlapping (unnecessary) keys and join over many tables, the optimiser could get confused and return 0 records.

User Comments