]> git.ipfire.org Git - thirdparty/sqlite.git/log
thirdparty/sqlite.git
16 years agounify TCLLIBDIR handling with libtclsqlite3.so and use libtool to install it rather...
vapier [Wed, 28 Jan 2009 04:46:14 +0000 (04:46 +0000)] 
unify TCLLIBDIR handling with libtclsqlite3.so and use libtool to install it rather than custom tclinstaller.tcl ... this integrates better with autotools and avoids relinking issues (RPATH pointing to builddir) (CVS 6210)

FossilOrigin-Name: 3a049ca761f36d0fdb3b5b5f254c00210b373e9e

16 years agoAdd testcase() macros for coverage in date.c. (CVS 6209)
drh [Wed, 28 Jan 2009 02:55:28 +0000 (02:55 +0000)] 
Add testcase() macros for coverage in date.c. (CVS 6209)

FossilOrigin-Name: 90b42eba8e02402c342e04236148bbd5e4d93eb8

16 years agouse AC_MSG_xxx funcs rather than `echo` (CVS 6208)
vapier [Mon, 26 Jan 2009 21:43:16 +0000 (21:43 +0000)] 
use AC_MSG_xxx funcs rather than `echo` (CVS 6208)

FossilOrigin-Name: ed08025ad2c5c9e52732ad91192e1c6d58272c87

