[
https://issues.apache.org/jira/browse/TRAFODION-2680?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16090060#comment-16090060
]
ASF GitHub Bot commented on TRAFODION-2680:
-------------------------------------------
Github user DaveBirdsall commented on a diff in the pull request:
https://github.com/apache/incubator-trafodion/pull/1169#discussion_r127759569
--- Diff: core/sql/optimizer/BindItemExpr.cpp ---
@@ -10851,6 +10851,96 @@ ItemExpr *ZZZBinderFunction::bindNode(BindWA
*bindWA)
}
break;
+ case ITM_CSV_FORMAT:
+ {
+ bindChildren(bindWA);
+ if (bindWA->errStatus())
+ return this;
+
+ // The way the arguments of CSV_FORMAT are represented in
+ // the parse tree is as a tree of ItemList nodes; so
+ // CSV_FORMAT(a,b,c,d) is represented as
+ //
+ // this
+ // / \
+ // a ItemList
+ // / \
+ // b ItemList
+ // / \
+ // c d
+ //
+ // The code below traverses accordingly.
--- End diff --
Thank you, Hans. Will use that.
> CSV_FORMAT function
> -------------------
>
> Key: TRAFODION-2680
> URL: https://issues.apache.org/jira/browse/TRAFODION-2680
> Project: Apache Trafodion
> Issue Type: New Feature
> Components: sql-cmp
> Affects Versions: 2.2-incubating
> Environment: All
> Reporter: David Wayne Birdsall
> Assignee: David Wayne Birdsall
>
> To make it easier to get Trafodion data into spreadsheets, add a CSV_FORMAT
> function to Trafodion SQL.
> Syntax: CSV_FORMAT(argument1, ... ,argumentn)
> Semantics: The result of CSV_FORMAT is a VARCHAR string consisting of a
> comma-separated list of the argument values. If the argument itself contains
> a comma, it is surrounded with double quotes.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
