Uploaded image for project: 'Phoenix'
  1. Phoenix
  2. PHOENIX-6402 Allow using local indexes with uncovered columns in the WHERE clause
  3. PHOENIX-6408

LIMIT on local index query with uncovered columns in the WHERE returns wrong result.

    XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • 5.1.1, 4.16.1, 5.2.0
    • 5.1.1, 4.16.1, 5.2.0
    • None
    • None

    Description

      Sorry one more issue.

      In PHOENIX-6402 I fixed local indexes with uncovered columns in the WHERE clause.

      It turns out that LIMIT is also executed as a filter, so now that also needs to change and be invoked after the extra filter.

      Attachments

        Issue Links

          Activity

            People

              larsh Lars Hofhansl
              larsh Lars Hofhansl
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: