| Subject | RE: [firebird-support] Infinite loop with INSERT INTO SELECT |
|---|---|
| Author | Leyne, Sean |
| Post date | 2009-08-26T17:36:44Z |
Daniel,
The issue is that the engine does not fully resolve the SELECT before starting to perform the INSERT operations. So the SELECT starts to see the new records which have been inserted by the current statement... and so the statement runs without end.
The engine change required to resolve the issue is "substantial"...
Sean
> > This is a known issue and a case has already been opened for this issueActually, the problem goes back much further (I can recall this problem back in 1994 with IB 4.x). I wouldn't be surprised if the problem has existed since day 1.
> (has existed for a long time)
>
> Firebird Core - infinite insertion cycle - Created: 13/Mar/01 12:00 AM
> Uhhhhps, okay - long time :-)
The issue is that the engine does not fully resolve the SELECT before starting to perform the INSERT operations. So the SELECT starts to see the new records which have been inserted by the current statement... and so the statement runs without end.
The engine change required to resolve the issue is "substantial"...
Sean