Issue Details (XML | Word | Printable)

Key: CORE-435
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Dmitry Yemanov
Reporter: ded
Votes: 0
Watchers: 0
Operations

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

Aggregate concatenated empty char

Created: 30/May/02 12:00 AM   Updated: 14/Jun/06 09:39 AM
Component/s: Engine
Affects Version/s: None
Fix Version/s: 1.5.0

Time Tracking:
Not Specified

SF_ID: 562417


 Description  « Hide
SFID: 562417#
Submitted By: ded

  Any aggregate function except Count concatenated with
'' returns null, Count returns empty string

Select Max(AnyColumn)||''
From AnyTable

     Max
========
 <null>

Select Count(*)||''
From AnyTable

   Count
========


Casting, such as

Select Cast(Max(AnyColumn) As Varchar (50) ||''
From AnyTable

results the same. Seems this bug affects all IB/FB
versions.

Alexander V.Nevsky

 All   Comments   Work Log   Change History   Version Control   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
There are no comments yet on this issue.