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

EXPLAIN REPLACE produces an error: Column count doesn't match value count

    XMLWordPrintable

Details

    • 10.0.22, 10.1.9-1, 10.1.9-2, 10.1.9-3, 10.0.23

    Description

      Filing based on elenst's example in CSC#8345: 

      drop table if exists t1, t2;
      		 
      create table t1 (a int);
      		 
      insert into t1 values (1);
      		 
      create table t2 (b int, c int);
      		 

      MariaDB [test]> replace into t2 select 100, (select a from t1);
      		 
      Query OK, 1 row affected (0.05 sec)
      		 
      Records: 1  Duplicates: 0  Warnings: 0
      		 
       
      		 
      MariaDB [test]> explain replace into t2 select 100, (select a from t1);
      		 
      ERROR 1136 (21S01): Column count doesn't match value count at row 1

      Attachments

        Issue Links

          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-21077 explain SQL return an error while the SQL without explain can be executed correctly

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-7220 Materialization strategy is not used for REPLACE ... SELECT

          • Major - Major loss of function.
          • Closed

          Activity

            People

              sanja Oleksandr Byelkin
              psergei Sergei Petrunia
              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.