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

    • Bug
    • Status: Closed (View Workflow)
    • Blocker
    • Resolution: Duplicate
    • 10.0.22
    • 10.0.23, 10.1.10
    • Server
    • 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

              Unassigned Unassigned
              hzw hzw
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.