Comment 3 for bug 1384632

Revision history for this message
Ramesh Sivaraman (rameshvs02) wrote :

******* Testcase

DROP DATABASE test;CREATE DATABASE test;USE test;
CREATE TABLE t1(c1 INT NOT NULL,c2 CHAR NOT NULL)ENGINE=csv;
CREATE TABLE t3(c1 INT UNSIGNED NOT NULL,c2 INT NULL,c3 INT,c4 INT,c5 INT,c6 INT,c7 INT,index idx(c2,c7));
LOCK TABLES t1 WRITE,t3 WRITE;
INSERT INTO t1 VALUES(0,0);
select get_lock('test3',0);
check table t1 extended;
LOCK TABLES performance_schema.table_io_waits_summary_by_table WRITE;
xa start 'test2';
SELECT COUNT(*)FROM information_schema.key_column_usage;