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

LP:889744 - Bug lp:833702 fails with wrong result in MariaDB 5.5, "Impossible where" in EXPLAIN

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Fixed
    • None
    • None
    • None

    Description

      Bug lp:833702 fails with wrong empty result.
      In addition the EXPLAIN for the test query changed to
      "Impossible where" which indicates that constant substitution was
      applied to subqueries. This is generally wrong in MariaDB 5.3 an on.

      Suggestion: detect all subquery evaluations during optimization
      by using sql_print_error.

      Attachments

        Activity

          People

            timour Timour Katchaounov (Inactive)
            timour Timour Katchaounov (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 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.