|Subject||Re: [firebird-support] insert bug in SQL execution???|
> At 12:53 PM 15/08/2004 -0400, you wrote:Then again - what is the SQL standard behaviour for this?
> > > 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.
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...
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL