Wrong results for CASE used together with GROUP BY [CORE2584] #2994
Comments
Modified by: @dyemanovassignee: Adriano dos Santos Fernandes [ asfernandes ] |
|
Commented by: Claudio Valderrama C. (robocop) What a funny output: ======= ====== ============ |
|
Commented by: @dyemanov This is a regression introduced after Alpha 1, probably related to other bugfixes in the grouping area happened that time. |
Modified by: @dyemanovVersion: 2.5 Beta 1 [ 10251 ] |
|
Commented by: @asfernandes Not difficult to imagine, as when this problem is happening I need to manually start finding the old related bugs, and manually run/interpret results of before/after changes. A better exercice than extend fbtcs or even run (never did that) the qm*thing. |
|
Commented by: @asfernandes The bug is caused by the line in pass1.cpp with this comment: Reason for this change is in CORE501 attached test and will be investigated. |
Modified by: @asfernandes |
Modified by: @asfernandes |
Modified by: @asfernandes |
Modified by: @asfernandes |
Modified by: @asfernandesstatus: Open [ 1 ] => Resolved [ 5 ] resolution: Fixed [ 1 ] Fix Version: 2.5 RC1 [ 10362 ] |
Modified by: @pmakowskistatus: Resolved [ 5 ] => Closed [ 6 ] |
Modified by: @pavel-zotovstatus: Closed [ 6 ] => Closed [ 6 ] QA Status: Done successfully Test Details: Changed code to make it independent of system tables content. |
Submitted by: @dyemanov
Is related to CORE501
Is related to CORE1343
Is related to CORE2041
Is related to CORE2051
Is related to QA411
Test case:
select
rdb$field_position as a,
case rdb$field_position when 0 then '0'
when 1 then '1'
when 2 then '2'
when 3 then '3'
when 4 then '4' end as b,
count(*) as cnt
from rdb$relation_fields
where rdb$field_position < 5
group by 1, 2
Commits: 88495f2
====== Test Details ======
Changed code to make it independent of system tables content.
The text was updated successfully, but these errors were encountered: