[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql-internals
Subject:    Re: Storage Engine Does Not Have Option
From:       Sergei Golubchik <serg () mysql ! com>
Date:       2006-06-29 6:56:16
Message-ID: 20060629070303.GB24237 () serg ! mylan
[Download RAW message or body]

Hi!

On Jun 28, Paul Whittington wrote:
> Given the following response from MySQL, what table_flags and/or 
> index_flags, or whatever else, do I need to set to resolve this?
> 
> mysql>  select c from t1 where b like '4%' order by 1 desc;
> ERROR 1031 (HY000): Table storage engine for 't1' doesn't have this option

I'm not quite sure about that, you'd better check where this error is
generated, in a debugger (see P.S.).

My guess in the light of your previous questions would be - you do not
support HA_READ_PREFIX_LAST (or ..._OR_PREV), but have HA_READ_PREV set
in the index_flags(), so MySQL tries to use HA_READ_PREFIX_LAST, and
gets "unsupported" error.

Regards,
Sergei

P.S. in sql/share/errmsg.txt search for "doesn't have this option".
You'll see it's the error "ER_ILLEGAL_HA". Grep the source for
ER_ILLEGAL_HA - it's mentioned on 19 lines in different files.
Start gdb, put 19 breakpoints on every line from those 19.

Alternatively just put a breakpoint on my_error.

If you'll find the error is generated in handler::print_error(),
repeat the procedure for HA_ERR_WRONG_COMMAND.

-- 
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /   Sergei Golubchik <serg@mysql.com>
 / /|_/ / // /\ \/ /_/ / /__  MySQL AB, Senior Software Developer
/_/  /_/\_, /___/\___\_\___/  Kerpen, Germany
       <___/  www.mysql.com

-- 
MySQL Internals Mailing List
For list archives: http://lists.mysql.com/internals
To unsubscribe:    http://lists.mysql.com/internals?unsub=mysql-internals@progressive-comp.com

[prev in list] [next in list] [prev in thread] [next in thread]