Debian Codegraph @

mysql-test/suite/innodb/t/high_prio_trx_predicate.test

raw
1 # Scenario:
2 # T1=({R(B)})
3 # T2=({W(B)})
4 # T3=({W(B), C}, HIGH_PRIORITY).
5 #
6 # Outcome: T1 must abort, T2 must commit.
7
8 --source include/count_sessions.inc
9
10 CREATE TABLE tab(c1 int NOT NULL PRIMARY KEY,c2 POINT NOT NULL SRID 0);
11 CREATE SPATIAL INDEX idx1 on tab(c2);
12 INSERT INTO tab(c1,c2) VALUES(1,ST_GeomFromText('POINT(10 10)'));
13
14 --connect(con1,localhost,root,,test)
15 --connect(con2,localhost,root,,test)
16 --connect(con3,localhost,root,,test)
17
18 --echo
19 --echo # On connection 1
20 --connection con1
21 set transaction isolation level serializable ;
22 START TRANSACTION;
23 SELECT ST_AsText(c2) FROM tab WHERE MBRWithin(c2, ST_GeomFromText('POLYGON((5 5, 15 5, 15 15, 5 15, 5 5))'));
24
25
26 --echo
27 --echo # On connection 2
28 --connection con2
29 start transaction;
30 --send INSERT INTO tab(c1,c2) VALUES(7, ST_GeomFromText('POINT(11 11)'));
31
32 --echo
33 --echo # On connection 3
34 --connection con3
35 --source include/start_transaction_high_prio.inc
36 INSERT INTO tab(c1,c2) VALUES(8, ST_GeomFromText('POINT(10 10)'));
37 COMMIT;
38 --disconnect con3
39
40 --echo
41 --echo # On connection 1
42 --connection con1
43 --error ER_ERROR_DURING_COMMIT
44 COMMIT;
45 --disconnect con1
46
47 --connection default
48 --let $assert_text= 'There is a 8 in tab'
49 --let $assert_cond= [SELECT COUNT(*) AS count FROM tab WHERE tab.c1 = 8, count, 1] = 1
50 --source include/assert.inc
51
52 --connection con2
53 --reap;
54 --disconnect con2
55
56 --connection default
57 SELECT c1 FROM tab;
58
59 DROP TABLE tab;
60
61 --source include/wait_until_count_sessions.inc