CAST('-0.0' AS NUMERIC) computes 0.0 rather than 0
|User & Date:||drh 2019-06-12 20:53:50|
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.
- login: "drh"
- mimetype: "text/x-fossil-wiki"
- resolution changed to: "Fixed"
- status changed to: "Fixed"