Debian Codegraph @

mysql-test/suite/innodb/t/innodb-virtual-columns2.test

raw
1 --source include/have_innodb.inc
2
3 #
4 # MDEV-11724: InnoDB: Failing assertion: len <= col->len || ((col->mtype) == 5 || (col->mtype) == 16 || (col->mtype) == 14) || (((col->mtype) == 15 || (col->mtype) == 16) && len == 2 * 2 * sizeof(double)) || (col->len == 0 && col->mtype == 1)
5 #
6
7 CREATE TABLE t1 (
8 y YEAR NULL,
9 i SMALLINT NULL,
10 c VARCHAR(8) NOT NULL DEFAULT '',
11 vi SMALLINT AS (i) VIRTUAL,
12 INDEX(y)
13 ) ENGINE=InnoDB;
14
15 SHOW CREATE TABLE t1;
16 SELECT * FROM t1 WHERE y BETWEEN 2012 AND 2016 FOR UPDATE;
17 INSERT INTO t1 (i) VALUES (1),(2);
18 SELECT * FROM t1 WHERE y BETWEEN 2012 AND 2016 FOR UPDATE;
19 DROP TABLE t1;
20
21 #
22 # MDEV-11725: InnoDB: Failing assertion: !rec || !cmp_dtuple_rec(tuple, rec, *offsets)
23 #
24
25 CREATE TABLE t1 (
26 y YEAR NULL,
27 i SMALLINT NULL,
28 vi SMALLINT AS (i) VIRTUAL,
29 INDEX(y)
30 ) ENGINE=InnoDB;
31
32 SHOW CREATE TABLE t1;
33 SELECT * FROM t1 WHERE y BETWEEN 2012 AND 2016 FOR UPDATE;
34 INSERT INTO t1 (i) VALUES (1),(2);
35 SELECT * FROM t1 WHERE y BETWEEN 2012 AND 2016 FOR UPDATE;
36 DROP TABLE t1;
37
38 #
39 # MDEV-11726: Server crashes in mach_read_from_n_little_endian
40 #
41
42 CREATE TABLE t1 (
43 y YEAR NULL,
44 i SMALLINT NULL,
45 b BLOB NULL,
46 vi SMALLINT AS (i) VIRTUAL,
47 INDEX(y)
48 ) ENGINE=InnoDB;
49
50 SHOW CREATE TABLE t1;
51 SELECT * FROM t1 WHERE y BETWEEN 2012 AND 2016 FOR UPDATE;
52 INSERT INTO t1 (i) VALUES (1),(2);
53 SELECT * FROM t1 WHERE y BETWEEN 2012 AND 2016 FOR UPDATE;
54 DROP TABLE t1;
55
56 --echo #
57 --echo # MDEV-23632 ALTER TABLE...ADD KEY creates corrupted index on virtual column
58 --echo #
59
60 CREATE TABLE t1(a INT PRIMARY KEY, b INT, g INT GENERATED ALWAYS AS(b)VIRTUAL) ENGINE=InnoDB;
61 INSERT INTO t1 VALUES (1,1,default);
62 ALTER TABLE t1 ADD COLUMN c INT;
63 ALTER TABLE t1 ADD KEY(g);
64 CHECK TABLE t1;
65 SELECT g FROM t1 FORCE INDEX (g);
66 DROP TABLE t1;
67
68 CREATE TABLE t1(a INT, b INT, g INT GENERATED ALWAYS AS(b)VIRTUAL) ENGINE=InnoDB;
69 INSERT INTO t1 VALUES (1,1,default);
70 ALTER TABLE t1 ADD COLUMN c INT PRIMARY KEY; # Triggers `new_clustered`
71 ALTER TABLE t1 ADD KEY(g);
72 CHECK TABLE t1;
73 SELECT g FROM t1 FORCE INDEX (g);
74 DROP TABLE t1;