1
connect (a,localhost,root,,);
2
connect (b,localhost,root,,);
5
CREATE TABLE t1 (a int);
6
SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
8
INSERT INTO t1 values (1);
11
SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
13
SELECT * from t1 order by a;
16
INSERT INTO t1 values (2);
19
SELECT * from t1 order by a;
22
SELECT * FROM t1 order by a;
28
SELECT * from t1 order by a;
31
SELECT * from t1 order by a;