| 1 |
SET @@session.default_storage_engine = 'archive'; |
| 2 |
create table t1 (a int, b int generated always as (a+1) virtual); |
| 3 |
ERROR HY000: 'Specified storage engine' is not supported for generated columns. |
| 4 |
create table t1 (a int); |
| 5 |
alter table t1 add column b int generated always as (a+1) virtual; |
| 6 |
ERROR HY000: 'Specified storage engine' is not supported for generated columns. |
| 7 |
drop table t1; |
| 8 |
DROP VIEW IF EXISTS v1,v2; |
| 9 |
DROP TABLE IF EXISTS t1,t2,t3; |
| 10 |
DROP PROCEDURE IF EXISTS p1; |
| 11 |
DROP FUNCTION IF EXISTS f1; |
| 12 |
DROP TRIGGER IF EXISTS trg1; |
| 13 |
DROP TRIGGER IF EXISTS trg2; |
| 14 |
set sql_warnings = 0; |