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

Assertion `value <= ((ulonglong) 0xFFFFFFFFL) * 10000ULL' failed in str_to_DDhhmmssff_internal

    XMLWordPrintable

Details

    Description

      SELECT EXTRACT(HOUR_MICROSECOND FROM '42949672955000x1');
      

      10.4 64f44b22d9a3dab3d4c0b77addbcbdafde57b466

      mysqld: /data/bld/10.4-asan/sql-common/my_time.c:964: str_to_DDhhmmssff_internal: Assertion `value <= ((ulonglong) 0xFFFFFFFFL) * 10000ULL' failed.
      231127 15:14:36 [ERROR] mysqld got signal 6 ;
       
      #9  0x00007f8f0c253e32 in __GI___assert_fail (assertion=0x55c6a35f8760 "value <= ((ulonglong) 0xFFFFFFFFL) * 10000ULL", file=0x55c6a35f8120 "/data/bld/10.4-asan/sql-common/my_time.c", line=964, function=0x55c6a35f8ce0 <__PRETTY_FUNCTION__.8> "str_to_DDhhmmssff_internal") at ./assert/assert.c:101
      #10 0x000055c6a279bc6e in str_to_DDhhmmssff_internal (neg=0 '\000', str=0x62b000062986 "x1", length=16, l_time=0x7f8f03210f00, max_hour=87649415, err_hour=87649415, status=0x7f8f03210c00, endptr=0x7f8f032100a0) at /data/bld/10.4-asan/sql-common/my_time.c:964
      #11 0x000055c6a279a618 in str_to_datetime_or_date_or_time_body (str=0x62b000062978 "42949672955000x1", length=16, l_time=0x7f8f03210f00, fuzzydate=0, status=0x7f8f03210c00, time_max_hour=87649415, time_err_hour=87649415, allow_dates_delimited=1 '\001', allow_dates_numeric=0 '\000') at /data/bld/10.4-asan/sql-common/my_time.c:754
      #12 0x000055c6a279aec6 in str_to_datetime_or_date_or_interval_hhmmssff (str=0x62b000062978 "42949672955000x1", length=16, to=0x7f8f03210f00, mode=0, status=0x7f8f03210c00, time_max_hour=87649415, time_err_hour=87649415) at /data/bld/10.4-asan/sql-common/my_time.c:839
      #13 0x000055c6a0f13e9f in Temporal::ascii_to_datetime_or_date_or_interval_DDhhmmssff (this=0x7f8f03210f00, st=0x7f8f03210c00, str=0x62b000062978 "42949672955000x1", length=16, mode=...) at /data/bld/10.4-asan/sql/sql_type.h:926
      #14 0x000055c6a0f13b76 in Temporal::ascii_to_temporal (this=0x7f8f03210f00, st=0x7f8f03210c00, str=0x62b000062978 "42949672955000x1", length=16, mode=...) at /data/bld/10.4-asan/sql/sql_type.h:910
      #15 0x000055c6a0f0a40b in Temporal::str_to_temporal (this=0x7f8f03210f00, thd=0x62b00005b208, status=0x7f8f03210c00, str=0x62b000062978 "42949672955000x1", length=16, cs=0x55c6a4383120 <my_charset_latin1>, flags=...) at /data/bld/10.4-asan/sql/sql_time.cc:412
      #16 0x000055c6a110514a in Temporal::make_from_str (this=0x7f8f03210f00, thd=0x62b00005b208, warn=0x7f8f03210a00, str=0x62b000062978 "42949672955000x1", length=16, cs=0x55c6a4383120 <my_charset_latin1>, fuzzydate=...) at /data/bld/10.4-asan/sql/sql_type.cc:246
      #17 0x000055c6a113cee5 in Temporal_hybrid::Temporal_hybrid (this=0x7f8f03210f00, thd=0x62b00005b208, warn=0x7f8f03210a00, str=0x62b0000629c8, mode=...) at /data/bld/10.4-asan/sql/sql_type.h:1114
      #18 0x000055c6a13ab8e3 in Item::get_date_from_string (this=0x62b000062998, thd=0x62b00005b208, to=0x7f8f03210f00, mode=...) at /data/bld/10.4-asan/sql/item.cc:1434
      #19 0x000055c6a08f814f in Item_string::get_date (this=0x62b000062998, thd=0x62b00005b208, ltime=0x7f8f03210f00, fuzzydate=<error reading variable: Cannot access memory at address 0xffffffffffffffe6>) at /data/bld/10.4-asan/sql/item.h:4512
      #20 0x000055c6a11053a5 in Temporal_hybrid::Temporal_hybrid (this=0x7f8f03210f00, thd=0x62b00005b208, item=0x62b000062998, fuzzydate=...) at /data/bld/10.4-asan/sql/sql_type.cc:255
      #21 0x000055c6a1616873 in Extract_source::Extract_source (this=0x7f8f03210f00, thd=0x62b00005b208, item=0x62b000062998, mode=<error reading variable: Cannot access memory at address 0xffffffffffffffe6>) at /data/bld/10.4-asan/sql/sql_type.h:1211
      #22 0x000055c6a160a797 in Item_extract::val_int (this=0x62b000062a68) at /data/bld/10.4-asan/sql/item_timefunc.cc:2169
      #23 0x000055c6a112aec8 in Type_handler::Item_send_longlong (this=0x55c6a3d91760 <type_handler_longlong>, item=0x62b000062a68, protocol=0x62b00005b808, buf=0x7f8f032110f0) at /data/bld/10.4-asan/sql/sql_type.cc:7146
      #24 0x000055c6a11443d0 in Type_handler_longlong::Item_send (this=0x55c6a3d91760 <type_handler_longlong>, item=0x62b000062a68, protocol=0x62b00005b808, buf=0x7f8f032110f0) at /data/bld/10.4-asan/sql/sql_type.h:5255
      #25 0x000055c6a08f4040 in Item::send (this=0x62b000062a68, protocol=0x62b00005b808, buffer=0x7f8f032110f0) at /data/bld/10.4-asan/sql/item.h:1045
      #26 0x000055c6a08e5c95 in Protocol::send_result_set_row (this=0x62b00005b808, row_items=0x62b0000625f8) at /data/bld/10.4-asan/sql/protocol.cc:1033
      #27 0x000055c6a0a911bf in select_send::send_data (this=0x62b0000634f8, items=...) at /data/bld/10.4-asan/sql/sql_class.cc:3130
      #28 0x000055c6a0c82992 in JOIN::exec_inner (this=0x62b000063528) at /data/bld/10.4-asan/sql/sql_select.cc:4493
      #29 0x000055c6a0c8156a in JOIN::exec (this=0x62b000063528) at /data/bld/10.4-asan/sql/sql_select.cc:4407
      #30 0x000055c6a0c855f8 in mysql_select (thd=0x62b00005b208, tables=0x0, wild_num=0, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x62b0000634f8, unit=0x62b00005f140, select_lex=0x62b000062498) at /data/bld/10.4-asan/sql/sql_select.cc:4846
      #31 0x000055c6a0c55edb in handle_select (thd=0x62b00005b208, lex=0x62b00005f080, result=0x62b0000634f8, setup_tables_done_option=0) at /data/bld/10.4-asan/sql/sql_select.cc:442
      #32 0x000055c6a0bc077c in execute_sqlcom_select (thd=0x62b00005b208, all_tables=0x0) at /data/bld/10.4-asan/sql/sql_parse.cc:6521
      #33 0x000055c6a0badb42 in mysql_execute_command (thd=0x62b00005b208) at /data/bld/10.4-asan/sql/sql_parse.cc:3978
      #34 0x000055c6a0bc9a6b in mysql_parse (thd=0x62b00005b208, rawbuf=0x62b0000623b8 "SELECT EXTRACT(HOUR_MICROSECOND FROM '42949672955000x1')", length=56, parser_state=0x7f8f03213c60, is_com_multi=false, is_next_command=false) at /data/bld/10.4-asan/sql/sql_parse.cc:8060
      #35 0x000055c6a0b9fae2 in dispatch_command (command=COM_QUERY, thd=0x62b00005b208, packet=0x62900021c209 "", packet_length=56, is_com_multi=false, is_next_command=false) at /data/bld/10.4-asan/sql/sql_parse.cc:1857
      #36 0x000055c6a0b9c651 in do_command (thd=0x62b00005b208) at /data/bld/10.4-asan/sql/sql_parse.cc:1378
      #37 0x000055c6a0fa2d15 in do_handle_one_connection (connect=0x6080000009a8) at /data/bld/10.4-asan/sql/sql_connect.cc:1419
      #38 0x000055c6a0fa262c in handle_one_connection (arg=0x6080000009a8) at /data/bld/10.4-asan/sql/sql_connect.cc:1323
      #39 0x000055c6a1c0726c in pfs_spawn_thread (arg=0x615000003508) at /data/bld/10.4-asan/storage/perfschema/pfs.cc:1869
      #40 0x00007f8f0c2a8044 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
      #41 0x00007f8f0c32861c in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
      

      Non-debug builds return NULL with a warning, which appears to be a correct outcome:

      EXTRACT(HOUR_MICROSECOND FROM '42949672955000x1')
      NULL
      Warnings:
      Warning	1292	Incorrect interval value: '42949672955000x1'
      

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.