summaryrefslogtreecommitdiff
path: root/mysql-test/suite/versioning/t/truncate.test
diff options
context:
space:
mode:
authorSergei Golubchik <serg@mariadb.org>2017-12-16 21:33:43 +0100
committerAleksey Midenkov <midenok@gmail.com>2017-12-19 16:35:38 +0300
commit617e108fb6e2bc24e5c9badb94e7d8eaa65d8851 (patch)
treeb7c0bc622483a2abd3b642e194609da625e8d52d /mysql-test/suite/versioning/t/truncate.test
parentee68d019d1e059fa0fcf9e63bd97176dd46582c2 (diff)
downloadmariadb-git-617e108fb6e2bc24e5c9badb94e7d8eaa65d8851.tar.gz
s/TRUNCATE ... TO/DELETE HISTORY FROM ... BEFORE/
Diffstat (limited to 'mysql-test/suite/versioning/t/truncate.test')
-rw-r--r--mysql-test/suite/versioning/t/truncate.test18
1 files changed, 9 insertions, 9 deletions
diff --git a/mysql-test/suite/versioning/t/truncate.test b/mysql-test/suite/versioning/t/truncate.test
index e732414f826..72da15b56d9 100644
--- a/mysql-test/suite/versioning/t/truncate.test
+++ b/mysql-test/suite/versioning/t/truncate.test
@@ -2,7 +2,7 @@
create table t (a int);
--error ER_VERSIONING_REQUIRED
-truncate t to system_time now();
+delete history from t before system_time now();
# TRUNCATE is not DELETE and trigger must not be called.
create or replace table t (a int) with system versioning;
@@ -11,7 +11,7 @@ update t set a=2;
set @test = 'correct';
create trigger trg_before before delete on t for each row set @test = 'incorrect';
create trigger trg_after after delete on t for each row set @test = 'incorrect';
-truncate t to system_time now(6);
+delete history from t before system_time now(6);
select @test from t;
drop table t;
@@ -23,9 +23,9 @@ set @ts1=now(6);
--real_sleep 0.01
update t set a=22 where a=2;
select * from t for system_time all;
-truncate t to system_time timestamp @ts1;
+delete history from t before system_time timestamp @ts1;
select * from t for system_time all;
-truncate table t to system_time timestamp now(6);
+delete history from t before system_time timestamp now(6);
select * from t for system_time all;
--echo ### Issue #399, truncate partitioned table is now unimplemented
@@ -38,20 +38,20 @@ partition by system_time (
partition pn current);
--error ER_NOT_ALLOWED_COMMAND
-truncate table t to system_time current_timestamp;
+delete history from t before system_time current_timestamp;
create or replace table t (i int) with system versioning;
-truncate t to system_time now();
+delete history from t before system_time now();
create or replace view v as select * from t;
--error ER_VERS_TRUNCATE_TO_VIEW
-truncate v to system_time now();
+delete history from v before system_time now();
create or replace table t (i int);
--error ER_VERSIONING_REQUIRED
-truncate t to system_time now();
+delete history from t before system_time now();
create or replace view v as select * from t;
--error ER_VERS_TRUNCATE_TO_VIEW
-truncate v to system_time now();
+delete history from v before system_time now();
drop table t;
drop view v;