← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to plugin/utility_functions/tests/t/execute_wait.test

  • Committer: Lee Bieber
  • Date: 2011-01-21 05:20:24 UTC
  • mfrom: (2099.1.3 build)
  • Revision ID: kalebral@gmail.com-20110121052024-43pl0aj8j5fmqnvl
Merge Stewart - Fix bug 664222: DDL operations have an implicit commit
Merge Stewart - Fix bug #695201: autocommit=1 not resetting session->server_status properly when committing ongoing txn
Add BSD copyright file to win32/config.h
Merge Brian - cleanup user_locks.kill_wait test

Show diffs side-by-side

added added

removed removed

Lines of Context:
plugin/utility_functions/tests/t/execute_wait.test
6
6
SELECT EXECUTE(A) WAIT, 1 FROM t1;
7
7
SELECT TABLE_NAME FROM DATA_DICTIONARY.TABLES WHERE TABLE_SCHEMA=SCHEMA() ORDER BY TABLE_NAME;
8
8
SELECT IF((COUNT(TABLE_NAME) = 3), "YES", "NO") FROM DATA_DICTIONARY.TABLES WHERE TABLE_NAME IN ("A", "B", "C") AND TABLE_SCHEMA=SCHEMA();
9
 
DROP TABLE A;
10
 
DROP TABLE B;
11
 
DROP TABLE C;
12
9
DROP TABLE t1;
 
10
 
 
11
CREATE TABLE t1 (A VARCHAR(150));
 
12
SET @execute= "SELECT WAIT('barrier')";
 
13
INSERT INTO t1 VALUES ("COMMIT; CREATE TABLE A (A INT)"), ("COMMIT; CREATE TABLE B (A INT)"), ("CREATE TABLE C (A INT)");
 
14
SELECT A FROM t1 ORDER BY A;
 
15
SELECT EXECUTE(A) WAIT, 1 FROM t1;
 
16
SELECT TABLE_NAME FROM DATA_DICTIONARY.TABLES WHERE TABLE_SCHEMA=SCHEMA() ORDER BY TABLE_NAME;
 
17
SELECT IF((COUNT(TABLE_NAME) = 2), "YES", "NO") FROM DATA_DICTIONARY.TABLES WHERE TABLE_NAME IN ("A", "B", "C") AND TABLE_SCHEMA=SCHEMA();
 
18
DROP TABLE A, B, t1;
 
19