From 5d478f5339b6ab1b9d22476abd603f44e236d433 Mon Sep 17 00:00:00 2001 From: Sergei Golubchik Date: Mon, 8 Feb 2016 20:07:38 +0100 Subject: Bug#19817021 test case for ALTER TABLE view CHECK PARTITION --- mysql-test/r/view.result | 8 ++++++++ 1 file changed, 8 insertions(+) (limited to 'mysql-test/r/view.result') 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. # ----------------------------------------------------------------- -- cgit v1.2.1