SQLite

All files named ”test/func.test”
Login

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

History for test/func.test

2025-04-10
10:18
[b6b6942b29] part of check-in [20acd630b9] Remove unnecessary "www." prefixes on domain names in URLs. (check-in: [20acd630b9] user: drh branch: trunk, size: 45990)
2024-12-19
12:08
[15f6867416] part of check-in [472abb492f] Fix additional integer overflow problems in the substr() function. (check-in: [472abb492f] user: drh branch: trunk, size: 45994)
2024-12-18
20:29
[59ae5fbfc2] part of check-in [b04b4006f3] Fix possible integer oveflow in the second and third argument to substr(). (check-in: [b04b4006f3] user: drh branch: trunk, size: 45889)
18:29
[4b8d5e7f13] part of check-in [a9759fc78d] Avoid 32-bit roundoff error on the second argument to round(). Forum post 170aeab92a. (check-in: [a9759fc78d] user: drh branch: trunk, size: 45728)
2024-12-12
20:39
[0caa32dda6] part of check-in [3c25c69c93] Increase the maximum number of arguments on an SQL function to 1000 with the capability to increase it further up to 32767 using a compile-time option. (check-in: [3c25c69c93] user: drh branch: cf8f1552-commit-instr, size: 45764)
15:11
[e643522c6c] part of check-in [e8d7d68ba0] Increase the maximum number of arguments on an SQL function to 1000 with the capability to increase it further up to 32767 using a compile-time option. (check-in: [e8d7d68ba0] user: drh branch: trunk, size: 45644)
2024-10-02
11:34
[098d28ecd1] part of check-in [11d6a89e4a] Remove a few more traces of long double from the code. (check-in: [11d6a89e4a] user: drh branch: omit-long-double, size: 45548)
2024-06-05
20:52
[8e18545298] part of check-in [07d8420285] Add an experimental concatb() function. (check-in: [07d8420285] user: mistachkin branch: concatb, size: 45895)
2024-03-19
10:46
[49a39f86fc] part of check-in [0984e5cd25] Fix a problem involving infinities int the Kahan-Babushka-Neumaier summation algorithm. (check-in: [0984e5cd25] user: drh branch: branch-3.44, size: 45457)
10:41
[b56905748c] part of check-in [0dddadbd5b] Adjustments to the test cases for the previous check-in to make them cross-platform Linux/Mac/Windows. Test changes only. No change to core code. (check-in: [0dddadbd5b] user: drh branch: trunk, size: 45668)
10:16
[648ca90b9c] part of check-in [45d272ef38] Fix another problem from [c63e26e705f5e967] involving infinities and the Kahan-Babushka-Neumaier summation algorithm. Problem reported by forum post 23b8688ef4. (check-in: [45d272ef38] user: drh branch: trunk, size: 45737)
2024-02-26
22:28
[504d202650] part of check-in [85dd79a6ed] The quote() SQL function should convert +Inf into 9.0e+999 and -Inf into -9.0e+999. See forum post 6675b25108. (check-in: [85dd79a6ed] user: drh branch: trunk, size: 44916)
2024-01-20
13:18
[da1332f6ab] part of check-in [01868ebcd2] Ensure that the replace() SQL function always returns a TEXT value even when its first argument is numeric and its second argument is an empty string. Fix for the issue reported by forum post 3776b48e71. (check-in: [01868ebcd2] user: drh branch: trunk, size: 44776)
2023-10-20
20:19
[3a29323b64] part of check-in [b91c19bf26] Add string_agg(X,Y) as an alias for group_concat(X,Y), for compatibility with SQLServer and PG. (check-in: [b91c19bf26] user: drh branch: string_agg, size: 44705)
2023-08-30
16:03
[cbcf086273] part of check-in [6df6f17ccb] Fix the AVG() and TOTAL() functions (after the SUM() fix of [77d3dcd283595c52]) so that they work with infinitites. Fixes a bug introduced by check-in. [c63e26e705f5e967]. Bug reported by forum post 8960fb40cc. (check-in: [6df6f17ccb] user: drh branch: trunk, size: 44538)
2023-08-28
12:20
[719076723b] part of check-in [77d3dcd283] Fix an issue with infinity handling by the SUM() function that goes back to the extended-precision SUM() enhancement of check-in [c63e26e705f5e967]. Problem reported by forum post 1c06ddcacc86032a. (check-in: [77d3dcd283] user: drh branch: trunk, size: 44484)
2023-07-06
17:14
[2acd982669] part of check-in [ad2e39626e] Fix octet_length() test cases so that they work when the database encoding is utf16. (check-in: [ad2e39626e] user: drh branch: trunk, size: 44206)
2023-06-30
14:01
[f246a12169] part of check-in [85be05b66e] Completely unwind the enhanced precision sum() from [a915f15a916af698] so as not to offend UBSAN and OSS-Fuzz. (check-in: [85be05b66e] user: drh branch: trunk, size: 44073)
11:51
[ee6e8c5f74] part of check-in [1be0646a2c] Make the sum() function less precise and slower in order to avoid harmless signed integer overflow UBSAN warnings from OSS-Fuzz. (check-in: [1be0646a2c] user: drh branch: trunk, size: 44357)
2023-06-26
19:57
[14ec60fd0c] part of check-in [c66ef2440e] Simple test cases for the enhanced SUM() function. (check-in: [c66ef2440e] user: drh branch: extended-precision-fp, size: 44355)
2023-06-22
15:26
[cdebc08012] part of check-in [034a5fe2a0] basic test cases for octet_length(). (check-in: [034a5fe2a0] user: drh branch: octet_length, size: 43829)
2022-01-16
19:11
[4be8bed4be] part of check-in [4883776669] Fix test cases so that they all still work even with -DSQLITE_DQS=0. (check-in: [4883776669] user: drh branch: trunk, size: 43323)
2022-01-07
14:58
[0a305e88a4] part of check-in [c4e4e3a3fc] Add new binary operators "->" and "->>" to the parser that evaluate to 2-argument SQL functions by the same name. Add new "->" and "->>" functions to the JSON extension that are aliases for json_extract(). (check-in: [c4e4e3a3fc] user: drh branch: json-enhancements, size: 43323)
2021-10-01
20:39
[3a65ddb6c1] part of check-in [2f7c946c5f] Change things so that SQLITE_OMIT_VIRTUALTABLE implies SQLITE_OMIT_ALTER_TABLE. (check-in: [2f7c946c5f] user: dan branch: trunk, size: 43043)
2021-09-30
21:42
[2d84a919fe] part of check-in [86f9c07a4f] Adjust 3 query result expectations to reflect changed group_concat() behavior with varying separator. (check-in: [86f9c07a4f] user: larrybr branch: group_concat_varsep, size: 43017)
2021-06-15
14:34
[77f6ea02c9] part of check-in [829343c26e] Prevent an infinite loop in the trim() SQL function if the second argument is a carefully malformed UTF8 string. (check-in: [829343c26e] user: drh branch: trunk, size: 43017)
2020-03-11
19:41
[f673822636] part of check-in [d7f1848997] Rename sqlite3ExprCodeAtInit() to sqlite3ExprCodeRunJustOnce(). Other changes to make the new code cleaner. Test cases added. (check-in: [d7f1848997] user: drh branch: do-not-factor-functions, size: 42333)
2020-01-10
01:05
[b7f1a706d1] part of check-in [0a500da6aa] Fix to the register validity tracking logic in debug builds. No impact on release builds. (check-in: [0a500da6aa] user: drh branch: trunk, size: 41706)
2020-01-08
17:28
[93d692f642] part of check-in [1da802d54b] Check for whether or not it is safe to use non-innocuous functions as the function is being coded, not when its name is resolved. (check-in: [1da802d54b] user: drh branch: new-security-options, size: 41159)
2019-11-15
21:16
[7d425f9a6e] part of check-in [8f4a3750b7] Modify three test cases so that they work even with unusual versions of the library printf(). (check-in: [8f4a3750b7] user: drh branch: trunk, size: 41216)
2019-08-15
20:04
[0889128141] part of check-in [fc745845d8] Provide the SQLITE_DIRECTONLY flag for app-defined functions that prohibits the use of those functions within triggers or views. (check-in: [fc745845d8] user: drh branch: directonly, size: 41197)
2019-05-10
12:06
[e4313baba8] part of check-in [db9acef14d] Fix the round() SQL function so that it handles infinities correctly. (check-in: [db9acef14d] user: drh branch: trunk, size: 39944)
2019-03-29
11:13
[150270b6e2] part of check-in [98da62dfda] Initial implementation of the sqlite3_value_frombind() interface. (check-in: [98da62dfda] user: drh branch: value_frombind, size: 39859)
2018-02-09
23:25
[09dda479bc] part of check-in [fab2c2b07b] Improve the performance of the built-in REPLACE() function in cases where it does many substitutions that make the string larger. OSSFuzz is reporting intermittant timeouts when running a test where it does a REPLACE() on a 930KB random blob. Perhaps this enhancement will fix that. (check-in: [fab2c2b07b] user: drh branch: trunk, size: 39220)
2014-05-07
17:19
[ae97561957] part of check-in [0deac87375] Make sure the group_concat() function returns an empty string, not a NULL, if it has at least one input row. Fix for ticket [55746f9e65f8587]. (check-in: [0deac87375] user: drh branch: tkt-55746f9e, size: 38978)
2014-03-20
18:56
[c2cbfc23d5] part of check-in [d8e1f75ddf] Only use the direct-overflow-read optimization if all data from the overflow page in question is being read. (check-in: [d8e1f75ddf] user: dan branch: overflow-pgno-cache, size: 38664)
2014-03-08
19:07
[a21814945d] part of check-in [ba39df9d4f] Fix a bug causing "SELECT char()" to return SQLITE_NOMEM. (check-in: [ba39df9d4f] user: dan branch: trunk, size: 38623)
2013-11-20
20:58
[00667bbeac] part of check-in [0e05679db7] Improved comments on the OP_Column changes. Optimize out loading of overflow pages for content with zero length. Add test cases for the latter. (check-in: [0e05679db7] user: drh branch: OP_Column-refactor, size: 38514)
2013-10-11
16:35
[c7e80a44ee] part of check-in [5f01cd36ee] Additional test cases and requirements marks for the unlikely(), likelihood() and instr() functions. (check-in: [5f01cd36ee] user: drh branch: trunk, size: 37792)
2013-07-19
23:58
[cd25cf605c] part of check-in [f755b4b21c] Fixes to test numbering. (check-in: [f755b4b21c] user: mistachkin branch: trunk, size: 37455)
2013-07-18
17:12
[9161beda51] part of check-in [71effa59c9] Ensure that all auxiliary data registered by calls to sqlite3_set_auxdata() is destroyed when the VM is halted. Partial fix for [406d3b2ef9]. DRH adds: Stray text accidentally inserted into vdbe.c just prior to the commit breaks the build. (check-in: [71effa59c9] user: dan branch: typo, size: 37432)
2013-03-26
01:07
[a4f24707e6] part of check-in [a850c7319c] Previous check-in accidently left mmap turned off by default. This checkin fixes that. Unfortunately, shared.test is now segfaulting. All other veryquick tests appear to work, however. (check-in: [a850c7319c] user: drh branch: experimental-mmap, size: 36828)
2013-03-19
19:28
[b0fc34fdc3] part of check-in [6183f1bd86] Add the sqlite3_io_methods.xMremap() method to the VFS interface. Also "PRAGMA mmap_size". (check-in: [6183f1bd86] user: dan branch: experimental-mmap, size: 36826)
2013-03-07
09:39
[2d243cc61d] part of check-in [e39391422e] Skip tests that require UTF-16 support when compiled with SQLITE_OMIT_UTF16. (check-in: [e39391422e] user: mistachkin branch: trunk, size: 36829)
2013-02-26
05:44
[b058483c17] part of check-in [d2e7dfca5a] Prevent Tcl file encoding issues in the tests for the unicode() and char() functions. (check-in: [d2e7dfca5a] user: mistachkin branch: funcTestEncoding, size: 36783)
2013-02-25
14:39
[dd81580d3e] part of check-in [be24939052] Add new SQL functions unicode() and char(). (check-in: [be24939052] user: drh branch: trunk, size: 36745)
2013-02-22
19:34
[0ea5489553] part of check-in [209b21085b] Two new SQL functions: unicode() and char(). (check-in: [209b21085b] user: drh branch: unicode-function, size: 36395)
2012-06-19
03:59
[0d89043dab] part of check-in [963eb24f73] Fix an incorrect testcase for the round() function. All tests are passing now, including new real->text->real round-trip tests. (check-in: [963eb24f73] user: drh branch: floating-point-conversions, size: 36172)
2012-03-28
02:51
[9809b7622d] part of check-in [d095fa4bfa] Test cases for length() of a large blob in an aggregate query. (check-in: [d095fa4bfa] user: drh branch: faster-typeof-and-length, size: 36172)
01:34
[6966ad939b] part of check-in [b899dbeb60] Evaluate typeof(X) and length(Y) where X is any column and Y is a blob column without actually loading X and Y from disk. (check-in: [b899dbeb60] user: drh branch: faster-typeof-and-length, size: 35918)
2010-02-17
03:57
[6c5ce11e3a] part of check-in [3863638b8c] More rounding tests. (check-in: [3863638b8c] user: shaneh branch: trunk, size: 34928)
2010-02-16
22:00
[c12663a99d] part of check-in [b8ee76bc1f] Added additional rounding tests. (check-in: [b8ee76bc1f] user: shaneh branch: trunk, size: 34902)
2009-08-18
16:05
[af106ed834] part of check-in [093917d7fd] Unknown functions in the DEFAULT clause of a table cause an error when the DEFAULT value is needed. Ticket [2d401a94287b5]. (check-in: [093917d7fd] user: drh branch: trunk, size: 32589)
2009-06-19
16:44
[004caa157b] part of check-in [90c3b23cca] Make sure group_concat() ignores initial NULL values. (CVS 6787) (check-in: [90c3b23cca] user: drh branch: trunk, size: 32378)
2009-04-15
15:16
[d4a8590511] part of check-in [b83fbf15a3] Fix the group_concat() function so that it inserts the separator string even if the initial content strings are empty. Ticket #3806. (CVS 6510) (check-in: [b83fbf15a3] user: drh branch: trunk, size: 31828)
2009-02-04
03:59
[70ea3d5b10] part of check-in [5cef400023] Changes to completely remove all floating point ops if SQLITE_OMIT_FLOATING_POINT defined. Note that w/o fp, date/time, round, nan, etc. are all gone or limited in functionality. Updated some of the test scripts to support missing fp and 64-bit functionality. Ticket #3029. (CVS 6250) (check-in: [5cef400023] user: shane branch: trunk, size: 31423)
2009-02-02
21:57
[e40978f089] part of check-in [f2ae82c4d4] Make group_concat() a 1- or 2-value function, as the documentation says it should be. Use the md5sum() function to verify ticket #3179, not group_concat(). This undoes the ill-advised group_concat() change of check-in (5233). (CVS 6233) (check-in: [f2ae82c4d4] user: drh branch: trunk, size: 29438)
2009-02-01
18:08
[c98d620d6e] part of check-in [ffebf10f6f] Change the replace() function to return a copy of its first argument when the 2nd argument is an empty string. Ticket #3624. (CVS 6226) (check-in: [ffebf10f6f] user: drh branch: trunk, size: 29272)
2009-01-31
22:28
[e361349bca] part of check-in [9cd43c82a3] Better error message when coalesce() has too few arguments. Ticket #3623. (CVS 6222) (check-in: [9cd43c82a3] user: drh branch: trunk, size: 29234)
2008-10-12
00:27
[a50f0a4b69] part of check-in [ba3711acee] Added SQLITE_OMIT_DEPRECATED compile time option to leave out deprecated functions. Updated test scripts to skip tests of deprecated functions if they are compiled out. (CVS 5808) (check-in: [ba3711acee] user: shane branch: trunk, size: 28956)
2008-08-04
03:51
[628dc9b321] part of check-in [9ca975c8fd] Fix (make test) with SQLITE_OMIT_COMPOUND_SELECT. Ticket #3235. (CVS 5530) (check-in: [9ca975c8fd] user: danielk1977 branch: trunk, size: 28925)
2008-07-31
01:47
[ca825e3781] part of check-in [2d5cec53c2] Omit calls to test_destructor16() if SQLITE_OMIT_UTF16 defined. (CVS 5508) (check-in: [2d5cec53c2] user: shane branch: trunk, size: 28848)
2008-07-16
18:20
[20973677b5] part of check-in [632bb3c734] More improvements to the 64-bit integer conversion testing in func.test. (CVS 5427) (check-in: [632bb3c734] user: drh branch: trunk, size: 28796)
18:04
[070ae66e38] part of check-in [8686959d42] Fix a test in func.test so that it works on machines that lack long double. (CVS 5425) (check-in: [8686959d42] user: drh branch: trunk, size: 28635)
2008-07-15
00:27
[92f017ac3c] part of check-in [7cf91e08c0] Increased test coverage. (CVS 5414) (check-in: [7cf91e08c0] user: drh branch: trunk, size: 28433)
2008-07-07
14:50
[1a2476c57e] part of check-in [4e941f3d43] Additional test cases added on the sqlite3_create_function() interface. (CVS 5349) (check-in: [4e941f3d43] user: drh branch: trunk, size: 28095)
2008-06-19
18:39
[7cc20ab845] part of check-in [9b04e10f6c] Unset global TCL variables in the func.test script prior to use to avoid conflicts from other scripts. (CVS 5251) (check-in: [9b04e10f6c] user: drh branch: trunk, size: 24734)
2008-06-18
15:34
[2c929a20e1] part of check-in [70c6739f4e] Make sure aggregate functions can take any number of arguments up to the limit imposed by SQLITE_LIMIT_FUNCTION_ARGS. Ticket #3179. Modify the group_concat() function to take an unlimited number of arguments in order to facilitate testing this behavior. (CVS 5233) (check-in: [70c6739f4e] user: drh branch: trunk, size: 24658)
2008-04-16
12:58
[b9f4cd2171] part of check-in [bb0f9e92e4] Add tests to verify that strings may use embedded zero characters. Ticket #3056. (CVS 5018) (check-in: [bb0f9e92e4] user: drh branch: trunk, size: 24301)
2008-04-15
12:14
[5227e6e6e9] part of check-in [d04246a463] Fix a code generator bug caused by the new CSE optimization. Add test cases to prevent a recurrence. (CVS 5011) (check-in: [d04246a463] user: drh branch: trunk, size: 24297)
2008-04-10
17:14
[4ae1fb477b] part of check-in [5be56dbe87] Enhanced testing and documentation of sqlite3_result_error_code(). Ticket #2940. (CVS 4983) (check-in: [5be56dbe87] user: drh branch: trunk, size: 24060)
2008-03-21
17:13
[4118b10101] part of check-in [13e388cecf] Make sure the text result of an aggregate function has the correct encoding. Ticket #3009. (CVS 4903) (check-in: [13e388cecf] user: drh branch: trunk, size: 23796)
2008-03-20
14:03
[03502ed9cb] part of check-in [60c77882b2] Initial implementation of per-connection limits and the sqlite3_limit() API. The sqllimits1.test script crashes. SQLITE_LIMIT_PAGE_COUNT and SQLITE_LIMIT_VDBE_OP are currently ignored. (CVS 4897) (check-in: [60c77882b2] user: drh branch: trunk, size: 23672)
2008-03-19
16:35
[c805453a6f] part of check-in [bb7218657f] Create the test_destructor16() test SQL function to enhance test coverage. Prior to check-in (4883), the test_destructor() function was sufficient, but we now need separate functions since the implementation is restricted to using the published API. (CVS 4884) (check-in: [bb7218657f] user: drh branch: trunk, size: 23698)
2008-01-12
19:03
[307b335a47] part of check-in [426f31ecdd] Continuing work toward converting the VM to a register machine. (CVS 4708) (check-in: [426f31ecdd] user: drh branch: trunk, size: 23486)
2007-11-28
22:36
[4d54202f6a] part of check-in [221aee72be] Add the {quote: StrAccum} object for accumulating strings. Revamp xprintf to use the new object. Rewrite the group_concat() function to use the new object. Productize and test the group_concat() function. (CVS 4578) (check-in: [221aee72be] user: drh branch: trunk, size: 23514)
2007-10-20
15:41
[fd05232dff] part of check-in [ca51b2f540] Simplify the mem3.c memory allocator. Have it call sqlite3_release_memory() automatically, without having to specify the soft heap limit. (CVS 4496) (check-in: [ca51b2f540] user: drh branch: trunk, size: 22925)
2007-09-12
17:01
[590fe3e1d2] part of check-in [c8405b15c0] Fixes for compilation/testing when the various OMIT macros are defined. (CVS 4423) (check-in: [c8405b15c0] user: danielk1977 branch: trunk, size: 22932)
2007-09-03
11:04
[71b39d44a0] part of check-in [c0ce631964] Handle transient malloc() failures in sqlite3CreateFunc(). (CVS 4371) (check-in: [c0ce631964] user: danielk1977 branch: trunk, size: 22865)
2007-05-15
18:35
[605989453d] part of check-in [448d3ef670] Additional tests for malformed UTF-8. (CVS 4011) (check-in: [448d3ef670] user: drh branch: trunk, size: 22683)
2007-05-11
01:44
[bf30bac1c5] part of check-in [d12a8924c6] Additional parsing bugs fixed. (CVS 3981) (check-in: [d12a8924c6] user: drh branch: trunk, size: 22177)
2007-05-08
14:39
[6f230b25b2] part of check-in [b0fb4a3cf6] Fix a potential buffer overrun in the replace() function. (CVS 3947) (check-in: [b0fb4a3cf6] user: danielk1977 branch: trunk, size: 22120)
2007-05-07
16:58
[5e32fe07bf] part of check-in [3e96105c1f] Add a version of the LIKE operator to the icu extension. Requires optimisation. (CVS 3939) (check-in: [3e96105c1f] user: danielk1977 branch: trunk, size: 21794)
2007-05-02
15:36
[6727c77294] part of check-in [4dbbfff4a7] Fix an invalid UTF8 encoding in the tests for the trim function. (CVS 3898) (check-in: [4dbbfff4a7] user: drh branch: trunk, size: 21761)
2007-04-27
21:59
[8a3bc8e836] part of check-in [ff1f4e7447] Internationalize the TRIM functions. Ticket #2323. (CVS 3883) (check-in: [ff1f4e7447] user: drh branch: trunk, size: 21761)
01:18
[d66c42af50] part of check-in [e6a0c90dd9] The replace() function should return NULL if the second argument is an empty string. Ticket #2324. (CVS 3877) (check-in: [e6a0c90dd9] user: drh branch: trunk, size: 21418)
2007-04-10
13:51
[865febfd5b] part of check-in [e14374e4e6] Be careful not to use the result of sqlite3_value_blob() after changing the representation of an object. Ticket #2290. (CVS 3834) (check-in: [e14374e4e6] user: drh branch: trunk, size: 21237)
2007-03-17
17:52
[019d706b24] part of check-in [6fe13eeade] Added TRIM, LTRIM, and RTRIM functions. (CVS 3698) (check-in: [6fe13eeade] user: drh branch: trunk, size: 21145)
13:27
[86c3322c92] part of check-in [c2fe746ea7] First cut at an implementation of the REPLACE() function. We might yet make this a compile-time option or move it into a separate source file. (CVS 3697) (check-in: [c2fe746ea7] user: drh branch: trunk, size: 19817)
2007-01-29
17:58
[71938e2ac7] part of check-in [f5ad74a9bc] Replace the randomHex() function with separate functions randomBlob() and hex(). (CVS 3620) (check-in: [f5ad74a9bc] user: drh branch: trunk, size: 18757)
15:50
[a2a780de5f] part of check-in [a6001589ab] Add the randomhex() function as a built-in. (CVS 3619) (check-in: [a6001589ab] user: drh branch: trunk, size: 18512)
2006-09-16
21:45
[0ed54b5aea] part of check-in [aa7728f9f5] Add the sqlite3_overload_function() API - part of the virtual table interface. (CVS 3426) (check-in: [aa7728f9f5] user: drh branch: trunk, size: 18110)
2006-08-19
11:34
[7f2c91a948] part of check-in [7810d1abf6] Fix for the (unsupported) soundex algorithm so that it conforms to Knuth. Ticket #1925. Test cases added. (CVS 3358) (check-in: [7810d1abf6] user: drh branch: trunk, size: 18052)
2006-06-20
11:01
[c0df82c29f] part of check-in [c6ea353bd9] Modifications so that compilation and testing with the various OMIT macros defined works. (CVS 3276) (check-in: [c6ea353bd9] user: danielk1977 branch: trunk, size: 17506)
2006-06-13
17:39
[7d8dd2e7d9] part of check-in [136bed496b] The optimizer recognizes MATCH operators and allows virtual-tables to make use of them. (CVS 3232) (check-in: [136bed496b] user: drh branch: trunk, size: 17430)
2006-03-26
01:21
[27d02fd00b] part of check-in [80cda9f7ce] SQLite now always chooses the column names for compound selects using the left-most select. This makes SQLite work like other SQL database, but it also is a change from historical behavior and may break some scripts. Ticket #1721. (CVS 3153) (check-in: [80cda9f7ce] user: drh branch: trunk, size: 16954)
2006-03-02
03:02
[0996e47cb5] part of check-in [9dbadfb211] Change the ROUND() function to return a REAL value instead of TEXT. Ticket #1699. (CVS 3116) (check-in: [9dbadfb211] user: drh branch: trunk, size: 16937)
2006-02-23
21:43
[9fdc0a5ba9] part of check-in [942c509595] Detect integer overflow in the abs() function. The random() function now provides 64 bits of randomness instead of just 32. Fix bugs in testing logic of test4.c. (CVS 3108) (check-in: [942c509595] user: drh branch: trunk, size: 16800)
2006-02-11
17:34
[1dbd4a4bb2] part of check-in [1c3e6002cd] I give up. SUM() now throws an error on integer overflow. Those of us who think this is goofy can use TOTAL() instead. Tickets #1664, #1669, #1670, #1674. (CVS 3084) (check-in: [1c3e6002cd] user: drh branch: trunk, size: 16563)
2006-02-09
22:13
[ba6159745e] part of check-in [9e04f8fdf1] SUM never gives an error. An integer result is returned for exact results and a floating point result is returned for approximate results. Tickets #1664, #1669, and #1670. (CVS 3066) (check-in: [9e04f8fdf1] user: drh branch: trunk, size: 15574)
17:47
[458898c38b] part of check-in [c72b946198] Integer overflow in SUM causes an exception. Ticket #1669. (CVS 3064) (check-in: [c72b946198] user: drh branch: trunk, size: 15471)
13:38
[ef312ca924] part of check-in [a9169e879d] Avoid overflowing the 48-bit mantissa of a floating point number when summing large integers in the SUM() function. Ticket #1664. (CVS 3061) (check-in: [a9169e879d] user: drh branch: trunk, size: 14842)
2006-01-20
15:45
[337888172c] part of check-in [fd4a6bb1ac] Fix and test the processing of sqlite3_result_error() withing aggregate functions. Allow errors to come from the step function (a new capability). Ticket #1632. (CVS 2981) (check-in: [fd4a6bb1ac] user: drh branch: trunk, size: 14620)
2006-01-03
00:33
[a7119afcc1] part of check-in [70b228575e] The sqlite TCL command no longer returns the hex address of the sqlite3* structure. Instead there is a new command in testfixture to find that information. (CVS 2852) (check-in: [70b228575e] user: drh branch: trunk, size: 14639)
2005-11-14
22:29
[e891bebf5a] part of check-in [ce06c123d0] Create separate affinities for INTEGER and REAL. (CVS 2766) (check-in: [ce06c123d0] user: drh branch: trunk, size: 14637)
2005-11-01
15:48
[ee08a30ba4] 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: 14635)
2005-09-08
20:37
[431f8e07a3] part of check-in [6281859425] SUM returns NULL when it has no inputs. Ticket #1413. (CVS 2678) (check-in: [6281859425] user: drh branch: trunk, size: 14637)
19:45
[e1f9489e76] part of check-in [2e6230edfd] A SUM() of all NULLs returns NULL. A SUM() of nothing return 0. A SUM() of a mixture of NULLs and numbers returns the sum of the numbers. Ticket #1413. (CVS 2677) (check-in: [2e6230edfd] user: drh branch: trunk, size: 14633)
10:37
[89206eb4ec] part of check-in [21adf4bd99] The SUM() aggregate function returns an integer result if all inputs are integers. Any single non-integer input causes the result to be a floating point value. (CVS 2669) (check-in: [21adf4bd99] user: drh branch: trunk, size: 14174)
2005-08-12
23:20
[8f9165f045] part of check-in [d6146a542a] 3rd argument to sqlite3Error() should always be a format string, never user-supplied error message text. Ticket #1354. (CVS 2583) (check-in: [d6146a542a] user: drh branch: trunk, size: 13798)
2005-06-25
18:42
[b062105b45] 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: 13522)
2005-06-22
10:53
[f5f9f2bd3f] part of check-in [affb0fa2e8] Add built-in functions numeric(), text(), and blob() that coerce types. Ticket #1287. (CVS 2524) (check-in: [affb0fa2e8] user: drh branch: trunk, size: 16290)
2005-03-29
03:10
[7d2d8489be] part of check-in [c41d55443c] Add the SQLITE_OMIT_TEMPDB compile time macro. (CVS 2427) (check-in: [c41d55443c] user: danielk1977 branch: trunk, size: 13529)
2005-01-21
11:55
[9a467351e2] part of check-in [9c4d0e13e8] Improve test coverage for minimum feature builds. (CVS 2254) (check-in: [9c4d0e13e8] user: danielk1977 branch: trunk, size: 13253)
2005-01-20
02:17
[47443316df] part of check-in [d267fb3ca3] Fix some test scripts so that they work with a minimal build configuration. (CVS 2241) (check-in: [d267fb3ca3] user: danielk1977 branch: trunk, size: 12897)
2005-01-11
16:54
[5920cc058d] part of check-in [3f46cd7767] Improved test coverage for vdbeaux.c. (CVS 2195) (check-in: [3f46cd7767] user: drh branch: trunk, size: 12861)
13:02
[810a1a2984] part of check-in [a6b4572207] Test cases to improve coverage of vdbe.c. (CVS 2193) (check-in: [a6b4572207] user: danielk1977 branch: trunk, size: 12826)
2004-08-20
18:34
[830d352574] part of check-in [e97c331362] Tcl interface transfers values directly between SQLite and Tcl_Objs, without at translation to strings. (CVS 1898) (check-in: [e97c331362] user: drh branch: trunk, size: 12723)
2004-07-18
21:14
[56b12001d4] part of check-in [223521c04e] Min() and max() ignore NULL values. Ticket #800. (CVS 1803) (check-in: [223521c04e] user: drh branch: version_2, size: 9995)
20:52
[d47ff9da6c] part of check-in [166234a2b6] min() ignores NULL values. Ticket #800. (CVS 1802) (check-in: [166234a2b6] user: drh branch: trunk, size: 12711)
2004-06-29
13:18
[7653394d85] part of check-in [15a084e9ea] Test cases intended to improve coverage of main.c. (CVS 1763) (check-in: [15a084e9ea] user: danielk1977 branch: trunk, size: 12677)
2004-06-24
00:20
[db369afc9e] part of check-in [0a26b91580] Apply (1679) to version 3. Ticket #777. (CVS 1680) (check-in: [0a26b91580] user: danielk1977 branch: trunk, size: 12423)
2004-06-23
21:16
[cf6434042b] part of check-in [78ced6e309] The MIN() aggregate function returns NULL if any element in the result was NULL. This makes MIN() consistent with ORDER BY which sorts NULL first. Ticket #777. (CVS 1679) (check-in: [78ced6e309] user: drh branch: version_2, size: 9953)
01:05
[95eba35f06] part of check-in [46107da7ed] Handle corrupt journal file headers correctly. (CVS 1674) (check-in: [46107da7ed] user: danielk1977 branch: trunk, size: 12297)
2004-06-19
17:33
[c97954ad23] part of check-in [fc3b3a8fe8] Make sure VdbeFunc entries are initialized before trying to destroy them. Also, unrelated comment changes in build.c. (CVS 1643) (check-in: [fc3b3a8fe8] user: drh branch: trunk, size: 12289)
00:16
[a680cac388] part of check-in [d705d051be] Change the name of the TCL command from "sqlite" to "sqlite3" so that both SQLite version 2 and SQLite version 3 can be used by Tcl at the same time. (CVS 1626) (check-in: [d705d051be] user: drh branch: trunk, size: 12292)
2004-06-17
05:36
[5fb6008f88] part of check-in [b9493c5fac] Use the faster LIKE function from sqlite v2. Add special user functions to test builds to test the auxdata APIs. (CVS 1610) (check-in: [b9493c5fac] user: danielk1977 branch: trunk, size: 12296)
2004-06-12
09:25
[a63cf7a16b] part of check-in [5903f53828] (1) Modifications to the user-function interface and (2) Internal changes to automatically created indices. (CVS 1575) (check-in: [5903f53828] user: danielk1977 branch: trunk, size: 10544)
2004-06-02
00:41
[9816fbed0a] part of check-in [b53640ed22] Remove the sqlite3_libencoding() api and the ISO8859 encoding option. (CVS 1523) (check-in: [b53640ed22] user: drh branch: trunk, size: 9700)
2004-05-27
14:23
[b6d87075ff] part of check-in [c85e5f1528] Enhance the C function used to test sqlite3_create_function() from Tcl. (CVS 1476) (check-in: [c85e5f1528] user: danielk1977 branch: trunk, size: 9830)
10:30
[0ef8b2ae7e] part of check-in [c9e3015faf] A few more bugfixes. Test cases pass now. (CVS 1472) (check-in: [c9e3015faf] user: danielk1977 branch: trunk, size: 9810)
2004-05-14
11:00
[e77f46af34] part of check-in [dbfe6e9316] Implement type affinity for table and index records (CVS 1375) (check-in: [dbfe6e9316] user: danielk1977 branch: trunk, size: 9830)
2002-11-04
19:32
[0005157790] part of check-in [7c8c0e7633] Add the sqlite_version() SQL function as a built-in. (CVS 777) (check-in: [7c8c0e7633] user: drh branch: trunk, size: 9823)
2002-08-13
23:02
[bed7ae7a34] part of check-in [310ac4fbaf] Make the distinction between text and numeric data. (CVS 710) (check-in: [310ac4fbaf] user: drh branch: trunk, size: 9682)
2002-07-01
00:31
[cae5f27e09] part of check-in [8924a7f5ba] Added additional tests. No new errors found. (CVS 653) (check-in: [8924a7f5ba] user: drh branch: trunk, size: 9682)
2002-06-29
02:20
[7e5500c9db] part of check-in [91c0db66c8] Add a few more tests and fix a few bugs that the tests uncovered. (CVS 652) (check-in: [91c0db66c8] user: drh branch: trunk, size: 8139)
2002-05-29
23:22
[628ab513b0] part of check-in [19ae12bef2] Built-in aggregate functions (MIN, SUM, AVG, etc) should ignore NULL entires. (CVS 597) (check-in: [19ae12bef2] user: drh branch: trunk, size: 7357)
2002-05-27
01:04
[1505ac9ebc] part of check-in [0e268d0c0f] Bug fixes and additional test cases for the distinct-NULL patch. (CVS 592) (check-in: [0e268d0c0f] user: drh branch: trunk, size: 7149)
2002-04-06
14:10
[d34e461f0a] part of check-in [6aca3f86bc] Added the last_insert_rowid() SQL function. (CVS 521) (check-in: [6aca3f86bc] user: drh branch: trunk, size: 7120)
2002-03-02
17:04
[4359344586] part of check-in [d5d3e79cc5] Subquery flattening is implemented and passes all regression tests. We still need to add addition tests to the suite to further exercise the flattener, however. (CVS 408) (check-in: [d5d3e79cc5] user: drh branch: trunk, size: 6993)
2002-02-28
03:04
[13572d84cb] part of check-in [b00cf110b1] The new function code passes regression tests. (CVS 403) (check-in: [b00cf110b1] user: drh branch: trunk, size: 5148)
2001-12-22
14:49
[51dbe3f8a4] part of check-in [29cab124b4] Bug fixing in the new integer primary key code. (CVS 334) (check-in: [29cab124b4] user: drh branch: trunk, size: 5102)
2001-10-20
12:30
[9012f7fc53] part of check-in [a835658e50] 2.0.7 (CVS 292) (check-in: [a835658e50] user: drh branch: trunk, size: 5091)
2001-10-13
02:59
[fb0f44de6d] part of check-in [75e90cf09b] 2.0.3 (CVS 287) (check-in: [75e90cf09b] user: drh branch: trunk, size: 4972)
2001-09-16
00:13
[dfee65686b] part of check-in [4e926efe2b] Disclaimed copyright. Preparing for release 2.0. (CVS 250) (check-in: [4e926efe2b] user: drh branch: trunk, size: 3805)
2001-04-06
16:13
[ac3def2a67] part of check-in [735d8b5c13] Check for miscompiled Tcl (CVS 204) (check-in: [735d8b5c13] user: drh branch: trunk, size: 4348)
2001-04-05
15:57
[11c415efe9] part of check-in [8390f6521a] i18n changes (CVS 201) (check-in: [8390f6521a] user: drh branch: trunk, size: 4345)
2000-08-28
16:21
Added: [02aed8845b] part of check-in [b8cec9b938] adding length() and substr() tests. fix shell.c bug (CVS 144) (check-in: [b8cec9b938] user: drh branch: trunk, size: 2921)