[V4MD] MAX/MIN

[Gregoire William]

It's why I asked if it's "normal"
I'm not a SQL man so it was just to be sure...
thanks

WilG

-----Message d'origine-----
De : valentina-bounces at lists.macserve.net
[mailto:valentina-bounces at lists.macserve.net]De la part de Ruslan
Zasukhin
Envoye : jeudi 4 novembre 2004 21:02
A : valentina at lists.macserve.net
Objet : Re: [V4MD] MAX/MIN


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
-------------------------------------------------------------


_______________________________________________
Valentina mailing list
Valentina at lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina