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

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

Lars Hofhansl created PHOENIX-882:
-------------------------------------

             Summary: Updatable view should 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)