diff options
| author | Sergei Golubchik <serg@mariadb.org> | 2016-02-08 20:07:38 +0100 |
|---|---|---|
| committer | Sergei Golubchik <serg@mariadb.org> | 2016-02-09 11:29:06 +0100 |
| commit | 5d478f5339b6ab1b9d22476abd603f44e236d433 (patch) | |
| tree | 0a71c35173cd7a170f8cfff6d66e470168947eca /mysql-test/r/view.result | |
| parent | 6703e5b6dafc93bd3b7a0964162e9f8f04473c83 (diff) | |
| download | mariadb-git-5d478f5339b6ab1b9d22476abd603f44e236d433.tar.gz | |
Bug#19817021
test case for ALTER TABLE view CHECK PARTITION
Diffstat (limited to 'mysql-test/r/view.result')
| -rw-r--r-- | mysql-test/r/view.result | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/r/view.result b/mysql-test/r/view.result index a8e5bc342fb..dbfdf3f0f56 100644 --- a/mysql-test/r/view.result +++ b/mysql-test/r/view.result @@ -5512,6 +5512,14 @@ execute stmt; deallocate prepare stmt; drop view v1,v2; drop table `t1`; +create table t1 (a int, b int); +create view v1 as select a+b from t1; +alter table v1 check partition p1; +Table Op Msg_type Msg_text +test.v1 check Error 'test.v1' is not BASE TABLE +test.v1 check status Operation failed +drop view v1; +drop table t1; # ----------------------------------------------------------------- # -- End of 5.5 tests. # ----------------------------------------------------------------- |