Issue Details (XML | Word | Printable)

Key: CORE-2659
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Dmitry Yemanov
Reporter: Dmitry Yemanov
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
Firebird Core

Sub-optimal (not indexed) query plan for outer joins involving complex views

Created: 02/Oct/09 09:24 PM   Updated: 12/Nov/09 05:48 PM
Component/s: Engine
Affects Version/s: 2.5 Beta 1, 2.5 Beta 2
Fix Version/s: 2.5 RC1

Time Tracking:
Not Specified

Planning Status: Unspecified


 Description  « Hide
Under some conditions (without a simple test case, unfortunately), if (a) some view contains unions/aggregations inside, (b) this view has expression based columns and (c) this view is used in outer joins with other streams and the join condition involves the view columns (expressions), then an outer join may be optimized badly.

 All   Comments   Work Log   Change History   Version Control   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
There are no comments yet on this issue.