/ All files named "test/cast.test"
Login

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

History for test/cast.test

2020-10-03
19:16
[336fa219] part of check-in [df12f097] Do not apply affinities when creating entries for automatic indexes on views. Fix for [95302bdb]. (check-in: [df12f097] user: dan branch: trunk, size: 12891)
2020-01-02
16:24
[2906ccab] part of check-in [e782096a] 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: [e782096a] user: dan branch: trunk, size: 12659)
2019-06-12
22:46
[3619f0c5] part of check-in [ebb81dad] Adjust requirements marks and add new requirements tests. (check-in: [ebb81dad] user: drh branch: trunk, size: 12357)
20:51
[66785644] part of check-in [491f0f9b] As a special case, casting '-0.0' into numeric should yield 0. Fix for ticket [674385aeba91c774]. (check-in: [491f0f9b] user: drh branch: trunk, size: 12488)
2019-06-10
23:45
[2067a08e] part of check-in [57050162] A string consisting of a single '.' is not a floating point literal with extra text at the end. Fix for ticket [412bba9b22c677da] (check-in: [57050162] user: drh branch: trunk, size: 12156)
18:33
[9fa79845] part of check-in [c0c90961] 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: [c0c90961] user: drh branch: trunk, size: 11866)
2019-06-07
22:26
[6505b8ae] part of check-in [67a68af5] 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 branch: trunk, size: 11343)
2018-01-26
18:37
[5ceb9207] part of check-in [ace0644a] 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: [ace0644a] user: drh branch: trunk, size: 10729)
2011-05-05
19:44
[4c275cbd] part of check-in [1586244b] Changes to various test scripts so that they pass on windows. (check-in: [1586244b] user: dan branch: win32-test-fixes, size: 9014)
2008-11-06
15:33
[16695166] part of check-in [1b6a5140] Fix a bug in the CAST operator associated with the column cache. (CVS 5866) (check-in: [1b6a5140] user: drh branch: trunk, size: 8974)
2008-01-19
20:11
[ce8f14fc] part of check-in [af129b6d] Miscellaneous code simplifications and cleanup and test coverage enhancements. (CVS 4730) (check-in: [af129b6d] user: drh branch: trunk, size: 8530)
2007-08-13
15:18
[c4780b58] part of check-in [4f4f8ef4] Disable tests that require 80-bit long doubles when the host only provides 64-bit long doubles. Ticket #2570. (CVS 4215) (check-in: [4f4f8ef4] user: drh branch: trunk, size: 7828)
2007-05-17
16:34
[0302bbc8] part of check-in [f2ce727c] Fix a problem with casting blobs to numeric types. (CVS 4021) (check-in: [f2ce727c] user: danielk1977 branch: trunk, size: 7700)
2007-05-16
11:55
[6f5073af] part of check-in [2ac985a3] Keep the full precision of integers if possible when casting to "numeric". Ticket #2364. (CVS 4012) (check-in: [2ac985a3] user: drh branch: trunk, size: 7208)
2006-03-03
19:12
[f88e7b69] part of check-in [cdca3383] 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: [cdca3383] user: drh branch: trunk, size: 4755)
2006-01-16
16:24
[aabdcb38] part of check-in [c058f483] Test file fixes for libaries compiled with various SQLITE_OMIT_ macros. (CVS 2961) (check-in: [c058f483] user: danielk1977 branch: trunk, size: 4548)
2005-11-01
15:48
[2543165c] part of check-in [e0d6f61c] 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: [e0d6f61c] user: drh branch: trunk, size: 4458)
2005-06-25
19:31
[937af85f] part of check-in [8c99dca6] The TCL interface binds variables as BLOB only if they have a bytearray representation but no text representation. Ticket #1287. (CVS 2528) (check-in: [8c99dca6] user: drh branch: trunk, size: 4456)
18:42
Added: [5c5ebb3e] part of check-in [17631785] Remove the blob(), text() and numeric() functions added in (2524) and replace them with the standard CAST operator. Ticket #1287. (CVS 2527) (check-in: [17631785] user: drh branch: trunk, size: 4461)