|
1976.7.4
by Brian Aker
Added WAIT to the execute() function. |
1 |
# Lets see if we wait!
|
2 |
CREATE TABLE t1 (A VARCHAR(150));
|
|
3 |
SET @execute= "SELECT WAIT('barrier')";
|
|
4 |
INSERT INTO t1 VALUES ("CREATE TABLE A (A INT)"), ("CREATE TABLE B (A INT)"), ("CREATE TABLE C (A INT)");
|
|
5 |
SELECT A FROM t1 ORDER BY A;
|
|
6 |
SELECT EXECUTE(A) WAIT, 1 FROM t1;
|
|
7 |
SELECT TABLE_NAME FROM DATA_DICTIONARY.TABLES WHERE TABLE_SCHEMA=SCHEMA() ORDER BY TABLE_NAME;
|
|
8 |
SELECT IF((COUNT(TABLE_NAME) = 3), "YES", "NO") FROM DATA_DICTIONARY.TABLES WHERE TABLE_NAME IN ("A", "B", "C") AND TABLE_SCHEMA=SCHEMA();
|
|
|
1990
by Brian Aker
Fixed table issue (I was not removing some tables after the test was done). |
9 |
DROP TABLE A;
|
10 |
DROP TABLE B;
|
|
11 |
DROP TABLE C;
|
|
|
1976.7.4
by Brian Aker
Added WAIT to the execute() function. |
12 |
DROP TABLE t1;
|