aboutsummaryrefslogtreecommitdiff
path: root/test/func.test
Commit message (Collapse)AuthorAge
* Remove unnecessary "www." prefixes on domain names in URLs.drh2025-04-10
| | | FossilOrigin-Name: 20acd630b91609725794ce84f9eda01d5f3c898407f0948264830851d25ccaa6
* Fix additional integer overflow problems in the substr() function.drh2024-12-19
| | | FossilOrigin-Name: 472abb492f1d1553ae6bdf53cc64bebfe75423526335beab7eaff26cc495cd7d
* Fix possible integer oveflow in the second and third argument to substr().drh2024-12-18
| | | FossilOrigin-Name: b04b4006f38f83d36eaf43c4bace7d53866b02b45e0ddcf1704266fed3bfc11c
* Avoid 32-bit roundoff error on the second argument to round().drh2024-12-18
| | | | | [forum:/forumpost/170aeab92a|Forum post 170aeab92a]. FossilOrigin-Name: a9759fc78d6cb0df7c81f20c2c5c358729e571ebee50ee2b1441a15239d0b4b6
* Increase the maximum number of arguments on an SQL function to 1000 with thedrh2024-12-12
| | | | | capability to increase it further up to 32767 using a compile-time option. FossilOrigin-Name: e8d7d68ba0bb0bc2f948db5d9966990a5d23597fc3658b7cd0bc99d53c7353a9
* Remove a few more traces of long double from the code.drh2024-10-02
| | | FossilOrigin-Name: 11d6a89e4a25c3f884ff617036d239dc42522859400cd1f4674634f6c7adbb02
* Adjustments to the test cases for the previous check-in to make themdrh2024-03-19
| | | | | cross-platform Linux/Mac/Windows. Test chance only. No change to core code. FossilOrigin-Name: 0dddadbd5b217a48bb5c1b0568a03fbafb89dba98c577727bf4f79ff7e0ca849
* Fix another problem from [c63e26e705f5e967] involving infinities and thedrh2024-03-19
| | | | | | Kahan-Babushka-Neumaier summation algorithm. Problem reported by [forum:/forumpost/23b8688ef4|forum post 23b8688ef4]. FossilOrigin-Name: 45d272ef38d5ee6189f81369aefb8e3ac35868a67687012d93c84f2bbc42520a
* The quote() SQL function should convert +Inf into 9.0e+999 and -Inf intodrh2024-02-26
| | | | | -9.0e+999. See [forum:/forumpost/6675b25108|forum post 6675b25108]. FossilOrigin-Name: 85dd79a6edecfc8c6307c6d215998f76dab086aa14528ddc64eb9955501becfd
* Ensure that the replace() SQL function always returns a TEXT value evendrh2024-01-20
| | | | | | | when its first argument is numeric and its second argument is an empty string. Fix for the issue reported by [forum:/forumpost/3776b48e71|forum post 3776b48e71]. FossilOrigin-Name: 01868ebcd25fadb2034da234c0636e82d07c5abc902ef66493cadfc988e74d7b
* Add string_agg(X,Y) as an alias for group_concat(X,Y), for compatibilitydrh2023-10-20
| | | | | with SQLServer and PG. FossilOrigin-Name: b91c19bf2680f60d7826ab5d9e7902e2dc2a55d847bbea565a6489d47f2cc8f1
* Fix the AVG() and TOTAL() functions (after the SUM() fix of [77d3dcd283595c52])drh2023-08-30
| | | | | | | so that they work with infinitites. Fixes a bug introduced by check-in. [c63e26e705f5e967]. Bug reported by [forum:/forumpost/8960fb40cc|forum post 8960fb40cc]. FossilOrigin-Name: 6df6f17ccb404c648076ccff4200d0eb5437f0e3e82424bf3da5ea682b107bb4
* Fix an issue with infinity handling by the SUM() function that goes backdrh2023-08-28
| | | | | | | to the extended-precision SUM() enhancement of [check-in c63e26e705f5e967]. Problem reported by [forum:/forumpost/1c06ddcacc86032a|forum post 1c06ddcacc86032a]. FossilOrigin-Name: 77d3dcd283595c52f24c07fc59ba60c9133b71c440cf3f799cf48c907c6fae3e
* Fix octet_length() test cases so that they work when the database encodingdrh2023-07-06
| | | | | is utf16. FossilOrigin-Name: ad2e39626e6115fd322ef9495ae3bcd91343d7131a725f1bf24211a51a21dcc2
* Completely unwind the enhanced precision sum() from [a915f15a916af698] sodrh2023-06-30
| | | | | as not to offend UBSAN and OSS-Fuzz. FossilOrigin-Name: 85be05b66ef975f02a3e7b2984bcab97d9280c7f3b6ee1e16718de549f240d46
* Make the sum() function less precise and slower in order to avoiddrh2023-06-30
| | | | | harmless signed integer overflow UBSAN warnings from OSS-Fuzz. FossilOrigin-Name: 1be0646a2c352dbf03d2af87fd48b6f9edfd68666790ac6863144ac95f3e0621
* Simple test cases for the enhanced SUM() function.drh2023-06-26
| | | FossilOrigin-Name: c66ef2440e4e6c7aa17b50e5a29e543713ccab69aa0a415bac29b35b6116504a
* basic test cases for octet_length().drh2023-06-22
| | | FossilOrigin-Name: 034a5fe2a0cfe085271385da1d281515b04b311e08962519d03ad8ad156fb4bd
* Fix test cases so that they all still work even with -DSQLITE_DQS=0.drh2022-01-16
| | | FossilOrigin-Name: 4883776669ee2f2310ea82b0d6df4d008eebaa7cb252102539cf21a635402ebb
* Add new binary operators "->" and "->>" to the parser that evaluate todrh2022-01-07
| | | | | | 2-argument SQL functions by the same name. Add new "->" and "->>" functions to the JSON extension that are aliases for json_extract(). FossilOrigin-Name: c4e4e3a3fc5da0381ccb7930706e57d7831d87f9c63bafe49ae64117701e1cfe
* Change things so that SQLITE_OMIT_VIRTUALTABLE implies SQLITE_OMIT_ALTER_TABLE.dan2021-10-01
| | | FossilOrigin-Name: 2f7c946c5f25a858167f5193ca06e53310394c8cff15426ab8a1327a1ec835fd
* Prevent an infinite loop in the trim() SQL function if the second argumentdrh2021-06-15
| | | | | is a carefully malformed UTF8 string. FossilOrigin-Name: 829343c26ed7b87fafc70de3369625209bad91e79bb7ca2946d5c8d61cc1c3c4
* Rename sqlite3ExprCodeAtInit() to sqlite3ExprCodeRunJustOnce().drh2020-03-11
| | | | | Other changes to make the new code cleaner. Test cases added. FossilOrigin-Name: d7f18489978fdbbe3ab317485518cac91a75416ccef55898301afdd76d3b415b
* Fix to the register validity tracking logic in debug builds. No impactdrh2020-01-10
| | | | | on release builds. FossilOrigin-Name: 0a500da6aa659a8e73206e6d22ddbf2da5e4f1d1d551eeb66433163a3e13109d
* Check for whether or not it is safe to use non-innocuous functions as thedrh2020-01-08
| | | | | function is being coded, not when its name is resolved. FossilOrigin-Name: 1da802d54b689a462e1fe899c6ffa08ef14d34f36728b14b055b5a76b1edc274
* Modify three test cases so that they work even with unusual versions of thedrh2019-11-15
| | | | | library printf(). FossilOrigin-Name: 8f4a3750b7d272daf96831655ffee80d457875ee121fc4537008046b9a00d0e7
* Provide the SQLITE_DIRECTONLY flag for app-defined functions that prohibitsdrh2019-08-15
| | | | | the use of those functions within triggers or views. FossilOrigin-Name: fc745845d8d76adc165575e2192f4176e3c28e614c72571d56f4011560499fe1
* Fix the round() SQL function so that it handles infinities correctly.drh2019-05-10
| | | FossilOrigin-Name: db9acef14d49212108c8082cc15a9b9b4a56b8afe4fe1104ddf62783739c1fbe
* Initial implementation of the sqlite3_value_frombind() interface.drh2019-03-29
| | | FossilOrigin-Name: 98da62dfdacc6b3c490c387d1f8a74cc5daa978776967e264ad4800c380b0ddf
* Improve the performance of the built-in REPLACE() function in cases wheredrh2018-02-09
| | | | | | | 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. FossilOrigin-Name: fab2c2b07b5d3cd851db3e6f5c8a44155e32b0df22905ea33412b153b825a928
* Make sure the group_concat() function returns an empty string, not a NULL,drh2014-05-07
| | | | | if it has at least one input row. Fix for ticket [55746f9e65f8587]. FossilOrigin-Name: 0deac8737545a020d344be96fff16660a7977ab8
* Only use the direct-overflow-read optimization if all data from the overflow ↵dan2014-03-20
| | | | | page in question is being read. FossilOrigin-Name: d8e1f75ddf10f3c0b21acd5455f90fdcea54a948
* Fix a bug causing "SELECT char()" to return SQLITE_NOMEM.dan2014-03-08
| | | FossilOrigin-Name: ba39df9d4f7ffc6475ae0dc794f7d3f58c486de8
* Improved comments on the OP_Column changes. Optimize out loading of overflowdrh2013-11-20
| | | | | pages for content with zero length. Add test cases for the latter. FossilOrigin-Name: 0e05679db7aa302a49e087a81f85203844b98cbe
* Additional test cases and requirements marks for the unlikely(),drh2013-10-11
| | | | | likelihood() and instr() functions. FossilOrigin-Name: 5f01cd36ee8678a07b79f9e01855daffb6bb8c43
* Fixes to test numbering.mistachkin2013-07-19
| | | FossilOrigin-Name: f755b4b21c885f3e897c2a79fc7ac1220210e653
* Ensure that all auxiliary data registered by calls to sqlite3_set_auxdata() ↵dan2013-07-18
| | | | | is destroyed when the VM is halted. Partial fix for [406d3b2ef9]. FossilOrigin-Name: 71effa59c98d167e6e4b269e59ad5f468e664ac1
* Refactoring the mmap interface. The controlling pragma is now "mmap_size"drh2013-04-15
| | | | | | | | | | | | | | | | instead of "mmap_limit". Also change SQLITE_CONFIG_MMAP_LIMIT and SQLITE_FCNTL_MMAP_LIMIT to SQLITE_CONFIG_MMAP_SIZE and SQLITE_FCNTL_MMAP_SIZE, respecctively. The default mmap_size is now always 0, meaning that memory mapped I/O is off by default. There is a new compile-time option SQLITE_MAX_MMAP_SIZE that determines a hard upper bound on the mmap_size. Setting SQLITE_MAX_MMAP_SIZE to zero disables the memory-mapped I/O logic and causes it to be omitted from the build. An extra argument is added to SQLITE_CONFIG_MMAP_SIZE that can optionally lower the SQLITE_MAX_MMAP_SIZE at start-time. The SQLITE_MAX_MMAP_SIZE is zero for platforms where we know that it does not work, meaning that it cannot be turned on by mistake on those platforms. FossilOrigin-Name: ea1404a10abd7f68e1f8e0708c8a3199d1f79665
* Previous check-in accidently left mmap turned off by default. This checkindrh2013-03-26
| | | | | | fixes that. Unfortunately, shared.test is now segfaulting. All other veryquick tests appear to work, however. FossilOrigin-Name: a850c7319c20b5757983443df05cf2aa4250053b
* Add the sqlite3_io_methods.xMremap() method to the VFS interface. Also ↵dan2013-03-19
| | | | | "PRAGMA mmap_size". FossilOrigin-Name: 6183f1bd86ceed76d22d9762f3d7eb33262c62d1
* Fix the char() function so that it works even if SQLITE_OMIT_UTF16 is defined.drh2013-03-07
| | | FossilOrigin-Name: af542c82e8e7f0415530b639fa397429c5f377f6
* Skip tests that require UTF-16 support when compiled with SQLITE_OMIT_UTF16.mistachkin2013-03-07
| | | FossilOrigin-Name: e39391422e748407d74853d3de297dc1ea6b991d
* Prevent Tcl file encoding issues in the tests for the unicode() and char() ↵mistachkin2013-02-26
| | | | | functions. FossilOrigin-Name: d2e7dfca5a92074a7984032deb6a4e3681389c72
* Add new SQL functions unicode() and char().drh2013-02-25
|\ | | | | FossilOrigin-Name: be2493905281e12c7f4c146ab17c8872e52da350
| * Two new SQL functions: unicode() and char().drh2013-02-22
|/ | | FossilOrigin-Name: 209b21085b9767f10f6ffb7c7cac756fcb74ded5
* Fix an incorrect testcase for the round() function. All tests are passingdrh2012-06-19
| | | | | now, including new real->text->real round-trip tests. FossilOrigin-Name: 963eb24f737f184d5fcdcd92ebf90466f818cfd8
* Test cases for length() of a large blob in an aggregate query.drh2012-03-28
| | | FossilOrigin-Name: d095fa4bfabd765c8e935ed227a334161097dd34
* Evaluate typeof(X) and length(Y) where X is any column and Y is a blob columndrh2012-03-28
| | | | | without actually loading X and Y from disk. FossilOrigin-Name: b899dbeb60752843287e2c6ad3577e1d00f0d587
* More rounding tests.shaneh2010-02-17
| | | FossilOrigin-Name: 3863638b8cd8d41cf4abf8b0d618892de845e91f
* Added additional rounding tests.shaneh2010-02-16
| | | FossilOrigin-Name: b8ee76bc1fd355110149bd9135dd31a5724c2ac6
generated by cgit v1.2.3 (git 2.25.1) at 2025-05-19 18:42:20 +0000