summaryrefslogtreecommitdiff
path: root/mysql-test/t/check.test
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/t/check.test')
-rw-r--r--mysql-test/t/check.test12
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/t/check.test b/mysql-test/t/check.test
index bc61aea2d66..c502655818d 100644
--- a/mysql-test/t/check.test
+++ b/mysql-test/t/check.test
@@ -22,3 +22,15 @@ connection con1;
reap;
drop table t1;
+#
+# Bug #9897 Views: 'Check Table' crashes MySQL, with a view and a table
+# in the statement
+#
+
+connection default;
+Create table t1(f1 int);
+Create table t2(f1 int);
+Create view v1 as Select * from t1;
+Check Table v1,t2;
+drop view v1;
+drop table t1, t2;