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

["James Taylor (JIRA)" <ji...@apache.org>]

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

James Taylor commented on PHOENIX-882:
--------------------------------------

Fixed bug plus cleaned up the implementation, as before we weren't tracking the constant values on the PColumn so had to keep more state.

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