diff options
Diffstat (limited to 'mysql-test/suite/gcol/r/gcol_merge.result')
| -rw-r--r-- | mysql-test/suite/gcol/r/gcol_merge.result | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/mysql-test/suite/gcol/r/gcol_merge.result b/mysql-test/suite/gcol/r/gcol_merge.result new file mode 100644 index 00000000..bffe6265 --- /dev/null +++ b/mysql-test/suite/gcol/r/gcol_merge.result @@ -0,0 +1,15 @@ +drop table if exists t1, t2, t3; +create table t1 (a int, b int generated always as (a % 10) virtual); +create table t2 (a int, b int generated always as (a % 10) virtual); +insert into t1 values (1,default); +insert into t2 values (2,default); +create table t3 (a int, b int generated always as (a % 10) virtual) engine=MERGE UNION=(t1,t2); +ERROR HY000: MRG_MyISAM storage engine does not support generated columns +drop table t1,t2; +DROP VIEW IF EXISTS v1,v2; +DROP TABLE IF EXISTS t1,t2,t3; +DROP PROCEDURE IF EXISTS p1; +DROP FUNCTION IF EXISTS f1; +DROP TRIGGER IF EXISTS trg1; +DROP TRIGGER IF EXISTS trg2; +set sql_warnings = 0; |