Comment 8 for bug 439719

Revision history for this message
fmpwizard (diego-fmpwizard) wrote :

Simplified queries:

drizzle> create database test;
drizzle> use test;
drizzle> CREATE TABLE `table1_innodb_int_autoinc` ( `enum_not_null` enum('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z') NOT NULL, `enum_key` enum('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z') DEFAULT NULL, KEY `enum_key` (`enum_key`) ) ENGINE=InnoDB;

drizzle> UPDATE `table1_innodb_int_autoinc` SET `enum_not_null` = "crash" WHERE `enum_key` = now() ;

Few notes:

* I had to make enum_key a key, otherwise there was no crash.
* "WHERE `enum_key` = now()" produces a crash, but
"WHERE `enum_key` = select 1 " does not . I could replace now() for something like convert("text", CHAR)
* The SET and WHERE clauses had to specified different columns to reproduce the crash.