database/sqlite
1
0
Fork 0
mirror of https://github.com/sqlite/sqlite.git synced 2025-08-08 14:02:16 +03:00
Code Activity
25,662 Commits 1,570 Branches 184 Tags
branch-3.28
Commit Graph

73 Commits

Author SHA1 Message Date
drh
19efd0db41 Simplifications to the sqlite3_normalized_sql() implementation. 
FossilOrigin-Name: 94ea6379178e3ff6a0d1d5819ca4ac558bdadb1ca8a3637c797079db7dc0cd61
 2018-12-05 17:48:57 +00:00
mistachkin
8bee11a41e Add the sqlite3_normalized_sql() API. 
FossilOrigin-Name: 592b66e8058dd03a056a036e2606247c9efdb06d15eebe9bcc455f7f55e30ae6
 2018-10-29 17:53:23 +00:00
drh
9201184711 Store application-defined function names as lower-case to avoid the need 
for case conversions before calling xFindFunction on virtual tables.
Avoid using lookaside to store the destructors for application defined
functions, as lookaside should be reserved for transient allocations.

FossilOrigin-Name: 777189ce88799f93f393fd14fd716111c85bcdcb23690fd561f78ea2bd2ce5da
 2018-05-26 16:00:26 +00:00
drh
7e8515d8be The query planner tries to avoids using indexes that use unknown collating 
functions.

FossilOrigin-Name: 02013fc120bf71a8be3550c696a588af8c92f2209f8e5db530624878ddc8aa7e
 2017-12-08 19:37:04 +00:00
drh
dc6b41ed47 Defer schema resets when the query planner is running. 
Proposed fix for ticket [be436a7f4587ce517].

FossilOrigin-Name: a7bc7752ba0266684f5317e424a4ee9add4af002272082183519e708ab9ffc79
 2017-08-17 02:26:35 +00:00
drh
8257aa8dbe Add the new sqlite3.mDbFlags field. Factor out bits of sqlite3.flags that 
do not interact with PRAGMA statements into sqlite3.mDbFlags.

FossilOrigin-Name: 3808a00f06d372cc531da039d97bd974e4a6576a30cf63bf562f83f186b313b3
 2017-07-26 19:59:13 +00:00
drh
ebaaa67db2 Avoid unnecessary upper-to-lower case conversion for function names when 
registering the built-in functions.

FossilOrigin-Name: 06269257647db51fbc9f8cda88abac5db28b6f917a509768af7686dfa2b94511
 2017-07-06 13:23:26 +00:00
drh
3b02e0f615 Small size reduction in findCollSeqEntry(). 
FossilOrigin-Name: 55ecd30304517acd23f89b3450fd6a5e18ac2f79aa24a4ff693f8d71a49f7837
 2017-07-06 03:06:20 +00:00
drh
666e86625c Avoid unnecessary calls to sqlite3GetCollSeq() for a small performance gain. 
FossilOrigin-Name: 503ba172e4c32e288abf006fc5cb53fd2b0313c4ee4c526c2d9c4c21b7178f2d
 2017-07-06 02:49:26 +00:00
drh
6ad224e91e Change a char* to const char* in order to suppress some harmless 
compiler warnings.

FossilOrigin-Name: 56f62e34ae9d5c7db07367f0007df258b2e76bd2
 2016-02-24 19:57:11 +00:00
drh
80738d9c3e Improvements to the application-defined function mechanism so that it is 
more compact and runs faster, especially when the application defines
thousands of new SQL functions.

FossilOrigin-Name: 3201fbcc5105d23132e6b8b7ac825e66af4f8a39
 2016-02-15 00:34:16 +00:00
drh
4a642b6060 Improvements to the way that OOM errors are processed. 
FossilOrigin-Name: c3ef03478a5788c855b3aef385d43ae7f494f440
 2016-02-05 01:55:27 +00:00
drh
2d80151f32 Combine the xFunc and xStep pointers of the FuncDef object into a single 
pointer xSFunc.

FossilOrigin-Name: 0d1b3d7d3ca66cb0b97493f1aeade1703af3c9f4
 2016-01-14 22:19:58 +00:00
peter.d.reid
60ec914c74 Fix typos in comments. No code changes. 
FossilOrigin-Name: e62aab5e9290503869e1f4d5e0fefd2b4dee0a69
 2014-09-06 16:39:46 +00:00
drh
acbcb7e013 Simplify the interface to the symbol table, saving 600 bytes of code space. 
FossilOrigin-Name: 14b0f561fe15622b61c6676c9c455dca6b9ba5f0
 2014-08-21 20:26:37 +00:00
drh
2c5e35ffd1 Rename the internal Schema.flags field to Schema.schemaFlags. 
FossilOrigin-Name: 5ae80b3c8f032528359c8c762505ce24da8db96f
 2014-08-05 11:04:21 +00:00
drh
4a8ee3dfe2 Allow the SQLITE_DETERMINISTIC flag to be ORed into the preferred text encoding 
of application-defined functions, to mark the function as deterministic.

