Bug lp:833702 fails with wrong result in MariaDB 5.5, "Impossible where" in EXPLAIN
Bug #889744 reported by
Timour Katchaounov
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.
