| 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; |