Debian Codegraph @

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

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