[jira] [Created] (CALCITE-1709) Support mixing table columns with extended columns in DML

["Kevin Liew (JIRA)" <ji...@apache.org>]

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)