Debian Codegraph @

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

raw
1 #Bug #22445211 GCOLS: SIMPLE DML, FAILING ASSERTION:
2 #!CURSOR->INDEX->IS_COMMITTED()
3 #Create and alter table examples for virtual column for full
4 #column index followed by prefix index.
5 CREATE TABLE t1(
6 f1 INT DEFAULT NULL,
7 f2 CHAR(2) GENERATED ALWAYS AS ('11') VIRTUAL,
8 f3 INT,
9 UNIQUE KEY(f1),
10 UNIQUE KEY(f3,f1),
11 KEY(f2,f1),
12 key(f1,f2(1))
13 )ENGINE=INNODB;
14 REPLACE INTO t1(f3) VALUES (1),(1);
15 DROP TABLE t1;
16 #Create and alter table examples for full column index followed by prefix index.
17 CREATE TABLE t1(
18 f1 VARCHAR(100),
19 f2 char(2),
20 KEY(f1,f2),
21 KEY(f1(5)))ENGINE=INNODB;
22 REPLACE INTO t1(f2) VALUES (1),(1);
23 ALTER TABLE t1 ADD INDEX(f2,f1);
24 DROP TABLE t1;
25 #Create and alter table examples for small prefix index followed by large
26 #prefix index.
27 CREATE TABLE t1(
28 f1 VARCHAR(100),
29 f2 char(2),
30 KEY(f1(5),f2),
31 KEY(f1(10)))ENGINE=INNODB;
32 REPLACE INTO t1(f2) VALUES (1),(1);
33 ALTER TABLE t1 ADD INDEX(f2,f1);
34 DROP TABLE t1;
35 #Create and alter table examples for prefix index followed by full column
36 #index.
37 CREATE TABLE t1(
38 f1 VARCHAR(100),
39 f2 char(2),
40 KEY(f1(5),f2),
41 KEY(f1))ENGINE=INNODB;
42 REPLACE INTO t1(f2) VALUES (1),(1);
43 ALTER TABLE t1 ADD INDEX(f2,f1);
44 DROP TABLE t1;