FossilOrigin-Name: 5716fc2341ddd8cf64139e7168597f864da4e10b
 2013-12-14 13:44:22 +00:00
drh
d36e104112 Combine the FuncDef.iPrefEnc and FuncDef.flags fields into a single 
new FuncDef.funcFlags field.

FossilOrigin-Name: 97b10e66e98e84755aa577f8da017bf1aea2056c
 2013-09-06 13:10:12 +00:00
drh
79e72a50aa Consolidate all occurrences of the "no such collation sequence" error message 
into a single spot.

FossilOrigin-Name: 8ea67522fb03134f355ecb776b70c6917241cab2
 2012-10-05 14:43:40 +00:00
drh
89d5d6a2a7 Fix the application-defined function logic so that functions with a variable 
number of parameters can be replaced or deleted correctly.  Also refactor
some of the function-finder code for clarity of presentation.

FossilOrigin-Name: 09d5581c81fb6a9bf6a369d0abf5ef6b54637576
 2012-04-07 00:09:21 +00:00
drh
b6ee66072e Rename sqlite3SchemaFree() to sqlite3SchemaClear() to more accurately reflect 
its function.

FossilOrigin-Name: 71d7440023f67760d0bff4bd7459fe88bd226f30
 2011-04-04 13:40:53 +00:00
drh
c2a75551ef Add a generation counter to the Schema object and enhance OP_VerifySchema 
to also check the Schema generation.  Fix for
ticket [f7b4edece25c99].

FossilOrigin-Name: 36c04dd1695f0899b53ce58738181b146fc005ed
 2011-03-18 21:55:46 +00:00
drh
6c5cecb63a Updates to the requirements on the sqlite3_create_function() family of 
interfaces.

FossilOrigin-Name: f03c608993d1c37b45ba8e0a6a4e941bdcb57ffa
 2010-09-16 19:49:22 +00:00
drh
b975598ea0 Make sure all memory from sqlite3DbMalloc() is freed by sqlite3DbFree() and 
all memory from sqlite3_malloc() is freed by sqlite3_free().

FossilOrigin-Name: ac1f37a647e9ed1c00a901d26d9956a86c40117a
 2010-07-24 16:34:37 +00:00
drh
b2468954c2 Remove additional traces (mostly in comments) of the Table.dbMem field. 
FossilOrigin-Name: 5c58f44aeb224e106497368d9290d75a08807761
 2010-07-23 17:06:32 +00:00
dan
1feeaed291 Remove the Table.dbMem variable, as it is no longer being used for its original purpose. 
FossilOrigin-Name: 6eddc6e601cf8f585c6c2cf79f36fcbfe98a307e
 2010-07-23 15:41:47 +00:00
drh
545f587fc8 When commands such as ALTER TABLE and VACUUM use SQL internally, make sure 
they use only the built-in functions and not application-defined overrides
for those functions.

FossilOrigin-Name: 0291ed974d5bf1e344e2c38422530cc961b897da
 2010-04-24 14:02:59 +00:00
drh
c81c11f62c Remove the obsolete "$Id:$" RCS identifier strings from the source code. 
FossilOrigin-Name: f6c045f649036958078cb15cd9d5453680c82b0c
 2009-11-10 01:30:52 +00:00
dan
1da40a381f Check in implementation of foreign key constraints. 
FossilOrigin-Name: d5d399811876391642937edeb9e8434dd9e356f5
 2009-09-19 17:00:31 +00:00
shane
cea72b2dc2 Warning cleanup from the MSVC compile. 
FossilOrigin-Name: 26cd015c0ee1c18dd37f11b47ce35cfa320b3514
 2009-09-07 04:38:36 +00:00
drh
9aeda79cf6 All the sqlite3GetCollSeq() function to specify an arbitrary text encoding. 
FossilOrigin-Name: 4ee44322ca3c92ed8d6f5d4a3f89d219bf379595
 2009-08-20 02:34:15 +00:00
drh
58fbb314ae Changes to prepare.c and callback.c to promote better test coverage. (CVS 6770) 
FossilOrigin-Name: 08cca219f16efab93cb00f04d2e2f8033893e5f1
 2009-06-17 00:35:30 +00:00
drh
7aaa878619 Updates to the extension loading logic to support full coverage testing. (CVS 6659) 
FossilOrigin-Name: 929cfbc66f6e2ea6b44417305d0f4ae36567c9bf
 2009-05-20 02:40:45 +00:00
drh
c4a64facce Rework the logic that generates a schema for tables created using 
"CREATE TABLE ... AS SELECT ...".  Instead of trying to copy the raw
datatype string from the right-hand side, just make the type one 
of TEXT, INT, REAL, NUM, or nothing.  This is much simpler than 
trying to parse and quote datatype strings.  Other minor 
implifications to build.c are bundled with this change. (CVS 6626)

