You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "Julian Hyde (JIRA)" <ji...@apache.org> on 2014/12/04 00:04:12 UTC
[jira] [Comment Edited] (CALCITE-505) Support updatable VIEW
[ 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)