[
https://issues.apache.org/jira/browse/TRAFODION-2254?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15537135#comment-15537135
]
Selvaganesan Govindarajan edited comment on TRAFODION-2254 at 9/30/16 9:33 PM:
-------------------------------------------------------------------------------
The phoneix test at
tests/phx/src/test/java/org/trafodion/phoenix/end2end/SaltedTableUpsertSelectTest.java
needs to be reverted back to use 'MERGE'. Remove the CQD traf_upsert_mode in
this program once this jira is fixed.
was (Author: selvag):
The phoneix test at
tests/phx/src/test/java/org/trafodion/phoenix/end2end/SaltedTableUpsertSelectTest.java
needs to be reverted back to use 'MERGE'. Remove the CQD traf_upsert_mode in
this program
> Self referencing upsert with missing values into aligned tables return an
> error
> -------------------------------------------------------------------------------
>
> Key: TRAFODION-2254
> URL: https://issues.apache.org/jira/browse/TRAFODION-2254
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-cmp
> Affects Versions: any
> Reporter: Selvaganesan Govindarajan
>
> self referencing upsert with missing values into aligned tables return
> an error if cqd traf_upsert_mode is set to 'MERGE' (default value). The plan
> doesn't have
> a blocking operator.
> >>create table t (a int not null primary key, b int, c int) attribute aligned
> >>format;
> — SQL operation complete.
> >>set transaction autocommit off;
> — SQL operation complete.
> >>upsert into t (a,c) select a,c from t;
> ERROR[8107] Self-referencing INSERT statement without blocking operator is
> not allowed with AUTOCOMMIT OFF.
> — 0 row(s) inserted.
> >>explain options 'f' upsert into t (a,c) select a,c from t;
> LC RC OP OPERATOR OPT DESCRIPTION CARD
> ---- ---- ---- -------------------- -------- -------------------- ---------
> 3 . 4 root x 1.00E+002
> 1 2 3 tuple_flow 1.00E+002
> . . 2 trafodion_merge T 1.00E+000
> . . 1 trafodion_scan T 1.00E+002
> — SQL operation complete.
> >>cqd traf_upsert_mode 'REPLACE';
> — SQL operation complete.
> >>
> >>explain options 'f' upsert into t (a,c) select a,c from t;
> LC RC OP OPERATOR OPT DESCRIPTION CARD
> ---- ---- ---- -------------------- -------- -------------------- ---------
> 4 . 5 root x 1.00E+002
> 2 3 4 tuple_flow 1.00E+002
> . . 3 trafodion_vsbb_upser T 1.00E+000
> 1 . 2 sort 1.00E+002
> . . 1 trafodion_scan T 1.00E+002
> — SQL operation complete.
> >>
> >>upsert into t (a,c) select a,c from t;
> — 0 row(s) inserted.
> >>
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
