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

INSERT from SELECT crashes server on error missing column.

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.5.11, 10.4(EOL), 10.5, 10.6
    • 10.4.25, 10.5.16, 10.6.8, 10.7.4, 10.8.3
    • Data Manipulation - Insert
    • None
    • Microsoft Windows 10
      mariadb Ver 15.1 Distrib 10.5.11-MariaDB, for Win64 (AMD64), source revision dc82effa5df5e59be6c7de4038f0a832f37d9bdc
      Lenovo t560 (Intel)

    Description

      Expected:
      Running the following query should produce an error about missing column 't.fup'.

      Actual:
      Instead I get error code 1, "MySQL server has gone away". Which indicates the server has crashed.

      — Query code —
      use test;

      DROP TABLE IF EXISTS tmp;
      		 
      CREATE TEMPORARY TABLE tmp (ID INTEGER UNSIGNED NOT NULL);
      		 
       
      		 
      INSERT INTO tmp
      		 
      SELECT t.foo AS ID
      		 
      FROM (select 1 AS foo) AS t
      		 
      LEFT JOIN (SELECT 1 AS dbl) AS broken ON (
      		 
                   SELECT MAX(1) 
                   FROM (select 3 AS baz) AS c 
                   WHERE c.baz = t.fup
      		 
      )
      		 
      ;

      See attached *.err file for crash details. I tested this same query on MariaDB 10.4.12 and it worked fine (produced expected error without crash).

      Attachments

        Issue Links

          duplicates

          Bug - A problem which impairs or prevents the functions of the product. MDEV-26412 Server crash in Item_field::fix_outer_field for INSERT SELECT

          • Major - Major loss of function.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-25206 Crash with CREATE VIEW .. SELECT with non-existing field in ON condition

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-29088 Server crash upon CREATE VIEW with unknown column in ON condition

          • Major - Major loss of function.
          • Closed

          Activity

            People

              igor Igor Babaev
              ebyrob Robert Eby
              Votes:
              0 Vote for this issue
              Watchers:
              4 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.