SQL: VIEW system fields propagation removed [fixes #393]

1 files changed, 4 insertions, 7 deletions

diff --git a/mysql-test/suite/versioning/t/view.test b/mysql-test/suite/versioning/t/view.test
index a82949673f6..e2ad96e70cc 100644
--- a/mysql-test/suite/versioning/t/view.test
+++ b/mysql-test/suite/versioning/t/view.test
@@ -69,11 +69,6 @@ create or replace view vt12 as select * from t1 for system_time as of timestamp
 select * from vt12;
 
 --echo # VIEW improvements [#183]
---error ER_VERS_VIEW_PROHIBITED
-create or replace view vt1 as select a, t1.sys_trx_start, t2.sys_trx_end from t1, t2;
---error ER_VERS_VIEW_PROHIBITED
-create or replace view vt1 as select a, t1.sys_trx_end, t2.sys_trx_end from t1, t2;
-
 create or replace table t3 (x int);
 create or replace view vt1 as select * from t1, t2, t3;
 --replace_result 18446744073709551615 MAX_RESULT "TIMESTAMP'2038-01-19 03:14:07.999999'" MAX_RESULT
@@ -89,8 +84,10 @@ show create view vt1;
 create or replace view vt1 as select * from t1 union select * from t1;
 select * from vt1;
 
---error ER_VERS_VIEW_PROHIBITED
-create or replace view vvt1 as select * from t1, t2, vt1;
+--echo # VIEW over UNION with non-versioned [#393]
+create or replace table t2 (a int);
+create or replace view vt1 as select * from t1 union select * from t2;
+select * from vt1;
 
 drop database test;
 create database test;