Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Not correct delete [CORE4697] #5005

Closed
firebird-automations opened this issue Feb 23, 2015 · 6 comments
Closed

Not correct delete [CORE4697] #5005

firebird-automations opened this issue Feb 23, 2015 · 6 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: Dmitry Kornilov (dk76)

Duplicates CORE3362

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

?

====== Test Details ======

See test cases in core_3362.fbt

@firebird-automations
Copy link
Collaborator Author

Commented by: Omacht András (aomacht)

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:
CORE3362

@firebird-automations
Copy link
Collaborator Author

Commented by: @dyemanov

Duplicate for CORE3362 (and its friends CORE634 and CORE3317).

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Duplicate [ 3 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

status: Resolved [ 5 ] => Closed [ 6 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @hvlad

Link: This issue duplicates CORE3362 [ CORE3362 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

status: Closed [ 6 ] => Closed [ 6 ]

QA Status: Covered by another test(s)

Test Details: See test cases in core_3362.fbt

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant