Debian Codegraph @

mysql-test/suite/gcol/r/gcol_merge.result

raw
1 drop table if exists t1, t2, t3;
2 create table t1 (a int, b int generated always as (a % 10) virtual);
3 create table t2 (a int, b int generated always as (a % 10) virtual);
4 insert into t1 values (1,default);
5 insert into t2 values (2,default);
6 create table t3 (a int, b int generated always as (a % 10) virtual) engine=MERGE UNION=(t1,t2);
7 ERROR HY000: 'Specified storage engine' is not supported for generated columns.
8 drop table t1,t2;
9 DROP VIEW IF EXISTS v1,v2;
10 DROP TABLE IF EXISTS t1,t2,t3;
11 DROP PROCEDURE IF EXISTS p1;
12 DROP FUNCTION IF EXISTS f1;
13 DROP TRIGGER IF EXISTS trg1;
14 DROP TRIGGER IF EXISTS trg2;
15 set sql_warnings = 0;