> > With this query:
> > select
> > *
> > from
> > "#test2"
> > order by 1
> >
> > and trying an editable result set, IBO modifies this to:
> >
> > SELECT "#test2".*
> > , "#test2".RDB$DB_KEY
> > from
> > "#test2"
> > ORDER BY 1 ASC
> >
> > But this fails with an error:
> > Dynamic SQL Error SQL error code = -206 Column unknown
> > #test2.* At line 1, column 1.
>
> It seems that this shouldn't fail. Could this be a problem with the

parser

> in Firebird?

It adds RDB$DB_KEY because there is no primary key, as far as I can see.

On InterBase, this fails:
select
*
from
"NAME.WITH.DOT"
order by 1

Query passed to the server:
SELECT "NAME.WITH.DOT".*
, "NAME.WITH.DOT".RDB$DB_KEY
from
"NAME.WITH.DOT"
ORDER BY 1 ASC

Error message:
ISC ERROR MESSAGE:
Dynamic SQL Error
SQL error code = -206
Column unknown
NAME.WITH.DOT.*


However (!!!) with a SQL-monitor turned on, this returns an access violation
in SessionBase.HandleException!!

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com