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.
Simplified queries:
drizzle> create database test; 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> use test;
drizzle> CREATE TABLE `table1_
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.