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

INSERT from SELECT crashes server on error missing column.

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Confirmed (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 10.4, 10.5, 10.6, 10.5.11
    • Fix Version/s: 10.4, 10.5, 10.6
    • Labels:
      None
    • Environment:
      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

            Activity

              People

              Assignee:
              igor Igor Babaev
              Reporter:
              ebyrob Robert Eby
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:

                  Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.