Assertion `item->null_value' failed in get_datetime_value in 5.1-micro
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MariaDB |
Fix Released
|
Critical
|
Sergei Golubchik |
Bug Description
Assertion:
mysqld: item_cmpfunc.
backtrace:
#8 0x006b0d98 in __assert_fail () from /lib/libc.so.6
#9 0x081e32d8 in get_datetime_value (thd=0x9c67090, item_arg=
at item_cmpfunc.cc:846
#10 0x081e36df in Arg_comparator:
#11 0x081ca14c in Arg_comparator:
#12 0x081e5231 in Item_func_
#13 0x082e34fa in make_join_select (join=0xb6b04e78, select=0xb6b0b6a8, cond=0xb6b04d18) at sql_select.cc:6272
#14 0x082d5306 in JOIN::optimize (this=0xb6b04e78) at sql_select.cc:1147
#15 0x082d9ebd in mysql_select (thd=0x9c67090, rref_pointer_
order=0x0, group=0x0, having=0x0, proc_param=0x0, select_
at sql_select.cc:2530
#16 0x082d292e in handle_select (thd=0x9c67090, lex=0x9c681ac, result=0xb6b04e60, setup_tables_
#17 0x0827aa6f in execute_
#18 0x08271926 in mysql_execute_
#19 0x0827cc28 in mysql_parse (thd=0x9c67090, rawbuf=0xb6b04628 "SELECT * FROM t1 WHERE f1 IN ( COALESCE( f1 , MAKEDATE( 2014 , 123 ) ) )", length=73,
found_
#20 0x0826f580 in dispatch_command (command=COM_QUERY, thd=0x9c67090,
packet=
#21 0x0826e7b0 in do_command (thd=0x9c67090) at sql_parse.cc:889
#22 0x0826caf5 in handle_
#23 0x00116919 in start_thread () from /lib/libpthread
#24 0x0076acce in clone () from /lib/libc.so.6
test case:
CREATE TABLE t1 ( f1 time ) ;
INSERT INTO t1 VALUES ('21:43:24');
SELECT * FROM t1 WHERE f1 IN ( COALESCE( f1 , MAKEDATE( 2014 , 123 ) ) ) ;
Related branches
Changed in maria: | |
milestone: | none → 5.3 |
assignee: | nobody → Sergei (sergii) |
Changed in maria: | |
importance: | Undecided → Critical |
Changed in maria: | |
status: | New → Fix Committed |
Changed in maria: | |
status: | Fix Committed → Fix Released |