SQLite

All files named ”test/cast.test”
Login

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

History for test/cast.test

2025-04-10
10:18
[a2a3b32df8] part of check-in [20acd630b9] Remove unnecessary "www." prefixes on domain names in URLs. (check-in: [20acd630b9] user: drh branch: trunk, size: 15099)
2024-10-01
20:29
[6d09530349] part of check-in [f622b52024] Remove all code that makes use of the C-language "long double" datatype. (check-in: [f622b52024] user: drh branch: omit-long-double, size: 15115)
2024-07-31
01:45
[42f7d79d88] part of check-in [71f2ee5db0] Implement a new comparison routine to compare text renderings of floating point values. This gets the number of failures down to just 5. But the routine needs work, and probably refactoring. (check-in: [71f2ee5db0] user: drh branch: tcl9, size: 15221)
2023-02-06
10:47
[af2286fdd2] part of check-in [81c118d90b] Fix some test scripts that were failing with SQLITE_OMIT_VIRTUALTABLE builds. (check-in: [81c118d90b] user: dan branch: trunk, size: 15210)
2022-12-15
20:03
[e3a7e452f3] part of check-in [44135d6ea8] Create a new affinity called FLEXNUM that works like NUMERIC except that it never tries to convert integer to real or real to integer. The affinity is only used internally - it is not possible to create a table column with this affinity. This affinity is used on subqueries and views that are built off of a compound SELECT and where the datatype is controlled by a CAST expression. dbsqlfuzz c9ee6f9a0a8b8fefb02cf69de2a8b67ca39525c8 (check-in: [44135d6ea8] user: drh branch: trunk, size: 15161)
2022-12-13
00:51
[46a5963a21] part of check-in [c43f433bca] Merge recent trunk changes into the coroutine-exp2 branch. (check-in: [c43f433bca] user: drh branch: coroutines-exp2, size: 13934)
2022-12-12
21:22
[8e5ad129d4] part of check-in [f0325359d5] Further fix for ticket [57c47526c34f01e8]. If a subquery has a result set column of the form "CAST(expr AS NUMERIC)" do not give that column NUMERIC affinity. NUMERIC affinity always goes to an integer if able, but a CAST to numeric is a no-op if the input is a number. So the two are not equivalent. (check-in: [f0325359d5] user: drh branch: trunk, size: 13932)
18:58
[4f14da6ed9] part of check-in [ece07d091c] If a subquery has a result column of the form "CAST(... AS NUMERIC)" then give that column no affinity rather than NUMERIC affinity. This is because casting to numeric preserves real values that could be integers but numeric affinity does not. By using no affinity on the column, we make the behavior consistent if the subquery is implemented as a co-routine or is materialized. (check-in: [ece07d091c] user: drh branch: cast-to-numeric, size: 13932)
2022-11-01
00:52
[6064022ba9] part of check-in [b6692de374] Enforce column affinity on the materialization of a subquery or view. (check-in: [b6692de374] user: drh branch: tkt-57c47526, size: 12889)
2020-10-03
19:16
[336fa21989] part of check-in [df12f09722] Do not apply affinities when creating entries for automatic indexes on views. Fix for [95302bdb]. (check-in: [df12f09722] user: dan branch: trunk, size: 12891)
2020-01-02
16:24
[2906ccab6a] part of check-in [e782096aa0] Handle blobs that are the return values of functions being cast to text in utf16 databases in the same way as blobs read directly from the database. Fix for [771fe617]. (check-in: [e782096aa0] user: dan branch: trunk, size: 12659)
2019-06-12
22:46
[3619f0c58c] part of check-in [ebb81dad1f] Adjust requirements marks and add new requirements tests. (check-in: [ebb81dad1f] user: drh branch: trunk, size: 12357)
20:51
[6678564470] part of check-in [491f0f9bbd] As a special case, casting '-0.0' into numeric should yield 0. Fix for ticket [674385aeba91c774]. (check-in: [491f0f9bbd] user: drh branch: trunk, size: 12488)
2019-06-10
23:45
[2067a08edf] part of check-in [5705016229] A string consisting of a single '.' is not a floating point literal with extra text at the end. Fix for ticket [412bba9b22c677da] (check-in: [5705016229] user: drh branch: trunk, size: 12156)
18:33
[9fa79845ef] part of check-in [c0c90961b4] Make sure a CAST to "NUMERIC" results in an integer if the value can be losslessly expressed as an integer, as the documentation requires. Ticket [dd6bffbfb6e61db9]. (check-in: [c0c90961b4] user: drh branch: trunk, size: 11866)
2019-06-07
22:26
[6505b8aecc] part of check-in [67a68af557] 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: [67a68af557] user: drh branch: trunk, size: 11343)
2018-01-26
18:37
[5ceb920718] part of check-in [ace0644a1a] Improve text-to-integer conversion in boundary cases. The sqlite3Atoi64() function always returns the minimum or maximum integer if the magnitude of the text value is too large. Trailing whitespace is now ignored. (check-in: [ace0644a1a] user: drh branch: trunk, size: 10729)
2011-05-05
19:44
[4c275cbdc8] part of check-in [1586244b6d] Changes to various test scripts so that they pass on windows. (check-in: [1586244b6d] user: dan branch: win32-test-fixes, size: 9014)
2008-11-06
15:33
[166951664a] part of check-in [1b6a514044] Fix a bug in the CAST operator associated with the column cache. (CVS 5866) (check-in: [1b6a514044] user: drh branch: trunk, size: 8974)
2008-01-19
20:11
[ce8f14fc80] part of check-in [af129b6d15] Miscellaneous code simplifications and cleanup and test coverage enhancements. (CVS 4730) (check-in: [af129b6d15] user: drh branch: trunk, size: 8530)
2007-08-13
15:18
[c4780b58b5] part of check-in [4f4f8ef416] Disable tests that require 80-bit long doubles when the host only provides 64-bit long doubles. Ticket #2570. (CVS 4215) (check-in: [4f4f8ef416] user: drh branch: trunk, size: 7828)
2007-05-17
16:34
[0302bbc8d1] part of check-in [f2ce727c4d] Fix a problem with casting blobs to numeric types. (CVS 4021) (check-in: [f2ce727c4d] user: danielk1977 branch: trunk, size: 7700)
2007-05-16
11:55
[6f5073af07] part of check-in [2ac985a380] Keep the full precision of integers if possible when casting to "numeric". Ticket #2364. (CVS 4012) (check-in: [2ac985a380] user: drh branch: trunk, size: 7208)
2006-03-03
19:12
[f88e7b6946] part of check-in [cdca3383c5] Ignore leading spaces on text to numeric conversions. Ticket #1662. Fixes to test cases broken by the recent changes to round(). (CVS 3118) (check-in: [cdca3383c5] user: drh branch: trunk, size: 4755)
2006-01-16
16:24
[aabdcb3873] part of check-in [c058f483a5] Test file fixes for libaries compiled with various SQLITE_OMIT_ macros. (CVS 2961) (check-in: [c058f483a5] user: danielk1977 branch: trunk, size: 4548)
2005-11-01
15:48
[2543165ced] part of check-in [e0d6f61c7d] Omit the SQLITE_AFF_INTEGER type affinity. All numeric values are now of type real, though an integer representation is still sometimes used internally for efficiency. (CVS 2753) (check-in: [e0d6f61c7d] user: drh branch: trunk, size: 4458)
2005-06-25
19:31
[937af85faa] part of check-in [8c99dca60a] The TCL interface binds variables as BLOB only if they have a bytearray representation but no text representation. Ticket #1287. (CVS 2528) (check-in: [8c99dca60a] user: drh branch: trunk, size: 4456)
18:42
Added: [5c5ebb3eda] part of check-in [17631785f9] Remove the blob(), text() and numeric() functions added in (2524) and replace them with the standard CAST operator. Ticket #1287. (CVS 2527) (check-in: [17631785f9] user: drh branch: trunk, size: 4461)