[ 
https://issues.apache.org/jira/browse/TRAFODION-1562?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15857037#comment-15857037
 ] 

ASF GitHub Bot commented on TRAFODION-1562:
-------------------------------------------

Github user DaveBirdsall commented on a diff in the pull request:

    https://github.com/apache/incubator-trafodion/pull/946#discussion_r99958672
  
    --- Diff: core/sql/optimizer/BindRelExpr.cpp ---
    @@ -10600,34 +10600,45 @@ Upsert is also converted into merge when 
TRAF_UPSERT_MODE is set to MERGE and
     there are omitted cols with default values in case of aligned format table 
or 
     omitted current timestamp cols in case of non-aligned row format
     */
    -NABoolean Insert::isUpsertThatNeedsMerge(NABoolean isAlignedRowFormat, 
NABoolean omittedDefaultCols,
    -                                   NABoolean 
omittedCurrentDefaultClassCols) const
    +NABoolean Insert::isUpsertThatNeedsTransformation(NABoolean 
isAlignedRowFormat, 
    +                                                  NABoolean 
omittedDefaultCols,
    +                                                  NABoolean 
omittedCurrentDefaultClassCols,
    +                                                  NABoolean &toMerge) const
    --- End diff --
    
    You've added a parameter to return more information from this function. 
This is fine. Another way to do it is to change the return type from NABoolean 
to an enum, then no added parameter would be needed. But this is just a matter 
of taste; it may or may not be more convenient for the caller.


> Changes in query tree when the upsert command is transformed into merge
> -----------------------------------------------------------------------
>
>                 Key: TRAFODION-1562
>                 URL: https://issues.apache.org/jira/browse/TRAFODION-1562
>             Project: Apache Trafodion
>          Issue Type: Sub-task
>          Components: sql-cmp
>            Reporter: Selvaganesan Govindarajan
>            Assignee: Sandhya Sundaresan
>         Attachments: BatchUpsertTransformation.pdf
>
>
> to improve the performance as explained in the main JIRA



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

Reply via email to