File: nonmonotone_trx_ids.test

package info (click to toggle)
mysql-8.0 8.0.43-3
  • links: PTS, VCS
  • area: main
  • in suites: sid
  • size: 1,273,924 kB
  • sloc: cpp: 4,684,605; ansic: 412,450; pascal: 108,398; java: 83,641; perl: 30,221; cs: 27,067; sql: 26,594; sh: 24,181; python: 21,816; yacc: 17,169; php: 11,522; xml: 7,388; javascript: 7,076; makefile: 2,194; lex: 1,075; awk: 670; asm: 520; objc: 183; ruby: 97; lisp: 86
file content (41 lines) | stat: -rw-r--r-- 900 bytes parent folder | download 
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
33
34
35
36
37
38
39
40
41
 
--source include/big_test.inc
--source include/have_debug.inc
--source include/count_sessions.inc

CREATE TABLE t1(id INT PRIMARY KEY, v INT NOT NULL) ENGINE=InnoDB;

--let $debug_point=trx_sys_rw_trx_add_rc
--let $debug_type=GLOBAL
--source include/add_debug_point.inc

DELIMITER |;
CREATE PROCEDURE create_rw_transactions(k INT)
 BEGIN
     WHILE 1 DO
       START TRANSACTION;
         UPDATE t1 SET v=v+1 WHERE id=k;
       COMMIT;
     END WHILE;
 END|
DELIMITER ;|
let $N=120;
let $i=0;
while($i<$N){
    --connect(C$i,localhost,root,,test)
        --eval INSERT INTO t1 (id,v) VALUES ($i,0)
        --send_eval CALL create_rw_transactions($i)
    --inc $i
}
--sleep 30
let $i=0;
while($i<$N){
    --disconnect C$i
    --inc $i
}
--connection default

DROP PROCEDURE create_rw_transactions;
DROP TABLE t1;
--source include/remove_debug_point.inc

--source include/wait_until_count_sessions.inc