Uploaded image for project: 'Phoenix'
  1. Phoenix
  2. PHOENIX-1480

Incorrect query results may occur when VIEW uses indexes from physical table

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 4.3.0, 3.3.0, 3.2.2, 4.2.2
    • None
    • None

    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.

      Attachments

        1. PHOENIX-1480.patch
          32 kB
          James R. Taylor

        Activity

          People

            jamestaylor James R. Taylor
            jamestaylor James R. Taylor
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: