> At 12:53 PM 15/08/2004 -0400, you wrote:
> > > the statement
> > > INSERT INTO T1 SELECT * FROM T1 (duplicating T1)
> > > causes (in Firebird 1.5.1, maybe in IB too) closed loop.
> > >
> > > PostgreSQL works correctly!
>
> At 12:53 PM 15/08/2004 -0400, Sean Leyne wrote:
>
> >Yes, this an old/long standing bug with FB and IB (all versions).
>
> ...while others would say it was a crippling bug if database rules
> prevented a transaction from seeing its own uncommitted work.

Then again - what is the SQL standard behaviour for this?

Should you rely on the fact that it creates a never ending loop?
Or should the resultset (SELECT * FROM) be ready before
entering the INSERT stuff?

Oh darn, where is D. Brown when you need her...

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com