Subject Re: [firebird-support] Wired AS-clause problem
Author Daniel Rail

At August 2, 2004, 12:32, Steffen Heil wrote:

> Hi

> I am using Firebird 1.5.1 and JayBird 1.5 RC3.

> I just run into a problem using the following select-statement by mistake:
> select a b from t
> instead of
> select a, b from t
> The server behaved as if I had said:
> select a as b from t
> I ran into this in my java code, but checked it inside IBExpert.

> Now, I have two problems with this:
> 1. IMHO "as" should NOT be optional. Am I wrong on this?

In the SQL-Standard(SQL-92, SQL-99 and SQL-2003), "AS" is optional in
this case.

Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (
ACCRA Med Software Inc. (