[
https://issues.apache.org/jira/browse/PHOENIX-882?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Lars Hofhansl updated PHOENIX-882:
----------------------------------
Summary: Updatable view should check view condition upon upsert (was:
Updatable view should view condition upon upsert)
> 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
>
>
> 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)
