Debian Codegraph @

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

raw
1 #
2 # wl#8919 InnoDB: Implement NOWAIT and SKIP LOCKED
3 #
4
5 --source include/count_sessions.inc
6
7 # Test different transaction isolation levels
8
9 connect (con1,localhost,root,,);
10 SET SESSION innodb_lock_wait_timeout=1;
11
12 connection default;
13 SET SESSION innodb_lock_wait_timeout=1;
14
15 let $trx_isolation_level = READ UNCOMMITTED;
16 let $for_share = FOR SHARE;
17 --source suite/innodb/include/skip_locked_nowait_isolation.inc
18
19 let $trx_isolation_level = READ COMMITTED;
20 let $for_share = FOR SHARE;
21 --source suite/innodb/include/skip_locked_nowait_isolation.inc
22
23 let $trx_isolation_level = REPEATABLE READ;
24 let $for_share = FOR SHARE;
25 --source suite/innodb/include/skip_locked_nowait_isolation.inc
26
27 let $trx_isolation_level = SERIALIZABLE;
28 # Serializable will lock records by default.
29 let $for_share =;
30 --source suite/innodb/include/skip_locked_nowait_isolation.inc
31
32 connection default;
33 disconnect con1;
34
35 --source include/wait_until_count_sessions.inc