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

Bug #889744 reported by Timour Katchaounov on 2011-11-13
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
MariaDB
Fix Released
Critical
Timour Katchaounov

Bug 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.

Related branches

Changed in maria:
assignee: nobody → Timour Katchaounov (timour)
importance: Undecided → Critical
milestone: none → 5.5
summary: - Bug lp:833702 fails with wrong result in MariaDB 5.5, suspicious
- "Impossible where" in EXPLAIN
+ Bug lp:833702 fails with wrong result in MariaDB 5.5, "Impossible where"
+ in EXPLAIN
Changed in maria:
status: New → In Progress
Changed in maria:
status: In Progress → Fix Released
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers