Small imprecision with REPAIR TABLE ... USE_FRM and non-MyISAM handler

Hi,

I just want to report a small imprecision in the error message when REPAIR
TABLE ... USE_FRM is used.

How-to-repeat :

On a HEAP or InnoDB table for example :

mysql> REPAIR TABLE online;
+-------------------+--------+----------+------------------- ----------------
---------------------+
| Table | Op | Msg_type | Msg_text
|
+-------------------+--------+----------+------------------- ----------------
---------------------+
| Hardwarefr.online | repair | error | The handler for the table doesn't
support check/repair |
+-------------------+--------+----------+------------------- ----------------
---------------------+
1 row in set (0.00 sec)

=> Error message is OK

mysql> REPAIR TABLE online USE_FRM;
+--------+--------+----------+---------------------------+
| Table | Op | Msg_type | Msg_text |
+--------+--------+----------+---------------------------+
| online | repair | error | Failed renaming .MYD file |
+--------+--------+----------+---------------------------+
1 row in set (0.00 sec)

=> Error message should be the same than without USE_FRM ?

Another imprecision with a InnoDB table :

mysql> REPAIR TABLE cookie;
+-------------------+--------+----------+------------------- ----------------
---------------------+
| Table | Op | Msg_type | Msg_text
|
+-------------------+--------+----------+------------------- ----------------
---------------------+
| Hardwarefr.cookie | repair | error | The handler for the table doesn't
support check/repair |
+-------------------+--------+----------+------------------- ----------------
---------------------+
1 row in set (0.00 sec)

However :

mysql> CHECK TABLE cookie;
+-------------------+-------+----------+----------+
| Table | Op | Msg_type | Msg_text |
+-------------------+-------+----------+----------+
| Hardwarefr.cookie | check | status | OK |
+-------------------+-------+----------+----------+
1 row in set (24.38 sec)

So the error message is not completely right since the handler support CHECK
TABLE :)

Regards,
Jocelyn


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread12815@lists.mysql.com
To unsubscribe, e-mail

Re: Small imprecision with REPAIR TABLE ... USE_FRM and non-MyISAM handler

Jocelyn Fournier writes:
> Hi,
>
> I just want to report a small imprecision in the error message when REPAIR
> TABLE ... USE_FRM is used.
>
> How-to-repeat :
>
> On a HEAP or InnoDB table for example :
>
> mysql> REPAIR TABLE online USE_FRM;
> +--------+--------+----------+---------------------------+
> | Table | Op | Msg_type | Msg_text |
> +--------+--------+----------+---------------------------+
> | online | repair | error | Failed renaming .MYD file |
> +--------+--------+----------+---------------------------+
> 1 row in set (0.00 sec)
>
> => Error message should be the same than without USE_FRM ?
>
> Regards,
> Jocelyn
>

Thanks for the info.

We shall fix the imprecision in the error message.

--
Regards,
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread12817@lists.mysql.com
To unsubscribe, e-mail