[
https://issues.apache.org/jira/browse/CALCITE-505?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14233640#comment-14233640
]
Julian Hyde edited comment on CALCITE-505 at 12/3/14 11:04 PM:
---------------------------------------------------------------
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
[has|https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_8004.htm]
{{CREATE VIEW ... WITH CHECK OPTION}} for this.
was (Author: julianhyde):
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)
