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) | |