--source include/have_innodb.inc

CREATE TABLE t1 (d DATE, c VARCHAR(10), KEY(d)) ENGINE=InnoDB;

INSERT INTO t1 VALUES ('2008-10-02','2008-10-02');

SELECT * FROM t1 WHERE TIMESTAMP(c,'02:04:42') AND d <=> MAKETIME(97,0,7);

#6  0x00007f9dea9836f1 in *__GI___assert_fail (assertion=0xdae744 "ltime->day == 0", file=<optimized out>, line=1122, function=0xdaef80 "bool time_to_datetime(MYSQL_TIME*)") at assert.c:81

#7  0x000000000070552b in time_to_datetime (ltime=0x7f9dec2a7dc0) at 5.5/sql/sql_time.cc:1122

#8  0x00000000007c5afa in Field_temporal::store_time_dec (this=0x7f9ddc0594b0, ltime=0x7f9dec2a8050, dec=0) at 5.5/sql/field.cc:5073

#9  0x0000000000808c61 in Item_cache_temporal::save_in_field (this=0x7f9ddc19dc80, field=0x7f9ddc0594b0, no_conversions=true) at 5.5/sql/item.cc:9027

#10 0x00000000007f4206 in Item::save_in_field_no_warnings (this=0x7f9ddc19dc80, field=0x7f9ddc0594b0, no_conversions=true) at 5.5/sql/item.cc:1407

#11 0x00000000008f0ad6 in get_mm_leaf (param=0x7f9dec2a8cc0, conf_func=0x7f9ddc19cf68, field=0x7f9ddc0594b0, key_part=0x7f9ddc142078, type=Item_func::EQUAL_FUNC, value=0x7f9ddc19dc80) at 5.5/sql/opt_range.cc:7825

#12 0x00000000008f01e0 in get_mm_parts (param=0x7f9dec2a8cc0, cond_func=0x7f9ddc19cf68, field=0x7f9ddc0594b0, type=Item_func::EQUAL_FUNC, value=0x7f9ddc19dc80, cmp_type=TIME_RESULT) at 5.5/sql/opt_range.cc:7616

#13 0x00000000008ef030 in get_func_mm_tree (param=0x7f9dec2a8cc0, cond_func=0x7f9ddc19cf68, field=0x7f9ddc0594b0, value=0x7f9ddc19dc80, cmp_type=TIME_RESULT, inv=false) at 5.5/sql/opt_range.cc:7282

#14 0x00000000008ef245 in get_full_func_mm_tree (param=0x7f9dec2a8cc0, cond_func=0x7f9ddc19cf68, field_item=0x7f9ddc19cb50, value=0x7f9ddc19dc80, inv=false) at 5.5/sql/opt_range.cc:7389

#15 0x00000000008effc1 in get_mm_tree (param=0x7f9dec2a8cc0, cond=0x7f9ddc19cf68) at 5.5/sql/opt_range.cc:7584

#16 0x00000000008ef467 in get_mm_tree (param=0x7f9dec2a8cc0, cond=0x7f9ddc19d0d8) at 5.5/sql/opt_range.cc:7430

#17 0x00000000008e623f in SQL_SELECT::test_quick_select (this=0x7f9ddc16a708, thd=0x7f9de43d4060, keys_to_use=..., prev_tables=0, limit=18446744073709551615, force_quick_range=false, ordered_output=false) at 5.5/sql/opt_range.cc:3101

#18 0x0000000000668b32 in get_quick_record_count (thd=0x7f9de43d4060, select=0x7f9ddc16a708, table=0x7f9ddc1e6860, keys=0x7f9ddc19dea0, limit=18446744073709551615) at 5.5/sql/sql_select.cc:3131

#19 0x000000000066aa2c in make_join_statistics (join=0x7f9ddc19d2c0, tables_list=..., conds=0x7f9ddc19d0d8, keyuse_array=0x7f9ddc19d5c8) at 5.5/sql/sql_select.cc:3716

#20 0x0000000000662046 in JOIN::optimize (this=0x7f9ddc19d2c0) at 5.5/sql/sql_select.cc:1229

#21 0x00000000006688af in mysql_select (thd=0x7f9de43d4060, rref_pointer_array=0x7f9de43d7cc8, tables=0x7f9ddc19c2c8, wild_num=1, fields=..., conds=0x7f9ddc19d0d8, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7f9ddc19d2a0, unit=0x7f9de43d7380, select_lex=0x7f9de43d7a58) at 5.5/sql/sql_select.cc:3080

#22 0x000000000065f411 in handle_select (thd=0x7f9de43d4060, lex=0x7f9de43d72d0, result=0x7f9ddc19d2a0, setup_tables_done_option=0) at 5.5/sql/sql_select.cc:319

#23 0x00000000006389c3 in execute_sqlcom_select (thd=0x7f9de43d4060, all_tables=0x7f9ddc19c2c8) at 5.5/sql/sql_parse.cc:4688

#24 0x0000000000631ba5 in mysql_execute_command (thd=0x7f9de43d4060) at 5.5/sql/sql_parse.cc:2233

#25 0x000000000063b0d2 in mysql_parse (thd=0x7f9de43d4060, rawbuf=0x7f9ddc19c078 "SELECT * FROM t1 WHERE TIMESTAMP(c,'02:04:42') AND d <=> MAKETIME(97,0,7)", length=73, parser_state=0x7f9dec2ac630) at 5.5/sql/sql_parse.cc:5799

#26 0x000000000062f11d in dispatch_command (command=COM_QUERY, thd=0x7f9de43d4060, packet=0x7f9de53b8061 "SELECT * FROM t1 WHERE TIMESTAMP(c,'02:04:42') AND d <=> MAKETIME(97,0,7)", packet_length=73) at 5.5/sql/sql_parse.cc:1079

#27 0x000000000062e2a9 in do_command (thd=0x7f9de43d4060) at 5.5/sql/sql_parse.cc:793

#28 0x00000000007300aa in do_handle_one_connection (thd_arg=0x7f9de43d4060) at 5.5/sql/sql_connect.cc:1266

#29 0x000000000072fb69 in handle_one_connection (arg=0x7f9de43d4060) at 5.5/sql/sql_connect.cc:1181

#30 0x0000000000b64819 in pfs_spawn_thread (arg=0x7f9de53be480) at 5.5/storage/perfschema/pfs.cc:1015

#31 0x00007f9debee4b50 in start_thread (arg=<optimized out>) at pthread_create.c:304

#32 0x00007f9deaa3420d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112

revision-id: knielsen@knielsen-hq.org-20140813134639-wk760plnzg5wu4x8

revno: 4270

branch-nick: 5.5