#8 0x006b0d98 in __assert_fail () from /lib/libc.so.6
#9 0x08211702 in Item_func_case::fix_length_and_dec (this=0xae612870) at item_cmpfunc.cc:2954
#10 0x081f3683 in Item_func::fix_fields (this=0xae612870, thd=0xa93c6b8, ref=0xae61296c) at item_func.cc:209
#11 0x082112ea in Item_func_case::fix_fields (this=0xae612870, thd=0xa93c6b8, ref=0xae61296c) at item_cmpfunc.cc:2869
#12 0x08304459 in setup_fields (thd=0xa93c6b8, ref_pointer_array=0xae612cf8, fields=..., mark_used_columns=MARK_COLUMNS_READ, sum_func_list=0xae625bfc,
allow_sum_func=true) at sql_base.cc:7672
#13 0x0831860f in JOIN::prepare (this=0xae620aa0, rref_pointer_array=0xa93e238, tables_init=0xae612a18, wild_num=0, conds_init=0x0, og_num=0,
order_init=0x0, group_init=0x0, having_init=0x0, proc_param_init=0x0, select_lex_arg=0xa93e0fc, unit_arg=0xa93de1c) at sql_select.cc:572
#14 0x0831ff54 in mysql_select (thd=0xa93c6b8, rref_pointer_array=0xa93e238, tables=0xae612a18, wild_num=0, fields=..., conds=0x0, og_num=0, order=0x0,
group=0x0, having=0x0, proc_param=0x0, select_options=2147764736, result=0xae612cd8, unit=0xa93de1c, select_lex=0xa93e0fc) at sql_select.cc:2879
#15 0x08317deb in handle_select (thd=0xa93c6b8, lex=0xa93ddc0, result=0xae612cd8, setup_tables_done_option=0) at sql_select.cc:283
#16 0x082b31b9 in execute_sqlcom_select (thd=0xa93c6b8, all_tables=0xae612a18) at sql_parse.cc:5090
#17 0x082a9fbd in mysql_execute_command (thd=0xa93c6b8) at sql_parse.cc:2234
#18 0x082b57f5 in mysql_parse (thd=0xa93c6b8, rawbuf=0xae6125f0 "SELECT CASE t1.f1 when '00:00:00' then NULL END FROM t1", length=55,
found_semicolon=0xae983228) at sql_parse.cc:6091
#19 0x082a7c3a in dispatch_command (command=COM_QUERY, thd=0xa93c6b8, packet=0xa995549 "SELECT CASE t1.f1 when '00:00:00' then NULL END FROM t1",
packet_length=55) at sql_parse.cc:1211
#20 0x082a7095 in do_command (thd=0xa93c6b8) at sql_parse.cc:906
#21 0x082a40fd in handle_one_connection (arg=0xa93c6b8) at sql_connect.cc:1186
#22 0x00821919 in start_thread () from /lib/libpthread.so.0
#23 0x0076acce in clone () from /lib/libc.so.6
test case:
CREATE TABLE t1 ( f1 time) ;
SELECT CASE t1.f1 when '00:00:00' then NULL END FROM t1;
backtrace:
mysqld: item_cmpfunc. cc:2954: virtual void Item_func_ case::fix_ length_ and_dec( ): Assertion `(Item_result)i != TIME_RESULT' failed.
#8 0x006b0d98 in __assert_fail () from /lib/libc.so.6 case::fix_ length_ and_dec (this=0xae612870) at item_cmpfunc. cc:2954 :fix_fields (this=0xae612870, thd=0xa93c6b8, ref=0xae61296c) at item_func.cc:209 case::fix_ fields (this=0xae612870, thd=0xa93c6b8, ref=0xae61296c) at item_cmpfunc. cc:2869 array=0xae612cf 8, fields=..., mark_used_ columns= MARK_COLUMNS_ READ, sum_func_ list=0xae625bfc , sum_func= true) at sql_base.cc:7672 array=0xa93e238 , tables_ init=0xae612a18 , wild_num=0, conds_init=0x0, og_num=0, init=0x0, select_ lex_arg= 0xa93e0fc, unit_arg=0xa93de1c) at sql_select.cc:572 array=0xa93e238 , tables=0xae612a18, wild_num=0, fields=..., conds=0x0, og_num=0, order=0x0, options= 2147764736, result=0xae612cd8, unit=0xa93de1c, select_ lex=0xa93e0fc) at sql_select.cc:2879 done_option= 0) at sql_select.cc:283 sqlcom_ select (thd=0xa93c6b8, all_tables= 0xae612a18) at sql_parse.cc:5090 command (thd=0xa93c6b8) at sql_parse.cc:2234 semicolon= 0xae983228) at sql_parse.cc:6091 length= 55) at sql_parse.cc:1211 one_connection (arg=0xa93c6b8) at sql_connect.cc:1186 .so.0
#9 0x08211702 in Item_func_
#10 0x081f3683 in Item_func:
#11 0x082112ea in Item_func_
#12 0x08304459 in setup_fields (thd=0xa93c6b8, ref_pointer_
allow_
#13 0x0831860f in JOIN::prepare (this=0xae620aa0, rref_pointer_
order_init=0x0, group_init=0x0, having_init=0x0, proc_param_
#14 0x0831ff54 in mysql_select (thd=0xa93c6b8, rref_pointer_
group=0x0, having=0x0, proc_param=0x0, select_
#15 0x08317deb in handle_select (thd=0xa93c6b8, lex=0xa93ddc0, result=0xae612cd8, setup_tables_
#16 0x082b31b9 in execute_
#17 0x082a9fbd in mysql_execute_
#18 0x082b57f5 in mysql_parse (thd=0xa93c6b8, rawbuf=0xae6125f0 "SELECT CASE t1.f1 when '00:00:00' then NULL END FROM t1", length=55,
found_
#19 0x082a7c3a in dispatch_command (command=COM_QUERY, thd=0xa93c6b8, packet=0xa995549 "SELECT CASE t1.f1 when '00:00:00' then NULL END FROM t1",
packet_
#20 0x082a7095 in do_command (thd=0xa93c6b8) at sql_parse.cc:906
#21 0x082a40fd in handle_
#22 0x00821919 in start_thread () from /lib/libpthread
#23 0x0076acce in clone () from /lib/libc.so.6
test case:
CREATE TABLE t1 ( f1 time) ;
SELECT CASE t1.f1 when '00:00:00' then NULL END FROM t1;
bzr version-info
revision-id: <email address hidden>
date: 2011-08-29 18:16:18 +0300
build-date: 2011-09-02 11:35:31 +0300
revno: 3169
branch-nick: maria-5.3
not repeatable in maria-5.2.