Issue Details (XML | Word | Printable)

Key: CORE-4574
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Adriano dos Santos Fernandes
Reporter: Alex Bekhtin
Votes: 0
Watchers: 2
Operations

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

Regression: Incorrect result in subquery with aggregate

Created: 09/Oct/14 11:40 AM   Updated: 23/Sep/15 11:30 AM
Component/s: Engine
Affects Version/s: 3.0 Alpha 1
Fix Version/s: 3.0 Beta 1

Environment: Firebird-3.0.0.31355-0_x64

QA Status: Done successfully


 Description  « Hide
with A(ID) as
(
    select 1 from rdb$database
    union all
    select 2 from rdb$database
    union all
    select 3 from rdb$database
),
B(ID1, ID2) as
(
    select 1, null from rdb$database
    union all
    select 2, null from rdb$database
    union all
    select 3, null from rdb$database
)
select
    sum((select count(*) from B where B.ID1 = A.ID))
    ,
    sum((select count(*) from B where B.ID2 = A.ID))
    -- must be (3,0) (FB2.5) , but not (3,3) (FB3.0)
from A

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Sean Leyne made changes - 09/Oct/14 03:10 PM
Field Original Value New Value
Summary Incorrect result in subquery with aggregate Regression: Incorrect result in subquery with aggregate
Dmitry Yemanov made changes - 09/Oct/14 04:37 PM
Assignee Dmitry Yemanov [ dimitr ]
Dmitry Yemanov made changes - 09/Oct/14 06:10 PM
Assignee Dmitry Yemanov [ dimitr ] Adriano dos Santos Fernandes [ asfernandes ]
Adriano dos Santos Fernandes made changes - 10/Oct/14 04:03 PM
Status Open [ 1 ] Resolved [ 5 ]
Fix Version/s 3.0 Beta 1 [ 10332 ]
Resolution Fixed [ 1 ]
Pavel Zotov made changes - 28/May/15 03:17 PM
Status Resolved [ 5 ] Resolved [ 5 ]
QA Status Done successfully
Pavel Cisar made changes - 23/Sep/15 11:30 AM
Status Resolved [ 5 ] Closed [ 6 ]