In the Raghu's test, the problem is due to: CREATE TABLE LIKE t, where t is a temporary table. Here is a simple test to reliably crash the slave:
mysql> create table pp (i int); mysql> insert into pp values (1); mysql> create temporary table pptmp (i int, j int); mysql> insert into pptmp values (1,2); mysql> drop table pp; mysql> create table pp like pptmp; mysql> insert into pp values (1,2);
In the Raghu's test, the problem is due to: CREATE TABLE LIKE t, where t is a temporary table.
Here is a simple test to reliably crash the slave:
mysql> create table pp (i int);
mysql> insert into pp values (1);
mysql> create temporary table pptmp (i int, j int);
mysql> insert into pptmp values (1,2);
mysql> drop table pp;
mysql> create table pp like pptmp;
mysql> insert into pp values (1,2);