Debian Codegraph @

mysql-test/suite/galera/t/galera_pk_bigint_signed.test

raw
1 #
2 # PK that is a BIGINT SIGNED
3 #
4
5 --source include/galera_cluster.inc
6 --source include/have_innodb.inc
7
8 CREATE TABLE t1 (f1 BIGINT SIGNED PRIMARY KEY, f2 VARCHAR(5)) ENGINE=InnoDB;
9
10 INSERT INTO t1 VALUES
11 (-9223372036854775808, 'min'),
12 (9223372036854775807, 'max')
13 ;
14
15 --connection node_2
16 SELECT * FROM t1;
17
18 UPDATE t1 SET f2 = CONCAT(f2, '_');
19
20 --connection node_1
21 SELECT * FROM t1;
22
23 #
24 # Deadlock
25 #
26
27 --connection node_1
28 SET AUTOCOMMIT=OFF;
29 START TRANSACTION;
30 UPDATE t1 SET f2 = 'foo' WHERE f1 = -9223372036854775808;
31
32 --connection node_2
33 SET AUTOCOMMIT=OFF;
34 START TRANSACTION;
35 UPDATE t1 SET f2 = 'bar' WHERE f1 = -9223372036854775808;
36
37 --connection node_1
38 COMMIT;
39 SET AUTOCOMMIT=ON;
40
41 --connection node_2
42 --error ER_LOCK_DEADLOCK
43 COMMIT;
44 SET AUTOCOMMIT=ON;
45
46 DROP TABLE t1;