[PHOENIX-1480] Incorrect query results may occur when VIEW uses indexes from physical table

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 4.3.0, 3.3.0, 3.2.2, 4.2.2
• Assignee: James R. Taylor
• Reporter: James R. Taylor
• Created: 25/Nov/14 02:24
• Updated: 21/Nov/15 02:16
• Resolved: 03/Dec/14 22:58

Description

We currently dynamically add the global indexes on the table to the VIEW as well (so that the indexes are considered in addition to the view). However, we don't add the where clause and view constants so it's possible that when the index is used that rows are returned that aren't applicable for the view.