You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Hudson (JIRA)" <ji...@apache.org> on 2014/12/02 19:02:13 UTC
[jira] [Commented] (PHOENIX-1480) Incorrect query results may occur
when VIEW uses indexes from physical table
[ 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)