Debian Codegraph @

mysql-test/suite/innodb/r/mvcc_cache.result

raw
1 #
2 # Bug #28825617 ASSERTION FAILURE: LOB0LOB.CC.*TRX == NULLPTR
3 # || TRX->IS_READ_UNCOMMITTED()
4 #
5 CREATE TABLE t1 (a INT PRIMARY KEY, b TEXT, c TEXT, INDEX (b(1)));
6 SHOW CREATE TABLE t1;
7 Table Create Table
8 t1 CREATE TABLE `t1` (
9 `a` int NOT NULL,
10 `b` text,
11 `c` text,
12 PRIMARY KEY (`a`),
13 KEY `b` (`b`(1))
14 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
15 # Connection con1:
16 INSERT INTO t1 (a, b, c) VALUES (1, 'hello', repeat('blob ', 12345));
17 BEGIN;
18 UPDATE t1 SET b=repeat('blob', 12345), c = 'world' where a = 1;
19 # Connection default:
20 set debug = '+d, innodb_cached_old_vers_offsets';
21 CHECK TABLE t1;
22 ERROR HY000: Lost connection to MySQL server during query
23 # restart
24 DROP TABLE t1;
25 #
26 # Repeat the scenario without the debug point.
27 #
28 CREATE TABLE t1 (a INT PRIMARY KEY, b TEXT, c TEXT, INDEX (b(1)));
29 SHOW CREATE TABLE t1;
30 Table Create Table
31 t1 CREATE TABLE `t1` (
32 `a` int NOT NULL,
33 `b` text,
34 `c` text,
35 PRIMARY KEY (`a`),
36 KEY `b` (`b`(1))
37 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
38 # Connection con1:
39 INSERT INTO t1 (a, b, c) VALUES (1, 'hello', repeat('blob ', 12345));
40 BEGIN;
41 UPDATE t1 SET b=repeat('blob', 12345), c = 'world' where a = 1;
42 # Connection default:
43 CHECK TABLE t1;
44 Table Op Msg_type Msg_text
45 test.t1 check status OK
46 # Connection con1:
47 commit;
48 # Connection default:
49 DROP TABLE t1;