From d76be7ab3fa02c60b68420a439b569d669af7d22 Mon Sep 17 00:00:00 2001
From: "gluh@mysql.com" <>
Date: Sat, 7 May 2005 12:17:54 +0000
Subject: Fix for bug#9897: Views: 'Check Table' crashes MySQL, with a view and
 a table in the statement    thd->lex->derived_tables should be zero(it may be
 changed if we open a view)

---
 mysql-test/r/check.result | 9 +++++++++
 1 file changed, 9 insertions(+)

(limited to 'mysql-test/r')

diff --git a/mysql-test/r/check.result b/mysql-test/r/check.result
index ecaa13642bd..4c565f4f1b1 100644
--- a/mysql-test/r/check.result
+++ b/mysql-test/r/check.result
@@ -5,3 +5,12 @@ insert into t1 values (200000);
 Table	Op	Msg_type	Msg_text
 test.t1	check	status	OK
 drop table t1;
+Create table t1(f1 int);
+Create table t2(f1 int);
+Create view v1 as Select * from t1;
+Check Table v1,t2;
+Table	Op	Msg_type	Msg_text
+test.v1	check	status	OK
+test.t2	check	status	OK
+drop view v1;
+drop table t1, t2;
-- 
cgit v1.2.1