[jira] [Commented] (CALCITE-505) Support updatable VIEW

["Julian Hyde (JIRA)" <ji...@apache.org>]

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

Julian Hyde commented on CALCITE-505:
-------------------------------------

Should the server allow people to insert (or upsert) rows into an updatable view that will not come out again?

{code}
create view female_emps as select * from emps where gender = 'F';
insert into female_emps (100, 'Leslie', 'M');
{code}

Oracle <a href="https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_8004.htm">has</a> {{CREATE VIEW ... WITH CHECK OPTION}} for this.

> Support updatable VIEW
> ----------------------
>
>                 Key: CALCITE-505
>                 URL: https://issues.apache.org/jira/browse/CALCITE-505
>             Project: Calcite
>          Issue Type: Bug
>            Reporter: James Taylor
>            Assignee: Julian Hyde
>              Labels: phoenix
>
> Phoenix allows updates to occur through a VIEW in certain, simple cases (i.e. when the WHERE clause of a VIEW contains only simple equality statements). It'd be useful if Calcite allowed for this as well. See http://phoenix.apache.org/views.html#Updatable_Views for more information.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)