Bug #9897 Views: 'Check Table' crashes MySQL, with a view and a table in the statement
Submitted: 14 Apr 2005 11:19 Modified: 19 May 2005 1:36
Reporter: Disha Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:5.0.3/5.0.5 BK OS:Linux (Linux 9.1)
Assigned to: Sergei Glukhov CPU Architecture:Any

[14 Apr 2005 11:19] Disha
Description:
If Check Table is called and a view name is followed by a table name in the statement, the server crashes. 
To reproduce the issue, the sequence of paramaters, that is, view name is the first paramater and table name is the second is important.
In cases other that the sequnce of paramaters mentioned above, the Check table works properly.

How to repeat:
1. Create table t1(f1 int);
2. Create table t2(f1 int);
3. Create view v1 as Select * from t1;
4. Check Table v1,t2;

ACTUAL RESULT
+----------+-------+----------+----------+
| Table    | Op    | Msg_type | Msg_text |
+----------+-------+----------+----------+
| test1.v1 | check | status   | OK       |
| test1.t2 | check | status   | OK       |
+----------+-------+----------+----------+
2 rows in set (0.01 sec)

EXPECTED RESULT
MySQL Server crashes.
[14 Apr 2005 13:45] MySQL Verification Team
The server crashes.
[6 May 2005 16:47] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/internals/24632
[7 May 2005 7:20] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/internals/24641
[7 May 2005 7:30] Sergei Glukhov
Fixed in 5.0.6 tree
[19 May 2005 1:31] Paul DuBois
Noted in 5.0.6 changelog.