diff options
Diffstat (limited to 'mysql-test/t/view.test')
| -rw-r--r-- | mysql-test/t/view.test | 25 |
1 files changed, 25 insertions, 0 deletions
diff --git a/mysql-test/t/view.test b/mysql-test/t/view.test index 880b4b6a645..8297013611f 100644 --- a/mysql-test/t/view.test +++ b/mysql-test/t/view.test @@ -3908,6 +3908,31 @@ DROP TABLE t1; --echo # -- End of 5.1 tests. --echo # ----------------------------------------------------------------- +# +# Bug#9801 (Views: imperfect error message) +# + +--disable_warnings +drop table if exists t_9801; +drop view if exists v_9801; +--enable_warnings + +create table t_9801 (s1 int); + +--error ER_VIEW_NONUPD_CHECK +create view v_9801 as + select sum(s1) from t_9801 with check option; + +--error ER_VIEW_NONUPD_CHECK +create view v_9801 as + select sum(s1) from t_9801 group by s1 with check option; + + --error ER_VIEW_NONUPD_CHECK +create view v_9801 as + select sum(s1) from t_9801 group by s1 with rollup with check option; + +drop table t_9801; + --echo # --echo # Bug #47335 assert in get_table_share --echo # |