[jira] [Comment Edited] (PHOENIX-1367) VIEW derived from another VIEW doesn't use parent VIEW indexes

["Cody Marcel (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/PHOENIX-1367?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15383378#comment-15383378 ] 

Cody Marcel edited comment on PHOENIX-1367 at 7/19/16 12:34 AM:
----------------------------------------------------------------

The attachment is only a test, but not an actual patch.

I have noticed this effects not only the view, but also writes to the index on the base view.
test scenario
--create table
--create view1 on base table
--create index on view1
--create view2 on view1.
--insert rows into view1
--insert rows into view2

--queries on view1 use the index as expected.
--queries on view2 do not use the index as described in this bug.
-- rows returned from query to view2 include all rows written to both views, but only because they are returned from the base table instead of the index.
--rows returned from index/view1 do not reflect data written into view2. This shows that the write path to the index on views of views is not kept in sync with the base table.


was (Author: cody.marcel@gmail.com):
The attachment is only a test, but an actual patch.

I have noticed this effects not only the view, but also writes to the index on the base view.
test scenario
--create table
--create view1 on base table
--create index on view1
--create view2 on view1.
--insert rows into view1
--insert rows into view2

--queries on view1 use the index as expected.
--queries on view2 do not use the index as described in this bug.
-- rows returned from query to view2 include all rows written to both views, but only because they are returned from the base table instead of the index.
--rows returned from index/view1 do not reflect data written into view2. This shows that the write path to the index on views of views is not kept in sync with the base table.

> VIEW derived from another VIEW doesn't use parent VIEW indexes
> --------------------------------------------------------------
>
>                 Key: PHOENIX-1367
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-1367
>             Project: Phoenix
>          Issue Type: Sub-task
>            Reporter: James Taylor
>         Attachments: PHOENIX_1367.test.patch
>
>
> If a VIEW has an index and another VIEW is derived from it, the child view will not use the parent view's indexes.



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