[
https://issues.apache.org/jira/browse/CALCITE-505?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14233665#comment-14233665
]
James Taylor commented on CALCITE-505:
--------------------------------------
Phoenix has a pretty conservative compile-time check that'll throw a
SQLException if it's being set to something other than the constant value (or
if we can't know what it's set to at compile time). For example, the following
would throw:
{code}
upsert into female_emps select * from emps;
{code}
Phoenix will set the column value to the constant, though, when it's not
present. For example, this would work (and set the gender column to 'F' for the
upserted rows):
{code}
upsert into female_emps(emp_id, name) select emp_id, name from emps where
salary > 10;
{code}
> 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)
