Incorrect result in subquery with aggregate
-------------------------------------------
Key: CORE-4574
URL: http://tracker.firebirdsql.org/browse/CORE-4574
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 3.0 Alpha 1
Environment: Firebird-3.0.0.31355-0_x64
Reporter: Alex Bekhtin
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
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Meet PCI DSS 3.0 Compliance Requirements with EventLog Analyzer
Achieve PCI DSS 3.0 Compliant Status with Out-of-the-box PCI DSS Reports
Are you Audit-Ready for PCI DSS 3.0 Compliance? Download White paper
Comply to PCI DSS 3.0 Requirement 10 and 11.5 with EventLog Analyzer
http://pubads.g.doubleclick.net/gampad/clk?id=154622311&iu=/4140/ostg.clktrk
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
