Debian Codegraph @

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

raw
1 #
2 # This checks that even tables with a single long VARCHARcolumn and no FK are replicated properly
3 #
4
5 --source include/galera_cluster.inc
6 --source include/have_innodb.inc
7
8 # From the Innodb manual: "The maximum row length, except for variable-length columns (VARBINARY, VARCHAR, BLOB and TEXT),
9 # is slightly less than half of a database page. That is, the maximum row length is about 8000 bytes"
10
11 CREATE TABLE t1 (f1 VARCHAR(8000)) ENGINE=InnoDB;
12 INSERT INTO t1 VALUES (NULL),(CONCAT(REPEAT('x', 7999), 'a'));
13
14 --connection node_2
15 SELECT LENGTH(f1) FROM t1;
16
17 DELETE FROM t1 WHERE f1 IS NULL;
18 UPDATE t1 SET f1 = CONCAT(REPEAT('x', 7999), 'b') WHERE f1 = CONCAT(REPEAT('x', 7999), 'a');
19
20 --connection node_1
21 SELECT COUNT(*) = 1 FROM t1;
22 SELECT LENGTH(f1) = 8000 FROM t1;
23 SELECT f1 = CONCAT(REPEAT('x', 7999), 'b') FROM t1;
24
25 #
26 # Provoke a conflict
27 #
28
29 --connection node_1
30 CREATE TABLE t2 (f1 BLOB) ENGINE=InnoDB;
31 INSERT INTO t2 VALUES (CONCAT(REPEAT('x', 7999), 'a'));
32
33 SET AUTOCOMMIT=OFF;
34 START TRANSACTION;
35 UPDATE t2 SET f1 = 'abc' WHERE f1 = CONCAT(REPEAT('x', 7999), 'a');
36
37 --connection node_2
38 SET AUTOCOMMIT=OFF;
39 START TRANSACTION;
40 UPDATE t2 SET f1 = 'xyz' WHERE f1 = CONCAT(REPEAT('x', 7999), 'a');
41
42 --connection node_1
43 COMMIT;
44
45 --connection node_2
46 --error ER_LOCK_DEADLOCK
47 COMMIT;
48
49 DROP TABLE t1;
50 DROP TABLE t2;