Debian Codegraph @

mysql-test/suite/stress/r/ddl_csv.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 = CSV 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 = CSV 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 = CSV 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 = CSV 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=CSV
35 # default: CREATE TABLE t1 (f1 BIGINT NOT NULL) ENGINE=CSV (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=CSV
41 # default: CREATE TABLE t1 (f1 BIGINT NOT NULL) ENGINE=CSV (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=CSV
47 # con2: CREATE TABLE t1 (f1 BIGINT NOT NULL) ENGINE=CSV (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=CSV
53 # con2: CREATE TABLE t1 (f1 BIGINT NOT NULL) ENGINE=CSV (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 disconnect con2;
57 DEALLOCATE PREPARE stmt_start;
58 DEALLOCATE PREPARE stmt_break;