diff options
author | Oleksandr Byelkin <sanja@mariadb.com> | 2019-12-04 15:57:09 +0100 |
---|---|---|
committer | Oleksandr Byelkin <sanja@mariadb.com> | 2019-12-04 15:57:09 +0100 |
commit | 670c9a3a182cfc3a75bc8ed847cadb2931aaaec4 (patch) | |
tree | a7e4e30ea32b49445d49502b82b04716718d2e9c /mysql-test/suite/versioning | |
parent | 81bf7d3317217f9aefb409deb0bff7169b3fe8a3 (diff) | |
parent | f6d8640d678799244cd9aede6abfd4493e139665 (diff) | |
download | mariadb-git-670c9a3a182cfc3a75bc8ed847cadb2931aaaec4.tar.gz |
Merge remote-tracking branch 'origin/bb-10.3-release' into 10.3
Diffstat (limited to 'mysql-test/suite/versioning')
-rw-r--r-- | mysql-test/suite/versioning/r/update.result | 8 | ||||
-rw-r--r-- | mysql-test/suite/versioning/t/update.test | 9 |
2 files changed, 17 insertions, 0 deletions
diff --git a/mysql-test/suite/versioning/r/update.result b/mysql-test/suite/versioning/r/update.result index 94f6f8fa998..e7c617f9196 100644 --- a/mysql-test/suite/versioning/r/update.result +++ b/mysql-test/suite/versioning/r/update.result @@ -299,5 +299,13 @@ create or replace table t1 (id int, k int, primary key (id)) engine=innodb with insert into t1 values (1,1),(2,2); create or replace view v1 as select * from t1; update v1 set id= 2 where k = 0; +create or replace table t1 (a int) with system versioning; +create or replace view v1 as select * from t1; +create or replace procedure sp() update v1 set xx = 1; +call sp; +ERROR 42S22: Unknown column 'xx' in 'field list' +call sp; +ERROR 42S22: Unknown column 'xx' in 'field list' +drop procedure sp; drop view v1; drop table t1; diff --git a/mysql-test/suite/versioning/t/update.test b/mysql-test/suite/versioning/t/update.test index 0af3c450ce5..548505bd39a 100644 --- a/mysql-test/suite/versioning/t/update.test +++ b/mysql-test/suite/versioning/t/update.test @@ -219,7 +219,16 @@ insert into t1 values (1,1),(2,2); create or replace view v1 as select * from t1; update v1 set id= 2 where k = 0; +create or replace table t1 (a int) with system versioning; +create or replace view v1 as select * from t1; +create or replace procedure sp() update v1 set xx = 1; +--error ER_BAD_FIELD_ERROR +call sp; +--error ER_BAD_FIELD_ERROR +call sp; + # cleanup +drop procedure sp; drop view v1; drop table t1; |