phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "James Taylor (JIRA)" <j...@apache.org>
Subject [jira] [Resolved] (PHOENIX-882) Updatable view should check view condition upon upsert
Date Fri, 02 May 2014 05:24:17 GMT

     [ https://issues.apache.org/jira/browse/PHOENIX-882?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

James Taylor resolved PHOENIX-882.
----------------------------------

    Resolution: Fixed

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

Mime
View raw message