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