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

Assertion `0' failed in Item_row::illegal_method_call on SELECT INTERVAL

    XMLWordPrintable

Details

    Description

      SELECT INTERVAL (0,ROW(1,1),1,1,1,1,1,1,1) AS i;
      

      Leads to:

      CS 10.5.29 e6ea5d568c0fb972a391a8c64716846ddb7c57ef (Debug) Build 12/04/2025

      mariadbd: /test/10.5_dbg/sql/item_row.cc:32: void Item_row::illegal_method_call(const char *): Assertion `0' failed.
      

      CS 10.5.29 e6ea5d568c0fb972a391a8c64716846ddb7c57ef (Debug) Build 12/04/2025

      Core was generated by `/test/MD120425-mariadb-10.5.29-linux-x86_64-dbg/bin/mariadbd --no-defaults --ma'.
      Program terminated with signal SIGABRT, Aborted.
      Download failed: Invalid argument.  Continuing without source file ./nptl/./nptl/pthread_kill.c.
      #0  __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:44
       
      [Current thread is 1 (LWP 1952712)]
      (gdb) bt
      #0  __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:44
      #1  __pthread_kill_internal (signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:78
      #2  __GI___pthread_kill (threadid=<optimized out>, signo=signo@entry=6)at ./nptl/pthread_kill.c:89
      #3  0x000078b3a544526e in __GI_raise (sig=sig@entry=6)at ../sysdeps/posix/raise.c:26
      #4  0x000078b3a54288ff in __GI_abort () at ./stdlib/abort.c:79
      #5  0x000078b3a542881b in __assert_fail_base (fmt=0x78b3a55d01e8 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x588a6a141958 "0", file=file@entry=0x588a6a136b6f "/test/10.5_dbg/sql/item_row.cc", line=line@entry=32, function=function@entry=0x588a6a136b8e "void Item_row::illegal_method_call(const char *)") at ./assert/assert.c:94
      #6  0x000078b3a543b507 in __assert_fail (assertion=0x588a6a141958 "0", file=0x588a6a136b6f "/test/10.5_dbg/sql/item_row.cc", line=32, function=0x588a6a136b8e "void Item_row::illegal_method_call(const char *)")at ./assert/assert.c:103
      #7  0x0000588a695b8649 in Item_row::illegal_method_call (this=0x78b1b80137c0, method=0x588a6a15f4fa "val") at /test/10.5_dbg/sql/item_row.cc:32
      #8  0x0000588a695b926c in Item_row::val_real (this=0x78b1b80137c0)at /test/10.5_dbg/sql/item_row.h:76
      #9  0x0000588a695341ba in Item_func_interval::fix_length_and_dec (this=0x78b1b8013ea0) at /test/10.5_dbg/sql/item_cmpfunc.cc:1972
      #10 0x0000588a69571f7f in Item_func::fix_fields (this=0x78b1b8013ea0, thd=0x78b1b8000d58, ref=0x78b1b8013f90)at /test/10.5_dbg/sql/item_func.cc:389
      #11 0x0000588a69533e89 in Item_func_interval::fix_fields (this=0x78b1b8013ea0, thd=0x78b1b8000d58, ref=0x78b1b8013f90)at /test/10.5_dbg/sql/item_cmpfunc.cc:1916
      #12 0x0000588a6902a2bb in Item::fix_fields_if_needed (this=0x78b1b8013ea0, thd=0x78b1b8000d58, ref=0x78b1b8013f90) at /test/10.5_dbg/sql/item.h:1005
      #13 0x0000588a69029589 in Item::fix_fields_if_needed_for_scalar (this=0x78b1b8013ea0, thd=0x78b1b8000d58, ref=0x78b1b8013f90)at /test/10.5_dbg/sql/item.h:1009
      #14 0x0000588a690b2467 in setup_fields (thd=0x78b1b8000d58, ref_pointer_array={m_array = 0x78b1b8014fc0, m_size = 14}, fields=@0x78b1b8013240: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x78b1b8013f88, last = 0x78b1b8013f88, elements = 1}, <No data fields>}, column_usage=MARK_COLUMNS_READ, sum_func_list=0x78b1b8014bf0, pre_fix=0x78b1b8013258, allow_sum_func=true)at /test/10.5_dbg/sql/sql_base.cc:7693
      #15 0x0000588a691a0482 in JOIN::prepare (this=0x78b1b80148b8, tables_init=0x0, conds_init=0x0, og_num=0, order_init=0x0, skip_order_by=false, group_init=0x0, having_init=0x0, proc_param_init=0x0, select_lex_arg=0x78b1b80130d8, unit_arg=0x78b1b8004d10)at /test/10.5_dbg/sql/sql_select.cc:1375
      #16 0x0000588a6919c0f3 in mysql_select (thd=0x78b1b8000d58, tables=0x0, fields=@0x78b1b8013240: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x78b1b8013f88, last = 0x78b1b8013f88, elements = 1}, <No data fields>}, conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x78b1b8014890, unit=0x78b1b8004d10, select_lex=0x78b1b80130d8) at /test/10.5_dbg/sql/sql_select.cc:4897
      #17 0x0000588a6919bca5 in handle_select (thd=0x78b1b8000d58, lex=0x78b1b8004c48, result=0x78b1b8014890, setup_tables_done_option=0)at /test/10.5_dbg/sql/sql_select.cc:449
      #18 0x0000588a6915fedd in execute_sqlcom_select (thd=0x78b1b8000d58, all_tables=0x0) at /test/10.5_dbg/sql/sql_parse.cc:6452
      #19 0x0000588a691539c2 in mysql_execute_command (thd=0x78b1b8000d58)at /test/10.5_dbg/sql/sql_parse.cc:4043
      #20 0x0000588a6914bcc6 in mysql_parse (thd=0x78b1b8000d58, rawbuf=0x78b1b8013020 "SELECT INTERVAL (0,ROW(1,1),1,1,1,1,1,1,1) AS i", length=47, parser_state=0x78b3a405ec38, is_com_multi=false, is_next_command=false) at /test/10.5_dbg/sql/sql_parse.cc:8252
      #21 0x0000588a69148b80 in dispatch_command (command=COM_QUERY, thd=0x78b1b8000d58, packet=0x78b1b800aa39 "SELECT INTERVAL (0,ROW(1,1),1,1,1,1,1,1,1) AS i", packet_length=47, is_com_multi=false, is_next_command=false)at /test/10.5_dbg/sql/sql_parse.cc:1891
      #22 0x0000588a6914c6ac in do_command (thd=0x78b1b8000d58)at /test/10.5_dbg/sql/sql_parse.cc:1375
      #23 0x0000588a692f4403 in do_handle_one_connection (connect=0x588a6dada968, put_in_cache=true) at /test/10.5_dbg/sql/sql_connect.cc:1386
      #24 0x0000588a692f41a2 in handle_one_connection (arg=0x588a6d9b16a8)at /test/10.5_dbg/sql/sql_connect.cc:1298
      #25 0x000078b3a549ca94 in start_thread (arg=<optimized out>)at ./nptl/pthread_create.c:447
      #26 0x000078b3a5529c3c in clone3 ()at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:78
      

      Bug Detection Matrix

          Rel    o/d  Build   Commit                                    UniqueID observed             
      CS  10.5   dbg  120425  e6ea5d568c0fb972a391a8c64716846ddb7c57ef  0|SIGABRT|Item_row::illegal_method_call|Item_row::val_real|Item_func_interval::fix_length_and_dec|Item_func::fix_fields
      CS  10.5   opt  120425  e6ea5d568c0fb972a391a8c64716846ddb7c57ef  No bug found                  
      CS  10.6   dbg  120425  690b2cf776faa2e1a6832077cec2246c86cd00bf  No bug found                  
      CS  10.6   opt  120425  690b2cf776faa2e1a6832077cec2246c86cd00bf  No bug found                  
      CS  10.11  dbg  120425  acd071f599f416ddb4821dec485c4d912844213f  No bug found                  
      CS  10.11  opt  120425  acd071f599f416ddb4821dec485c4d912844213f  No bug found                  
      CS  11.4   dbg  120425  4a701e8ce4a178faf955641caf59fc13fcc718e9  No bug found                  
      CS  11.4   opt  120425  4a701e8ce4a178faf955641caf59fc13fcc718e9  No bug found                  
      CS  11.8   dbg  120425  db5bb6f3339be5a49c0f397eb80a0f259f73f447  No bug found                  
      CS  11.8   opt  120425  db5bb6f3339be5a49c0f397eb80a0f259f73f447  No bug found                  
      CS  12.0   dbg  120425  22efc2c784e1b7199fb5804e6330168277ea7dce  No bug found                  
      CS  12.0   opt  120425  22efc2c784e1b7199fb5804e6330168277ea7dce  No bug found                  
      ES  10.5   dbg  120425  0d368ec0042a81d9549fc939fb742f82350b20ab  0|SIGABRT|Item_row::illegal_method_call|Item_row::val_real|Item_func_interval::fix_length_and_dec|Item_func::fix_fields
      ES  10.5   opt  120425  0d368ec0042a81d9549fc939fb742f82350b20ab  No bug found                  
      ES  10.6   dbg  120425  74602d1b054ba6c9ee20af79d6e7807440a7a98e  No bug found                  
      ES  10.6   opt  120425  74602d1b054ba6c9ee20af79d6e7807440a7a98e  No bug found                  
      ES  11.4   dbg  120425  9cd12544ebfd0d52d2158af66b5aced58121cf1f  No bug found                  
      ES  11.4   opt  120425  9cd12544ebfd0d52d2158af66b5aced58121cf1f  No bug found                  
      MS  5.5    dbg  070123  bac287c315b1792e7ae33f91add6a60292f9bae8  0|SIGABRT|Item_row::illegal_method_call|Item_row::val_real|Item_func_interval::fix_length_and_dec|Item_func::fix_fields
      MS  5.5    opt  070123  bac287c315b1792e7ae33f91add6a60292f9bae8  No bug found                  
      MS  5.6    dbg  070123  dab95781a1244104d6b87020ac2fc4d190ba2946  0|SIGABRT|Item_row::illegal_method_call|Item_row::val_real|Item_func_interval::fix_length_and_dec|Item_func::fix_fields
      MS  5.6    opt  070123  dab95781a1244104d6b87020ac2fc4d190ba2946  No bug found                  
      MS  5.7    dbg  060224  f7680e98b6bbe3500399fbad465d08a6b75d7a5c  No bug found                  
      MS  5.7    opt  060224  f7680e98b6bbe3500399fbad465d08a6b75d7a5c  No bug found                  
      MS  8.0    dbg  060224  49ef33f7edadef3ae04665e73d1babd40179a4f1  No bug found                  
      MS  8.0    opt  060224  49ef33f7edadef3ae04665e73d1babd40179a4f1  No bug found                  
      MS  9.1    dbg  211024  61a3a1d8ef15512396b4c2af46e922a19bf2b174  No bug found                  
      MS  9.1    opt  211024  61a3a1d8ef15512396b4c2af46e922a19bf2b174  No bug found                  
      

      Attachments

        Activity

          People

            bar Alexander Barkov
            Roel Roel Van de Paar
            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.