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

crash in make_join_statistics with multi-table update involving view

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • 10.0.4, 5.3.12, 5.5.33a
    • 5.5.34, 10.0.6, 5.3.13
    • None
    • 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

            igor Igor Babaev
            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.