[V4MD] MAX/MIN

[Ruslan Zasukhin]

On 11/4/04 9:16 PM, "Frank Schima" <frank-list3 at mindstarprods.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.

You are right Frank.

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------