aboutsummaryrefslogtreecommitdiff
path: root/src/func.c
Commit message (Collapse)AuthorAge
...
* Start of experimental implementation of SQL window functions. Does not yetdan2018-05-16
| | | | | work. FossilOrigin-Name: 3781e520854808fe02ad3fe77dd11fc917448c58ff1fd79123289dd91937decd
* Make the internal dynamic string interface available to extensions usingdrh2018-05-09
| | | | | | | the new sqlite3_str object and its associated methods. This is mostly just a renaming of internal objects and methods to use external names, through there are a few small wrapper functions. FossilOrigin-Name: 87f261f0cb800b06ad786f6df16f2c4dddd0d93dfdcc77b4a4eaa22920b56bf1
* Fix misplaced testcase() macros from the previous check-in.drh2018-02-10
| | | FossilOrigin-Name: 3aed949a18a251c5795f21f0385c205a127502b7e9cf06bc7f4c763951cd7984
* 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
* Remove an unreachable branch from sqlite3SkipAccumulatorLoad().drh2018-01-23
| | | FossilOrigin-Name: 8b9c8eab60b692e45c55a718d76b70e63040416040696907463692cbf83fb0c5
* Slightly faster implementation of the length() SQL function.drh2018-01-23
| | | FossilOrigin-Name: 9a4199aedb039141a50a68943ef863d7df9637ada318793cce6c12b9d39bcdc5
* Slightly faster function dispatch in the virtual machine by avoidingdrh2018-01-23
| | | | | | unnecessary reinitialization of variables that are already correctly initialized. FossilOrigin-Name: edd4e6876cc08ab907bb21f075380de946562d4c56a04923760848b4b11536ac
* Remove the snarky "_supported_" qualifier from the name of thedrh2018-01-04
| | | | | sqlite_offset() SQL function. FossilOrigin-Name: a6eee0fcd89d3958f8720ebdb5f0a8558b4795d747128091dae283eb81c4f74f
* Change the function name to sqlite_unsupported_offset(X). Only enable thedrh2017-12-29
| | | | | | function if compiled with -DSQLITE_ENABLE_OFFSET_SQL_FUNC. The makefiles add that definition to shell builds. FossilOrigin-Name: 7a7f826e324b1a2c332e2f1d0740fd0babffcaca6275a798572f02ad367b99ab
* Add an experimental location(X) SQL function that attempt to return thedrh2017-12-16
| | | | | | | location of the payload within the database for the record that contains column X. location(X) returns NULL if X is not an ordinary table column or if SQLite cannot figure out the location because it is using a covering index. FossilOrigin-Name: 51be9558164301c5dd4df23ab8b3e67de0b522f8d36f79f3d84d45d3dc2a83a4
* Improve the performance of the LIKE operator by using strcspn() to aiddrh2017-10-30
| | | | | wildcard matching. FossilOrigin-Name: 37284d4e8f501a37c582aa899419a3dfe0932e2a8e2ef2fdf59addd1d3cdacb4
* Fix a few over-length source code lines. No functional changes.drh2017-08-25
| | | FossilOrigin-Name: 1783c54ce9dcb4b2c4f2a66f6d3315e646b71b54a8899fc32a7bf0f935a21f7f
* Enhance the like optimization so that it works with an ESCAPE clause.drh2017-07-27
| | | FossilOrigin-Name: f5d330f495d07a704e115595bbdf5422ddb68fd8191114c5a12c9c873d983f7c
* Add requirements marks for some of the new features in the 3.20 release.drh2017-07-14
| | | FossilOrigin-Name: 264238671379306b14d62a6ddaefd2a20acd34ca77276b6ce872253160fe0146
* More compact implementation of the typeof() SQL function.drh2017-07-06
| | | FossilOrigin-Name: efb4aab0caa4145732a5438cc2a193bc12c455b4007220564d240e75900ea8ad
* Simplified OOM detection in the instr() SQL function.drh2017-03-16
| | | FossilOrigin-Name: 6d85eb5736781b43aa674d9544c7523b849b4e634f371702f8764b33e22e1e9f
* Fix a crash that could follow an OOM condition in the instr() SQL function.dan2017-03-16
| | | FossilOrigin-Name: 6e59e903e4e956617bddef0b94e5cae02d724ac8145940b57ab5b0f628759736
* Put the affinity() function implementation inside of #ifdef SQLITE_DEBUG.drh2017-01-03
| | | FossilOrigin-Name: f778f58ae4ea3e16f51b94591a2c1e563dcb0cde
* Merge all the latest changes from trunk.drh2017-01-03
|\ | | | | FossilOrigin-Name: c27cd8a8127b81d3176f6a5b9915c9b3c69574fb
| * Fix a crash that could occur following an OOM in the group_concat() functiondan2016-12-30
| | | | | | | | | | if the second argument is an SQLITE_BLOB value. FossilOrigin-Name: 14d855d2b2b5b3485e0673d11405db7266b34c6d
| * Strengthen the defense against OOM in the instr() SQL function.drh2016-12-30
| | | | | | FossilOrigin-Name: a0971e713682a73d8c7c20511db256c20d2f6388
| * Avoid passing NULL pointers to memcmp() or memcpy(), even when thedan2016-12-30
| | | | | | | | | | "number-of-bytes" argument is passed 0. FossilOrigin-Name: 56ff72ab44288296efc99a608f7edc4346366a50
* | Add the built-in affinity() SQL function.drh2016-12-26
|/ | | FossilOrigin-Name: 57e40e1cb1bcd3dd8473d2fdeecc9c7ff3d6192b
* Faster version of patternCompare() that uses new return values rather thandrh2016-12-01
| | | | | | an extra parameter to communicate wildcard information back up to parent searches. FossilOrigin-Name: a1e2b6ce3af690ae91bda3d056357205c4018da7
* Modify the patternCompare() function (used for GLOB, LIKE) to better handledan2016-12-01
| | | | | patterns containing multiple wildcard characters ("*", "%"). FossilOrigin-Name: c5e5614d98a752738c081fecdd1e349a1a92b0e5
* Avoid a crash that can occur after an obscure OOM in the built-in INSTR()dan2016-11-04
| | | | | function. FossilOrigin-Name: b86b79c442a58d10aa005ba4f34095375a88d242
* Add the experimental SQLITE_ENABLE_UNKNOWN_SQL_FUNCTION compile-time option.drh2016-08-04
| | | | | | | | | When enabled, the "unknown function" error is suppressed for EXPLAIN and a no-op function named "unknown()" is substituted. This facilitiates using the command-line shell to analyze queries from applications that contain many application-defined functions that are not normally available to the shell. FossilOrigin-Name: b7f30a9ff20d580fdaecdcf2b644d09ad6c2575e
* Small performance improvement in the LIKE function.drh2016-06-06
| | | FossilOrigin-Name: 5fb0c35459cf7a8662bf8cd84ac345f6fafda6cc
* Test cases for SQLITE_DBCONFIG_ENABLE_LOAD_EXTENSION.drh2016-04-21
| | | FossilOrigin-Name: debafa5efd37ac60e030d0963ce8e7c4f51a0f10
* Revert sqlite3_enable_load_extension() to its original long-standing behavior.drh2016-04-21
| | | | | | Add SQLITE_DBCONFIG_ENABLE_LOAD_EXTENSION which will enable only the C-API and leave the SQL function disabled. FossilOrigin-Name: b2ae5bfa32e608625bd177907596df3dbc2212e1
* <b>API Change:</b> Modify sqlite3_enable_load_extension() so that it onlydrh2016-04-20
| | | | | | | enables/disables the load_extension() SQL function, and leaves the C-APIs enabled at all times. In this way, applications can enable extension loading for the C interface without having to expose that capability to the SQL. FossilOrigin-Name: edb454e45ae008e051e2f48d704a855b0c3e4be9
* Improvements to the application-defined function mechanism so that it isdrh2016-02-15
| | | | | | more compact and runs faster, especially when the application defines thousands of new SQL functions. FossilOrigin-Name: 3201fbcc5105d23132e6b8b7ac825e66af4f8a39
* Improvements to the way that OOM errors are processed.drh2016-02-05
| | | FossilOrigin-Name: c3ef03478a5788c855b3aef385d43ae7f494f440
* Simplification and size reduction to the printf logic. Remove the bFlagsdrh2016-01-30
| | | | | | parameter from sqlite3VXPrintf() and sqlite3XPrintf(). Use sqlite3XPrintf() instead of sqlite3_snprintf() for rendering P4 values in EXPLAIN output. FossilOrigin-Name: 0bdb41c45aa1cc8e5c136aaa6605d54b401483bd
* Case folding in the LIKE operator should look at all bits of the character,drh2016-01-20
| | | | | | not just the lower 8 bits. Fix for ticket [80369eddd5c94]. This is a back-out of check-in [0a99a8c4facf] with a testcase added. FossilOrigin-Name: 204432ee72fda8e82d244c4aa18de7ec4811b8e1
* Slightly smaller and faster LIKE/GLOB comparison implementation.drh2016-01-11
| | | FossilOrigin-Name: 5dddcc78eec5bcd0c7e8fe1b70875ce775488f0c
* Remove unnecessary tests from the LIKE pattern matcher. Slightly faster anddrh2015-12-30
| | | | | slightly smaller, and it should also now works with EBCDIC. FossilOrigin-Name: 0a99a8c4facf65ec67d8d86108c9a3f723f7cbd6
* Add the SQLITE_LIKE_DOESNT_MATCH_BLOBS compile-time option.drh2015-12-01
| | | FossilOrigin-Name: 9e1d6d4c391ff90077f0d1cdeb567969fee9f747
* Add the sqlite3_strlike() interface, which might be useful for implementingdrh2015-11-24
| | | | | LIKE operators on virtual tables. FossilOrigin-Name: e70ec71d6883f2f8fc75301ff985bccb5aa06127
* Not only date/time functions, but also functions like sqlite_version() anddrh2015-08-31
| | | | | changes() need to be prohibited from use inside of indexes. FossilOrigin-Name: 487131303980f15dd5e1b6695b4f29efda229eb8
* Fix compiler warnings. Get the new sqlite3_result_zeroblob64() workingdrh2015-07-24
| | | | | on loadable extensions. FossilOrigin-Name: f8991e6f726485301c80d2dbb05e7d5c0d283b5d
* Add the sqlite3_result_zeroblob64() API. Use it in the SQL zeroblob() function.dan2015-07-24
| | | FossilOrigin-Name: c6445b9fb4d7d1a8479436d7d183bad754a01615
* More robust handling of zeroblob() with oversized arguments. Fix fuzzcheckdrh2015-07-24
| | | | | so that it can be run with limited heap memory. FossilOrigin-Name: 4e3e516a42059c97f42a7eb59bdf5cded0ff843a
* Performance optimization and comment fixes for the LIKE and GLOB operators.drh2015-06-17
| | | FossilOrigin-Name: c89d772628564a808173f6f73bc1798ec714276b
* Cleanup of the sqlite3StrAccumInit() function. No functionality changes.drh2015-05-02
| | | FossilOrigin-Name: 7952c32268aa650d9ee946d5bfe190f712e3bbe6
* Use sqlite3_malloc64() in place of sqlite3_malloc() internally.drh2015-04-29
| | | FossilOrigin-Name: 48f553b05c05373c0af4b9c3a542979db3a2ee19
* The valueFromFunction() routine is better able to handle OOM errors.drh2015-03-12
| | | | | Omit unreachable branches. FossilOrigin-Name: 8fb6bd9be59d6b04e922d7b246aaefd4851539b6
* Refactor some jump opcodes in the VDBE. Add JumpZeroIncr and DecrJumpZero.drh2015-03-07
| | | | | Fix the LIKE optimization to work with DESC sort order. FossilOrigin-Name: 26cb5145bf52f8c3fffa8c69b6c24aee4d974883
* First small steps toward brining trunk and apple-osx closer together.drh2015-02-19
| | | FossilOrigin-Name: 28284ccc0d7301503f6d2d7bee9093738d52e331
* Fix a typo in a requirements mark on the abs() SQL function.drh2014-11-20
| | | FossilOrigin-Name: b1e6c02f8b9a2afaa12ac15a33e3f698c3be27d6