Kbase P117856: Formerly working SELECT statement now fails in 10.01A01 and later with error 10713
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
08/08/2006 |
|
Status: Unverified
FACT(s) (Environment):
OpenEdge 10.1A
OpenEdge 10.0B
SYMPTOM(s):
OpenEdge 10.1A01
A SELECT statement that worked in 10.0B now fails in 10.1A01 with a syntax error
Syntax error at or about (statement excerpt). (10713)
Syntax error at or about ('!='). (10713)
SELECT MIN(X) X FROM PUB.SomeTable WHERE Field1 = 'A' AND X != 0
CAUSE:
The SELECT statement was missing a comma after the MIN(X) and the missing comma caused the SQL parser to believe that 'X' was a column alias for 'MIN(X)' and consequently generated a syntax error when parsing the WHERE clause because column aliases from the SELECT list are not allowed in the WHERE clause if the alias refers to a complex expression (i.e. more complex than a simple column reference)
FIX:
Modify the SELECT statement and add a comma after column in the SELECT list