[sqlite] Bug report for MAX()

[Simon Slavin]

On 25 Nov 2015, at 11:09am, R Smith <rsmith at rsweb.co.za> wrote:

> sqlite> SELECT max(UnitCost) FROM BOMData;
> 
> sqlite> SELECT min(UnitCost) FROM BOMData;
> 0.0

Can you please post the result of

SELECT DISTINCT typeof(UnitCost) FROM BOMData;

(I think that's how you do it.  You might need to use GROUP BY.)

Simon.