Debian Codegraph @

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

raw
1 --source include/innodb_page_size_small.inc
2
3 --echo #
4 --echo # MDEV-25459 MVCC read from index on CHAR or VARCHAR wrongly omits rows
5 --echo #
6
7 CREATE TABLE t1 (
8 pk int PRIMARY KEY, c varchar(255) UNIQUE,
9 d char(255), e varchar(255), f char(255), g char(255)
10 ) ENGINE=InnoDB ROW_FORMAT=DYNAMIC DEFAULT CHARACTER SET ucs2;
11
12 INSERT INTO t1 VALUES
13 (1,REPEAT('c',248),REPEAT('a',106),REPEAT('b',220),REPEAT('x',14),'');
14
15 BEGIN;
16 UPDATE t1 SET c=REPEAT('d',170);
17
18 connect (con1,localhost,root,,);
19 SELECT pk FROM t1 FORCE INDEX (c);
20 connection default;
21 COMMIT;
22 connection con1;
23 SELECT pk FROM t1 FORCE INDEX (c);
24 disconnect con1;
25 connection default;
26 DROP TABLE t1;