Issue Details (XML | Word | Printable)

Key: CORE-4697
Type: Bug Bug
Status: Closed Closed
Resolution: Duplicate
Priority: Major Major
Assignee: Unassigned
Reporter: Dmitry Kornilov
Votes: 0
Watchers: 2
Operations

If you were logged in you would be able to see more operations.
Firebird Core

Not correct delete

Created: 23/Feb/15 02:56 PM   Updated: 18/Oct/16 04:20 PM
Component/s: None
Affects Version/s: 2.5.3
Fix Version/s: None

Environment: Windows
Issue Links:
Duplicate
 

QA Status: Covered by another test(s)
Test Details: See test cases in core_3362.fbt


 Description  « Hide
create table t1(id1 int, id2 int);
insert into t1(id1,id2) values(1,2);
insert into t1(id1,id2) values(1,3);
insert into t1(id1,id2) values(1,4);


delete from t1 where id1 in (select id1 from t1 where id2=2) delete one record
delete from t1 where id1 in (select id1 from t1 where id2=3) delete two record
delete from t1 where id1 in (select id1 from t1 where id2=4) delete three record

?

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Omacht András added a comment - 23/Feb/15 03:20 PM
It works well:
delete from t1 where id1 = (select id1 from t1 where id2=2);
delete from t1 where id1 = (select id1 from t1 where id2=3);
delete from t1 where id1 = (select id1 from t1 where id2=4);

This ticket is related to:
http://tracker.firebirdsql.org/browse/CORE-3362

Dmitry Yemanov added a comment - 23/Feb/15 03:23 PM
Duplicate for CORE-3362 (and its friends CORE-634 and CORE-3317).