[
https://issues.apache.org/jira/browse/PHOENIX-1480?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14231834#comment-14231834
]
Hudson commented on PHOENIX-1480:
---------------------------------
SUCCESS: Integrated in Phoenix-master #508 (See
[https://builds.apache.org/job/Phoenix-master/508/])
PHOENIX-1480 Incorrect query results may occur when VIEW uses indexes from
physical table (jtaylor: rev 766eec2b502410387e90a598649e88064e8c84d8)
* phoenix-core/src/main/java/org/apache/phoenix/compile/FromCompiler.java
* phoenix-core/src/test/java/org/apache/phoenix/compile/QueryOptimizerTest.java
* phoenix-core/src/main/java/org/apache/phoenix/util/QueryUtil.java
* phoenix-core/src/main/java/org/apache/phoenix/compile/WhereOptimizer.java
*
phoenix-core/src/it/java/org/apache/phoenix/end2end/index/DropIndexDuringUpsertIT.java
* phoenix-core/src/main/java/org/apache/phoenix/compile/StatementContext.java
* phoenix-core/src/it/java/org/apache/phoenix/end2end/ViewIT.java
* phoenix-core/src/main/java/org/apache/phoenix/schema/PTableImpl.java
* phoenix-core/src/main/java/org/apache/phoenix/util/IndexUtil.java
* phoenix-core/src/main/java/org/apache/phoenix/compile/CreateTableCompiler.java
* phoenix-core/src/main/java/org/apache/phoenix/schema/ColumnRef.java
* phoenix-core/src/main/java/org/apache/phoenix/schema/MetaDataClient.java
* phoenix-core/src/main/java/org/apache/phoenix/schema/TableRef.java
* phoenix-core/src/main/java/org/apache/phoenix/compile/WhereCompiler.java
*
phoenix-core/src/main/java/org/apache/phoenix/compile/IndexStatementRewriter.java
> Incorrect query results may occur when VIEW uses indexes from physical table
> ----------------------------------------------------------------------------
>
> Key: PHOENIX-1480
> URL: https://issues.apache.org/jira/browse/PHOENIX-1480
> Project: Phoenix
> Issue Type: Bug
> Reporter: James Taylor
> Assignee: James Taylor
> Attachments: PHOENIX-1480.patch
>
>
> 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.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
