database/sqlite
database/sqlite
1
0
Fork 0
mirror of https://github.com/sqlite/sqlite.git synced 2025-04-20 08:47:46 +03:00
Code
29,836 Commits 1,540 Branches 176 Tags
Commit Graph

138 Commits

Author SHA1 Message Date
stephan
065c0a6120 Test app/script patches from Jan Nijtmans for cygwin. Add/replace many more sentinel arguments for TCL variadic functions which specifically need a NULL trailing argument. With this, 'make test' on cygwin runs to completion for me, with 134 of 329227 tests failing. MSC build fails the same 13 tests which fail for me in trunk. 
FossilOrigin-Name: 84d8fcfca19cd183d05a702d0eb1742bfae462d3383a3db72741a48cefac1058
 2025-03-08 06:53:06 +00:00
stephan
b6503f1444 Cygwin-centric fixes from Jan Nijtmans. 
FossilOrigin-Name: 205979813c7300debb5f1ba270583ef2f08e069d6d01865b5910702889a5c1ed
 2025-03-06 13:38:07 +00:00
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
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
bb2d9b1bf1 Change sqlite3BtreeBeginTrans() to return the BTREE_SCHEMA_COOKIE, for a 
small speed improvement when starting new transactions.

FossilOrigin-Name: a10662aa915ae2b5a78b3e10920350d32255b2d6b1a8aac0aba1ad173b07ed2b
 2018-06-06 16:28:40 +00:00
drh
2ab792e4c0 Change sqlite3BtreeNext() and sqlite3BtreePrevious() so that they return 
SQLITE_DONE if they have already reached the end (or beginning) of the table.
This gives a performance increase and size reduction.

FossilOrigin-Name: e972a3860892022d57b26ec44ce0fbadc61c1ff54b7a10b7e82390db88d323a7
 2017-05-30 18:34:07 +00:00
drh
2eb22af03d Changes to give a warning-free build with SQLITE_OMIT_INCRBLOB and 
SQLITE_OMIT_SHARED_CACHE.

FossilOrigin-Name: 711c59171b22df04224183a713e6c36e0bb3bba8
 2016-09-10 19:51:40 +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
drh
a7c90c42ea Change the sqlite3BtreeKeySize() interface into sqlite3BtreeIntegerKey() and 
make it only work for table btrees.  Change sqlite3BtreeDataSize() into
sqlite3BtreePayloadSize() and make it work for all btrees.  Combine
sqlite3BtreeDataFetch() and sqlite3BtreeKeyFetch() into a single
sqlite3BtreePayloadFetch() routine.  These changes seem to make the
b-tree interface more rational and they reduce both binary size and
CPU usage.

FossilOrigin-Name: bef35e18dd19732f7859287b097feeb593e5900f
 2016-06-04 20:37:10 +00:00
drh
8eeb4463d9 Simplify the sqlite3BtreeInsert() interface by gathering the five arguments 
describing the content to be inserted into the new BtreePayload structure, and
thus reducing the number of parameters from eight to four.

FossilOrigin-Name: 55f348cdd24c7812ea4b63345514764b69f64dc8
 2016-05-21 20:03:42 +00:00
dan
9131ab9386 For a pager backed by a temp file, store the main journal in memory until it is at least sqlite3_config.nStmtSpill bytes in size. Prevent the backup API from being used to change the page-size of a temp file. 
FossilOrigin-Name: 84c557010c211595d2ec80b62c63af1c7f4714bd
 2016-04-06 18:20:51 +00:00
dan
6a75c8ad94 Add mutex operations to test code in test3.c to avoid triggering assert() failures in certain configurations. 
FossilOrigin-Name: 9f19420b0a79dff65fc3a9d548f4b3fc4955f9f9
 2015-10-30 20:54:25 +00:00
drh
ad61c46409 Capture BTREE_FORDELETE test cases that were mistakenly omitted from the 
previous merge.

FossilOrigin-Name: de6972515f65c5cf5da7cfdf876a05718299e9b8
 2015-10-26 18:01:36 +00:00
dan
433d5aaed1 Fix an uninitialized variable problem in the test code added by the previous commit. 
FossilOrigin-Name: 7849662ef94fa48fe53177db5623f46b3cb401e8
 2015-10-26 16:34:13 +00:00
dan
6b513640c0 Test that the binary record "0x01 0x00" is interpreted by OP_Column as a vector of NULL (or default) values. 
FossilOrigin-Name: 5bdc3c82bd10f924c12568eb0fa7a07393fc864f
 2015-10-26 16:31:18 +00:00
