Assertion `table_ref->has_record' failed in maria-5.3-mwl128 with join_cache_level=4, join_buffer_size=1
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MariaDB |
Invalid
|
Undecided
|
Igor Babaev |
Bug Description
Even after the fix for 665057 sql_select.
SELECT t2 .col_int_key
FROM t4
LEFT JOIN t2 JOIN t5 ON t2 .col_varchar_
LEFT JOIN t3 JOIN t1 ON t3 .col_varchar_
WHERE t2 .pk <> 4 ;
crashes with the same assertion and the following backtrace:
#8 0x00133d98 in __assert_fail () from /lib/libc.so.6
#9 0x083249c1 in join_read_key2 (thd=0xb846b00, tab=0xb6ccab3c, table=0xb6c98be0, table_ref=
#10 0x083247dd in join_read_key (tab=0xb6ccab3c) at sql_select.cc:13850
#11 0x08323589 in sub_select (join=0xb6cc3630, join_tab=
#12 0x08323c50 in evaluate_
#13 0x0832372a in sub_select (join=0xb6cc3630, join_tab=
#14 0x083229fd in do_select (join=0xb6cc3630, fields=0xb848514, table=0x0, procedure=0x0) at sql_select.cc:12872
#15 0x08308873 in JOIN::exec (this=0xb6cc3630) at sql_select.cc:2382
#16 0x08308fa9 in mysql_select (thd=0xb846b00, rref_pointer_
order=0x0, group=0x0, having=0x0, proc_param=0x0, select_
at sql_select.cc:2584
#17 0x083016f1 in handle_select (thd=0xb846b00, lex=0xb848188, result=0xb6c3f7d8, setup_tables_
#18 0x0829dcab in execute_
#19 0x08294873 in mysql_execute_
#20 0x082a023c in mysql_parse (thd=0xb846b00,
rawbuf=
#21 0x0829235c in dispatch_command (command=COM_QUERY, thd=0xb846b00, packet=0xb85f1a1 "", packet_length=271) at sql_parse.cc:1209
#22 0x082917c6 in do_command (thd=0xb846b00) at sql_parse.cc:902
#23 0x0828e8a4 in handle_
#24 0x00bea919 in start_thread () from /lib/libpthread
#25 0x001edcbe in clone () from /lib/libc.so.6
Related branches
Changed in maria: | |
status: | New → Incomplete |
status: | Incomplete → Invalid |
Attached test case with
- tables named t1 , t2 , t3
- no backticks
- multiline insert