virtual bool Item_cache::is_expensive(): Assertion `example' failed.
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MariaDB |
Fix Released
|
High
|
Timour Katchaounov |
Bug Description
mysqld: ./maria-
Program received signal SIGABRT, Aborted.
[Switching to Thread 0x7ffff42d3700 (LWP 29894)]
0x00000030b84330c5 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 __assert_fail at assert.c:81
#3 in Item_cache:
#4 in make_join_
#5 in JOIN::optimize at ./maria-
#6 in mysql_select at ./maria-
#7 in handle_select at ./maria-
#8 in execute_
#9 in mysql_execute_
#10 in mysql_parse at ./maria-
#11 in dispatch_command at ./maria-
#12 in do_command at ./maria-
#13 in do_handle_
#14 in handle_
#15 in start_thread at pthread_
#16 in clone () at ../sysdeps/
How to repeat:
------------------
#on a debug build:
drop table if exists `t1`;
create table `t1`(`a` date,key(
insert into `t1` values ('2012-
select 1 from `t1` as `t1_0` inner join `t1` as `t2`
on (`t1_0`.`a` <=> now()) join `t1` on 1;
Related branches
Changed in maria: | |
status: | New → Confirmed |
status: | Confirmed → In Progress |
Changed in maria: | |
status: | In Progress → Fix Committed |
Changed in maria: | |
status: | Fix Committed → Fix Released |
Reproducible also with MyISAM and Aria, and on 5.3 as well as 5.5.
No visible effect on a release build.