Debian Codegraph @

mysql-test/suite/gcol/t/main_alter_table.test

raw
1 --source include/have_innodb.inc
2
3 --echo #
4 --echo # Bug#22017616: ASSERTION FAILED: TABLE_SHARE->IS_MISSING_PRIMARY_KEY()
5 --echo # == M_PREBUILT->CLUST_IND
6 --echo #
7 --echo # Ensure that adding indexes with virtual columns are not promoted to
8 --echo # primary keys
9 --echo #
10 --echo # Base line with normal column - should be promoted
11 CREATE TABLE t0(a INT NOT NULL) ENGINE=INNODB;
12 ALTER TABLE t0 ADD UNIQUE INDEX (a);
13
14 --echo # Case a: Create table with virtual unique not null column
15 CREATE TABLE t1(a POINT GENERATED ALWAYS AS (POINT(1,1)) VIRTUAL UNIQUE) ENGINE=INNODB;
16 SELECT * FROM t1;
17
18 --echo # Case b: Create table with index on virtual point column
19 CREATE TABLE t2(a POINT GENERATED ALWAYS AS (POINT(1,1)) VIRTUAL, UNIQUE INDEX no_pk(a(1))) ENGINE=INNODB;
20 SELECT * FROM t2;
21
22 --echo # Case c: Add unique index on virtual point column
23 CREATE TABLE t3(a POINT GENERATED ALWAYS AS (POINT(1,1)) VIRTUAL)
24 ENGINE=INNODB;
25 ALTER TABLE t3 ADD UNIQUE INDEX (a(1));
26 SELECT * FROM t3;
27
28 --echo # Case d: Add unique index on virtual blob column
29 CREATE TABLE t4 (a BLOB, b BLOB GENERATED ALWAYS AS (a) VIRTUAL) ENGINE=INNODB;
30 ALTER TABLE t4 ADD UNIQUE INDEX (b(1));
31 SELECT * FROM t4;
32
33 --echo # Query I_S to verify that 'a' is promoted to pk only when it
34 --echo # isn't virtual
35 SELECT T.NAME AS TABLE_NAME, I.NAME AS INDEX_NAME,
36 CASE (I.TYPE & 3)
37 WHEN 3 THEN "yes"
38 ELSE "no" END AS IS_PRIMARY_KEY,
39 F.NAME AS FIELD_NAME, F.POS AS FIELD_POS FROM
40 INFORMATION_SCHEMA.INNODB_SYS_TABLES AS T JOIN
41 INFORMATION_SCHEMA.INNODB_SYS_INDEXES AS I JOIN
42 INFORMATION_SCHEMA.INNODB_SYS_FIELDS AS F
43 ON I.INDEX_ID = F.INDEX_ID AND I.TABLE_ID = T.TABLE_ID
44 WHERE T.NAME LIKE 'test/t%';
45
46 DROP TABLE t0;
47 DROP TABLE t1;
48 DROP TABLE t2;
49 DROP TABLE t3;
50 DROP TABLE t4;