[V4MD] MAX/MIN

[Frank Schima]

Hi Guys,


On Nov 4, 2004, at 11:42 AM, Ruslan Zasukhin wrote:

> On 11/4/04 6:25 PM, "Gregoire William" 
> <wgregoire at paris.mediagerance.com>
> wrote:
>
>> Hi
>>
>> If I use "SELECT MIN(Table1.Value) FROM Table1" on a EMPTY table 
>> Table1,
>> GetRecordCount() return 1
>>
>> Is it a normal feature ?!
>
> Looks to be be bug

Actually, I think it is correct. All summation functions should return 
1 record - or 1 record per group when using GROUP BY. Even if the 
result is Null, it is still a record to say that.

I checked on MySQL and it returns 1 record (with a Null value) in such 
a case.


Best regards,
Frank