| Subject | Re: [firebird-support] Stored procedure stops functioning correctly after restore under Firebird 3 |
|---|---|
| Author | Dimitry Sibiryakov |
| Post date | 2019-02-13T15:56:09Z |
13.02.2019 16:39, Mark Rotteveel mark@... [firebird-support] wrote:
cannot see changes made inside of the same savepoint, so sub-query in second query miss
data inserted by first insert.
In any case the procedure smells. It would better to use RETURNING for that purpose
instead of sub-query.
--
WBR, SD.
> My bet is on the addition of the savepoint.Yes, this is the way partial cursor stability is implemented in 3.0: insert-select
cannot see changes made inside of the same savepoint, so sub-query in second query miss
data inserted by first insert.
In any case the procedure smells. It would better to use RETURNING for that purpose
instead of sub-query.
--
WBR, SD.