Subject Bug in Firebird 2.1.1 (and Firebird 2.1.0)
Author trtoms
The following simple queries cause an error in the latest 2.1.1
release of Firebird:

SELECT * FROM RAORDERS O
WHERE O.ORDERID = 1

The error returned includes the text "Unknown column db_key".

The database is dialect 1, and has been restored by the current
version of gbak.

Other similar queries fail when a table alias is used without a join
to another table. I haven't proved that this is always the case, as
most of our non-join queries don't use aliases!

So this works:
SELECT * FROM RAORDERS O
INNER JOIN RACUSTOMERS C ON C.CUSTOMERID = O.CUSTOMERID
WHERE O.ORDERID = 1

We connect to the database using Delphi 2007 and the BDE (sorry!) but
the same query fails when entered directly into IBOConsole.

Hope someone can help!

Regards,
Trevor