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

Regression: Server crashes when aggregate functions are used together with NOT IN predicate [CORE5153] #5436

Closed
firebird-issue-importer opened this issue Mar 17, 2016 · 10 comments

Comments

@firebird-issue-importer

Submitted by: @pavel-zotov

Simplified test case:

select r.rdb$relation_id, count(*)
from rdb$database r
group by r.rdb$relation_id
having count(*) not in (select r2.rdb$relation_id from rdb$database r2);

Commits: c2d7536 f30733f

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

NB: test does NOT check correctness of query results - this will be done by test for ticket CORE5165.

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Mar 17, 2016

Modified by: @dyemanov

reporter: Dmitry Yemanov [ dimitr ] => Pavel Zotov [ tabloid ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Mar 17, 2016

Modified by: @dyemanov

assignee: Adriano dos Santos Fernandes [ asfernandes ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Mar 17, 2016

Modified by: @dyemanov

Fix Version: 3.0.0 [ 10740 ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Mar 21, 2016

Modified by: @asfernandes

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

resolution: Fixed [ 1 ]

Fix Version: 4.0 Alpha 1 [ 10731 ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Mar 23, 2016

Commented by: @pavel-zotov

Consider following sample:

set list on;
set count on;
select 1 as check_ok from rdb$database r group by r.rdb$relation_id having count(*) not in (select -1 from rdb$database r2) ;
. . . rest was moved in core-5165 . . .

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Mar 23, 2016

Modified by: @pavel-zotov

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

QA Status: No test => Deferred

Test Details: Waiting for reply on comment 23/Mar/16 02:16 PM.

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Mar 23, 2016

Commented by: @asfernandes

Pavel, this is another bug, so please create another ticket.

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Mar 23, 2016

Commented by: @pavel-zotov

> this is another bug, so please create another ticket.

CORE5165

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Mar 23, 2016

Modified by: @pavel-zotov

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

QA Status: Deferred => Done successfully

Test Details: Waiting for reply on comment 23/Mar/16 02:16 PM. => NB: test does NOT check correctness of query results - this will be done by test for ticket CORE5165.

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Mar 23, 2016

Modified by: @pavel-zotov

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

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