[#CORE-2660] COUNT(*) incorrectly returns 0 when a condition of an outer join doesn't match

Firebird Core

COUNT(*) incorrectly returns 0 when a condition of an outer join doesn't match

Created: 04/Oct/09 07:25 AM Updated: 04/Oct/09 07:31 AM

Return to search

Component/s:

Engine

Affects Version/s:

2.0.0, 1.5.4, 2.0.1, 2.0.2, 2.0.3, 1.5.5, 2.1.0, 2.0.4, 2.5 Alpha 1, 2.1.1, 2.0.5, 2.1.2, 2.5 Beta 1, 2.5 Beta 2, 2.1.3

Fix Version/s:

2.5 RC1

Time Tracking:

Not Specified

Planning Status:

Unspecified

Description

« Hide

select b.*
  from rdb$database a
  left join (
    select count(*) c
      from rdb$database
  ) b on 1 = 0;

           C
============
           0

It should return NULL.

All

Comments

Work Log

Change History

Version Control

Sort Order:

Adriano dos Santos Fernandes made changes - 04/Oct/09 07:31 AM

Field	Original Value	New Value
Fix Version/s		2.5 RC1 [ 10362 ]
Resolution		Fixed [ 1 ]
Status	Open [ 1 ]	Resolved [ 5 ]
Assignee		Adriano dos Santos Fernandes [ asfernandes ]