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

        Details

        • Type: Bug
        • Status: Closed
        • Priority: Critical
        • Resolution: Fixed
        • Affects Version/s: None
        • Fix Version/s: None
        • Component/s: None
        • Labels:

          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.

            Gliffy Diagrams

              Attachments

                Activity

                Hide
                Permalink
                ratzpo Rasmus Johansson added a comment -

                Launchpad bug id: 889744

                Show
                ratzpo Rasmus Johansson added a comment - Launchpad bug id: 889744

                  People

                  • Assignee:
                    timour Timour Katchaounov
                    Reporter:
                    timour Timour Katchaounov
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    0 Start watching this issue

                    Dates

                    • Created:
                      Updated:
                      Resolved: