[jira] [Updated] (PHOENIX-882) Updatable view should check view condition upon upsert

["Lars Hofhansl (JIRA)" <ji...@apache.org>]

     [ 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)