Regression: Server crashes when aggregate functions are used together with NOT IN predicate [CORE5153] #5436
Comments
Modified by: @dyemanovreporter: Dmitry Yemanov [ dimitr ] => Pavel Zotov [ tabloid ] |
Modified by: @dyemanovassignee: Adriano dos Santos Fernandes [ asfernandes ] |
Modified by: @dyemanovFix Version: 3.0.0 [ 10740 ] |
Modified by: @asfernandesstatus: Open [ 1 ] => Resolved [ 5 ] resolution: Fixed [ 1 ] Fix Version: 4.0 Alpha 1 [ 10731 ] |
|
Commented by: @pavel-zotov Consider following sample: set list on; |
Modified by: @pavel-zotovstatus: Resolved [ 5 ] => Resolved [ 5 ] QA Status: No test => Deferred Test Details: Waiting for reply on comment 23/Mar/16 02:16 PM. |
|
Commented by: @asfernandes Pavel, this is another bug, so please create another ticket. |
|
Commented by: @pavel-zotov > this is another bug, so please create another ticket. |
Modified by: @pavel-zotovstatus: 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. |
Modified by: @pavel-zotovstatus: Resolved [ 5 ] => Closed [ 6 ] |
firebird-automations
added
affect-version: 4.0 Initial
affect-version: 3.0 RC2
affect-version: 3.0 RC1
affect-version: 3.0 Beta 2
affect-version: 3.0 Beta 1
fix-version: 3.0.0
fix-version: 4.0 Alpha 1
resolution: fixed
priority: major
component: engine
type: bug
qa: done successfully
labels
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.
The text was updated successfully, but these errors were encountered: