[MDEV-2466] LP:889744 - Bug lp:833702 fails with wrong result in MariaDB 5.5, "Impossible where" in EXPLAIN Created: 2011-11-13  Updated: 2014-06-20  Resolved: 2012-10-04

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Bug Priority: Critical
Reporter: Timour Katchaounov (Inactive) Assignee: Timour Katchaounov (Inactive)
Resolution: Fixed Votes: 0
Labels: Launchpad

Attachments: XML File LPexportBug889744.xml    

 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.

 Comments   
Comment by Rasmus Johansson (Inactive) [ 2011-11-15 ]

Launchpad bug id: 889744

Generated at Thu Feb 08 06:42:02 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.