Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-6592

Assertion `ltime->day == 0' failed with TIMESTAMP, MAKETIME

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 5.5.39
    • Fix Version/s: 5.5.40
    • Component/s: Temporal Types
    • Labels:
      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

            Activity

              People

              Assignee:
              bar Alexander Barkov
              Reporter:
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: