Subject Wired AS-clause problem
Author Steffen Heil

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?
2. ResultSet.getString("a") gave me "null" instead of "no such column". Why?

Can anyone comment on this?


BTW: Can someone give me an url of a sql syntax specification?
Preferably SQL92 or SQL99, not only firebirds docs, which I already have.