aboutsummaryrefslogtreecommitdiff
path: root/src/func.c
Commit message (Collapse)AuthorAge
...
* Add the load_extension() SQL function. (CVS 3269)drh2006-06-17
| | | FossilOrigin-Name: e08e2ddafe909ae6073ec56dfa3fdca23e36bf2e
* The (unsupported) soundex() function returns '?000' when given a NULL.drh2006-06-13
| | | | | Ticket #1845. (CVS 3233) FossilOrigin-Name: 9372481f233e1563b5ee137535f0fbf19851ffad
* The optimizer recognizes MATCH operators and allows virtual-tables to makedrh2006-06-13
| | | | | use of them. (CVS 3232) FossilOrigin-Name: 136bed496b89943522310ec511199b78198d0844
* Fix comments on the implementation of the SUM() function. (CVS 3183)drh2006-05-11
| | | FossilOrigin-Name: a8909f3e5fc67ac1ba7d1abd7fb0f4004fec5984
* Avoid the use of atof(). Ticket #1756. (CVS 3168)drh2006-04-07
| | | FossilOrigin-Name: 76aef93c3e113b0077f534a437a339be2b15ca3d
* Fix some compiler warnings. (CVS 3140)drh2006-03-16
| | | FossilOrigin-Name: 6c5175bc0f98e4ce715b099394f3fdc878ed82e8
* Change the ROUND() function to return a REAL value instead of TEXT.drh2006-03-02
| | | | | Ticket #1699. (CVS 3116) FossilOrigin-Name: 9dbadfb2111f7d7f971e1832db3992ed5851d8b1
* Make sure the random() function always returns a value that can be passeddrh2006-02-23
| | | | | to abs(). (CVS 3109) FossilOrigin-Name: 5d2e7ea01989fc9ba2c79d192760bc29f8cab463
* Detect integer overflow in the abs() function. The random() functiondrh2006-02-23
| | | | | | now provides 64 bits of randomness instead of just 32. Fix bugs in testing logic of test4.c. (CVS 3108) FossilOrigin-Name: 942c509595a2a300e798e6b048ad7fc3bc54af43
* I give up. SUM() now throws an error on integer overflow. Those of usdrh2006-02-11
| | | | | | who think this is goofy can use TOTAL() instead. Tickets #1664, #1669, #1670, #1674. (CVS 3084) FossilOrigin-Name: 1c3e6002cd9fd5d30e197448c4d98cdd59163cac
* SUM never gives an error. An integer result is returned for exact resultsdrh2006-02-09
| | | | | | and a floating point result is returned for approximate results. Tickets #1664, #1669, and #1670. (CVS 3066) FossilOrigin-Name: 9e04f8fdf1ec0dc36effb55c05d075b3b4777fef
* Deprecate the sqlite3_aggregate_count() API. Make sure all aggregate countersdrh2006-02-09
| | | | | are 64 bits. Remove unused StdDev structure from func.c. Ticket #1669. (CVS 3065) FossilOrigin-Name: 44bd7ba432123ec77904b862d11521f4ab96d2cf
* Integer overflow in SUM causes an exception. Ticket #1669. (CVS 3064)drh2006-02-09
| | | FossilOrigin-Name: c72b946198128cbceb12dffbdf4706d9fda0fd72
* Avoid overflowing the 48-bit mantissa of a floating point number whendrh2006-02-09
| | | | | summing large integers in the SUM() function. Ticket #1664. (CVS 3061) FossilOrigin-Name: a9169e879de5d5e4192d1681bc3e119fb83e739c
* Various fixes that allow the malloc() failure tests to pass again. (CVS 2963)danielk19772006-01-17
| | | FossilOrigin-Name: 0505405fb9ae1068b7976718efbf2aabd07592d4
* Add support for the TOTAL() aggregate function - works like SUM() exceptdrh2006-01-12
| | | | | that it returns 0 instead of NULL when presented with an empty list. (CVS 2930) FossilOrigin-Name: a7f528ff3446d50b280fb0b85063879e3ac5751a
* Fix some errors to do with attached databases and text encodings in ↵danielk19772006-01-09
| | | | | shared-cache mode. (CVS 2895) FossilOrigin-Name: 3e75d3d5efebc0dfff1adfc13d85e85ec39db3eb
* Changes so that SQLITE_OMIT_PARSER and SQLITE_OMIT_DISKIO work. (CVS 2878)drh2006-01-06
| | | FossilOrigin-Name: 9d71b7deaffdd7eb9ddad1f03df3e4c51c2cbd98
* Clean up annoying (and pointless) compiler warnings about differing ↵drh2005-12-09
| | | | | signedness. (CVS 2810) FossilOrigin-Name: 83a59151559d9496d4f546e03e65087ea974717d
* Modify ATTACH and DETACH to execute at runtime instead of compile time. (CVS ↵danielk19772005-12-06
| | | | | 2803) FossilOrigin-Name: 5e04ec694add7a8331e3d6fbdfcaed51349ae7bc
* Attempt to fix the SQLite core so that no floating point operations are useddrh2005-10-13
| | | | | | | anywhere if SQLITE_OMIT_FLOATING_POINT is defined at compile-time. This is useful to people who use SQLite on embedded processors that lack floating point support. (CVS 2749) FossilOrigin-Name: a0bdb584680ce6400d9e8c57db9d91197cc7b776
* SUM returns NULL when it has no inputs. Ticket #1413. (CVS 2678)drh2005-09-08
| | | FossilOrigin-Name: 6281859425d39c11d82875301fefafad1f08416d
* A SUM() of all NULLs returns NULL. A SUM() of nothing return 0.drh2005-09-08
| | | | | | A SUM() of a mixture of NULLs and numbers returns the sum of the numbers. Ticket #1413. (CVS 2677) FossilOrigin-Name: 2e6230edfd651b40481ebad8aa01a22ac92ce80c
* The SUM() aggregate function returns an integer result if all inputs aredrh2005-09-08
| | | | | | integers. Any single non-integer input causes the result to be a floating point value. (CVS 2669) FossilOrigin-Name: 21adf4bd99e732650a1e8e9a1cc954126983a654
* Cleanup the processing of MEM_Agg elements. (CVS 2660)drh2005-09-06
| | | FossilOrigin-Name: 7ecf3654aa9a275a4cf0c3ec5f63a8c1e0a11fc9
* The LIKE optimization does the right thing when collating sequences are drh2005-08-28
| | | | | | present. LIKE expressions where the left-hand side has COLLATE NOCASE are optimized in the default case. (CVS 2637) FossilOrigin-Name: ef84ff795c85e9d28f1cac84ff42d8d4ef84cfc4
* Fix comment in vdbeapi.c. Remove unused structure definition from func.c. ↵drh2005-08-27
| | | | | (CVS 2629) FossilOrigin-Name: 51a381345db45967567dd0a18905d352bf1081e0
* The case_sensitive_like pragma added.drh2005-08-14
| | | | | Test cases added for the LIKE optimization. (CVS 2592) FossilOrigin-Name: 72ee21c05e618b6f46f5460f8c85779c72fe32d7
* Make the round() function work correctly on numbers with very large exponents.drh2005-08-13
| | | | | Ticket #1340. (CVS 2585) FossilOrigin-Name: 4f47c3c884e38b810450b6127ab33c7b86e6743c
* Use the internal sqlite3_snprintf function instead of sprintf to avoiddrh2005-07-09
| | | | | cross-platform incompatibilities. Ticket #1316. (CVS 2545) FossilOrigin-Name: 431999da7bf0079e0d514483b3bfd9f8471cba7d
* Add the SQLITE_CASE_SENSITIVE_LIKE compile-time option. (CVS 2539)drh2005-07-08
| | | FossilOrigin-Name: b72bff81f9937378417a0af0610d8558279b67a7
* Remove the blob(), text() and numeric() functions added in (2524) and drh2005-06-25
| | | | | | replace them with the standard CAST operator. Ticket #1287. (CVS 2527) FossilOrigin-Name: 17631785f9ee8ab280c82677eb53886912e085bc
* Add built-in functions numeric(), text(), and blob() that coerce types. drh2005-06-22
| | | | | Ticket #1287. (CVS 2524) FossilOrigin-Name: affb0fa2e8c5ff497838ba3c2994cdb1f6f50c68
* Move a few things around to make building without the parser easier. (CVS 2479)danielk19772005-05-24
| | | FossilOrigin-Name: 5fadb464eb77b4b998d8555f83401769960ea904
* Add hook to register SSE user-functions. (CVS 2471)danielk19772005-05-22
| | | FossilOrigin-Name: 20bd303e8c6f7e69ba82ce1dc3041ea4e02d55cf
* Move the special built-in SQL functions used by ALTER TABLE out of func.cdrh2005-02-15
| | | | | and into alter.c. (CVS 2343) FossilOrigin-Name: dbd11a0c581b447bb2f220a1a185d9fd36933ee3
* Split the logic for the ALTER TABLE command off into a separate sourcedrh2005-02-15
| | | | | code file. (CVS 2342) FossilOrigin-Name: 90d6573c2631fac92b9e572e9e21698ae2480c9d
* Document SQLITE_DEFAULT_CACHE_SIZE and SQLITE_DEFAULT_TEMP_CACHE_SIZE ↵danielk19772005-02-09
| | | | | macros. (CVS 2320) FossilOrigin-Name: ddcea6f8891b02e64f96591af161feb55c00a72c
* Make sure the #include of "sqliteInt.h" always comes first in C source ↵drh2005-01-28
| | | | | files. (CVS 2284) FossilOrigin-Name: 522c094f799220468780acb77731edb715bf5e3c
* Test cases to improve coverage of vdbe.c. (CVS 2193)danielk19772005-01-11
| | | FossilOrigin-Name: a6b45722071bde543c4ea28a432339d8708a5cac
* Fix bugs in ALTER TABLE related to (a) whitespace in table defn, (b) temp ↵danielk19772004-11-19
| | | | | triggers. (CVS 2112) FossilOrigin-Name: 1fd8e835a3656799c23f4ef6ea1311fecf5a15cb
* Handle triggers correctly in ALTER TABLE. (CVS 2111)danielk19772004-11-18
| | | FossilOrigin-Name: c61b7de107cea76b561d0d6cd90c752b62c5df95
* Speed improvement on the LIKE command. (CVS 2110)drh2004-11-18
| | | FossilOrigin-Name: 85d56beb7494ce63e70ab1ffc3797c2ee4c36749
* Add the ESCAPE clause to the LIKE operator. Not fully tested yet. (CVS 2107)danielk19772004-11-17
| | | FossilOrigin-Name: 49268c2b7a84c4c618214dac8bef0f541440fe6b
* The SQLITE_OMIT_UTF16 macro now removes lots of code and all tests still ↵drh2004-11-14
| | | | | pass. (CVS 2100) FossilOrigin-Name: 98c7a55478f7c465b219edc1a33eee222586fd65
* Add the "ALTER TABLE xxx RENAME TO yyy" command. (CVS 2092)danielk19772004-11-12
| | | FossilOrigin-Name: a1b2cc63e604785bd51e358ff72c485d858752e3
* Convert many constants to have type "const". (CVS 2006)drh2004-10-06
| | | FossilOrigin-Name: d790c84c5a889928d07f5394fffef0cbb8d5f214
* Fix an uninitialized variable bug in nullif(). Ticket #898. (CVS 1957)drh2004-09-13
| | | FossilOrigin-Name: ee335b501cf45727929aac12c0b74547dd54729e
* Fix a naming conflict between sqlite versions 2 and 3. An open sqlite3drh2004-09-06
| | | | | | connection now *must* be called "sqlite3". You cannot call it "sqlite". This might break existing code. (CVS 1941) FossilOrigin-Name: 3ddf5a9d1c480a2e3aa32685879063b11afddbe1
* Address some minor 32/64 bit issues. (CVS 1932)drh2004-09-02
| | | FossilOrigin-Name: 6c9be972c1c289b657ba87db8db08fceb89b0171
generated by cgit v1.2.3 (git 2.25.1) at 2025-07-20 21:50:15 +0000