[jira] [Created] (PHOENIX-2214) ORDER BY optimization incorrect for queries over views containing WHERE clause

["Eli Levine (JIRA)" <ji...@apache.org>]

Eli Levine created PHOENIX-2214:
-----------------------------------

             Summary: ORDER BY optimization incorrect for queries over views containing WHERE clause
                 Key: PHOENIX-2214
                 URL: https://issues.apache.org/jira/browse/PHOENIX-2214
             Project: Phoenix
          Issue Type: Bug
            Reporter: Eli Levine


Phoenix optimizes away ORDER BY clauses if they are the same order as the default PK order. However, this optimization is not done correctly for views (tenant-specific and regular) if the view has been created with a WHERE clause.

See attached patch for repro, in which the last assertEquals() fails due to the fact that ORDER BY is not optimized away, as expected.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)