[sqlite] MIN/MAX of column loses decltype

[Simon Slavin]

On 22 Feb 2016, at 4:02pm, Eric Hill <Eric.Hill at jmp.com> wrote:

> I can call sqlite3_column_decltype() and get back "REAL_DATE" and know I 
> should convert.
> 
> However, if I execute this SQL:
> 
> SELECT MAX( theDate ) FROM t1;
> 
> My call to sqlite3_column_decltype() returns nothing - the decltype of the 
> column being aggregated is not preserved by the MAX() operation.

What happens for

SELECT theDate,length(theDate),typeof(theDate) FROM t1 LIMIT 1;

?