Author: shawkins Date: 2010-02-25 12:05:21 -0500 (Thu, 25 Feb 2010) New Revision: 1875 Modified: trunk/documentation/reference/src/main/docbook/en-US/content/sql_support.xml Log: TEIID-989 aliased items should not be referenced in an order by expression 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-02-25 02:07:39 UTC (rev 1874) +++ trunk/documentation/reference/src/main/docbook/en-US/content/sql_support.xml 2010-02-25 17:05:21 UTC (rev 1875) @@ -793,7 +793,7 @@ <para>Syntax Rules: </para> <listitem> - <para>Sort columns may be specified positionally by a 1 based + <para>Sort columns may be specified positionally by a 1-based positional integer, by SELECT clause alias name, by SELECT clause expression, or by an unrelated expression.</para> </listitem> <listitem> @@ -806,7 +806,8 @@ </listitem> <listitem> <para>Unrelated expressions, expressions not appearing as an aliased expression in the select clause, - are allowed in the order by clause of a non-set QUERY. The columns referenced in the expression must also follow the prior rule. + are allowed in the order by clause of a non-set QUERY. The columns referenced in the expression must come from the + from clause table references. The column references cannot be to alias names or positional. </para> </listitem> <listitem>