CAST('-0.0' AS NUMERIC) computes 0.0 rather than 0
|User & Date:||drh 2019-06-12 20:53:50|
- Change icomment to:
The CAST of '-0.0' into numeric now yields 0 as a special case, which resolves this ticket.
The issue of whether or not to display the minus sign when rendering a -0.0 value into text is still open. I observe that other database engines, and in particular PostgreSQL, do *not* display the minus sign. So, for now, SQLite will follow PostgreSQL's lead and behave the same.
- Change login to "drh"
- Change mimetype to "text/x-fossil-wiki"
- Change resolution to "Fixed"
- Change status to "Fixed"