diff options
Diffstat (limited to 'mysql-test/suite/versioning/r/alter.result')
-rw-r--r-- | mysql-test/suite/versioning/r/alter.result | 15 |
1 files changed, 9 insertions, 6 deletions
diff --git a/mysql-test/suite/versioning/r/alter.result b/mysql-test/suite/versioning/r/alter.result index 5092adc2b11..b2dbbba7027 100644 --- a/mysql-test/suite/versioning/r/alter.result +++ b/mysql-test/suite/versioning/r/alter.result @@ -199,6 +199,8 @@ a 2 1 select row_start from t where a=3 into @tm; +Warnings: +Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead alter table t add column b int; select @tm=row_start from t where a=3; @tm=row_start @@ -448,11 +450,11 @@ alter table t1 engine=myisam; # MDEV-14692 crash in MDL_context::upgrade_shared_lock() create or replace temporary table t (a int); alter table t change column if exists b c bigint unsigned generated always as row start; -ERROR HY000: TEMPORARY tables do not support system versioning +ERROR HY000: System-versioned tables do not support CREATE TEMPORARY TABLE alter table t change column if exists b c bigint unsigned generated always as row end; -ERROR HY000: TEMPORARY tables do not support system versioning +ERROR HY000: System-versioned tables do not support CREATE TEMPORARY TABLE alter table t add system versioning; -ERROR HY000: TEMPORARY tables do not support system versioning +ERROR HY000: System-versioned tables do not support CREATE TEMPORARY TABLE drop table t; # MDEV-14744 trx_id-based and transaction-based mixup in assertion create or replace table t (c text) engine=innodb with system versioning; @@ -528,9 +530,9 @@ ERROR HY000: Table `t` is already system-versioned # use mysql; create or replace table t (x int) with system versioning; -ERROR HY000: System versioning tables in the `mysql` database are not supported -alter table user add system versioning; -ERROR HY000: System versioning tables in the `mysql` database are not supported +ERROR HY000: System-versioned tables in the `mysql` database are not supported +alter table db add system versioning; +ERROR HY000: System-versioned tables in the `mysql` database are not supported use test; # MDEV-15956 Strange ER_UNSUPPORTED_ACTION_ON_GENERATED_COLUMN upon ALTER on versioning column create or replace table t1 (i int, j int as (i), s timestamp(6) as row start, e timestamp(6) as row end, period for system_time(s,e)) with system versioning; @@ -546,6 +548,7 @@ alter table t add check (a > 0); insert into t values (0); ERROR 23000: CONSTRAINT `CONSTRAINT_1` failed for `test`.`t` insert into t values (2); +drop table t; # # MDEV-18869 Assertion `!((field)->vcol_info && (field)->stored_in_db())' failed in innodb_col_no upon altering table with system versioning # |