Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
None
-
None
-
None
Description
Not repeatable with maria-5.3. Simple blob queries crash as follows:
#4 <signal handler called>
#5 0x082125bd in Item_func::Item_func (this=0xae513d50, a=0xae5132c8, b=0x0) at item_func.h:82
#6 0x08212681 in Item_int_func::Item_int_func (this=0xae513d50, a=0xae5132c8, b=0x0) at item_func.h:402
#7 0x08212d09 in Item_bool_func2::Item_bool_func2 (this=0xae513d50, a=0xae5132c8, b=0x0) at item_cmpfunc.h:357
#8 0x08212f13 in Item_bool_rowready_func2::Item_bool_rowready_func2 (this=0xae513d50, a=0xae5132c8, b=0x0) at item_cmpfunc.h:390
#9 0x08213147 in Item_func_eq::Item_func_eq (this=0xae513d50, a=0xae5132c8, b=0x0) at item_cmpfunc.h:495
#10 0x0821153e in Item_equal::add_const (this=0xae513700, c=0xae5132c8, f=0x0) at item_cmpfunc.cc:5621
#11 0x08211771 in Item_equal::update_const (this=0xae513700) at item_cmpfunc.cc:5750
#12 0x08326adc in update_const_equal_items (cond=0xae513700, tab=0xae5138c8) at sql_select.cc:10349
#13 0x0832fa24 in join_read_const_table (tab=0xae5138c8, pos=0xae528c80) at sql_select.cc:14374
#14 0x083161a6 in make_join_statistics (join=0xae526440, tables_arg=0xae513008, conds=0xae513700, keyuse_array=0xae52b568) at sql_select.cc:3023
#15 0x0830f7b3 in JOIN::optimize (this=0xae526440) at sql_select.cc:992
#16 0x08315079 in mysql_select (thd=0xa7d2ed8, rref_pointer_array=0xa7d4978, tables=0xae513008, wild_num=1, fields=..., conds=0xae513368, og_num=0,
order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147764736, result=0xae5134e0, unit=0xa7d45d8, select_lex=0xa7d4874)
at sql_select.cc:2687
#17 0x0830d95b in handle_select (thd=0xa7d2ed8, lex=0xa7d457c, result=0xae5134e0, setup_tables_done_option=0) at sql_select.cc:282
#18 0x082aa308 in execute_sqlcom_select (thd=0xa7d2ed8, all_tables=0xae513008) at sql_parse.cc:5094
#19 0x082a1152 in mysql_execute_command (thd=0xa7d2ed8) at sql_parse.cc:2239
#20 0x082ac8ab in mysql_parse (thd=0xa7d2ed8, rawbuf=0xae512eb0 "SELECT * FROM t1 WHERE f1 = f2", length=31, found_semicolon=0xae8e1228)
at sql_parse.cc:6094
#21 0x0829eddb in dispatch_command (command=COM_QUERY, thd=0xa7d2ed8, packet=0xa82dae9 "SELECT * FROM t1 WHERE f1 = f2 ", packet_length=32)
at sql_parse.cc:1215
#22 0x0829e239 in do_command (thd=0xa7d2ed8) at sql_parse.cc:904
#23 0x0829b2ec in handle_one_connection (arg=0xa7d2ed8) at sql_connect.cc:1154
#24 0x00821919 in start_thread () from /lib/libpthread.so.0
#25 0x0076acce in clone () from /lib/libc.so.6
test case:
CREATE TABLE t1 ( f1 blob, f2 blob );
INSERT INTO t1 VALUES ('','');
SELECT * FROM t1 WHERE f1 = f2 ;