percona-server-test-5.6 5.6.22-rel71.0-0ubuntu4 / usr / lib / mysql-testsuite / t / bug1294190.test

##############################################################################
# Bug 1294190: Crash when selecting from GLOBAL_TEMPORARY_TABLES
##############################################################################

source include/have_debug.inc;
source include/have_debug_sync.inc;

connect(con1,localhost,root,,,);
connection default;

CREATE TABLE foo (id SERIAL PRIMARY KEY) ENGINE=innodb;
INSERT INTO foo SELECT NULL;
INSERT INTO foo SELECT NULL FROM foo;

SET DEBUG_SYNC="after_open_altered_table signal open_done wait_for select_done";

SEND ALTER TABLE foo ADD COLUMN x INT, ADD KEY (x), ALGORITHM=INPLACE;

connection con1;

SET DEBUG_SYNC="now wait_for open_done";

SELECT TABLE_SCHEMA, ENGINE, TABLE_ROWS
        FROM INFORMATION_SCHEMA.GLOBAL_TEMPORARY_TABLES;

SET DEBUG_SYNC = "now signal select_done";

connection default;

reap;

disconnect con1;

DROP TABLE foo;