Debian Codegraph @

mysql-test/suite/maria/concurrent.result

raw
1 CREATE TABLE t1 (a INT, b CHAR(12), c INT, FULLTEXT KEY(b), KEY (c)) ENGINE=Aria;
2 CREATE TABLE t2 (a INT, b CHAR(12), c INT) ENGINE=Aria;
3 INSERT INTO t2 VALUES (1,'foo',8), (2,'bar',9);
4 connect con1,localhost,root,,test;
5 INSERT INTO t1 SELECT * FROM t2;
6 connection default;
7 select 1;
8 1
9 1
10 select 1;
11 1
12 1
13 select 1;
14 1
15 1
16 select 1;
17 1
18 1
19 select 1;
20 1
21 1
22 select 1;
23 1
24 1
25 select 1;
26 1
27 1
28 SELECT * FROM t1 WHERE a = ( SELECT 1 FROM non_existing_table2 );
29 ERROR 42S02: Table 'test.non_existing_table2' doesn't exist
30 connection con1;
31 disconnect con1;
32 connection default;
33 DROP TABLE t1, t2;