Since this query works in 7.0.3, 8.0.3, 11.0.1 and 12.0.1 (and I am sure many other versions)...
SELECT x + 1, 1 AS x; x+1,x 2,1
...what is the meaning of this 12.0.1 Help topic?
Error constant SQLE_ALIAS_NOT_YET_DEFINED ODBC 2 state 37000 ODBC 3 state ERROR Parameter 1 Name of the alias. Severity 15 SQLCODE -831 SQLSTATE 42W61 Sybase error code 13837
An expression contains a reference to an alias, but the alias is defined later in the SELECT list. The alias definition must appear before its first reference.
What's New in SQL Anywhere Studio 6. What's New in Version 7.0.2 Behavior changes in version 7.0.2
Aliases must be defined before first reference
In earlier versions of SQL Anywhere, it was possible to refer to an alias in a SELECT list before the definition of the alias had appeared. An attempt to do so will now generate the error "Definition for alias alias-name must appear before its first reference". To prevent this error, the SELECT list must be re-ordered so that the alias definition appears before its first use.
asked 19 Jul '12, 08:50