Benton and others,

> Table TAMACONT has one field only, field name is VALOR.
>
> In Firebird 2.0,
>
> SELECT VALOR,VALOR FROM TAMACONT ORDER BY VALOR
>
> causes this error:
>
> Undefined name.
> Dynamic SQL Error.
> SQL error code = -204.
> Ambiguous field name between a field and a field in the select list
> with name.
> VALOR.

The tightening of the SQL syntax parser is a well documented change in
v2.0 -- this syntax is illegal according to the SQL Standard.


PLEASE, PLEASE read the releases notes before posting issues here!!!!


Sean