Failing assertion: templ->mysql_col_len == len
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MariaDB |
New
|
Medium
|
Sergei Golubchik |
Bug Description
InnoDB: Assertion failure in thread X in file row0sel.c line 2681
InnoDB: Failing assertion: templ->
Program received signal SIGABRT, Aborted.
[Switching to Thread 0x7ffff42d3700 (LWP 30861)]
in raise (sig=6) at ../nptl/
64 return INLINE_SYSCALL (tgkill, 3, pid, selftid, sig);
(gdb) bt
#0 in raise (sig=6) at ../nptl/
#1 in abort () at abort.c:92
#2 in row_sel_
#3 in row_sel_
#4 in row_search_
#5 in row_search_
#6 in ha_innobase:
#7 in handler:
#8 in handler:
#9 in handler:
#10 in handler:
#11 in Mrr_simple_
#12 in DsMrr_impl:
#13 in ha_innobase:
#14 in QUICK_RANGE_
#15 in rr_quick at ./maria-
#16 in join_init_
#17 in sub_select at ./maria-
#18 in do_select at ./maria-
#19 in JOIN::exec at ./maria-
#20 in mysql_select at ./maria-
#21 in handle_select at ./maria-
#22 in execute_
#23 in mysql_execute_
#24 in mysql_parse at ./maria-
#25 in dispatch_command at ./maria-
#26 in do_command at ./maria-
#27 in do_handle_
#28 in handle_
#29 in start_thread at pthread_
#30 in clone () at ../sysdeps/
Reminds me of an old bug:
http://
(Assert in row_sel_
How to repeat:
-----------------
# might have to use debug build
# repeatable with 5.5.24-
drop table if exists `t1`;
create table `t1` (`a` int,`b` char(5),primary key (`a`), key (`b`(1))) engine=innodb ;
insert into `t1` values ('a','b');
select 1 from `t1` where `a` and `b` >= 'aa';
Reproducible on maria-5.5 with XtraDB.
Could not reproduce on maria-5.3, percona-server, mysql-5.5, and on maria-5.5 with InnoDB plugin, but possibly only because in all these cases a different plan is chosen (5.5 with XtraDB says 'Using index condition', others don't).
Comments in http:// bugs.mysql. com/bug. php?id= 58015 say that the assertion is bogus, so it's just a debug nuisance.