[
https://issues.apache.org/jira/browse/TRAFODION-2117?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15410200#comment-15410200
]
ASF GitHub Bot commented on TRAFODION-2117:
-------------------------------------------
Github user sureshsubbiah commented on a diff in the pull request:
https://github.com/apache/incubator-trafodion/pull/639#discussion_r73768646
--- Diff: core/sql/optimizer/BindRelExpr.cpp ---
@@ -3035,6 +3035,98 @@ RelExpr *Intersect::bindNode(BindWA *bindWA)
// LCOV_EXCL_STOP
// -----------------------------------------------------------------------
+// member functions for class Except
+// -----------------------------------------------------------------------
+
+// LCOV_EXCL_START - cnu
+RelExpr *Except::bindNode(BindWA *bindWA)
+{
+ if (nodeIsBound())
+ {
+ bindWA->getCurrentScope()->setRETDesc(getRETDesc());
+ return this;
+ }
+
+ // Bind the child nodes.
+ //
+ bindChildren(bindWA);
+ if (bindWA->errStatus()) return this;
+
+ // Check that there are an equal number of select items on both sides.
+ //
+ const RETDesc &leftTable = *child(0)->getRETDesc();
+ const RETDesc &rightTable = *child(1)->getRETDesc();
+ if (leftTable.getDegree() != rightTable.getDegree()) {
+ // 4014 The operands of an intersect must be of equal degree.
+ *CmpCommon::diags() << DgSqlCode(-4014);
+ bindWA->setErrStatus();
+ return this;
+ }
+
+ // Join the columns of both sides.
+ //
+ if(CmpCommon::getDefault(MODE_SPECIAL_4) != DF_ON)
--- End diff --
I forget now, why is this guarded by MODE_SPECIAL_4 ?
> add support of SQL extension 'EXCEPT'
> --------------------------------------
>
> Key: TRAFODION-2117
> URL: https://issues.apache.org/jira/browse/TRAFODION-2117
> Project: Apache Trafodion
> Issue Type: New Feature
> Reporter: liu ming
> Assignee: liu ming
>
> add syntax and basic functional support for 'EXCEPT', meet the requirement to
> run TPCDS as initial goal.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
