1.8.6.1 Errors in 3.23 Fixed in a Later MySQL Version

The following known errors/bugs are not fixed in MySQL 3.23 because fixing them would involves changing a lot of code which could introduce other even worse bugs. The bugs are also classified as 'not fatal' or 'bearable'.

• One can get a deadlock when doing LOCK TABLE on multiple tables and then in the same connection doing a DROP TABLE on one of them while another thread is trying to lock the table. One can however do a KILL on any of the involved threads to resolve this. Fixed in 4.0.12.
• SELECT MAX(key_column) FROM t1,t2,t3... where one of the tables are empty doesn't return NULL but instead the maximum value for the column. Fixed in 4.0.11.
• DELETE FROM heap_table without a WHERE doesn't work on a locked HEAP table.

User Comments

Add your own comment.