FossilOrigin-Name: 33cf83591e6e13875ef6ada5b8ac8ab07619d8bc
 2009-05-11 20:53:28 +00:00
drh
dee0e404d6 Changes to facility full coverage testing of util.c. (CVS 6597) 
FossilOrigin-Name: a612299092a48b38c5f9cf430bbcaf41777cbcb3
 2009-05-03 20:23:53 +00:00
drh
e61922a6a1 Remove the aFKey hash table, which was not being used. Simplify the 
FKey object.  Simplify the hash.c module since the copyKey parameter
formerly used only by aFKey is now no longer required. (CVS 6594)

FossilOrigin-Name: 80c43a355c6e482457abc2f9c3ad3a565cec55fb
 2009-05-02 13:29:37 +00:00
drh
d9da78a2c8 Changes to insure that lookaside memory allocations are never used to hold 
schema content.
Ticket #3743. (CVS 6377)

FossilOrigin-Name: ea74d8dc62f5784089aa8ef098e97c505a79b176
 2009-03-24 15:08:09 +00:00
shane
be21779385 Corrected typos and misspellings. Ticket #3702. (CVS 6336) 
FossilOrigin-Name: 6404afa0c515a6536fc2e878d4fb451e4dc06942
 2009-03-05 04:20:31 +00:00
drh
dfbc3a8a3b Better error message when coalesce() has too few arguments. Ticket #3623. (CVS 6222) 
FossilOrigin-Name: 9cd43c82a3c123829806aa7bf14efdd29f4424d8
 2009-01-31 22:28:48 +00:00
drh
1bd10f8a00 Additional work at eliminating silly compiler warnings. (CVS 6010) 
FossilOrigin-Name: ea01d43788a75e39c7f03c22681d1a338d52cf0e
 2008-12-10 21:19:56 +00:00
drh
ea6788322e Never use strlen(). Use our own internal sqlite3Strlen30() which is 
guaranteed to never overflow an integer.  Additional explicit casts to
avoid nuisance warning messages. (CVS 6007)

FossilOrigin-Name: c872d554930ecf221ac2be5f886d5d67bb35288c
 2008-12-10 19:26:22 +00:00
drh
1b67f3caf2 Simplify the symbol hash table to use only a single key class. Other 
changes to improve code coverage. (CVS 5794)

FossilOrigin-Name: ff50a8a7e5a15fac192939ff3206fa18d1c5a6dd
 2008-10-10 17:41:28 +00:00
drh
e3602be8fd Calling sqlite3_create_function with nArg==(-1) does not override prior 
calls on the same function name with nArg>=0.  Ticket #3345.  Add the
new -argcount option to the "function" method in the TCL interface. (CVS 5684)

FossilOrigin-Name: 5aa5b8044a14f59559c1839dc0799b0d2f990809
 2008-09-09 12:31:33 +00:00
danielk1977
075c23af26 Begin adding support for the SQLITE_OMIT_WSD macro. Some (many) WSD variables still need wrappers added to them. (CVS 5652) 
FossilOrigin-Name: 573d92abb9adb1c321ebc2fcadcf14374213b093
 2008-09-01 18:34:20 +00:00
drh
777c5386c3 Move date+time functions to start-time initialization. Additional 
start-time function cleanup. (CVS 5585)

FossilOrigin-Name: 80d6a31cb3851704c09ac9d99fe4bc241df3c180
 2008-08-21 20:21:34 +00:00
drh
70a8ca3c1e Initialize the global built-in function table at start-time 
instead of at compile-time.  This is less prone to malfunction when
compile-time parameters very. (CVS 5583)

FossilOrigin-Name: ef6936e50adb9ebea39c890167403fff01bbb5ed
 2008-08-21 18:49:27 +00:00
danielk1977
8c0a791a58 Add the pcache module from the experimental branch. Also change things so that most of the built-in SQL functions are kept in single static hash-table, rather than creating and populating a separate hash table for each open database connection. (CVS 5566) 
FossilOrigin-Name: cb494e10d71852024647aaa254203579ad438ea9
 2008-08-20 14:49:23 +00:00
drh
633e6d57d9 Implement the "lookaside" memory allocation cache. Use of this cache makes 
the speed1.test script run about 15% faster.  Added new interfaces to
control the cache. (CVS 5488)

FossilOrigin-Name: e48f9697e9fea339e150ddc32940760027dd07d9
 2008-07-28 19:34:53 +00:00
drh
0a687d123e Improved enforcement of the SQLITE_LIMIT_LENGTH limit. (CVS 5368) 
FossilOrigin-Name: ee93150878436ce6e992ea8a1d348fb58b03b5e2
 2008-07-08 14:52:07 +00:00
danielk1977
8cf6c554c0 Fix a bug causing the pager-cache size to be reset to its default value whenever the database schema was reloaded. (CVS 5283) 
FossilOrigin-Name: 6dbe67da5cb0141e011b4fdcc3964a20f68be843
 2008-06-23 16:53:46 +00:00