Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Minor
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: None
-
Labels:
Description
Affected versions: maria-5.3 , maria-5.3-handler . Not affected, maria-5.1, maria-5.2 , mysql-5.1 mysql-5.5
Assertion:
mysqld: sql_class.h:3552: int handler::ha_index_prev(uchar*): Assertion `inited==INDEX' failed.
backtrace:
#8 0x006b0d98 in __assert_fail () from /lib/libc.so.6
#9 0x081b21b8 in handler::ha_index_prev (this=0xa0cb1c0,
buf=0xa0cb6e8 "\377\217\217\217\217\217\217\217\217\245\245\245\245\245\245\245\377\245\245\245\245\245\245\245\245\245\245\245\245\245\245\245\030\267\f\n\200\267\f\n") at sql_class.h:3552
#10 0x081b0d88 in mysql_ha_read (thd=0xa06e9d8, tables=0xa0bbe90, mode=RPREV, keyname=0xa0bc098 "PRIMARY", key_expr=0xa5a5a5a5,
ha_rkey_mode=HA_READ_KEY_EXACT, cond=0x0, select_limit_cnt=1, offset_limit_cnt=0) at sql_handler.cc:606
#11 0x082a1461 in mysql_execute_command (thd=0xa06e9d8) at sql_parse.cc:4061
#12 0x082a6f46 in mysql_parse (thd=0xa06e9d8, rawbuf=0xa0bbd78 "HANDLER t1 READ `PRIMARY` PREV", length=30, found_semicolon=0x9f6fb228) at sql_parse.cc:6077
#13 0x08298eac in dispatch_command (command=COM_QUERY, thd=0xa06e9d8, packet=0xa086a69 "", packet_length=30) at sql_parse.cc:1210
#14 0x08298316 in do_command (thd=0xa06e9d8) at sql_parse.cc:903
#15 0x082953f2 in handle_one_connection (arg=0xa06e9d8) at sql_connect.cc:1154
#16 0x00821919 in start_thread () from /lib/libpthread.so.0
#17 0x0076acce in clone () from /lib/libc.so.6
test case:
--source include/have_innodb.inc
--disable_abort_on_error
CREATE TABLE t1 ( f1 integer, f2 integer, primary key (f1), key (f2)) ENGINE=innodb;
HANDLER t1 OPEN;
HANDLER t1 READ FIRST WHERE f2 <= 1;
HANDLER t1 OPEN;
HANDLER t1 READ `PRIMARY` PREV;
Gliffy Diagrams
Attachments
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
Launchpad bug id: 697610