aboutsummaryrefslogtreecommitdiff
path: root/src/func.c
Commit message (Collapse)AuthorAge
...
* Complete the initialization of the loadable extension thunk table. Alsodrh2013-03-01
| | | | | fix other (harmless) compiler warnings. FossilOrigin-Name: 780d06c5e54590f677f993fa9c313989c2eab8c7
* Fix the handling of UTF16 surrogate pairs in the char() function.drh2013-03-01
| | | FossilOrigin-Name: ff67d87894eeb0036374235c5723e267536909f9
* Remove extra use of the sqlite3_value_int64() function.mistachkin2013-02-26
| | | FossilOrigin-Name: 6d7973524a7d3bf3158fdac58975945da7f51740
* Two new SQL functions: unicode() and char().drh2013-02-22
| | | FossilOrigin-Name: 209b21085b9767f10f6ffb7c7cac756fcb74ded5
* Fix a harmless compiler warning.drh2012-12-04
| | | FossilOrigin-Name: 12693deba9b8a47ad02ca4e32d5fba6006b0401c
* Implementation of the INSTR() SQL function, as found in SQL Server, MySQL,drh2012-10-25
| | | | | and Oracle. FossilOrigin-Name: 49ccae964f3a8ae5aab87f56503121e09424545f
* Remove an unnecessary parameter from sqlite3Utf8Read() resulting in a slightdrh2012-09-17
| | | | | performance increase. FossilOrigin-Name: 8b962c94a2f829f71efdd0ca770469b02feea3e1
* Remove the stale implementation of the ifnull and coalesce functions - codedrh2012-09-10
| | | | | that has been commented out for ages. No functional changes. FossilOrigin-Name: c2ad691174b8af2e8b158d8840cfc93f75d7db71
* Move variable declaration to fix compilation with MSVC.mistachkin2012-06-19
| | | FossilOrigin-Name: d45f7a013f05fe7603d5e6d02df0e6bab2c7ffd8
* Improved accuracy on text-to-real and real-to-text conversions. Mostdrh2012-06-19
| | | | | | conversions now round-trip correctly. Still need to fix some corner cases. FossilOrigin-Name: 8ecffca900cd6a8922001fd458a266ce8c83fb66
* 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
* Another attempt to fix warnings in the randomFunc() function.drh2012-02-11
| | | FossilOrigin-Name: 768df4e11670ac704d96e3b601d009aaa2fd793a
* Fix a warning coming from the Solaris Studio compiler.drh2012-02-10
| | | FossilOrigin-Name: 33294bbd1724665832464b33f865a29dc82b90f6
* Fix a problem with NULL handling in aggregate min/max when returningdrh2012-02-02
| | | | | values from the row containing the min or max. FossilOrigin-Name: f27c7b4fb193126548e6a620ac89664d1efa3856
* For queries of the form "SELECT p, max(q) FROM t1", the value of column pdrh2012-02-02
| | | | | returned is the one on the same row that holds the maximum value of q. FossilOrigin-Name: adb29232b659c5332b6841776372407fcc350b08
* Simplifications to the upper() and lower() SQL functions.drh2011-10-13
| | | | | | | | Updates to documentation on sqlite3_bind_text() and sqlite3_result_text() to make it clear that users should not try to create strings with embedded NULs and that if they do the result of expression on those strings is undefined. Ticket [57c971fc74524a] FossilOrigin-Name: 9984cc20ca70b7fb39c0b99580a1317a7b0c9c85
* Fix a couple of compiler warnings.drh2011-06-15
| | | FossilOrigin-Name: 3899f3b95ed50773a72d907b39b451fefce69c9e
* Use only unsigned values in the implementatin of LIKE and GLOB so thatdrh2011-06-13
| | | | | values won't overflow to negative when dealing with malformed UTF8. FossilOrigin-Name: 77f01578bb565d1bc884b374b68bae10ce34a084
* Change the name of an internal function to avoid conflicts with the mathdrh2011-04-27
| | | | | library. FossilOrigin-Name: 1bd1484cd7e09709d87aa84b82e87597d00a4162
* Add the (deliberately undocumented) sqlite_log() SQL function as a built-in.drh2011-04-25
| | | FossilOrigin-Name: f7806e03995b314771aa72a08ce55d56d60096cf
* Fix all known instances of signed-integer overflow. Within SQL expressions,drh2011-03-05
| | | | | | | integer overflow now forces coercion to floating point. The shift operators work with any integer right-hand operand with negative values reversing the direction of the shift. FossilOrigin-Name: abf21394124a0af46f072793718964cee2ce55d0
* Fix an instance of signed arithmetic overflow and an one bit-shift overflow.drh2011-03-05
| | | | | Mark six other signed arithmetic overflow locations that need fixing. FossilOrigin-Name: 04abab71ecd52f6070b9f84781a3df3d6dba7722
* When registering the built-in LIKE and GLOB functions, make sure that theydrh2010-12-15
| | | | | | | are tagged with SQLITE_UTF8 so that if other application-defined LIKE and GLOB implementations are provided for UTF16, then the appropriate function will be selected. FossilOrigin-Name: e1660764f20fed3fe92156d2b7f06075ff6ac145
* Rework the text to numeric conversion routines so that they work with eitherdrh2010-09-30
| | | | | | UTF8 or UTF16 and do not require a NULL terminator. This allowed text to numeric conversion without reallocating the string. FossilOrigin-Name: 14eed3a0e0a45c6f2904a3a134aa27c159916f7b
* Fix several harmless compiler warnings.drh2010-09-28
| | | FossilOrigin-Name: 7be03ecc04235420e54fed8a88742243278de160
* Add the sqlite3_create_function_v2() API, a version of create_function that ↵dan2010-08-27
| | | | | allows a destructor to be specified. FossilOrigin-Name: 9a724dfbe822c77e76721abe3443c9cb018bb2e2
* Fix disabled implementation-mark comments in func.c.drh2010-08-03
| | | FossilOrigin-Name: 57c0960038b8ce97f9d6665f15e7f6ec310c681f
* Make sure all memory from sqlite3DbMalloc() is freed by sqlite3DbFree() anddrh2010-07-24
| | | | | all memory from sqlite3_malloc() is freed by sqlite3_free(). FossilOrigin-Name: ac1f37a647e9ed1c00a901d26d9956a86c40117a
* Remove an unreachable branch from the function initialization logic.drh2010-04-25
| | | FossilOrigin-Name: 064d3ddd6199b7b049b1706974e4295f78fb5ab9
* When commands such as ALTER TABLE and VACUUM use SQL internally, make suredrh2010-04-24
| | | | | | they use only the built-in functions and not application-defined overrides for those functions. FossilOrigin-Name: 0291ed974d5bf1e344e2c38422530cc961b897da
* Rename the sqlite_compile_option_*() SQL functions to sqlite_compileoption_*()drh2010-02-26
| | | | | for consistency with the C/C++ interface. FossilOrigin-Name: dd4962aa34c4dd118d2cb15465384636eacc64d5
* Minor simplifications to the compile-time option reporting functions anddrh2010-02-25
| | | | | pragmas to facilitate coverage testing. FossilOrigin-Name: 633d874783a94f923ff8240f9153764033d37a89
* Merge the compile-time option introspection interfaces into the trunk.drh2010-02-23
|\ | | | | FossilOrigin-Name: 9f429434c0404f03a3e5c6741b769afe98a5c6c9
| * Refactored compile time option diagnostic support to use strings identifiers ↵shaneh2010-02-23
| | | | | | | | | | instead of bitmask. FossilOrigin-Name: 76a0294ab4208a0858a13bab0858e1bc1448b651
| * Test new api to report which options (defines) were used to compile SQLite.shaneh2010-02-23
|/ | | FossilOrigin-Name: 84c9756993caf82710a0905ed1987d144bc764fd
* Avoid using the internal printf routine for round(x,y) in the common case ↵shaneh2010-02-17
| | | | | where y==0. FossilOrigin-Name: d76ad8b3c494ffb4e670da0e92a1f8dbf7f48daf
* Add a few documentation evidence comments to the built-in function drh2010-01-11
| | | | | implementations. FossilOrigin-Name: 8bd0f8147dbf75367243b3eecfb705da6e794ab7
* Add evidence marks for the abs() and soundex() SQL functions.drh2009-12-08
| | | FossilOrigin-Name: 003f3ed10cdb64b73d6df00e28260dd3491e1f16
* Update comment for substrFunc(). Added additional SUBSTR() test cases.shaneh2009-11-12
| | | FossilOrigin-Name: d7b3801dc7fad1b002f892fb5d82047ebff98369
* Tweaks to the SUBSTR() function to make it dramatically faster in the commondrh2009-11-11
| | | | | | case where the input string is large but the 2nd and 3rd arguments are small positive integers. FossilOrigin-Name: 5a474a867c5988ad5ec03719516fdd38f0da5c2c
* Generate VDBE code for the built-in COALESCE() and IFNULL() functions. Thisdrh2009-11-11
| | | | | | allows unused arguments to never be evaluated, which is a performance win when the unused argument is a subquery. FossilOrigin-Name: 30055b257c3c65f8123cad5ac6c62c4c6ca2c900
* Incorporate fossil-scm version information into the build. Add thedrh2009-08-14
| | | | | | SQLITE_SOURCE_ID macro to the header. Add the sqlite3_sourceid() interface. Add the sqlite_source_id() SQL function. FossilOrigin-Name: 302dabe98f50b472bccd65c58504bc8a330049c4
* Make sure group_concat() ignores initial NULL values. (CVS 6787)drh2009-06-19
| | | FossilOrigin-Name: 90c3b23ccac8a9e7fc1cc831e43888e4e43badc9
* Reorganize and cleanup the prepared statement object. Remove code that hasdrh2009-06-19
| | | | | been commented out for ages and is no longer relevant to anything. (CVS 6786) FossilOrigin-Name: 37ae5f5e8feb34a8e6e8b34aa18df1e9a1ce55cb
* Additional changes to reduce stack usage. The SQLITE_SMALL_STACK compile-timedrh2009-06-03
| | | | | option is now available. (CVS 6708) FossilOrigin-Name: baea79fd0cfeb860973846c3f2776776c87f0ae3
* Additional refinements to Expr handling. Restore compression of triggerdrh2009-05-28
| | | | | | expressions. Change Expr.zToken to Expr.u.zToken and added Expr.u.iValue. Remove an unnecessary ExprDup from CHECK constraint processing. And so forth. (CVS 6682) FossilOrigin-Name: 4ac2bdfbb4230b6ceaae87e738fa61036bbe03cb
* Simplifications to the Expr object: Remove Expr.span completely and convertdrh2009-05-27
| | | | | | Expr.token into a char* Expr.zToken. Also simplify the Token object by removing the Token.dyn and Token.quoted fields. (CVS 6681) FossilOrigin-Name: 7cb1c3ba0759539cb035978fdaff6316775986f3
* Do not use deprecated interfaces internally when compiling withdrh2009-04-20
| | | | | SQLITE_OMIT_DEPRECATED. Ticket #3813. (CVS 6523) FossilOrigin-Name: 7f17956dfbf3090fd5832378e77bd83a525fed9d
* Fix the group_concat() function so that it inserts the separator stringdrh2009-04-15
| | | | | even if the initial content strings are empty. Ticket #3806. (CVS 6510) FossilOrigin-Name: b83fbf15a3920755ed77dc9c91b4f00a86ddb9ac
* Mark an branch in alter.c as always false. Only run the assert() ondrh2009-04-15
| | | | | | the sqlite3_aggregate_count() function in func.c if the SQLITE_OMIT_DEPRECATED compile-time option is off. (CVS 6508) FossilOrigin-Name: c0bba77ae619e709f3fb068526073a4a83cf33b6