> >> > > 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.
>
> MT> Then again - what is the SQL standard behaviour for this?
>
> IIRC the standard says Firebird is wrong. :-(

In that case, it's bug and should be fixed. Period.

With regards,

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