Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
5.5.39
-
None
Description
Initially reported in a comment to https://tokutek.atlassian.net/browse/DB-516
--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
|
Stack trace from:
revision-id: knielsen@knielsen-hq.org-20140813134639-wk760plnzg5wu4x8
|
revno: 4270
|
branch-nick: 5.5
|
Attachments
Issue Links
- relates to
-
MDEV-5750 Assertion `ltime->year == 0' fails on a query with EXTRACT DAY_MINUTE and TIME column
- Closed