diff options
author | Sergei Golubchik <serg@mariadb.org> | 2018-02-23 12:51:43 +0100 |
---|---|---|
committer | Sergei Golubchik <serg@mariadb.org> | 2018-02-24 01:28:45 +0100 |
commit | 17f8e0ecdf68846d6fb5e157e003794ba9a959c2 (patch) | |
tree | c354f117e62b56a0d08241cc13eb7ec42205e436 /mysql-test/suite/versioning/r | |
parent | 5282d0dce163f73691c2ca9a1a5a951fa47563b2 (diff) | |
download | mariadb-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.result | 14 |
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; |