Hi,



I have a problem with Firebird 2.01 and the "ORDER BY"-clause:



The following Query reports an error "column unknown Person.Name1":



SELECT * FROM Person P

ORDER BY Person.Name1 (Firebird 1.5 does the query without
problems)



Changing the query to one of the following works fine:



SELECT * FROM Person

ORDER BY Person.Name1

or

SELECT * FROM Person P

ORDER BY P.Name1



My question:

Is this a new syntax or a bug by Firebird 2.0 ?



Thanks,

Martin



[Non-text portions of this message have been removed]