Debian Codegraph @

mysql-test/suite/compat/oracle/t/vcol_innodb.test

raw
1 --source include/have_innodb.inc
2
3 --echo #
4 --echo # MDEV-27744 LPAD in vcol created in ORACLE mode makes table corrupted in non-ORACLE
5 --echo #
6
7 FLUSH TABLES;
8 SET sql_mode='';
9 CREATE TABLE t (d INT,b VARCHAR(1),c CHAR(1),g CHAR(1) GENERATED ALWAYS AS (SUBSTR(b,0,0)) VIRTUAL,PRIMARY KEY(b),KEY g(g)) ENGINE=InnoDB;
10 --error ER_WRONG_VALUE_COUNT_ON_ROW
11 INSERT INTO t VALUES (0);
12 SET sql_mode='ORACLE';
13 INSERT INTO t SET c=REPEAT (1,0);
14 --error ER_BAD_FIELD_ERROR
15 ALTER TABLE t CHANGE COLUMN a b INT;
16 DELETE FROM t;
17 SET sql_mode='';
18 FLUSH TABLES;
19 INSERT INTO t SET c='0';
20 DROP TABLE t;
21 FLUSH TABLES;
22
23 SET sql_mode='';
24 CREATE TABLE t (a INT(1),d INT(1),b VARCHAR(1),c CHAR(1),vadc INT(1) GENERATED ALWAYS AS ( (a + length (d))) STORED,vbc CHAR(1) GENERATED ALWAYS AS (SUBSTR(b,0,0)) VIRTUAL,vbidxc CHAR(1) GENERATED ALWAYS AS (SUBSTR(b,0,0)) VIRTUAL,PRIMARY KEY(b (1),a,d),KEY d (d),KEY a (a),KEY c_renamed (c (1),b (1)),KEY b (b (1),c (1),a),KEY vbidxc (vbidxc),KEY a_2 (a,vbidxc),KEY vbidxc_2 (vbidxc,d)) DEFAULT CHARSET=latin1 ENGINE=InnoDB;
25 --error ER_WRONG_VALUE_COUNT_ON_ROW
26 INSERT INTO t VALUES (0,0,1,0,1,0,1,0,0);
27 SET SESSION sql_mode='ORACLE';
28 INSERT INTO t SET c=REPEAT (1,0);
29 --error ER_DUP_FIELDNAME
30 ALTER TABLE t CHANGE COLUMN a b CHAR(1);
31 DELETE FROM t;
32 SET SESSION sql_mode=DEFAULT;
33 DROP TABLE t;
34
35 SET sql_mode='';
36 CREATE TABLE t1 (d INT,b VARCHAR(1),c CHAR(1),g CHAR(1) GENERATED ALWAYS AS (SUBSTR(b,0,0)) VIRTUAL,PRIMARY KEY(b),KEY g(g)) ENGINE=InnoDB;
37 --error ER_WRONG_VALUE_COUNT_ON_ROW
38 INSERT INTO t1 VALUES (0);
39 SET sql_mode='ORACLE';
40 INSERT INTO t1 SET c=REPEAT (1,0);
41 --error ER_BAD_FIELD_ERROR
42 ALTER TABLE t1 CHANGE COLUMN a b INT;
43 DELETE FROM t1;
44 SET sql_mode='';
45 FLUSH TABLES;
46 INSERT INTO t1 SET c='0';
47 DROP TABLE t1;