[#CORE-3362] Cursors should ignore changes made by the same statement

Firebird Core

Cursors should ignore changes made by the same statement

Created: 25/Feb/11 09:08 AM Updated: 25/Apr/18 05:29 AM

Component/s:

Engine

Affects Version/s:

2.1.0, 2.0.4, 2.1.1, 2.0.5, 2.1.2, 2.1.3, 1.5.6, 2.0.6, 2.5.0

Fix Version/s:

3.0 RC2

Issue Links:

Duplicate

This issue is duplicated by:

~~CORE-4697~~ Not correct delete

Relate

This issue is related to:

~~CORE-634~~ Bad treatment of FIRST/SKIP in subselect

~~CORE-92~~ infinite insertion cycle

~~CORE-2799~~ Changing sort directon in delete statement cause deletion of all records in table

~~CORE-3317~~ Success of deleting rows depending on order of row insertion

~~CORE-5305~~ CASCADE UPDATE fails for self-referencing FK

QA Status:

Done with caveats

Test Details:

« Hide

Test ("core_3362_basic.fbt") verifies BASIC issues that were accumulated in miscenaleous tickets.
More complex cases (which involve not only SQL but also PSQL features) will
follow in separate .fbt in order to keep size of each test in reasonable limits.

See also test for ~~CORE-5794~~

All

Comments

Change History

Subversion Commits

Sort Order:

Vlad Khorsun made changes - 25/Feb/11 09:09 AM

Field	Original Value	New Value
Link		This issue is related to ~~CORE-92~~ [ ~~CORE-92~~ ]

Vlad Khorsun made changes - 25/Feb/11 09:10 AM

Link

This issue depends on ~~CORE-634~~ [ ~~CORE-634~~ ]

Vlad Khorsun made changes - 25/Feb/11 09:10 AM

Link

This issue depends on ~~CORE-634~~ [ ~~CORE-634~~ ]

Vlad Khorsun made changes - 25/Feb/11 09:10 AM

Link

This issue is related to ~~CORE-634~~ [ ~~CORE-634~~ ]

Vlad Khorsun made changes - 25/Feb/11 09:11 AM

Link

This issue is related to ~~CORE-2799~~ [ ~~CORE-2799~~ ]

Vlad Khorsun made changes - 25/Feb/11 09:11 AM

Link

This issue is related to ~~CORE-3317~~ [ ~~CORE-3317~~ ]

Vlad Khorsun made changes - 25/Feb/11 09:30 AM

Assignee

Vlad Khorsun [ hvlad ]

Vlad Khorsun made changes - 24/Feb/15 09:18 AM

Link

This issue is duplicated by ~~CORE-4697~~ [ ~~CORE-4697~~ ]

Dmitry Yemanov made changes - 26/Feb/16 04:24 PM

Status	Open [ 1 ]	Resolved [ 5 ]
Fix Version/s		3.0 RC2 [ 10048 ]
Resolution		Fixed [ 1 ]

Vlad Khorsun made changes - 11/Aug/16 06:01 PM

Link

This issue is related to ~~CORE-5305~~ [ ~~CORE-5305~~ ]

Pavel Zotov made changes - 18/Sep/16 09:18 PM

Status	Resolved [ 5 ]	Resolved [ 5 ]
Test Details		Test ("core_3362_basic.fbt") verifies BASIC issues that were accumulated in miscenaleous tickets. More complex cases (which involve not only SQL but also PSQL features) will follow in separate .fbt(s) in order to keep size of each test in reasonable limits.
QA Status		Done with caveats

Pavel Zotov made changes - 25/Apr/18 05:29 AM

Status	Resolved [ 5 ]	Resolved [ 5 ]
Test Details	Test ("core_3362_basic.fbt") verifies BASIC issues that were accumulated in miscenaleous tickets. More complex cases (which involve not only SQL but also PSQL features) will follow in separate .fbt(s) in order to keep size of each test in reasonable limits.	Test ("core_3362_basic.fbt") verifies BASIC issues that were accumulated in miscenaleous tickets. More complex cases (which involve not only SQL but also PSQL features) will follow in separate .fbt in order to keep size of each test in reasonable limits. See also test for ~~CORE-5794~~