Yet another Assertion `!table || (!table->read_set || bitmap_is_set(table->read_set, field_index))' failed in maria-5.3-mwl89
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MariaDB |
Fix Released
|
High
|
Timour Katchaounov |
Bug Description
Reproducible even with bug 715027 fixed. Not reproducible on maria-5.3
mysqld: field.cc:3730: virtual longlong Field_long:
backtrace:
#8 0x006b0d98 in __assert_fail () from /lib/libc.so.6
#9 0x08255613 in Field_long::val_int (this=0xae74e278) at field.cc:3730
#10 0x081c50cb in Item_field::val_int (this=0xae733648) at item.cc:2133
#11 0x081c0962 in Item::val_bool (this=0xae733648) at item.cc:187
#12 0x0820a98b in Item_cond_
#13 0x083248f7 in evaluate_
#14 0x08324553 in sub_select (join=0xae7891c0, join_tab=
#15 0x0832398b in do_select (join=0xae7891c0, fields=0xae732a1c, table=0x0, procedure=0x0) at sql_select.cc:13063
#16 0x0830b3cb in JOIN::exec (this=0xae7891c0) at sql_select.cc:2450
#17 0x0823d1d0 in subselect_
#18 0x08237917 in Item_subselect:
#19 0x082388c3 in Item_singlerow_
#20 0x081d6f08 in Item::val_
#21 0x081d2c22 in Item_cache_
#22 0x081dad4c in Item_cache_
#23 0x081d0999 in Item_cache_
#24 0x0820a98b in Item_cond_
#25 0x082e1f5e in SQL_SELECT:
#26 0x083c8b6e in find_all_keys (param=0xb6e4df94, select=0xae75c5a8, sort_keys=
at filesort.cc:632
#27 0x083c7868 in filesort (thd=0x95eac38, table=0xae7659b8, sortorder=
sort_
#28 0x0832b43b in create_sort_index (thd=0x95eac38, join=0xae784328, order=0xae75aea8, filesort_
select_
#29 0x0830b126 in JOIN::exec (this=0xae784328) at sql_select.cc:2393
#30 0x0830bb91 in mysql_select (thd=0x95eac38, rref_pointer_
order=
at sql_select.cc:2667
#31 0x083045ed in handle_select (thd=0x95eac38, lex=0x95ec2d8, result=0xae75bab8, setup_tables_
#32 0x082a20ac in execute_
#33 0x082990bb in mysql_execute_
#34 0x082a4644 in mysql_parse (thd=0x95eac38,
rawbuf=
#35 0x08296d53 in dispatch_command (command=COM_QUERY, thd=0x95eac38,
packet=
#36 0x08296200 in do_command (thd=0x95eac38) at sql_parse.cc:903
#37 0x082932de in handle_
#38 0x00821919 in start_thread () from /lib/libpthread
#39 0x0076acce in clone () from /lib/libc.so.6
test case:
SET SESSION optimizer_switch = 'materializatio
CREATE TABLE t1 ( f1 int(11), f2 int(11), f3 int(11)) ;
INSERT IGNORE INTO t1 VALUES (28,5,6)
CREATE TABLE t2 ( f10 varchar(1) );
INSERT IGNORE INTO t2 VALUES (NULL);
SELECT f1 AS field1
FROM ( SELECT * FROM t1 ) AS alias1
WHERE (
SELECT t1.f1
FROM t2 JOIN t1 ON t1.f2
WHERE alias1.f3 AND t1.f3
) AND f2
ORDER BY field1;
Related branches
Changed in maria: | |
assignee: | nobody → Timour Katchaounov (timour) |
milestone: | none → 5.3 |
Changed in maria: | |
importance: | Undecided → High |
status: | New → Fix Released |