[MDEV-42] lp:905353 - analyze and fix Created: 2012-01-04  Updated: 2012-02-16  Resolved: 2012-02-16

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

Type: Bug Priority: Major
Reporter: Rasmus Johansson (Inactive) Assignee: Timour Katchaounov (Inactive)
Resolution: Duplicate Votes: 0
Labels: None


 Comments   
Comment by Timour Katchaounov (Inactive) [ 2012-02-16 ]

Fixed by the following commit:

revno: 3380
committer: sanja@montyprogram.com
branch nick: work-maria-5.3-lpb908269
timestamp: Tue 2012-01-10 23:26:00 +0200
message:
Fix for LP BUG#908269 Wrong result with subquery in select list, EXISTS, constant MyISAM/Aria table.

Problem: When building the condition for JOIN::outer_ref_cond the optimizer forgot to take into account
that this condition could depend on constant tables as well.

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