Subject | Bug in Firebird 2.1.1 (and Firebird 2.1.0) |
---|---|
Author | trtoms |
Post date | 2008-10-29T16:43:24Z |
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
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