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

[Ivan Smahin]

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