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

crash/valgrind error in resolve_ref_in_select_and_group

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: 10.3, 10.4, 10.5, 10.6, 10.6.3
    • Fix Version/s: N/A
    • Labels:
      None
    • Environment:
      Linux x64

      Description

      This segfaulted a release build. But run it in valgrind to see:

      errors in context 1 of 1:
      Conditional jump or move depends on uninitialised value(s)
      at: resolve_ref_in_select_and_group (item.cc:5409)
      by: Item_ref::fix_fields (item.cc:7910)
      by: fix_fields_if_needed (item.h:1144)
      by: Item_func::fix_fields (item_func.cc:347)
      by: fix_fields_if_needed (item.h:1144)
      by: fix_fields_if_needed_for_scalar (item.h:1148)
      by: fix_fields_if_needed_for_bool (item.h:1152)
      by: JOIN::prepare (sql_select.cc:1459)
      by: subselect_single_select_engine::prepare(item_subselect.cc:3895)
      by: Item_subselect::fix_fields (item_subselect.cc:295)
      by: fix_fields_if_needed (item.h:1144)
      by: fix_fields_if_needed_for_scalar (item.h:1148)
      by: fix_fields_if_needed_for_bool (item.h:1152)
      by: setup_conds (sql_base.cc:8444)
      by: setup_without_group (sql_select.cc:832)
      by: JOIN::prepare (sql_select.cc:1407)
      by: mysql_select (sql_select.cc:4958)
      by: mysql_multi_update (sql_update.cc:1968)
      by: mysql_execute_command (sql_parse.cc:4499)
      by: mysql_parse (sql_parse.cc:8026)
      

      Testcase

       
      drop table if exists t;
      create table t (a blob,  b text ) engine=innodb;
      update t  set  a =current_timestamp 
      where exists 
      (
       select b from  t
       where @b:=a
       having a  >  72057594037927936
      );
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              sanja Oleksandr Byelkin
              Reporter:
              sbester1 sbester1
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Git Integration

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