Debian Codegraph @

mysql-test/suite/stress/r/ddl_archive.result

raw
1 SET @@session.sql_mode = 'NO_ENGINE_SUBSTITUTION';
2 PREPARE stmt_start FROM "SELECT UNIX_TIMESTAMP() INTO @start";
3 SET @runtime = <intended_runtime>;
4 PREPARE stmt_break FROM "SELECT UNIX_TIMESTAMP() - @start > @runtime - 1";
5 connect con2,localhost,root,,;
6 connection default;
7 DROP TABLE IF EXISTS t1;
8 # Subtest 2A (one connection, no PREPARE/EXECUTE)
9 # connection action
10 # default: CREATE TABLE t1 ENGINE = ARCHIVE AS SELECT 1 AS f1
11 # default: SELECT COUNT(*) <> 1 FROM t1 WHERE f1 = 1
12 # default: DROP TABLE t1
13 # default: SELECT COUNT(*) <> 1 FROM t1 WHERE f1 = 1 (expect to get ER_NO_SUCH_TABLE)
14 # Subtest 2B (one connection, use PREPARE/EXECUTE)
15 # connection action
16 # default: CREATE TABLE t1 ENGINE = ARCHIVE AS SELECT 1 AS f1
17 # default: SELECT COUNT(*) <> 1 FROM t1 WHERE f1 = 1
18 # default: DROP TABLE t1
19 # default: SELECT COUNT(*) <> 1 FROM t1 WHERE f1 = 1 (expect to get ER_NO_SUCH_TABLE)
20 # Subtest 2C (two connections, no PREPARE/EXECUTE)
21 # connection action
22 # default: CREATE TABLE t1 ENGINE = ARCHIVE AS SELECT 1 AS f1
23 # con2: SELECT COUNT(*) <> 1 FROM t1 WHERE f1 = 1
24 # default: DROP TABLE t1
25 # con2: SELECT COUNT(*) <> 1 FROM t1 WHERE f1 = 1 (expect to get ER_NO_SUCH_TABLE)
26 # Subtest 2D (two connections, use PREPARE/EXECUTE)
27 # connection action
28 # default: CREATE TABLE t1 ENGINE = ARCHIVE AS SELECT 1 AS f1
29 # con2: SELECT COUNT(*) <> 1 FROM t1 WHERE f1 = 1
30 # default: DROP TABLE t1
31 # con2: SELECT COUNT(*) <> 1 FROM t1 WHERE f1 = 1 (expect to get ER_NO_SUCH_TABLE)
32 # Subtest 3A (one connection, no PREPARE/EXECUTE)
33 # connection action
34 # default: CREATE TABLE t1 (f1 BIGINT NOT NULL) ENGINE=ARCHIVE
35 # default: CREATE TABLE t1 (f1 BIGINT NOT NULL) ENGINE=ARCHIVE (expect to get ER_TABLE_EXISTS_ERROR)
36 # default: DROP TABLE t1
37 # default: DROP TABLE t1 (expect to get ER_BAD_TABLE_ERROR)
38 # Subtest 3B (one connection, use PREPARE/EXECUTE)
39 # connection action
40 # default: CREATE TABLE t1 (f1 BIGINT NOT NULL) ENGINE=ARCHIVE
41 # default: CREATE TABLE t1 (f1 BIGINT NOT NULL) ENGINE=ARCHIVE (expect to get ER_TABLE_EXISTS_ERROR)
42 # default: DROP TABLE t1
43 # default: DROP TABLE t1 (expect to get ER_BAD_TABLE_ERROR)
44 # Subtest 3C (two connections, no PREPARE/EXECUTE)
45 # connection action
46 # default: CREATE TABLE t1 (f1 BIGINT NOT NULL) ENGINE=ARCHIVE
47 # con2: CREATE TABLE t1 (f1 BIGINT NOT NULL) ENGINE=ARCHIVE (expect to get ER_TABLE_EXISTS_ERROR)
48 # default: DROP TABLE t1
49 # con2: DROP TABLE t1 (expect to get ER_BAD_TABLE_ERROR)
50 # Subtest 3D (two connections, use PREPARE/EXECUTE)
51 # connection action
52 # default: CREATE TABLE t1 (f1 BIGINT NOT NULL) ENGINE=ARCHIVE
53 # con2: CREATE TABLE t1 (f1 BIGINT NOT NULL) ENGINE=ARCHIVE (expect to get ER_TABLE_EXISTS_ERROR)
54 # default: DROP TABLE t1
55 # con2: DROP TABLE t1 (expect to get ER_BAD_TABLE_ERROR)
56 # Subtest 5A (one connection, no PREPARE/EXECUTE)
57 # connection action
58 # default: CREATE TABLE t1 (f1 MEDIUMINT NOT NULL AUTO_INCREMENT,f2 BIGINT, UNIQUE(f1)) ENGINE = ARCHIVE
59 # default: INSERT INTO t1 SET f2 = 9
60 # default: SELECT f1 <> 1 OR f1 IS NULL FROM t1 WHERE f2 = 9
61 # default: DROP TABLE t1
62 # Subtest 5B (one connection, use PREPARE/EXECUTE)
63 # connection action
64 # default: CREATE TABLE t1 (f1 MEDIUMINT NOT NULL AUTO_INCREMENT,f2 BIGINT, UNIQUE(f1)) ENGINE = ARCHIVE
65 # default: INSERT INTO t1 SET f2 = 9
66 # default: SELECT f1 <> 1 OR f1 IS NULL FROM t1 WHERE f2 = 9
67 # default: DROP TABLE t1
68 # Subtest 5C (two connections, no PREPARE/EXECUTE)
69 # connection action
70 # default: CREATE TABLE t1 (f1 MEDIUMINT NOT NULL AUTO_INCREMENT,f2 BIGINT, UNIQUE(f1)) ENGINE = ARCHIVE
71 # con2: INSERT INTO t1 SET f2 = 9
72 # default: SELECT f1 <> 1 OR f1 IS NULL FROM t1 WHERE f2 = 9
73 # con2: DROP TABLE t1
74 # Subtest 5D (two connections, use PREPARE/EXECUTE)
75 # connection action
76 # default: CREATE TABLE t1 (f1 MEDIUMINT NOT NULL AUTO_INCREMENT,f2 BIGINT, UNIQUE(f1)) ENGINE = ARCHIVE
77 # con2: INSERT INTO t1 SET f2 = 9
78 # default: SELECT f1 <> 1 OR f1 IS NULL FROM t1 WHERE f2 = 9
79 # con2: DROP TABLE t1
80 disconnect con2;
81 DEALLOCATE PREPARE stmt_start;
82 DEALLOCATE PREPARE stmt_break;