Fwd: Question relating to bug 1812 (and Check Table results)

  Hi Folks,

I'm trying to code a succinct test case to expose the bug reported in 
Bug #1812. I cannot repeat the table corruption yet, with my cutdown 
code, but I do get lots of interesting messages when running "CHECK TABLE".

Hence, my question is, should I see warnings like the following if the 
table is OK, or are these likely to be relevant to my problems?

mysql> check table Event;
+---------------+-------+----------+----------------------------------------------------+ 

| Table         | Op    | Msg_type | Msg_text        |
+---------------+-------+----------+----------------------------------------------------+ 

| Daelibs.Event | check | warning  | Size of indexfile is: 145408      
Should be: 1024  |
| Daelibs.Event | check | warning  | Size of datafile is: 66560       
Should be: 0      |
| Daelibs.Event | check | warning  | Found 1280 deleted blocks       
Should be:0       |
| Daelibs.Event | check | warning  | Found 1280 parts                
Should be:0 parts |
| Daelibs.Event | check | status   | OK        |
+---------------+-------+----------+----------------------------------------------------+ 

5 rows in set (0.00 sec)

Cheers,

   Paul




-- 
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe:    http://lists.mysql.com/[email protected]