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

crash in Item_field::used_tables

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 5.5.36, 10.0.10
    • 5.5.38, 10.0.11
    • None
    • None

    Description

      mysqld.exe!Item_field::used_tables()[item.cc:2768]
      mysqld.exe!Item::const_item()[item.h:1048]
      mysqld.exe!Item_in_subselect::const_item()[item_subselect.h:606]
      mysqld.exe!st_select_lex::optimize_unflattened_subqueries()[sql_lex.cc:3457]
      mysqld.exe!JOIN::optimize_constant_subqueries()[opt_subselect.cc:4986]
      mysqld.exe!JOIN::optimize_inner()[sql_select.cc:1118]
      mysqld.exe!JOIN::optimize()[sql_select.cc:1013]
      mysqld.exe!st_select_lex::optimize_unflattened_subqueries()[sql_lex.cc:3489]
      mysqld.exe!mysql_update()[sql_update.cc:369]
      mysqld.exe!mysql_execute_command()[sql_parse.cc:3334]
      mysqld.exe!mysql_parse()[sql_parse.cc:6457]
      mysqld.exe!dispatch_command()[sql_parse.cc:1311]
      mysqld.exe!do_command()[sql_parse.cc:1012]
      mysqld.exe!threadpool_process_request()[threadpool_common.cc:233]
      mysqld.exe!io_completion_callback()[threadpool_win.cc:568]

      How to repeat:

      drop table if exists `r`;
      create table `r`(`c` int)engine=innodb;
      select exists(select 1 from `r`
      group by `c` in (select `c` from `r`));

      Attachments

        Activity

          People

            sanja Oleksandr Byelkin
            sbester1 sbester1
            Votes:
            0 Vote for this issue
            Watchers:
            5 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.