GNU Info

(mysql.info)News-3.23.9

---

Next: News-3.23.8 Prev: News-3.23.10 Up: News-3.23.x

---

Enter node , (file) or (file)node

Changes in release 3.23.9
-------------------------

   * Fixed problem that affected queries that did arithmetic on group
     functions.

   * Fixed problem with timestamps and `INSERT DELAYED'.

   * Fixed that `date_column BETWEEN const_date AND const_date' works.

   * Fixed problem when only changing a 0 to `NULL' in a table with
     `BLOB/TEXT' columns.

   * Fixed bug in range optimizer when using many key parts and or on
     the middle key parts:  `WHERE K1=1 and K3=2 and (K2=2 and K4=4 or
     K2=3 and K4=5)'

   * Added command `source' to `mysql' to allow reading of batch files
     inside the `mysql' client.  Original patch by Matthew Vanecek.

   * Fixed critical problem with the `WITH GRANT OPTION' option.

   * Don't give an unnecessary `GRANT' error when using tables from many
     databases in the same query.

   * Added VIO wrapper (needed for SSL support ; By Andrei Errapart and
     Tõnu Samuel).

   * Fixed optimizer problem on `SELECT' when using many overlapping
     indexes.  MySQL should now be able to choose keys even better when
     there is many keys to choose from.

   * Changed optimizer to prefer a range key instead of a ref key when
     the range key can uses more columns than the ref key (which only
     can use columns with =).  For example, the following type of
     queries should now be faster: `SELECT * from key_part_1=const and
     key_part_2 > const2'

   * Fixed bug that a change of all `VARCHAR' columns to `CHAR' columns
     didn't change row type from dynamic to fixed.

   * Disabled floating-point exceptions for FreeBSD to fix core dump
     when doing `SELECT floor(pow(2,63))'.

   * Changed `mysqld' startup option `--delay-key-write' to
     `--delay-key-write-for-all-tables'

   * Added `read-next-on-key' to `HEAP' tables.  This should fix all
     problems with `HEAP' tables when using not `UNIQUE' keys.

   * Added print of default arguments options to all clients.

   * Added `--log-slow-queries' to `mysqld' to log all queries that
     take a long time to a separate log file with a time of how long
     the query took.

   * Fixed core dump when doing `WHERE key_column=RAND(...)'

   * Fixed optimization bug in `SELECT ... LEFT JOIN ... key_column IS
     NULL', when `key_column' could contain `NULL' values.

   * Fixed problem with 8-bit characters as separators in `LOAD DATA
     INFILE'.