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

crash in make_join_statistics with multi-table update involving view

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 10.0.4, 5.3.12, 5.5.33a
    • Fix Version/s: 5.5.34, 10.0.6, 5.3.13
    • Component/s: None
    • Labels:
      None

      Description

      Version: '10.0.4-MariaDB'  mariadb.org binary distribution
      [ERROR] mysqld got exception 0xc0000005 ;
       
      mysqld.exe!make_join_statistics()[sql_select.cc:3740]
      mysqld.exe!JOIN::optimize_inner()[sql_select.cc:1303]
      mysqld.exe!JOIN::optimize()[sql_select.cc:1010]
      mysqld.exe!mysql_select()[sql_select.cc:3208]
      mysqld.exe!mysql_multi_update()[sql_update.cc:1414]
      mysqld.exe!mysql_execute_command()[sql_parse.cc:3309]
      mysqld.exe!mysql_parse()[sql_parse.cc:6269]
      mysqld.exe!dispatch_command()[sql_parse.cc:1280]
      mysqld.exe!do_command()[sql_parse.cc:989]
      mysqld.exe!threadpool_process_request()[threadpool_common.cc:232]
      mysqld.exe!io_completion_callback()[threadpool_win.cc:568]

      How to repeat:

      drop table if exists a,b,c,d;
      create table a(a int,b tinyint,c tinyint)engine=innodb;
      create table b(a tinyint,b float,c int,key b(b))engine=innodb;
      create table d(a int,b int,c int,key(a),key(b),key(c))engine=myisam;
      create or replace view c as select b.b a,a.b b from a,b where a.a=b.a;
      update `d` natural join `c` set a:=1;

        Attachments

          Activity

            People

            • Assignee:
              igor Igor Babaev
              Reporter:
              sbester1 sbester1
            • Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: