2:30 a.m.
Author: shawkins
Date: 2010-10-29 13:30:50 -0400 (Fri, 29 Oct 2010)
New Revision: 2690
Modified:
trunk/build/kits/jboss-container/teiid-releasenotes.html
trunk/documentation/reference/src/main/docbook/en-US/content/sql_support.xml
Log:
TEIID-962 refinements to textagg.
Modified: trunk/build/kits/jboss-container/teiid-releasenotes.html
===================================================================
--- trunk/build/kits/jboss-container/teiid-releasenotes.html 2010-10-29 17:21:21 UTC (rev
2689)
+++ trunk/build/kits/jboss-container/teiid-releasenotes.html 2010-10-29 17:30:50 UTC (rev
2690)
@@ -42,9 +42,8 @@
<LI><B>Improved clustering support</B> - see the Admin Guide
chapter on clustering.
<LI><B>IPv6 support</B> - Teiid can started using IPv6 bind address
and can be used with JDBC connection.
<LI><B>SESSION_ID</B> - A new system function
"SESSION_ID" is added to the system function library.
- <LI><B>Assignment Syntax Improvements<B> - Teiid's procedure
syntax for assignments was clarified so that the assignment value must be a proper
expression. INSERT/UPDATE/DELETE update counts must be obtained from VARIABLES.ROWCOUNT,
scalar values must be obtained via a scalar subquery.
- <LI><B>TEXTAGG</B> - SQL support for Text aggregation. Using this
function expression values can be aggregated into a single line of text with delimiter and
header, that can be optionally saved to a text file.
- The parser will continue to accept the old syntax and convert the query into the
proper form.
+ <LI><B>Assignment Syntax Improvements<B> - Teiid's procedure
syntax for assignments was clarified so that the assignment value must be a proper
expression. INSERT/UPDATE/DELETE update counts must be obtained from VARIABLES.ROWCOUNT,
scalar values must be obtained via a scalar subquery. The parser will continue to accept
the old syntax and convert the query into the proper form.
+ <LI><B>TEXTAGG</B> - SQL support for Text aggregation. Using this
function expression values can be aggregated into a CSV BLOB with configurable delimiter,
header, and encoding. The result can be optionally saved to a text file.
</UL>
<h2><a name="Compatibility">Compatibility
Issues</a></h2>
Modified: trunk/documentation/reference/src/main/docbook/en-US/content/sql_support.xml
===================================================================
---
trunk/documentation/reference/src/main/docbook/en-US/content/sql_support.xml 2010-10-29
17:21:21 UTC (rev 2689)
+++
trunk/documentation/reference/src/main/docbook/en-US/content/sql_support.xml 2010-10-29
17:30:50 UTC (rev 2690)
@@ -238,10 +238,12 @@
<para>STDDEV_SAMP(x) – sample standar deviation (excluding null)
logically equals SQRT(VAR_SAMP(x))</para>
</listitem>
<listitem>
- <para>TEXTAGG((expression [as name], ... [DELIMITER char] [QUOTE char]
[HEADER]
- <link linkend="orderby_clause">[ORDER BY ...]</link>) –
Text concatination of all expressions in a group (excluding null).
- When DELIMITER is not specified, by default comma(,) is used as delimiter. Use
QUOTE, to quote the each expression value with
- provided character. If HEADER is specified, the result contains the header row
as first line. This aggregation returns a Clob.
+ <para>TEXTAGG(FOR (expression [as name], ... [DELIMITER char] [QUOTE
char] [HEADER] [ENCODING id]
+ <link linkend="orderby_clause">[ORDER BY ...]</link>) –
CSV text aggregation of all expressions in each row of a group.
+ When DELIMITER is not specified, by default comma(,) is used as delimiter.
Double quotes(") is the default quote character.
+ Use QUOTE to specify a differnt value. All non-null values will be quoted.
+ If HEADER is specified, the result contains the header row as the first line -
the header line will be present even if there are no rows in a group.
+ This aggregation returns a blob.
</para>
</listitem>
<listitem>