Kevin Liew created CALCITE-1709:
-----------------------------------
Summary: Support mixing table columns with extended columns in DML
Key: CALCITE-1709
URL: https://issues.apache.org/jira/browse/CALCITE-1709
Project: Calcite
Issue Type: New Feature
Affects Versions: 1.11.0
Reporter: Kevin Liew
Assignee: Julian Hyde
Phoenix allows embedding dynamic column definitions in the {{UPDATE}} target
column list whereas Calcite requires that extended columns be specified
separately from the target columns.
ie.
Phoenix
{code:sql}
UPSERT INTO EventLog
(eventId, eventTime, eventType, lastGCTime TIME, usedMemory BIGINT, maxMemory
BIGINT)
VALUES (1, CURRENT_TIME(), ‘abc’, CURRENT_TIME(), 512, 1024);
{code}
Calcite
{code:sql}
UPSERT INTO EventLog
(lastGCTime TIME, usedMemory BIGINT, maxMemory BIGINT)
(eventId, eventTime, eventType, lastGCTime, usedMemory, maxMemory)
VALUES (1, CURRENT_TIME(), ‘abc’, CURRENT_TIME(), 512, 1024);
{code}
We should have a conformance setting for this feature.
https://issues.apache.org/jira/browse/PHOENIX-3732?focusedCommentId=15930704&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-15930704
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
