database/sqlite
1
0
Fork 0
mirror of https://github.com/sqlite/sqlite.git synced 2025-08-05 15:55:57 +03:00
Code Activity
30,100 Commits 1,570 Branches 183 Tags
optimize-null-values
Commit Graph

107 Commits

Author SHA1 Message Date
drh
064b681e9b First attempt at getting the build to work with Tcl 9.0. 
FossilOrigin-Name: 6e5bb48a74d63fb8c30528f0005d1763cd2dbb882abf86baf1565721e6bfcf84
 2024-07-30 15:49:02 +00:00
drh
1935887a68 Ensure that all fields of static sqlite3_module objects are explicitly 
initialized, in order to hush-up nuisance compiler warnings.

FossilOrigin-Name: f3b3d712d6e58b1cb8fdebd2b6b3125080b6b3ac8c7c849a8cc1e5e778d62fe7
 2023-10-06 12:51:05 +00:00
larrybr
bc91738e66 Add a C-source spell-checking facility. make misspell (on Nix) 
FossilOrigin-Name: 26c1bb4bd9e9f56613c3aa87407a7f562fd4ebde5bfd6dece02078001d9a45f8
 2023-06-07 08:40:31 +00:00
drh
ba39ca4058 When deleting an SQL function that does not exist, return without doing 
anything at all rather than creating a tombstone function.  In this way,
function deletes that happen inside virtual-table destructors that are run
when a database connection is closing do not create new tombstones in the
function table after the function table has already been purged.
[forum:/forumpost/726219164b|forum post 726219164b].

FossilOrigin-Name: 391c73132c80df944fb49a17d8fe78203c54ac48f968ee9dd9dd8c769c0b4b10
 2021-05-17 13:11:24 +00:00
drh
1e32bed3c1 Further refactoring of the schema table name. 
FossilOrigin-Name: 9536fa0ae0c1ae6e2e98d2fa11e5acda7f3c9b8ca5061b6f7f8cae63a11d936b
 2020-06-19 13:33:53 +00:00
dan
d03024d814 Enhance the vtab interface to handle IS, !=, IS NOT, IS NULL and IS NOT NULL 
constraints.

FossilOrigin-Name: 34c8e952616013deb6fffec701ac5989afac9bef1bf92458a2e4ba92c7ee924f
 2017-09-09 19:41:12 +00:00
mistachkin
7617e4a8a4 Make sure the SQLITE_TCLAPI macro is always defined. 
FossilOrigin-Name: f2f1323cc4d2ad2d6794dbfae8d50b747213e85d
 2016-07-28 17:11:20 +00:00
mistachkin
52b1dbb5fc Allow the 'testfixture.exe' target to be compiled with the __stdcall calling convention. 
FossilOrigin-Name: e8be3dfeabaa31b3490793cf8230faae1204be15
 2016-07-28 14:37:04 +00:00
mistachkin
8ccdef6be4 Fix some more harmless compiler warnings. 
FossilOrigin-Name: 18f531e1cf3c8bb986d912c9c5e3f5698360c93e
 2015-12-16 22:06:52 +00:00
dan
1acb539f4c Add the "colUsed" field to the sqlite3_index_info structure passed to virtual table xBestIndex methods. To indicate the subset of the virtual table columns that may be required by the current scan. 
FossilOrigin-Name: 116b206494eb8ba963c7c5acfbf9e7b6db11c79c
 2015-11-26 19:33:41 +00:00
dan
898f70bc28 Merge latest trunk changes with this branch. 
FossilOrigin-Name: 99222bb3e5f9b2a9a10d9561a9fd8c0f717baaff
 2015-11-24 17:44:26 +00:00
mistachkin
a9124d359b Add a clarifying comment to the virtual table test module 'test8'. 
FossilOrigin-Name: e92f97a6794440eb9d64e21218d39cb0e297a98e
 2015-11-24 01:17:01 +00:00
dan
07bdba86d5 Add experimental support for LIKE, GLOB and REGEXP to the virtual table interface. 
FossilOrigin-Name: 277a5b4027d4c2caba8143228a4f7d6df899dbb4
 2015-11-23 21:09:54 +00:00
drh
65545b5993 Eliminate all use of sprintf(), strcpy() and strcat() from test logic because 
OpenBSD hates those functions.

FossilOrigin-Name: 10321910990195878c0af1e94b34ae0cdc0cb31b
 2015-01-19 00:35:53 +00:00
mistachkin
27b2f05335 Harmless compiler warning fixes for 'testfixture' and the miscellaneous extensions when built with the MSVC makefile. 
FossilOrigin-Name: 923fd66031ed1876bc63c3a038f0b8e33678184e
 2015-01-12 19:49:46 +00:00