dan
fd261ec67e Modifications to pass a flag to internal routine sqlite3BtreeCursor() when a cursor that is used solely for deleting b-tree entries, or for obtaining the components of keys to delete from other b-trees, is opened. 
FossilOrigin-Name: cdc92919e600007cae5eb61223684f48a65babc0
 2015-10-22 20:54:33 +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
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
d040e76442 Add new primary error codes SQLITE_NOTICE and SQLITE_WARNING for use with 
sqlite3_log().  Add new extended error codes SQLITE_NOTICE_RECOVER_WAL and
SQLITE_NOTICE_RECOVER_ROLLBACK to use with sqlite3_log() messages that occur
on each recovery.

FossilOrigin-Name: be7d2c5482c41baf000d7fb5dccc31b974e91064
 2013-04-10 23:48:37 +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
7da5fcb0b7 Fix MSVC compiler warnings in test code. 
FossilOrigin-Name: cb7a850439c9a4a7887650d6b81d95ab8025de5b
 2012-03-30 14:59:43 +00:00
drh
c02a43afae Only require double-zero terminators on database filenames, not any every 
files supplied to the xOpen method.  This backs out [2544f233f1].  Also
refactor the fillInUnixFile() routine in os_unix.c to reduce the number
of parameters.

FossilOrigin-Name: cb774b26e13745cfad0d76a71e47466d703e0007
 2012-01-10 23:18:38 +00:00
dan
3a6d8aec2a Have the ATTACH command do URI interpretation in the same way as sqlite3_open() and sqlite3_open_v2() do. 
FossilOrigin-Name: 68240e75e87a54cde93352b0ec364d34365a8170
 2011-04-23 15:54:54 +00:00
drh
75c014c321 Remove the sqlite3BtreeFactor() wrapper routine. All modules now call 
sqlite3BtreeOpen() directly.

FossilOrigin-Name: 0900e35348f4b9bf327d6ae2884c4ddbb6345d8d
 2010-08-30 15:02:28 +00:00
dan
93a696f61b Changes to test code so that testfixture compiles when OMIT_SHARED_CACHE and OMIT_UTF16 are defined. 
FossilOrigin-Name: d6ee5ff6c815e3aadd92d331560b529394eae661
 2010-01-07 11:27:30 +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
3054866c7c Restore (btree_set_cache_size) to test3.c. This is used on unix for the tcl "crash tests". Make some functions no longer used outside of btree.c static. (CVS 6869) 
FossilOrigin-Name: 1d96ce8c76e007ca29e7971a6c72b6387fe0fb93
 2009-07-09 05:07:37 +00:00
shane
cbcadd41f9 removed the test function sqlite3BtreeFlags() (test code only); (CVS 6868) 
FossilOrigin-Name: 579ba6c83f52d26860e5152f06355aa4f49e568d
 2009-07-09 03:20:46 +00:00
shane
20a35fd826 removed unused functions from test3.c (test code only); (CVS 6867) 
FossilOrigin-Name: 0eb69e8dda13e2d52a06f66a71480f59fd766271
 2009-07-09 02:48:23 +00:00
danielk1977
3509a65827 Make the sqlite3BtreeMoveto function static, since it is only used from within btree.c. Remove unused function lockBtreeWithRetry from btree.c. (CVS 6850) 
FossilOrigin-Name: 30d5ec62ab6a85ee60ee4128e20959842f8c7ad1
 2009-07-06 18:56:13 +00:00
drh
ee152b00a3 Remove an unused variable from the test code in test3.c. (CVS 6843) 
FossilOrigin-Name: 9e35bec9ef924ec44e87294a549238e0104bb27b
 2009-07-03 17:23:48 +00:00
danielk1977
602b466e99 Cause opening a transaction on a sharable b-tree module automatically obtain a read-lock on page 1. This means there is no way for sqlite3BtreeGetMeta() to fail. (CVS 6836) 
FossilOrigin-Name: e3c055f167f895ae45858de9d9d8a264df2f36b6
 2009-07-02 07:47:33 +00:00
danielk1977
96d48e963a Cause incremental-blob read/write operations lock shared-cache tables in the same way as normal SQL read/writes. Add complex assert statements to make sure tehe correct shared-cache locks are held when accessing the database. Eliminate some redundant checks from btree.c. (CVS 6830) 
FossilOrigin-Name: f17ef37897da9bcaf20b5acdce6840522c0a0b16
 2009-06-29 06:00:37 +00:00
danielk1977
de630353d8 Speed up INSERT operations that add data to UNIQUE or PRIMARY KEY indexes by rationalizing duplicate seek operations. (CVS 6599) 
FossilOrigin-Name: cac4f3d812f0a02ca5c1fa78d366f694403929a8
 2009-05-04 11:42:29 +00:00
