D.3.36 Modifications de la version 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 at http://www.mysql.com/Contrib site.
• 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 (ANSI SQL 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 optimizer could get confused and return 0 records.