summaryrefslogtreecommitdiff
path: root/mysql-test/suite/versioning/r
diff options
context:
space:
mode:
authorSergei Golubchik <serg@mariadb.org>2018-02-23 12:51:43 +0100
committerSergei Golubchik <serg@mariadb.org>2018-02-24 01:28:45 +0100
commit17f8e0ecdf68846d6fb5e157e003794ba9a959c2 (patch)
treec354f117e62b56a0d08241cc13eb7ec42205e436 /mysql-test/suite/versioning/r
parent5282d0dce163f73691c2ca9a1a5a951fa47563b2 (diff)
downloadmariadb-git-17f8e0ecdf68846d6fb5e157e003794ba9a959c2.tar.gz
unify error messages a bit
Diffstat (limited to 'mysql-test/suite/versioning/r')
-rw-r--r--mysql-test/suite/versioning/r/truncate.result14
1 files changed, 12 insertions, 2 deletions
diff --git a/mysql-test/suite/versioning/r/truncate.result b/mysql-test/suite/versioning/r/truncate.result
index 33f21d6245b..181b120eafb 100644
--- a/mysql-test/suite/versioning/r/truncate.result
+++ b/mysql-test/suite/versioning/r/truncate.result
@@ -65,14 +65,24 @@ create or replace table t (i int) with system versioning;
delete history from t;
create or replace view v as select * from t;
delete history from v;
-ERROR HY000: DELETE HISTORY from VIEW is prohibited
+ERROR 42S02: 'v' is a view
create or replace table t (i int);
delete history from t;
ERROR HY000: Table `t` is not system-versioned
create or replace view v as select * from t;
delete history from v;
-ERROR HY000: DELETE HISTORY from VIEW is prohibited
+ERROR 42S02: 'v' is a view
prepare stmt from 'delete history from t';
ERROR HY000: Table `t` is not system-versioned
drop table t;
drop view v;
+create or replace table t (i int);
+create or replace view v as select * from t;
+drop table v;
+ERROR 42S02: 'test.v' is a view
+lock table v write;
+delete history from v before system_time now(6);
+ERROR 42S02: 'v' is a view
+unlock tables;
+drop view v;
+drop table t;