danielk1977
bd43455c38 Fix some cases where executing SQL from within a user-function callback could cause problems related to statement-transactions. (CVS 6355) 
FossilOrigin-Name: a60f4191791dd7bb49d5c95b350a9924845b59a8
 2009-03-18 10:33:00 +00:00
danielk1977
c7af484b4b Make sqlite3_count_changes() and total_changes() work with "DELETE FROM <table-name>". (CVS 5844) 
FossilOrigin-Name: e68e4282adb9003aa297d033aeb5d9cadee215cd
 2008-10-27 13:59:33 +00:00
drh
e63d999189 Additional changes toward fixing ticket #3292. (CVS 5562) 
FossilOrigin-Name: 0b92cbf5255020d4fde382f81590ff0488936667
 2008-08-13 19:11:48 +00:00
drh
e8f52c5089 Remove leftover debugging commands (breakpoint and btree_breakpoint) from 
test scripts. (CVS 5400)

FossilOrigin-Name: dcb160249fa2d592ad09b8b0052102dc44a93511
 2008-07-12 14:52:20 +00:00
drh
93a960a0a8 Remove unused code. Test coverage enhancements. Modify the algorithm used 
to select column names for VIEWs of joins so that the constructed column
names omits the underlying table names. (CVS 5386)

FossilOrigin-Name: 636cd723296a8b1709011fdd99b236ffddf3f1b0
 2008-07-10 00:32:42 +00:00
danielk1977
59f8c08ecc Implement the 'CONFIG_SINGLETHREAD' and 'CONFIG_MULTITHREAD' configuration modes. (CVS 5234) 
FossilOrigin-Name: 5059644c4bc5f6679afd939e0bc26080f42a9918
 2008-06-18 17:09:10 +00:00
danielk1977
17b90b5316 Remove the xGetTempname() method from the vfs structure. Temp files are now opened by passing a NULL pointer as the filename to xOpen(). (CVS 5190) 
FossilOrigin-Name: 5173b3e816c7eb711cd21a9068bbafb9ebb7cff1
 2008-06-06 11:11:25 +00:00
shane
1ca0ed4692 In test3.c, use type 'u32' instead of 'unsigned int' to remove a warning/error from native x86_64 compile. (CVS 5165) 
FossilOrigin-Name: 02447e4e47659d70f014529e9baa3bf8ff75844c
 2008-05-27 20:17:00 +00:00
shane
3f8d5cfcad Consolidated varint macro usage from btreeInt.h, vdbe.c, and vdbeaux.c into sqliteInt.h and made their use consistent. Slight improvements to varint32 macros. (CVS 5045) 
FossilOrigin-Name: 0d04ccd97841bbbda564cc6ae5da057ee3888fa3
 2008-04-24 19:15:09 +00:00
drh
e14006d0de Modify the {quote: IdxDelete} opcode so that it takes an array of registers rather 
than a record formed using {quote: MakeRecord.}  This avoids a needless packing
and unpacking of the record to be deleted. (CVS 4916)

FossilOrigin-Name: ee381b43563e1b0637ee74389d076dff77deddf9
 2008-03-25 17:23:32 +00:00
danielk1977
cd3e8f7ce9 Use a vdbe memory cell to allocate the space required for vdbe cursors. (CVS 4912) 
FossilOrigin-Name: 047153648155654b0cd70b811935209d2e21776c
 2008-03-25 09:47:35 +00:00
drh
1e968a0cbf Removed the direct btree tests - part of the ongoing effort to test by 
calling only public interfaces.  Modify the sqlite3VdbeRecordCompare
interface to used a pre-parsed second key - resulting in a 13%
performance improvement on speed1p.test. (CVS 4911)

FossilOrigin-Name: 0e1d84f2f456e7680bb667266745b629ddf3605f
 2008-03-25 00:22:21 +00:00
mlcreech
3a00f907a9 Various renames & cleanups to limit exported symbols on amalgamation build (CVS 4819) 
FossilOrigin-Name: 9c6694bb61a8ecdbfb2d05e5e05a8cc97b792240
 2008-03-04 17:45:01 +00:00
drh
45b5ba88dc Delete unused "pager3_refinfo_enable" flag and its associated debugging 
macros.  Ticket #2923. (CVS 4774)

FossilOrigin-Name: fccb217d91d08c5a2f5d51b21c6035474931957b
 2008-02-02 20:47:38 +00:00
drh
de4fcfdd7a Additional test coverage improvements. Test coverage now stands at 98.73%. (CVS 4731) 
FossilOrigin-Name: 010f7b780cb9c8f21af9ce810494fbd2be98a13f
 2008-01-19 23:50:26 +00:00