Hi,
when a SELECT statement uses an alias named "field2" as first column,
firebird reports an error:
"A component named Field2 already exists"

e. g.:
select id as field2
, code as field3
from t_invline

doesn't work, while

select id as field1
, code as field2
from t_invline

works fine, as it does, when the aliases don't start with 2:

select id as field3
, code as field2
from t_invline

works fine too.

I've tested it with firebird 1.0 on win2k and firebird 1.5 on linux/fedora3.

Sincerly
André