Debian Codegraph @

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

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