[
https://issues.apache.org/jira/browse/PHOENIX-882?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
James Taylor updated PHOENIX-882:
---------------------------------
Attachment: PHOENIX-882.patch
> Updatable view should check view condition upon upsert
> ------------------------------------------------------
>
> Key: PHOENIX-882
> URL: https://issues.apache.org/jira/browse/PHOENIX-882
> Project: Phoenix
> Issue Type: Bug
> Reporter: Lars Hofhansl
> Fix For: 3.0.0, 4.0.0
>
> Attachments: PHOENIX-882.patch
>
>
> Updating a row can make it disappear from the view:
> create table X (X varchar primary key, Y varchar);
> create view X1 as select * from X where Y = '1';
> upsert into X1 values('1', '1');
> // now the row with key '1' is visible through the view
> upsert into X1 values('1', '2');
> // row with key '1' is no longer visible
> upsert into X1 values('2', '2');
> // the new row never shows up in the view
--
This message was sent by Atlassian JIRA
(v6.2#6252)
