[
https://issues.apache.org/jira/browse/PHOENIX-882?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13942897#comment-13942897
]
Hudson commented on PHOENIX-882:
--------------------------------
SUCCESS: Integrated in Apache Phoenix - Branch:3.0 #52 (See
[https://builds.apache.org/job/Phoenix-3.0/52/])
PHOENIX-882 Updatable view should check view condition upon upsert
(JamesTaylor) (jamestaylor: rev 74fa97d9c6478065b16fda06695870c6c480e075)
* phoenix-core/src/main/java/org/apache/phoenix/exception/SQLExceptionCode.java
* phoenix-core/src/it/java/org/apache/phoenix/end2end/ViewIT.java
* phoenix-core/src/main/java/org/apache/phoenix/compile/UpsertCompiler.java
PHOENIX-882 Updatable view should check view condition upon upsert
(JamesTaylor) (jamestaylor: rev c24a71ec379cd89f7fe3ebe88b84042ff0bc6396)
* phoenix-core/src/main/java/org/apache/phoenix/compile/UpsertCompiler.java
* phoenix-core/src/main/java/org/apache/phoenix/util/SchemaUtil.java
> 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)
