diff options
author | kevg <claprix@yandex.ru> | 2017-01-31 22:41:38 +0300 |
---|---|---|
committer | Aleksey Midenkov <midenok@gmail.com> | 2017-05-05 20:36:27 +0300 |
commit | 7aa3ebdd189c1ba5b8556959839362514190dbd1 (patch) | |
tree | 41a030d0603ea37c7048e386bc1b837425ec3d00 /mysql-test/suite/versioning/r/view.result | |
parent | 5853266fab57fa695403f260fed97257bc31f13b (diff) | |
download | mariadb-git-7aa3ebdd189c1ba5b8556959839362514190dbd1.tar.gz |
SQL, Tests: FOR SYSTEM_TIME for VIEWs [closes #98]
Diffstat (limited to 'mysql-test/suite/versioning/r/view.result')
-rw-r--r-- | mysql-test/suite/versioning/r/view.result | 93 |
1 files changed, 90 insertions, 3 deletions
diff --git a/mysql-test/suite/versioning/r/view.result b/mysql-test/suite/versioning/r/view.result index 5fa59b23c47..0406f47cf3b 100644 --- a/mysql-test/suite/versioning/r/view.result +++ b/mysql-test/suite/versioning/r/view.result @@ -12,10 +12,10 @@ set @vt2= concat("create view vt2 as select * from t1 for system_time as of time prepare stmt from @vt2; execute stmt; drop prepare stmt; -select * from vt1; +select * from vt1 for system_time all; x 1 -select * from vt2; +select * from vt2 for system_time all; x 2 select * from t1; @@ -23,7 +23,94 @@ x create or replace view vt1 as select * from t1; show create view vt1; View Create View character_set_client collation_connection -vt1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `vt1` AS select `t1`.`x` AS `x` from `t1` where `t1`.`sys_trx_end` = 18446744073709551615 query for system_time all latin1 latin1_swedish_ci +vt1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `vt1` AS select `t1`.`x` AS `x`,`t1`.`sys_trx_start` AS `sys_trx_start`,`t1`.`sys_trx_end` AS `sys_trx_end` from `t1` FOR SYSTEM_TIME ALL where `t1`.`sys_trx_end` = 18446744073709551615 latin1 latin1_swedish_ci drop view vt1; drop view vt2; +create view vt1 as select * from t1 for system_time all; +select * from vt1 for system_time all; +x +2 +1 +prepare stmt from 'select * from vt1 for system_time all'; +execute stmt; +x +2 +1 +drop prepare stmt; +select * from vt1; +x +2 +1 +prepare stmt from 'select * from vt1'; +execute stmt; +x +drop prepare stmt; +select * from t1 for system_time as of timestamp @t1; +x +1 +select * from vt1 for system_time as of timestamp @t1; +x +2 +1 +prepare stmt from 'select * from vt1 for system_time as of timestamp @t1'; +execute stmt; +x +drop prepare stmt; +create or replace view vt1 as select * from t1; +select * from vt1 for system_time all; +x +prepare stmt from 'select * from vt1 for system_time all'; +execute stmt; +x +drop prepare stmt; +insert into vt1 values (3); +select * from t1; +x +3 +select * from vt1; +x +3 +select * from t1 for system_time all; +x +2 +1 +3 +select * from vt1 for system_time all; +x +3 +create view error_view as select *, sys_trx_start from t1; +ERROR 42S21: Duplicate column name 'sys_trx_start' +create view error_view as select *, sys_trx_end from t1; +ERROR 42S21: Duplicate column name 'sys_trx_end' +create or replace table t1 (x int) with system versioning; +insert into t1 values (1), (2); +set @t1=now(6); +delete from t1 where x=2; +set @t2=now(6); +delete from t1 where x=1; +set @t3=now(6); +set @tmp= concat("create or replace view vt1 as select * from t1 for system_time as of timestamp '", @t1, "'"); +prepare stmt from @tmp; +execute stmt; +drop prepare stmt; +set @tmp= concat("create or replace view vvt1 as select * from vt1 for system_time as of timestamp '", @t2, "'"); +prepare stmt from @tmp; +execute stmt; +drop prepare stmt; +set @tmp= concat("create or replace view vvvt1 as select * from vvt1 for system_time as of timestamp '", @t3, "'"); +prepare stmt from @tmp; +execute stmt; +drop prepare stmt; +select * from vt1 for system_time all; +x +1 +2 +select * from vvt1 for system_time all; +x +1 +select * from vvvt1 for system_time all; +x +drop view vvvt1; +drop view vvt1; +drop view vt1; drop table t1; |