Debian Codegraph @

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

raw
1 --echo #
2 --echo # MDEV-13500 sql_mode=ORACLE: can't create a virtual column with function MOD
3 --echo #
4
5 SET sql_mode=ORACLE;
6 CREATE TABLE t1 (c1 INTEGER, c2 INTEGER AS (c1 MOD 10) VIRTUAL);
7 SHOW CREATE TABLE t1;
8 INSERT INTO t1 (c1) VALUES (999);
9 SELECT * FROM t1;
10 DROP TABLE t1;
11
12 CREATE TABLE t1 (a INT);
13 CREATE VIEW v1 AS SELECT a MOD 10 FROM t1;
14 SHOW CREATE VIEW v1;
15 DROP VIEW v1;
16 DROP TABLE t1;