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

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

      Description

      Filing based on Elena Stepanova'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

            Activity

              People

              Assignee:
              sanja Oleksandr Byelkin
              Reporter:
              psergei Sergei Petrunia
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: