(mysql.info.gz) Errors in 3

 
 1.5.7.1 Errors in 3.23 Fixed in a Later MySQL Version
 .....................................................
 
 The following known errors or bugs are not fixed in MySQL 3.23 because
 fixing them would involve changing a lot of code that could introduce
 other even worse bugs. The bugs are also classified as "not fatal" or
 "bearable."
 
    * You should avoid using spaces at the end of column names because
      this can cause weird behavior. (Fixed in MySQL 4.0.) (Bug #4196)
 
    * You can get a deadlock (hung thread) if you use `LOCK TABLE' to
      lock multiple tables and then in the same connection use `DROP
      TABLE' to drop one of them while another thread is trying to lock
      it.  (To break the deadlock, you can use `KILL' to terminate any
      of the threads involved.)  This issue is resolved as of MySQL
      4.0.12.
 
    * `SELECT MAX(key_column) FROM t1,t2,t3...' where one of the tables
      are empty doesn't return `NULL' but instead returns the maximum
      value for the column.  This issue is resolved as of MySQL 4.0.11.
 
    * `DELETE FROM heap_table' without a `WHERE' clause doesn't work on
      a locked `HEAP' table.

Info Catalog

(mysql.info.gz) Bugs

(mysql.info.gz) Errors in 4

automatically generated byinfo2html