SQL - FIRST() and LAST() aggregate functions return numeric type fields even from string types

[Ernesto Giannotta]

Done!

On Aug 29, 2010, at 20:21, Ivan Smahin wrote:

> Hello Ernesto,
> 
> Sunday, August 29, 2010, 5:13:54 PM, you wrote:
> 
>> Hello Ruslan,
> 
>> I'm getting strange results from the FIRST() and LAST() aggregate functions.
> 
>> a query like this:
> 
>> select FIRST(Artist) as Name 
>> FROM Artists 
> 
>> returns a field containing the number 0
> 
>> Shouldn't it return a string? 
> 
>> I get it correct with group_concat().
> 
> Indeed, bug. Please report it to the Mantis - it's easy to fix.
> 
> -- 
> Best regards,
> Ivan Smahin 
> Senior Software Engineer
> Paradigma Software, Inc
> Valentina - The Ultra-Fast Database
> http://www.valentina-db.com
> 
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina