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

crash in Item_field::used_tables

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 5.5.36, 10.0.10
    • Fix Version/s: 5.5.38, 10.0.11
    • Component/s: None
    • Labels:
      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

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

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration