UPDATE FOR PERIOD OF: don't crash on multi-table views

4 files changed, 26 insertions, 0 deletions

diff --git a/mysql-test/suite/period/r/delete.result b/mysql-test/suite/period/r/delete.result
index c5333dcf39a..d2ead48e2e7 100644
--- a/mysql-test/suite/period/r/delete.result
+++ b/mysql-test/suite/period/r/delete.result
@@ -288,6 +288,10 @@ id	log
 create or replace view v as select * from t;
 delete from v for portion of p from '2000-01-01' to '2018-01-01';
 ERROR 42S02: 'v' is a view
+# View can't be used
+create or replace view v as select t.* from t, t as t1;
+delete from v for portion of p from '2000-01-01' to '2018-01-01';
+ERROR 42S02: 'v' is a view
 # auto_increment field overflow
 create or replace table t (id tinyint auto_increment primary key,
 s date, e date, period for apptime(s,e));
diff --git a/mysql-test/suite/period/r/update.result b/mysql-test/suite/period/r/update.result
index 6b6e8de3081..a9e6a735a03 100644
--- a/mysql-test/suite/period/r/update.result
+++ b/mysql-test/suite/period/r/update.result
@@ -200,6 +200,14 @@ ERROR 42000: You have an error in your SQL syntax; check the manual that corresp
 set t.id= t.id + 5' at line 1
 update t1 set x= (select id from t for portion of apptime from '2000-01-01' to '2018-01-01');
 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'portion of apptime from '2000-01-01' to '2018-01-01')' at line 1
+# single-table views
+create or replace view v1 as select * from t where id<10;
+update v1 for portion of apptime from '2000-01-01' to '2018-01-01' set id= id + 5;
+ERROR 42S02: 'v1' is a view
+# multi-table views
+create or replace view v1 as select * from t, t1 where x=id;
+update v1 for portion of apptime from '2000-01-01' to '2018-01-01' set id= id + 5;
+ERROR 42S02: 'v1' is a view
 # SQL16: 14.14 <update statement: searched>, Syntax Rules, 7)a) iii-iv)
 # Let FROMVAL be <point in time 1>. FROMVAL shall not generally contain a
 # reference to a column of T or a <routine invocation>
diff --git a/mysql-test/suite/period/t/delete.test b/mysql-test/suite/period/t/delete.test
index e4fc17decf2..c83da42bd6c 100644
--- a/mysql-test/suite/period/t/delete.test
+++ b/mysql-test/suite/period/t/delete.test
@@ -131,6 +131,10 @@ create or replace view v as select * from t;
 --error ER_IT_IS_A_VIEW
 delete from v for portion of p from '2000-01-01' to '2018-01-01';
 
+--echo # View can't be used
+create or replace view v as select t.* from t, t as t1;
+--error ER_IT_IS_A_VIEW
+delete from v for portion of p from '2000-01-01' to '2018-01-01';
 
 --echo # auto_increment field overflow
 create or replace table t (id tinyint auto_increment primary key,
diff --git a/mysql-test/suite/period/t/update.test b/mysql-test/suite/period/t/update.test
index c2616cfe4a8..2ec722c5be5 100644
--- a/mysql-test/suite/period/t/update.test
+++ b/mysql-test/suite/period/t/update.test
@@ -87,6 +87,16 @@ update t for portion of apptime from '2000-01-01' to '2018-01-01', t1
 --error ER_PARSE_ERROR
 update t1 set x= (select id from t for portion of apptime from '2000-01-01' to '2018-01-01');
 
+--echo # single-table views
+create or replace view v1 as select * from t where id<10;
+--error ER_IT_IS_A_VIEW
+update v1 for portion of apptime from '2000-01-01' to '2018-01-01' set id= id + 5;
+
+--echo # multi-table views
+create or replace view v1 as select * from t, t1 where x=id;
+--error ER_IT_IS_A_VIEW
+update v1 for portion of apptime from '2000-01-01' to '2018-01-01' set id= id + 5;
+
 --echo # SQL16: 14.14 <update statement: searched>, Syntax Rules, 7)a) iii-iv)
 --echo # Let FROMVAL be <point in time 1>. FROMVAL shall not generally contain a
 --echo # reference to a column of T or a <routine invocation>