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

explain SQL return an error while the SQL without explain can be executed correctly

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Blocker
    • Resolution: Duplicate
    • Affects Version/s: 10.0.22
    • Fix Version/s: 10.0.23, 10.1.10
    • Component/s: Server
    • Labels:
      None

      Description

      Mariadb version: 10.0.22
      Desc: When I execute the following SQL:

      EXPLAIN
      INSERT INTO `table_test`(
      `id`,
      `status`
      )
      SELECT
      id,
      status
      FROM
      table_test
      WHERE
      id NOT IN (SELECT id FROM table_testwhere id < 10)

      the server return a error which states 'Column count doesn't match value count at row 1'.
      but I can execute that SQL correctly without 'EXPLAIN'.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              hzw hzw
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Git Integration