TIME_to_ulonglong: Assertion `0' failed in 5.1-micro on wrong argument to MAKETIME

Bug #730627 reported by Philip Stoev
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
MariaDB
Fix Released
Critical
Sergei Golubchik

Bug Description

Assertion:

mysqld: my_time.c:1319: TIME_to_ulonglong: Assertion `0' failed.

backtrace:

#8 0x006b0d98 in __assert_fail () from /lib/libc.so.6
#9 0x0845af18 in TIME_to_ulonglong (my_time=0xb6e9bb9c) at my_time.c:1319
#10 0x08203211 in Item_temporal_func::val_int (this=0xb6b04b08) at item_timefunc.cc:1405
#11 0x081cb877 in eval_const_cond (cond=0xb6b04b08) at item_func.cc:63
#12 0x082e997a in remove_eq_conds (thd=0x9e5b090, cond=0xb6b04b08, cond_value=0xb6b05d28) at sql_select.cc:9402
#13 0x082e93c0 in optimize_cond (join=0xb6b04c10, conds=0xb6b04b08, join_list=0x9e5c53c, cond_value=0xb6b05d28) at sql_select.cc:9250
#14 0x082d3f4c in JOIN::optimize (this=0xb6b04c10) at sql_select.cc:887
#15 0x082d9b8d in mysql_select (thd=0x9e5b090, rref_pointer_array=0x9e5c570, tables=0xb6b04798, wild_num=1, fields=..., conds=0xb6b04b08, og_num=0,
    order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147764736, result=0xb6b04bf8, unit=0x9e5c208, select_lex=0x9e5c478)
    at sql_select.cc:2530
#16 0x082d25fe in handle_select (thd=0x9e5b090, lex=0x9e5c1ac, result=0xb6b04bf8, setup_tables_done_option=0) at sql_select.cc:269
#17 0x0827a73f in execute_sqlcom_select (thd=0x9e5b090, all_tables=0xb6b04798) at sql_parse.cc:5129
#18 0x082715f6 in mysql_execute_command (thd=0x9e5b090) at sql_parse.cc:2278
#19 0x0827c8f8 in mysql_parse (thd=0x9e5b090, rawbuf=0xb6b04628 "SELECT * FROM t1 WHERE MAKETIME\n( 20 , 61 , 10 )", length=48, found_semicolon=0xb6e9d210)
    at sql_parse.cc:6054
#20 0x0826f250 in dispatch_command (command=COM_QUERY, thd=0x9e5b090, packet=0x9ea0539 "SELECT * FROM t1 WHERE MAKETIME\n( 20 , 61 , 10 )", packet_length=48)
    at sql_parse.cc:1249
#21 0x0826e480 in do_command (thd=0x9e5b090) at sql_parse.cc:889
#22 0x0826c7c5 in handle_one_connection (arg=0x9e5b090) at sql_connect.cc:1136
#23 0x00821919 in start_thread () from /lib/libpthread.so.0
#24 0x0076acce in clone () from /lib/libc.so.6

test case:

CREATE TABLE t1 ( f1 int );

SELECT * FROM t1 WHERE MAKETIME
( 20 , 61 , 10 );

Related branches

Changed in maria:
milestone: none → 5.3
assignee: nobody → Sergei (sergii)
Changed in maria:
importance: Undecided → Critical
status: New → Fix Committed
Changed in maria:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.