Subject Re: [firebird-support] Re: Strange behaviour in Firebird
Author Nando Dessena

j> More simply it could be a firebird bug!

it's rather an incomplete support for SQL aliases, and it's more or
less documented. Your example works fine and produces the expected
result in Fb 2.


H> What is the parser supposed to deduce if you
H> duplicate the table name as its alias?

aliases hide table names. They didn't do that always in Fb 1.x. The
parser ain't able to distinguish a dumb alias from a smart one. :-)

Nando Dessena
I support Firebird, I am a Firebird Foundation member!
Join today at