drh
4081d5da3b Add logic to releasetest.tcl that detects -fsanitize=undefined errors. 
Fix a few false-positivies that come up when running the sanitize=undefined
test.

FossilOrigin-Name: 2835e79a0afec6e4d449ac9340afec068c2d4c11
 2015-01-01 23:02:01 +00:00
drh
693e671936 Fixes for various clang warnings. 
FossilOrigin-Name: 87bf60637e5863c54c5e2d05aaaca0835b7aace8
 2014-01-24 22:58:00 +00:00
drh
6b169bd86d Fix an issue in the test8.c test module that arises because of the change 
to PRAGMA index_list().  Remove an unused local variable.

FossilOrigin-Name: 029430c503f243a34439698779db7e591cfbe126
 2013-10-05 20:18:25 +00:00
mistachkin
e84d8d3219 More refinements to Windows OSTRACE usage. Replace all usage of sqlite3TestErrorName() with sqlite3ErrName() and add missing return codes. 
FossilOrigin-Name: 05ba5e23fcc5da416d47a8ad5e667ed6a0c7a34a
 2013-04-29 03:09:10 +00:00
drh
b7045ab2ed Move the test_spellfix.c module to ext/misc/spellfix.c. 
FossilOrigin-Name: de556add10150140981a2e34b3712e96a7c262e3
 2013-04-25 14:59:01 +00:00
drh
ef4c035275 Fix the test_spellfix.c extension so that it can be made loadable at run-time. 
Add spellfix to the shell when building using the build-shell.sh script.

FossilOrigin-Name: 7813b17d8b9fe48ddc841fe1c4bb75f7747073de
 2013-01-25 19:11:31 +00:00
drh
13a2bed309 Fix compiler warnings about unused code in spellfix. Fix the editDist3Core() 
routine to return the matchlen in characters instead of bytes.

FossilOrigin-Name: f96d4e7bd7d81b05b1490bf5d79c77ff583e444c
 2012-07-16 22:16:44 +00:00
dan
2deb165f4b Update test_spellfix.c with latest changes. 
FossilOrigin-Name: cba2a65870481df213e006b07e74f0ca19d2d57c
 2012-07-13 16:15:20 +00:00
dan
ca8b9bac3b Return SQLITE_MISUSE if an application attempts to register a virtual table module with the same name as an existing module. 
FossilOrigin-Name: ea2cd55e098b21cd8997fd6c1978131d3ef2fab4
 2012-05-16 14:29:11 +00:00
drh
83cc139231 Fix harmless compiler warnings on x64 MSVC, mostly in test code, but also in 
tclsqlite.c and in the FTS4 module.

FossilOrigin-Name: 3281972eaa46cb57fd9f0387063f47430dc0a3b4
 2012-04-19 18:04:28 +00:00
drh
82ebc2a098 Fix out-of-bounds array references in the "echo" virtual table module 
used for testing.  No changes to the SQLite core.

FossilOrigin-Name: 7b449b301ea03295262b8d572b02625e4b39cfa5
 2012-03-20 03:10:51 +00:00
dan
3b504df151 Add a test for [48f29963] that does not depend on FTS. 
FossilOrigin-Name: fb15f5458eb3e17ce9795c09bffe1224fea0eecd
 2011-10-29 15:29:43 +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
c81c11f62c Remove the obsolete "$Id:$" RCS identifier strings from the source code. 
FossilOrigin-Name: f6c045f649036958078cb15cd9d5453680c82b0c
 2009-11-10 01:30:52 +00:00
danielk1977
6eacd28a28 Fix a case in where.c where a crash can follow a malloc failure. Also modify test code in test8.c to check a return code that was being dropped (causing a test in vtab_err.test to fail). (CVS 6567) 
FossilOrigin-Name: 9664e2b6c69271a7ca55af7812a186773a7c6592
 2009-04-29 11:50:53 +00:00
danielk1977
1d46146b58 Attempt to optimize virtual table queries with 'OR' expressions in the WHERE clause. (CVS 6527) 
FossilOrigin-Name: f61e4cd93682fd98bea2a71d346f9eaa68454390
 2009-04-21 09:02:45 +00:00
drh
bc6160b0d6 Remove a pair unnecessary conditions from printf.c. The "db" parameter is 
now required for sqlite3MPrintf(). (CVS 6471)

FossilOrigin-Name: 6fe8b5d70247d9c6b70dd482db3990986be97e69
 2009-04-08 15:45:31 +00:00
shane
f5eccb6925 Changed to used sqlite3_snprintf instead of snprintf (test code only). (CVS 5648) 
FossilOrigin-Name: d68791e35d13f5ae4befeb0bb5f8ccaf14fd3763
 2008-08-31 00:29:08 +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
