1
2
3
4
5
6
7
8
9
10
11
12
|
# Lets see if we wait!
CREATE TABLE t1 (A VARCHAR(150));
SET @execute= "SELECT WAIT('barrier')";
INSERT INTO t1 VALUES ("CREATE TABLE A (A INT)"), ("CREATE TABLE B (A INT)"), ("CREATE TABLE C (A INT)");
SELECT A FROM t1 ORDER BY A;
SELECT EXECUTE(A) WAIT, 1 FROM t1;
SELECT TABLE_NAME FROM DATA_DICTIONARY.TABLES WHERE TABLE_SCHEMA=SCHEMA() ORDER BY TABLE_NAME;
SELECT IF((COUNT(TABLE_NAME) = 3), "YES", "NO") FROM DATA_DICTIONARY.TABLES WHERE TABLE_NAME IN ("A", "B", "C") AND TABLE_SCHEMA=SCHEMA();
DROP TABLE A;
DROP TABLE B;
DROP TABLE C;
DROP TABLE t1;
|