16 years ago(#3449) search for tclConfig.sh first by asking tclsh itself where it is (CVS 6207)
vapier [Mon, 26 Jan 2009 21:39:33 +0000 (21:39 +0000)] 
(#3449) search for tclConfig.sh first by asking tclsh itself where it is (CVS 6207)

FossilOrigin-Name: ff2912dc1483bf934c94bd7866b4ec314a0d784f

16 years ago(#1428) installed shared libs with exec perms (CVS 6206)
vapier [Mon, 26 Jan 2009 21:25:57 +0000 (21:25 +0000)] 
(#1428) installed shared libs with exec perms (CVS 6206)

FossilOrigin-Name: 3f2a3414d008636e0d70f3ed8b728ffdd46ae9fc

16 years ago(#3583) add a rule for sqlite3.pc in case the .in file is updated (CVS 6205)
vapier [Mon, 26 Jan 2009 20:59:02 +0000 (20:59 +0000)] 
(#3583) add a rule for sqlite3.pc in case the .in file is updated (CVS 6205)

FossilOrigin-Name: 4d03b69317acde5c29f38ae88276c15abf05266a

16 years agoRemove obsolete files from the tools subfolder. (CVS 6204)
drh [Sat, 24 Jan 2009 15:23:00 +0000 (15:23 +0000)] 
Remove obsolete files from the tools subfolder. (CVS 6204)

FossilOrigin-Name: d74560803e16eb2d28fc644b9aedb8c60eb224c6

16 years agoFix some minor compiler warnings. Added sqlite3Isalpha() for use in
drh [Sat, 24 Jan 2009 11:30:42 +0000 (11:30 +0000)] 
Fix some minor compiler warnings.  Added sqlite3Isalpha() for use in
the soundex() function. (CVS 6203)

FossilOrigin-Name: bfc71edca471221add6b32b867d0b15171974eaf

16 years agoRemove incorrect ALWAYS macro associated with empty IN() sets. Ticket #3602. (CVS...
danielk1977 [Sat, 24 Jan 2009 09:56:15 +0000 (09:56 +0000)] 
Remove incorrect ALWAYS macro associated with empty IN() sets. Ticket #3602. (CVS 6202)

FossilOrigin-Name: f3c09a0cb8bfc1a112c31b556d8921d5c75c5eef

16 years agoOptimization: When loading a new page into the cache, avoid redundant memset() calls...
danielk1977 [Fri, 23 Jan 2009 16:45:00 +0000 (16:45 +0000)] 
Optimization: When loading a new page into the cache, avoid redundant memset() calls to zero it. (CVS 6201)

FossilOrigin-Name: 9c0b9f881367871105965d4268e2f2cde7f4d884

16 years agoFix the VACUUM command so that it does not commit a transaction when it is
drh [Thu, 22 Jan 2009 23:04:45 +0000 (23:04 +0000)] 
Fix the VACUUM command so that it does not commit a transaction when it is
mistakenly run within a transaction - it should leave the transaction open. (CVS 6200)

FossilOrigin-Name: 75cc709be46ae2096d2ba3e7ac58de8140f8130c

16 years agoSilence a C++ builder warning by writing "if( (rc = function())!=SQLITE_OK )" instead...
danielk1977 [Thu, 22 Jan 2009 17:12:39 +0000 (17:12 +0000)] 
Silence a C++ builder warning by writing "if( (rc = function())!=SQLITE_OK )" instead of "if( (rc = function()) )" in two places in pager.c. Ticket #3605. (CVS 6199)

FossilOrigin-Name: 78ae96def54026461c0d03a90394480f724ea584

16 years agoAdd a comment to fts3_tokenizer.h to make it clear how the xNext() method is supposed...
danielk1977 [Wed, 21 Jan 2009 17:45:33 +0000 (17:45 +0000)] 
Add a comment to fts3_tokenizer.h to make it clear how the xNext() method is supposed to set its output variables. Make sure the output variables of xNext() are only used if SQLITE_OK is returned. Ticket #3604. (CVS 6198)

FossilOrigin-Name: 5b3c075f96be9671d0bcffe928589b211559e835

16 years agoBig change to make pager.c easier to follow. Unused variables removed, comments impro...
danielk1977 [Tue, 20 Jan 2009 17:06:27 +0000 (17:06 +0000)] 
Big change to make pager.c easier to follow. Unused variables removed, comments improved, etc. (CVS 6197)

FossilOrigin-Name: 12f7346c13c180ed73d7a2e3b590be457360254a

16 years agoWhen not compiling for an EBCDIC system, use built-in alternatives to the tolowe
danielk1977 [Tue, 20 Jan 2009 16:53:39 +0000 (16:53 +0000)] 
When not compiling for an EBCDIC system, use built-in alternatives to the tolowe
r(), toupper() and other ctype.h library functions. Ticket #3597. (CVS 6196)

FossilOrigin-Name: 1041abd6784d283bebf646c54e93599522f7889d

16 years agoMake sure the *pzErrMsg return from sqlite3_get_table() is aways zeroed.
drh [Mon, 19 Jan 2009 20:49:09 +0000 (20:49 +0000)] 
Make sure the *pzErrMsg return from sqlite3_get_table() is aways zeroed.
Ticket #3598. (CVS 6195)

FossilOrigin-Name: 7035c35dbef72b7b4d00201a65734a6d93dd0d3e

16 years agoFix the --enable-tempstore option on the configure script. Ticket #3599 (CVS 6194)
drh [Mon, 19 Jan 2009 18:18:40 +0000 (18:18 +0000)] 
Fix the --enable-tempstore option on the configure script.  Ticket #3599 (CVS 6194)

FossilOrigin-Name: c2eabb99fe852142e54f35f423f766411d7ba6c0

16 years agoMake sure mutexes are fully enabled for thread001.test. Take steps to
drh [Mon, 19 Jan 2009 17:40:12 +0000 (17:40 +0000)] 
Make sure mutexes are fully enabled for thread001.test.  Take steps to
ensure that the thread tests run during regression testing. (CVS 6193)

FossilOrigin-Name: 6242f113eb40d472b78685c296fecf9f749a11cd

16 years agoFix a bug that was preventing SQLite from releasing locks properly under obscure...
danielk1977 [Sat, 17 Jan 2009 16:59:40 +0000 (16:59 +0000)] 
Fix a bug that was preventing SQLite from releasing locks properly under obscure circumstances. (CVS 6192)

FossilOrigin-Name: 502c66df8b5fc5ec8e3d94202030571a4920fb9c

16 years agoBack out the Makefile.in changes from check-in (6181) because of reports
drh [Sat, 17 Jan 2009 15:53:31 +0000 (15:53 +0000)] 
Back out the Makefile.in changes from check-in (6181) because of reports
(ticket #3594) that they do not work on NetBSD.  Separately, documentation
is updated to make clear that configure and Makefile.in are unsupported. (CVS 6191)

FossilOrigin-Name: 2d79aaab134c8a09722cb0466d45e04002bce54f

16 years agoRemove a harmless UMR that occurs inside some debugging code. (CVS 6190)
drh [Fri, 16 Jan 2009 23:47:42 +0000 (23:47 +0000)] 
Remove a harmless UMR that occurs inside some debugging code. (CVS 6190)

FossilOrigin-Name: 191c399fc6354b35477ec21f685377e2af26f49b

16 years agoFix a change-counter bug similar to #3584. This one is much more obscure though,...
danielk1977 [Fri, 16 Jan 2009 16:40:14 +0000 (16:40 +0000)] 
Fix a change-counter bug similar to #3584. This one is much more obscure though, requiring a transient IO or malloc error to occur while running in exclusive mode. (CVS 6189)

FossilOrigin-Name: 9f07d2d9226b73c4dc311fd142e0aaba4ffcb078

16 years agoRevert (6187). (CVS 6188)
danielk1977 [Fri, 16 Jan 2009 16:23:38 +0000 (16:23 +0000)] 
Revert (6187). (CVS 6188)

FossilOrigin-Name: a353c1ab376b159c4d12532412365318cdbdcc60

16 years agoThis commit is an error. Reverted by (6188). (CVS 6187)
danielk1977 [Fri, 16 Jan 2009 15:21:05 +0000 (15:21 +0000)] 
This commit is an error. Reverted by (6188). (CVS 6187)

FossilOrigin-Name: aa67fd0cdb4f53a0c6e15c001d37554d15006718

16 years agoAllow recently added keywords 'savepoint' and 'release' to be used as database object...
danielk1977 [Fri, 16 Jan 2009 11:04:58 +0000 (11:04 +0000)] 
Allow recently added keywords 'savepoint' and 'release' to be used as database object names. Just as they could be prior to 3.6.8. Ticket #3590. (CVS 6186)

FossilOrigin-Name: 54ab8326a1ea574b183f84c8465315e989a23ca4

16 years agoTreat "or" as an ANSI-C keyword, even though it is not. Ticket #3588. (CVS 6185)
drh [Thu, 15 Jan 2009 17:40:42 +0000 (17:40 +0000)] 
Treat "or" as an ANSI-C keyword, even though it is not.  Ticket #3588. (CVS 6185)

FossilOrigin-Name: ed4e308caaa50c55aa01cd34079f1be5c8a93c71

16 years agoVersion 3.6.10 (CVS 6184) version-3.6.10
drh [Thu, 15 Jan 2009 17:04:23 +0000 (17:04 +0000)] 
Version 3.6.10 (CVS 6184)

FossilOrigin-Name: 21b720cc9b9f88b8262c85c58287dd01486c936e

16 years agoDisable test case select2-2.0.3. This was a timing test that sometimes
drh [Thu, 15 Jan 2009 15:23:59 +0000 (15:23 +0000)] 
Disable test case select2-2.0.3.  This was a timing test that sometimes
fails due to CPU contention with other processes on the same host. (CVS 6183)

FossilOrigin-Name: ffdf91fec93aed35cf3dde1edbe9d7f8a5d23ae8

16 years agoAvoid using ENOTSUP on systems that do not define that symbol.
drh [Thu, 15 Jan 2009 04:30:02 +0000 (04:30 +0000)] 
Avoid using ENOTSUP on systems that do not define that symbol.
Ticket #3512. (CVS 6182)

FossilOrigin-Name: fcb6c677124102558f7a7a22bc3569b664424a4c

16 years agoMake some changes requested by Fedora. (CVS 6181)
drh [Wed, 14 Jan 2009 23:38:02 +0000 (23:38 +0000)] 
Make some changes requested by Fedora. (CVS 6181)

FossilOrigin-Name: 7bc08bc719c2e9ca6d92d4709c0478e15fdfb131

16 years agoFix the shell so that the ".schema" command works regardless of the
drh [Wed, 14 Jan 2009 23:17:55 +0000 (23:17 +0000)] 
Fix the shell so that the ".schema" command works regardless of the
pragma settings.  Ticket #3585. (CVS 6180)

FossilOrigin-Name: 6f6b638e44a8cfc741594f02b0178fa98ed7e2c1

16 years agoAdd asserts to detect if a transaction commits without first incrementing
drh [Wed, 14 Jan 2009 23:03:40 +0000 (23:03 +0000)] 
Add asserts to detect if a transaction commits without first incrementing
the transaction counter.  These asserts are intended to prevent future
problems similar to ticket #3584. (CVS 6179)

FossilOrigin-Name: b676ccfd9019e65b52251332d94de1b3018ec823

16 years agoFix typos in comments in FTS3 implementation. (CVS 6178)
drh [Wed, 14 Jan 2009 18:59:41 +0000 (18:59 +0000)] 
Fix typos in comments in FTS3 implementation. (CVS 6178)

FossilOrigin-Name: b0f066630c35c4947d3ecd29d32d91036da19e94

16 years agoIncrement the version number in preparation for yet another release. (CVS 6177)
drh [Wed, 14 Jan 2009 18:59:12 +0000 (18:59 +0000)] 
Increment the version number in preparation for yet another release. (CVS 6177)

FossilOrigin-Name: dce60ea764ae50f1008d178029eff5b3959eca38

16 years agoFix a problem with committing a transaction while there are other active statements...
danielk1977 [Wed, 14 Jan 2009 17:45:57 +0000 (17:45 +0000)] 
Fix a problem with committing a transaction while there are other active statements. Sometimes, the database change counter was not being updated. (CVS 6176)

FossilOrigin-Name: b7d2a477aa2c3dbbb81d18fba1faa6835711b5c3

16 years agoVersion 3.6.9 (CVS 6175)
drh [Wed, 14 Jan 2009 04:09:36 +0000 (04:09 +0000)] 
Version 3.6.9 (CVS 6175)

FossilOrigin-Name: b6ce8199a9286eb2d0a590abc8ef080594d84f83

16 years agoHere is the test case to prove that ticket #3581 is fixed. (CVS 6174)
drh [Wed, 14 Jan 2009 01:10:40 +0000 (01:10 +0000)] 
Here is the test case to prove that ticket #3581 is fixed. (CVS 6174)

FossilOrigin-Name: f5f5ef646bef6de6a744b565e089219d4e47397d

16 years agoMake sure the OR-clause optimizer takes the cost of sorting into account.
drh [Wed, 14 Jan 2009 00:55:09 +0000 (00:55 +0000)] 
Make sure the OR-clause optimizer takes the cost of sorting into account.
Reset the rowid cache on the OP_Rewind and OP_Last opcodes.  Bump the
version number so that we can do an emergency release.  Ticket #3581. (CVS 6173)

FossilOrigin-Name: d28b58209bf5eb575d0cad8dc71ac043395c6471

16 years agoUpdates to comments as suggested by tickets #3578 and #3579. (CVS 6172)
drh [Tue, 13 Jan 2009 20:14:15 +0000 (20:14 +0000)] 
Updates to comments as suggested by tickets #3578 and #3579. (CVS 6172)

FossilOrigin-Name: b5927213b6171e57018f1f265940c9bcc7a0ba04

16 years agoIf the journal file is open when unlocking the database, close it just before unlocki...
danielk1977 [Tue, 13 Jan 2009 16:03:44 +0000 (16:03 +0000)] 
If the journal file is open when unlocking the database, close it just before unlocking the database file instead of just after. This may fix #3572. (CVS 6171)

FossilOrigin-Name: 36fe9a7a51b5279f1a3964139aa636e81f9c8b06

16 years agoVersion 3.6.8 (CVS 6170)
drh [Mon, 12 Jan 2009 15:46:57 +0000 (15:46 +0000)] 
Version 3.6.8 (CVS 6170)

FossilOrigin-Name: 8ca0b7c13620c8e2acf73343ebfb13128dd4c3b1

16 years agoOnly run tests that depend on SQLITE_PREFER_PROXY_LOCKING builds when said symbol...
danielk1977 [Mon, 12 Jan 2009 14:01:45 +0000 (14:01 +0000)] 
Only run tests that depend on SQLITE_PREFER_PROXY_LOCKING builds when said symbol is set. (CVS 6169)

FossilOrigin-Name: 5d88f8be7342acd2a7ed6f269bec615cd03e59e2

16 years agoSometimes a single byte is written to the main database file. Make sure
drh [Sun, 11 Jan 2009 18:24:27 +0000 (18:24 +0000)] 
Sometimes a single byte is written to the main database file.  Make sure
that journaltest knows this. (CVS 6168)

FossilOrigin-Name: e0af5a43f3c6ae41042c74339e7404d3373fd6ce

16 years agoFix an assert() so that it works correctly with SQLITE_TEMP_STORE=3. (CVS 6167)
drh [Sun, 11 Jan 2009 17:00:02 +0000 (17:00 +0000)] 
Fix an assert() so that it works correctly with SQLITE_TEMP_STORE=3. (CVS 6167)

FossilOrigin-Name: fd2bbcf8d8d03eecd4614636ae787331a8e99816

16 years agoFix jrnlmode.test so that it does not run tests involving in-memory journals during...
danielk1977 [Sun, 11 Jan 2009 05:54:40 +0000 (05:54 +0000)] 
Fix jrnlmode.test so that it does not run tests involving in-memory journals during the "journaltest" permutation. (CVS 6166)

FossilOrigin-Name: b47ddefc772ee59aa1509ab8d8f229a3d7c4ddaf

16 years agoThe crash8.test depends on auto_vacuum being off. Make sure that is the
drh [Sun, 11 Jan 2009 00:44:47 +0000 (00:44 +0000)] 
The crash8.test depends on auto_vacuum being off.  Make sure that is the
case. (CVS 6165)

FossilOrigin-Name: 3538d2a981c5abfe2f88aec75175ae33475e6bcb

16 years agoIn io.test, reset the connection after manually deleting the journal file,
drh [Sun, 11 Jan 2009 00:42:02 +0000 (00:42 +0000)] 
In io.test, reset the connection after manually deleting the journal file,
so that the connection does not continue to use the old deleted journal file. (CVS 6164)

FossilOrigin-Name: 1e79f4f9e59469fb9e3e0007163de3e604dcf00f

16 years agoAdjust savepoint.test so that it can deal with SQLITE_TEMP_STORE=3. (CVS 6163)
drh [Sun, 11 Jan 2009 00:18:38 +0000 (00:18 +0000)] 
Adjust savepoint.test so that it can deal with SQLITE_TEMP_STORE=3. (CVS 6163)

FossilOrigin-Name: 3cb910f0ce116af3f291cb913b32abc89493bcc5

16 years agoDo not run crash8.test as part of the "journaltest" permutation. crash8.test uses...
danielk1977 [Sat, 10 Jan 2009 18:51:40 +0000 (18:51 +0000)] 
Do not run crash8.test as part of the "journaltest" permutation. crash8.test uses "PRAGMA synchronous=off", which is incompatible with journaltest. (CVS 6162)

FossilOrigin-Name: 5f184da6758327e0d5fefe61ac3be06a79cc8269

16 years agoRemove the unused Pager.alwaysRollback flag. Fix a couple of comments in pager.c...
danielk1977 [Sat, 10 Jan 2009 17:57:48 +0000 (17:57 +0000)] 
Remove the unused Pager.alwaysRollback flag. Fix a couple of comments in pager.c. (CVS 6161)

FossilOrigin-Name: 8f0672af8d7d46124d01e540eec7b43fc16dd552

16 years agoRemove an faulty assertion inserted a few days ago. (CVS 6160)
drh [Sat, 10 Jan 2009 17:02:02 +0000 (17:02 +0000)] 
Remove an faulty assertion inserted a few days ago. (CVS 6160)

FossilOrigin-Name: 495f017e03f32420e6a6a7685125a86929cef142

16 years agoWhen compiled with SQLITE_DEBUG (in other words, when assert() is enabled)
drh [Sat, 10 Jan 2009 16:15:20 +0000 (16:15 +0000)] 
When compiled with SQLITE_DEBUG (in other words, when assert() is enabled)
the ALWAYS and NEVER macros will throw an assertion if their arguments are
not true or false, respectively. (CVS 6159)

FossilOrigin-Name: 64a8dcd8d6152108809e4d10c459f1de5d36a435

16 years agoImprove coverage of pager.c. (CVS 6158)
danielk1977 [Sat, 10 Jan 2009 16:15:09 +0000 (16:15 +0000)] 
Improve coverage of pager.c. (CVS 6158)

FossilOrigin-Name: 855c4093cf331496d9ef508011ad814e91e3882f

16 years agoFix a bug caused by overzealous code test coverage simplifications.
drh [Sat, 10 Jan 2009 15:34:12 +0000 (15:34 +0000)] 
Fix a bug caused by overzealous code test coverage simplifications.
Bug found by TH3. (CVS 6157)

FossilOrigin-Name: 3da5578726cb22118dfca38a2098a1e378644387

16 years agoRemove some unused code from expr.c in order to increase test coverage. (CVS 6156)
drh [Sat, 10 Jan 2009 13:24:50 +0000 (13:24 +0000)] 
Remove some unused code from expr.c in order to increase test coverage. (CVS 6156)

FossilOrigin-Name: 2cbea64fb00a1b5b8aa0e9c958b2a09256ae59bc

16 years agoFix a bug in the previous commit - use SQL comments instead of Tcl comments in SQL...
danielk1977 [Sat, 10 Jan 2009 11:13:39 +0000 (11:13 +0000)] 
Fix a bug in the previous commit - use SQL comments instead of Tcl comments in SQL blocks. (CVS 6155)

FossilOrigin-Name: 3d7a8de248ad5fba0e9c88f439cd2d988dcbab8c

16 years agoAdd a malloc failure test case that covers a few previously untested lines in pager...
danielk1977 [Sat, 10 Jan 2009 11:10:18 +0000 (11:10 +0000)] 
Add a malloc failure test case that covers a few previously untested lines in pager.c (CVS 6154)

FossilOrigin-Name: 000aedb0471b5f5a69e7b61f5e1d4b2644994f32

16 years agoCoverage improvements in pragma.c. Change the __DARWIN__ macro to __APPLE__,
drh [Fri, 9 Jan 2009 21:41:17 +0000 (21:41 +0000)] 
Coverage improvements in pragma.c.  Change the __DARWIN__ macro to __APPLE__,
which is available by default on Leopard. (CVS 6153)

FossilOrigin-Name: 64c56226b91e57883c8059f65330318e53376b8a

16 years agoIncrease pager.c coverage a bit. Fix an assert failure that can occur following a...
danielk1977 [Fri, 9 Jan 2009 17:11:04 +0000 (17:11 +0000)] 
Increase pager.c coverage a bit. Fix an assert failure that can occur following a "PRAGMA omit_readlock" command on a read-only database. (CVS 6152)

FossilOrigin-Name: 0f3f9011fa143f7b63c9bf79d3e411327d5c6f9d

16 years agoFix two problems in test instrumentation that show up on some fulltests. (CVS 6151)
drh [Fri, 9 Jan 2009 14:29:35 +0000 (14:29 +0000)] 
Fix two problems in test instrumentation that show up on some fulltests. (CVS 6151)

FossilOrigin-Name: c917961743e9ab60a096801c8910c6cd8367ee2f

16 years agoSimplifications to btree.c to improve test coverage. (CVS 6150)
drh [Fri, 9 Jan 2009 14:11:04 +0000 (14:11 +0000)] 
Simplifications to btree.c to improve test coverage. (CVS 6150)

FossilOrigin-Name: ac84f106d572e881136adc3434d00d70564f57cb

16 years agoAdd a couple of coverage tests. (CVS 6149)
danielk1977 [Fri, 9 Jan 2009 10:49:14 +0000 (10:49 +0000)] 
Add a couple of coverage tests. (CVS 6149)

FossilOrigin-Name: 6a64109d1f9b63ac8b29ea2c77da02506387b4a1

16 years agoMore coverage improvements. (CVS 6148)
drh [Fri, 9 Jan 2009 02:49:31 +0000 (02:49 +0000)] 
More coverage improvements. (CVS 6148)

FossilOrigin-Name: 6e171c0a64850013b26a223189d5bebcc0a01a8b

16 years agoIncreased test coverage. (CVS 6147)
drh [Fri, 9 Jan 2009 01:12:27 +0000 (01:12 +0000)] 
Increased test coverage. (CVS 6147)

FossilOrigin-Name: 45bb5703d7ef5e835b43a6fa7ee2a2d96db76939

16 years agoIncreased test coverage in where.c. (CVS 6146)
drh [Thu, 8 Jan 2009 21:00:02 +0000 (21:00 +0000)] 
Increased test coverage in where.c. (CVS 6146)

FossilOrigin-Name: 1e5725c5179660277c2e8c321877d7ee3ca21808

16 years agoFix a comment in pager.c. No actual code changes. (CVS 6145)
danielk1977 [Thu, 8 Jan 2009 18:04:13 +0000 (18:04 +0000)] 
Fix a comment in pager.c. No actual code changes. (CVS 6145)

FossilOrigin-Name: 44d3bfddf44b10b3744db6b41bc3f53c3903df5e

16 years agoAvoid an 'invalid cast' warning in test_osinst.c. (CVS 6144)
danielk1977 [Thu, 8 Jan 2009 17:57:31 +0000 (17:57 +0000)] 
Avoid an 'invalid cast' warning in test_osinst.c. (CVS 6144)

FossilOrigin-Name: 931f3a21bd4b6c5760ed64c23e8210cf2c3e3ab5

16 years agoFix a couple of potential corruption problems in pager.c. (CVS 6143)
danielk1977 [Thu, 8 Jan 2009 17:50:45 +0000 (17:50 +0000)] 
Fix a couple of potential corruption problems in pager.c. (CVS 6143)

FossilOrigin-Name: 5a39525ba3e65f1c6df3cf23fbfb57f6a0bf4b62

16 years agoAdd a test script for ticket #2565. Change the assert() in pager.c into
drh [Thu, 8 Jan 2009 15:24:01 +0000 (15:24 +0000)] 
Add a test script for ticket #2565.  Change the assert() in pager.c into
a testcase() macro. (CVS 6142)

FossilOrigin-Name: 1e53e382e5030de4d908098bf77af053dd81f0c5

16 years agoAllow database files to be created in the root directory on unix.
drh [Thu, 8 Jan 2009 14:36:20 +0000 (14:36 +0000)] 
Allow database files to be created in the root directory on unix.
Ticket #3570. (CVS 6141)

FossilOrigin-Name: 81014334ad57e380e21c47ad6eebe9f16b4ad24c

16 years agoClean up test_journal.c to make it easier to follow. (CVS 6140)
danielk1977 [Thu, 8 Jan 2009 12:05:56 +0000 (12:05 +0000)] 
Clean up test_journal.c to make it easier to follow. (CVS 6140)

FossilOrigin-Name: 5a28c7c7b45655dcfd0da4898e77d0240b511c5f

16 years agoIncrease test coverage of where.c. Make sure OR-optimization works on
drh [Thu, 8 Jan 2009 03:11:19 +0000 (03:11 +0000)] 
Increase test coverage of where.c.  Make sure OR-optimization works on
UPDATE and DELETE in addition to SELECT.  (Bug found by coverage tests.) (CVS 6139)

FossilOrigin-Name: 4b2c08e8984befb12fa2173ca89d9f54cf764d22

16 years agoAdd new test cases to increase coverage of where.c. (CVS 6138)
drh [Wed, 7 Jan 2009 20:58:57 +0000 (20:58 +0000)] 
Add new test cases to increase coverage of where.c. (CVS 6138)

FossilOrigin-Name: 2e1ab51f05447f9c1f291636b53b1ec584003841

16 years agoFix a bug in the LIKE query optimization. (Found by coverage testing.) (CVS 6137)
drh [Wed, 7 Jan 2009 18:24:03 +0000 (18:24 +0000)] 
Fix a bug in the LIKE query optimization.  (Found by coverage testing.) (CVS 6137)

FossilOrigin-Name: fe90e9116b6e1e25cf3119d2777a8e9c135153ce

16 years agoMake the same change as (6121) (accidentally reverted). Also enhance test_journal...
danielk1977 [Wed, 7 Jan 2009 18:08:48 +0000 (18:08 +0000)] 
Make the same change as (6121) (accidentally reverted). Also enhance test_journal.c to catch this kind of bug. (CVS 6136)

FossilOrigin-Name: ccc9c211a285fd4da68b69e15594f080371be522

16 years agoAdd a "synchronous = off" variant to savepoint6.test. (CVS 6135)
danielk1977 [Wed, 7 Jan 2009 17:06:52 +0000 (17:06 +0000)] 
Add a "synchronous = off" variant to savepoint6.test. (CVS 6135)

FossilOrigin-Name: 0f57011e3b21fa5f6a819ce5a7fd8d44ea70679f

16 years agoChange SQLITE_MAX_FUNCTION_ARG from 100 to 127 to match invariant H16124. Ticket...
danielk1977 [Wed, 7 Jan 2009 16:15:42 +0000 (16:15 +0000)] 
Change SQLITE_MAX_FUNCTION_ARG from 100 to 127 to match invariant H16124. Ticket #3567. (CVS 6134)

FossilOrigin-Name: 1fe79ffd772900bdca85ec6cf072677be53cd5ff

16 years agoFor archival purposes, add the TCL script that was used to generate many
drh [Wed, 7 Jan 2009 15:52:54 +0000 (15:52 +0000)] 
For archival purposes, add the TCL script that was used to generate many
of the test cases for where7.test. (CVS 6133)

FossilOrigin-Name: 0e01cdc8d283acd2757d69bf6d8e36bb1f47d460

16 years agoConjecture: a journal header with nRec==0 must be the last header in the
drh [Wed, 7 Jan 2009 15:33:45 +0000 (15:33 +0000)] 
Conjecture: a journal header with nRec==0 must be the last header in the
journal.  Add asserts to make this conjecture explicit. (CVS 6132)

FossilOrigin-Name: 15b5b5f90c2ffa79155cdc2dbc4fb5583cb72017

16 years agoFix for 'truncate file' operations on in-memory databases. (CVS 6131)
danielk1977 [Wed, 7 Jan 2009 15:18:20 +0000 (15:18 +0000)] 
Fix for 'truncate file' operations on in-memory databases. (CVS 6131)

FossilOrigin-Name: 83d1eafbde556f56969c6f285b6767d2c658dbfc

16 years agoAdd a comment to the openSubjournal() function in pager.c. (CVS 6130)
danielk1977 [Wed, 7 Jan 2009 10:52:56 +0000 (10:52 +0000)] 
Add a comment to the openSubjournal() function in pager.c. (CVS 6130)

FossilOrigin-Name: 04387ae10ab3be24c93497f4af6f48d6832f37eb

16 years agoFix a problem with reverting a 'DROP TABLE' command executed inside of a savepoint...
danielk1977 [Wed, 7 Jan 2009 10:35:18 +0000 (10:35 +0000)] 
Fix a problem with reverting a 'DROP TABLE' command executed inside of a savepoint on an auto-vacuum database. (CVS 6129)

FossilOrigin-Name: 3a4bb83235e9a79297e7d5d47ac7674c9df960bf

16 years agoFix savepoint related bugs. A rollback caused by an IO error or "OR ROLLBACK" clause...
danielk1977 [Wed, 7 Jan 2009 08:12:16 +0000 (08:12 +0000)] 
Fix savepoint related bugs. A rollback caused by an IO error or "OR ROLLBACK" clause while one or more savepoints were open was leaving the sqlite3 structure in an invalid state. (CVS 6128)

FossilOrigin-Name: e5d42c69a3b325ca12f53184e33964230acbdd1f

16 years agoAdd a HIGHSTRESS parameter to the sqlite3_config_alt_pcache debugging
drh [Wed, 7 Jan 2009 03:59:47 +0000 (03:59 +0000)] 
Add a HIGHSTRESS parameter to the sqlite3_config_alt_pcache debugging
command in the test harness - to force calling pagerStress() more
frequently. (CVS 6127)

FossilOrigin-Name: e426860b94f5b47e3a265549dbac64a421cae425

16 years agoPager changes attempting to verify that ticket #2565 cannot recur. (CVS 6126)
drh [Wed, 7 Jan 2009 02:03:35 +0000 (02:03 +0000)] 
Pager changes attempting to verify that ticket #2565 cannot recur. (CVS 6126)

FossilOrigin-Name: 15b9dac455b3f457bb177fc4985b45957647cbec

16 years agoNow that we have permutations.test, it is really only necessary to run
drh [Tue, 6 Jan 2009 18:43:51 +0000 (18:43 +0000)] 
Now that we have permutations.test, it is really only necessary to run
all.test for a single cycle.  So make that the default. (CVS 6125)

FossilOrigin-Name: 3c2f292fb7c79ba9be32fe8f19e52b35b9cadf6a

16 years agoReduce the number of paths in btreeCopyFile(). (CVS 6124)
danielk1977 [Tue, 6 Jan 2009 18:21:08 +0000 (18:21 +0000)] 
Reduce the number of paths in btreeCopyFile(). (CVS 6124)

FossilOrigin-Name: df2c285cb99ac188c96dd1a4e6a30f689195a150

16 years agoModify test_journal.c to verify the page data being written to the journal file....
danielk1977 [Tue, 6 Jan 2009 17:52:43 +0000 (17:52 +0000)] 
Modify test_journal.c to verify the page data being written to the journal file. (CVS 6123)

FossilOrigin-Name: 0d258956f8971c0af7853b836a7d6e7f3a800c37

16 years agoCleanup of the PAGERTRACE macro. Other comment changes in pager.c. (CVS 6122)
drh [Tue, 6 Jan 2009 15:58:57 +0000 (15:58 +0000)] 
Cleanup of the PAGERTRACE macro.  Other comment changes in pager.c. (CVS 6122)

FossilOrigin-Name: ee7b4b60880e80e6fb0b2f93ebc6ee5ad6917f9d

16 years agoThe fix in (6120) wasn't quite right. This fixes it. (CVS 6121)
danielk1977 [Tue, 6 Jan 2009 15:28:34 +0000 (15:28 +0000)] 
The fix in (6120) wasn't quite right. This fixes it. (CVS 6121)

FossilOrigin-Name: ddc2ebfa529b15cdbdd3b6b6d4873cb085cfd3b9

16 years agoFix a recently introduced problem in "permutations.test autovacuum_crash". (CVS 6120)
danielk1977 [Tue, 6 Jan 2009 15:20:58 +0000 (15:20 +0000)] 
Fix a recently introduced problem in "permutations.test autovacuum_crash". (CVS 6120)

FossilOrigin-Name: 2cdbb468ed81d35a7e1a580683864de60e103083

16 years agoUpdate permutations.test so that it does not show an error when running
drh [Tue, 6 Jan 2009 14:50:11 +0000 (14:50 +0000)] 
Update permutations.test so that it does not show an error when running
the singlethread and multithread test cases on THREADSAFE=0 builds. (CVS 6119)

FossilOrigin-Name: 301b57b7bac949dd77037ad3175ba87c41c8c843

16 years agoFix a memory leak in test_journal.c (test code). Also remove function pager_truncate_...
danielk1977 [Tue, 6 Jan 2009 14:34:34 +0000 (14:34 +0000)] 
Fix a memory leak in test_journal.c (test code). Also remove function pager_truncate_cache(), a wrapper around sqlite3PCacheTruncate(), from pager.c. (CVS 6118)

FossilOrigin-Name: a64f3db0b39af53c8d8f80c242baa8aa4b5bd04e

16 years agoFix compiler warnings. (CVS 6117)
drh [Tue, 6 Jan 2009 14:19:36 +0000 (14:19 +0000)] 
Fix compiler warnings. (CVS 6117)

FossilOrigin-Name: da770a8dff183b28aca287cafb9c8b82b98ea968

16 years agoAdd some savepoint related test cases and fix a few problems. (CVS 6116)
danielk1977 [Tue, 6 Jan 2009 13:40:08 +0000 (13:40 +0000)] 
Add some savepoint related test cases and fix a few problems. (CVS 6116)

FossilOrigin-Name: 8c62ea4fded2251e9daf16f2a050f94359299d76

16 years agoRemove leftover "breakpoint" from the fuzz.test script. (CVS 6115)
drh [Tue, 6 Jan 2009 00:11:25 +0000 (00:11 +0000)] 
Remove leftover "breakpoint" from the fuzz.test script. (CVS 6115)

FossilOrigin-Name: c2482d8877a5f9e387b288377e410ae1b8267f3c

16 years agoFix a problem in the WHERE clause generator when the FROM clause is empty. (CVS 6114)
drh [Tue, 6 Jan 2009 00:08:02 +0000 (00:08 +0000)] 
Fix a problem in the WHERE clause generator when the FROM clause is empty. (CVS 6114)

FossilOrigin-Name: a7015625610624be1645e918d0a62cf85bec86ce

16 years agoThe fix in (6111) was not quite right. This version works better. (CVS 6113)
drh [Mon, 5 Jan 2009 22:30:38 +0000 (22:30 +0000)] 
The fix in (6111) was not quite right.  This version works better. (CVS 6113)

FossilOrigin-Name: 5f80140a2df48fd43a7cbc0990de0205004541b0

16 years agoReenable fuzz testing for all.test. Make sure the query flattener copies
drh [Mon, 5 Jan 2009 19:36:30 +0000 (19:36 +0000)] 
Reenable fuzz testing for all.test.  Make sure the query flattener copies
over aggregate information from expressions on outer query terms while
flattening. (CVS 6112)

FossilOrigin-Name: e02323b3629545a3e7e7db0d4edc76807ae903aa

16 years agoMake sure the MEM_Zero flags is cleared whenever removing MEM_Blob. (CVS 6111)
drh [Mon, 5 Jan 2009 18:02:27 +0000 (18:02 +0000)] 
Make sure the MEM_Zero flags is cleared whenever removing MEM_Blob. (CVS 6111)

FossilOrigin-Name: b2131e868a3a948ba81f7458270493085da1ae60