danielk1977
6e89162dd1 Fix warnings and a compilation error in test code. (CVS 5556) 
FossilOrigin-Name: 80c129e63ec7dbed3de1e485dffea96fae40aa6d
 2008-08-12 14:48:40 +00:00
drh
b36d88abd3 Remove a reference to snprintf() in test8.c. (CVS 5538) 
FossilOrigin-Name: 32d32b743642c2f6d9e4f8845a9cd07e4f83f4cd
 2008-08-05 21:36:06 +00:00
danielk1977
987a00e8b5 Also test that setting sqlite3_vtab.zErrMsg works from within the xRename method. (CVS 5520) 
FossilOrigin-Name: 4f4a9ccae7d25b9856d1203f6b289d552c2b425e
 2008-08-01 17:51:47 +00:00
danielk1977
3e3a84d32a Test that virtual table methods xBestIndex, xOpen, xFilter, xNext, xColumn, xRowid, xUpdate, xSync and xBegin can all return error messages using the sqlite3_vtab.zErrMsg variable. (CVS 5519) 
FossilOrigin-Name: 007359b770f225877880b11f4c5d97bb548e38ca
 2008-08-01 17:37:40 +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
4dc754d96d Read the sqlite3_vtab.zErrMsg after each call to a virtual table 
method and transfer any error into the database connection.
Fix the fts2.test and fts3.test scripts to that they return
silently rather than failing the test sequence if the appropriate
FTS implementation is unavailable. (CVS 5463)

FossilOrigin-Name: e2c6771d44f1b4fee16ef90e91c3498be2a7d2b1
 2008-07-23 18:17:32 +00:00
drh
24b58dd717 Additional test cases added on the sqlite3_create_function() interface. (CVS 5349) 
FossilOrigin-Name: 4e941f3d43556d8a503bb96e8a74451de36d243e
 2008-07-07 14:50:14 +00:00
danielk1977
2d1d86fbbe Add a mode to the sqlite3_test_control() interface to register hooks called at the beginning and end of "benign malloc failure" blocks. This allows malloc() failure testing to be done using public APIs only. (CVS 5254) 
FossilOrigin-Name: 56c8af1452dfdc8da858a2411bd6f3663a8a9326
 2008-06-20 14:59:51 +00:00
danielk1977
99e925da51 Fix a problem with the incremental blob API. sqlite3_blob_open() was always reading the data for the leftmost column of the row that the opened blob was stored in. If this column happened to contain a (the) large blob, sqlite would make a large memory allocation to read the data into. Which defeats the purpose of using incremental blobs. (CVS 5222) 
FossilOrigin-Name: 1b9478da2f421c1270e76297324fff8037d2f231
 2008-06-16 14:19:57 +00:00
drh
4873d5f614 Make the benign-fault setting recursive. Make all malloc failures 
during a rollback benign since there is nothing we can do about them. (CVS 5128)

FossilOrigin-Name: a9d1d931358637a6f039723a053098f65530de4b
 2008-05-13 13:27:33 +00:00
drh
344c38e340 Fix a couple of minor problems with transactions in virtual tables. (CVS 5081) 
FossilOrigin-Name: 2275fc6ee06b17da5808cecfa5570ac6439eaf74
 2008-05-05 13:23:04 +00:00
drh
cd3dd9d343 Add test cases to verify that multiple virtual tables can be updated 
within a trigger and that xSync, xCommit, and xRollback are never called
except following xBegin or xCreate.  Ticket #3083. (CVS 5064)

FossilOrigin-Name: 76175199ac2fda57e616eb386ba0bad6aa9f74b4
 2008-04-28 20:27:53 +00:00
danielk1977
39359dc020 Return an error when an xBestIndex() method indicates that it intends to use the value of an unusable constraint. Related to #2998. (CVS 4867) 
FossilOrigin-Name: ffd470279540b1b8e3fdce6eb14001bae489b16d
 2008-03-17 09:36:44 +00:00
danielk1977
a7a8e14bf2 Where possible, avoid freeing buffers allocated for vdbe memory cells in case they can be reused. (CVS 4783) 
FossilOrigin-Name: 990237e27e417aff3dbf05784b716c21f3761a3a
 2008-02-13 18:25:27 +00:00
drh
643167ff21 Add the fault injector module in fault.c. Use it as a basis for memory 
allocation failure testing. (CVS 4742)

FossilOrigin-Name: 1a335e180183b414fcc3510ce28b98b21cd134a6
 2008-01-22 21:30:53 +00:00
drh
85b623f2f9 Change all instances of "it's" in comments to either "its" or "it is", 
as appropriate, in case the comments are ever again read by a pedantic
grammarian.  Ticket #2840. (CVS 4629)

FossilOrigin-Name: 4e91a267febda572e7239f0f1cc66b3102558c36
 2007-12-13 21:54:09 +00:00