Icon View Incident Report

Serious Serious
Reported By: Alexey Parshin
Reported On: 5/14/2008
For: Version 1.07 Build 3
# 2610 MIN and MAX Aggregate Functions Not Working Properly on VARCHAR or CHAR Columns

The Category table contains a varchar(10) field populated with integers. I'm trying to get a max value of the field, treating it as string.

Expected result: a field with the max value.
Actual result: NULL

If I add cast to bigint, then the result is correct.

SELECT max(CategoryCode) from Category
where categoryCode is not null



Resolution Resolution
Fixed Problem on 5/14/2008 in version 1.09 build 4


Products Affected Products Affected
ElevateDB Additional Software and Utilities
ElevateDB DAC Client-Server
ElevateDB DAC Client-Server with Source
ElevateDB DAC Standard
ElevateDB DAC Standard with Source
ElevateDB DAC Trial
ElevateDB VCL Client-Server
ElevateDB VCL Client-Server with Source
ElevateDB VCL Standard
ElevateDB VCL Standard with Source
ElevateDB VCL Trial

Image