1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
|
--source include/have_linux.inc
--source include/have_valgrind.inc
SET SESSION storage_engine=pbxt;
connect (con1,localhost,root,,);
connect (con2,localhost,root,,);
connection con1;
CREATE TABLE t1 (a int primary key);
INSERT INTO t1 VALUES (1),(2),(3),(4),(5),(6),(7),(8),(9),(10), (11),(12),(13),(14),(15),(16),(17),(18),(19),(20), (21),(22),(23),(24),(25),(26),(27),(28),(29),(30), (31),(32);
connection con2;
select count(*) from t1;
connection con1;
INSERT INTO t1 VALUES (33),(34),(35),(36),(37),(38),(39),(40),(41),(42);
COMMIT;
SELECT count(*) from t1;
disconnect con1;
disconnect con2;
connection default;
DROP TABLE t1;
|