Subject Re: [firebird-support] ORDER BY invalid column
Author Alexandre Benson Smith
Rick Debay wrote:

>Thanks that works, but I'm also looking for confirmation that my
>previous query was valid SQL, so I can submit a bug report.
There was discussion about it on fb-devel sometime ago.

The use of

select * from A order by 5

could lead to diferent results since the order of the fields are not
explicitly defined.

The resolution that I recall was that on version 2.0 Fb will allow such
constructs, and the developer will be responsible for a error-prone
approach like this.

All I said above are from memory, if you want to be sure look on
fb-devel archives or wait for someone to confirm it.

see you !

Alexandre Benson Smith
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil