/ Check-in [67a68af5]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:When casting string values into numeric and the string has a prefix that looks like a number but total string is not a well-formed number, then take extra care that the result is either integer or real depending on what the prefix looks like. Fix for tickets [e8bedb2a184001] and [4c2d7639f076aa].
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: 67a68af5578f08d2be2e48cf4fd12a6cf35a09c47d259deda81950f7ee1f02f7
User & Date: drh 2019-06-07 22:26:08
References
2019-06-08
21:31 New ticket [dd6bffbf] CAST to NUMERIC no longer converts to INTEGER. artifact: f550c0f0 user: mrigger
Context
2019-06-07
22:51
Remove code in the round() SQL function that became unreachable due to the optimization of check-in [e95138f5f4febde5] check-in: b141bae3 user: drh tags: trunk
22:26
When casting string values into numeric and the string has a prefix that looks like a number but total string is not a well-formed number, then take extra care that the result is either integer or real depending on what the prefix looks like. Fix for tickets [e8bedb2a184001] and [4c2d7639f076aa]. check-in: 67a68af5 user: drh tags: trunk
18:56
Also upgrade script config.sub to the latest version. This should have been part of the previous commit. check-in: efbf31b8 user: dan tags: trunk
Changes
Unified Diffs Side-by-Side Diffs Patch

Changes to src/date.c.

Changes to src/func.c.

Changes to src/util.c.

Changes to src/vdbe.c.

Changes to src/vdbemem.c.

Changes to test/cast.test.

Changes to test/e_expr.test.

Changes to test/tkt-a8a0d2996a.test.