Debian Codegraph @

mysql-test/suite/compat/oracle/r/vcol_innodb.result

raw
1 #
2 # MDEV-27744 LPAD in vcol created in ORACLE mode makes table corrupted in non-ORACLE
3 #
4 FLUSH TABLES;
5 SET sql_mode='';
6 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;
7 INSERT INTO t VALUES (0);
8 ERROR 21S01: Column count doesn't match value count at row 1
9 SET sql_mode='ORACLE';
10 INSERT INTO t SET c=REPEAT (1,0);
11 Warnings:
12 Warning 1364 Field 'b' doesn't have a default value
13 ALTER TABLE t CHANGE COLUMN a b INT;
14 ERROR 42S22: Unknown column 'a' in 't'
15 DELETE FROM t;
16 SET sql_mode='';
17 FLUSH TABLES;
18 INSERT INTO t SET c='0';
19 Warnings:
20 Warning 1364 Field 'b' doesn't have a default value
21 DROP TABLE t;
22 FLUSH TABLES;
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 INSERT INTO t VALUES (0,0,1,0,1,0,1,0,0);
26 ERROR 21S01: Column count doesn't match value count at row 1
27 SET SESSION sql_mode='ORACLE';
28 INSERT INTO t SET c=REPEAT (1,0);
29 Warnings:
30 Warning 1364 Field 'a' doesn't have a default value
31 Warning 1364 Field 'd' doesn't have a default value
32 Warning 1364 Field 'b' doesn't have a default value
33 ALTER TABLE t CHANGE COLUMN a b CHAR(1);
34 ERROR 42S21: Duplicate column name 'b'
35 DELETE FROM t;
36 SET SESSION sql_mode=DEFAULT;
37 DROP TABLE t;
38 SET sql_mode='';
39 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;
40 INSERT INTO t1 VALUES (0);
41 ERROR 21S01: Column count doesn't match value count at row 1
42 SET sql_mode='ORACLE';
43 INSERT INTO t1 SET c=REPEAT (1,0);
44 Warnings:
45 Warning 1364 Field 'b' doesn't have a default value
46 ALTER TABLE t1 CHANGE COLUMN a b INT;
47 ERROR 42S22: Unknown column 'a' in 't1'
48 DELETE FROM t1;
49 SET sql_mode='';
50 FLUSH TABLES;
51 INSERT INTO t1 SET c='0';
52 Warnings:
53 Warning 1364 Field 'b' doesn't have a default value
54 DROP TABLE t1;