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

p_s: crash in simplify_joins with delete using subselect from view

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.0.2, 5.5.31, 5.3.12
    • Fix Version/s: 10.0.4, 5.5.32, 5.3.13
    • Component/s: None
    • Labels:
      None
    • Environment:
      Win X64, Linux

      Description

      mysqld.exe!simplify_joins()[sql_select.cc:12827]
      mysqld.exe!JOIN::optimize()[sql_select.cc:1054]
      mysqld.exe!st_select_lex::optimize_unflattened_subqueries()[sql_lex.cc:3476]
      mysqld.exe!mysql_delete()[sql_delete.cc:123]
      mysqld.exe!mysql_execute_command()[sql_parse.cc:3067]
      mysqld.exe!Prepared_statement::execute()[sql_prepare.cc:3905]
      mysqld.exe!Prepared_statement::execute_loop()[sql_prepare.cc:3564]
      mysqld.exe!mysql_sql_stmt_execute()[sql_prepare.cc:2732]
      mysqld.exe!mysql_execute_command()[sql_parse.cc:2207]
      mysqld.exe!mysql_parse()[sql_parse.cc:5765]
      mysqld.exe!dispatch_command()[sql_parse.cc:1071]
      mysqld.exe!do_command()[sql_parse.cc:794]
      mysqld.exe!threadpool_process_request()[threadpool_common.cc:224]
      mysqld.exe!io_completion_callback()[threadpool_win.cc:568]

      drop table if exists `t1`,`t2`,`v1`;
      create table `t1`(`a` int)engine=innodb;
      create table `t2`(`a` int)engine=innodb;
      create or replace view `v1` as select `a` from `t1`;
      prepare s from "delete  from `t2` order by (select 1 from `v1`)";
      execute s;

        Attachments

          Activity

            People

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

              Dates

              Created:
              Updated:
              Resolved: