]> git.ipfire.org Git - thirdparty/sqlite.git/log
thirdparty/sqlite.git
6 years agoFix building the shell with SQLITE_OMIT_VIRTUAL_TABLE. And without SQLITE_ENABLE_DBPA... dbdata
dan [Sat, 27 Apr 2019 20:15:15 +0000 (20:15 +0000)] 
Fix building the shell with SQLITE_OMIT_VIRTUAL_TABLE. And without SQLITE_ENABLE_DBPAGE_VTAB.

FossilOrigin-Name: 425d708c3908fe74f69b62e6dd1722a0018088977e12f14b312dad1df0fbb804

6 years agoAdd comments and fix formatting issues in new code in shell.c.in.
dan [Sat, 27 Apr 2019 19:36:49 +0000 (19:36 +0000)] 
Add comments and fix formatting issues in new code in shell.c.in.

FossilOrigin-Name: b91d819bd16de43fc99e379da0ba9c915b0c5afc68e804a50c3c1662c1f9a740

6 years agoAdd the "--lost-and-found" option to the ".recover" command. For setting the name...
dan [Sat, 27 Apr 2019 18:47:03 +0000 (18:47 +0000)] 
Add the "--lost-and-found" option to the ".recover" command. For setting the name of the orphaned rows table.

FossilOrigin-Name: 67bb88e24c74d02ae0c4ac6ff2f873f6b0035ccefe5cccfc71c5686cbc76b4c3

6 years agoFix a problem in the .recover command with recovering WITHOUT ROWID tables where...
dan [Sat, 27 Apr 2019 15:35:45 +0000 (15:35 +0000)] 
Fix a problem in the .recover command with recovering WITHOUT ROWID tables where the PK columns are not the leftmost in the CREATE TABLE statement.

FossilOrigin-Name: 91df4b8e0386105d01614921e8410994b621404a3d46ec4af8687b8743c52d52

6 years agoHave .recover store all orphaned rows in a single table, with extra columns to indica...
dan [Fri, 26 Apr 2019 21:11:37 +0000 (21:11 +0000)] 
Have .recover store all orphaned rows in a single table, with extra columns to indicate the orphaned page and sub-tree they were discovered within.

FossilOrigin-Name: 7221f6e33ed6a5a96ec61e25f2a1f70b84aae66e503d897eb7b7ff1aec42355d

6 years agoFix another problem with database freelist handling in the ".recover" command.
dan [Fri, 26 Apr 2019 15:40:27 +0000 (15:40 +0000)] 
Fix another problem with database freelist handling in the ".recover" command.

FossilOrigin-Name: bee2652ac26370e612a8c81dd7554befc2d523442a2fbbc77dc73479e6a0d7fd

6 years agoFix a locking-page related problem with the ".recover" command.
dan [Fri, 26 Apr 2019 15:14:53 +0000 (15:14 +0000)] 
Fix a locking-page related problem with the ".recover" command.

FossilOrigin-Name: afdae10424f0f3d0f10a4b73e9732aa55c5ee664814d8ca0edd372cfb17c2445

6 years agoMerge latest trunk changes into this branch.
dan [Thu, 25 Apr 2019 20:06:34 +0000 (20:06 +0000)] 
Merge latest trunk changes into this branch.

FossilOrigin-Name: 1da302d85d7ad4ba54f877117a45d667439fd2ef31dc70ea1d54dc1fba196e68

6 years agoUnless the "--freelist-corrupt" option is specified, do not have the .recover command...
dan [Thu, 25 Apr 2019 19:23:15 +0000 (19:23 +0000)] 
Unless the "--freelist-corrupt" option is specified, do not have the .recover command attempt to recover data from pages that are on the database free-list.

FossilOrigin-Name: 8d2f52bb640d6d0f84b18d746043e56f45a73ace93239be1d036701f7f4018fd

6 years agoFix a bug preventing .recover from working on databases where the final page of the...
dan [Thu, 25 Apr 2019 16:20:40 +0000 (16:20 +0000)] 
Fix a bug preventing .recover from working on databases where the final page of the db is corrupt.

FossilOrigin-Name: 959bbd11e92cc789973daf20dfcb8a6d8dc724dd603b286cbdd59e5d1fdb2909

6 years agoImprove the performance of the .recover command.
dan [Wed, 24 Apr 2019 20:48:55 +0000 (20:48 +0000)] 
Improve the performance of the .recover command.

FossilOrigin-Name: a50768314d10d743a0cc013b434b516f0763e0a6c5b79655d8fefde7de53e869

6 years agoNew test cases in test/fuzzdata8.db.
drh [Wed, 24 Apr 2019 17:04:02 +0000 (17:04 +0000)] 
New test cases in test/fuzzdata8.db.

FossilOrigin-Name: 7be6222c9ec44596e4eddd906c831eb1272b90fbdf68641d791f216264feb7cf

6 years agoFix another instance in fts3 where a corrupt record can cause a buffer overflow.
dan [Wed, 24 Apr 2019 16:13:52 +0000 (16:13 +0000)] 
Fix another instance in fts3 where a corrupt record can cause a buffer overflow.

FossilOrigin-Name: e1724f1d618cfbcfd1e495d8965a395656cfc1114e1bffd4bc3be0bd5cdb6550

6 years agoFix a problem in fts5 where a corrupt position list could lead to a buffer overwrite.
dan [Wed, 24 Apr 2019 15:57:25 +0000 (15:57 +0000)] 
Fix a problem in fts5 where a corrupt position list could lead to a buffer overwrite.

FossilOrigin-Name: 516ca8945150bdc1363603e234be5f3f4a3861f581d7cc9455da3e87b9974309

6 years agoFix an error in fts3_write.c allowing a corrupt database to cause a crash.
dan [Wed, 24 Apr 2019 15:13:02 +0000 (15:13 +0000)] 
Fix an error in fts3_write.c allowing a corrupt database to cause a crash.

FossilOrigin-Name: 6e4a5f22811bcd1485e27073ec96821d448b91b6d1ff1659cc3772449d19a762

6 years agoCorrection to the #if in the previous check-in.
mistachkin [Wed, 24 Apr 2019 04:53:01 +0000 (04:53 +0000)] 
Correction to the #if in the previous check-in.

FossilOrigin-Name: 30dc05ac12910d318a737f8d7a0e895e5c42ff4c53472aeebc89f052eac05deb

6 years agoFix for 8-byte alignment asserts that can trigger in some circumstances with 32-bit...
mistachkin [Wed, 24 Apr 2019 00:37:11 +0000 (00:37 +0000)] 
Fix for 8-byte alignment asserts that can trigger in some circumstances with 32-bit MSVC.

FossilOrigin-Name: 4c02832e0c4351ced9d2391f09ee071c65a74b85a0509bf58f045afeb166f48c

6 years agoMake no atttempt to generate VDBE code for VACUUM after a syntax error.
drh [Tue, 23 Apr 2019 22:00:39 +0000 (22:00 +0000)] 
Make no atttempt to generate VDBE code for VACUUM after a syntax error.

FossilOrigin-Name: 930842470da27d72650033ef2c1df413e70f7c40eb46f91027b35f5ee156af38

6 years agoHave ".recover" handle "\r" and "\n" in the same way as ".dump".
dan [Tue, 23 Apr 2019 20:48:32 +0000 (20:48 +0000)] 
Have ".recover" handle "\r" and "\n" in the same way as ".dump".

FossilOrigin-Name: f95f0f02ab6c6cf45f25b613c7ab57f68249689d0a9eddf4c9518ddf0edad365

6 years agoFixes for the ".recover" shell command.
dan [Tue, 23 Apr 2019 18:03:02 +0000 (18:03 +0000)] 
Fixes for the ".recover" shell command.

FossilOrigin-Name: 8dcc1d89d955bf58c80a8c30a37960f0cf95719953951a92626cc332cc75ec60

6 years agoChanges to the --hexdb decoder option in the shell (and also in the TCL
drh [Tue, 23 Apr 2019 15:30:58 +0000 (15:30 +0000)] 
Changes to the --hexdb decoder option in the shell (and also in the TCL
test code) so that it works on systems where sscanf() does not recognize
"%hhx" as wanting to delivery results into a character-size variable.

FossilOrigin-Name: 4258e42d92b0113ba59f407197fc24f21734900e5b02952deed07818be3e3e5d

6 years agoMinor simplification of NULL value handling for STAT4.
mistachkin [Tue, 23 Apr 2019 15:08:11 +0000 (15:08 +0000)] 
Minor simplification of NULL value handling for STAT4.

FossilOrigin-Name: 69bad9257f8db6a2a761bdd298d972eb48d4f845ec11dedc802ba3bafb979915

6 years agoNew test cases in fuzzdata8.db.
drh [Tue, 23 Apr 2019 12:31:41 +0000 (12:31 +0000)] 
New test cases in fuzzdata8.db.

FossilOrigin-Name: 0fe3c3fd30294d15cdfe29e9c49f3c8968e864ec8a114282561642f75586ab09

6 years agoImprovement on the previous check-in. Parse.rc is less reliable than
drh [Tue, 23 Apr 2019 12:30:15 +0000 (12:30 +0000)] 
Improvement on the previous check-in.  Parse.rc is less reliable than
Parse.nErr for detecting SQLITE_TOOBIG errors.

FossilOrigin-Name: 8d478cfb92fdeb87591403fe1713b290fee309a38b71abee0002012935d1db98

6 years agoEnhance the ".recover" command. Fix a problem with overflow pages in dbdata.c.
dan [Mon, 22 Apr 2019 20:52:12 +0000 (20:52 +0000)] 
Enhance the ".recover" command. Fix a problem with overflow pages in dbdata.c.

FossilOrigin-Name: f193ca587f9e4f925f4f2343b0b07053bd6f93dd87fc6f8f41cf4479e90cf562

6 years agoEarly detection of SQLITE_TOOBIG when processing nested queries.
drh [Mon, 22 Apr 2019 20:05:54 +0000 (20:05 +0000)] 
Early detection of SQLITE_TOOBIG when processing nested queries.

FossilOrigin-Name: 5d85d80ef8b216639244c6f4e6a2c0050af3cf9c3998f372bae4a19c0430f2fd

6 years agoFix an assert() that may be false for corrupt databases.
dan [Mon, 22 Apr 2019 11:47:40 +0000 (11:47 +0000)] 
Fix an assert() that may be false for corrupt databases.

FossilOrigin-Name: b2ce5ed175cb5029ac07392ae371c86eeec23c74624aad007dee51cf359f3eeb

6 years agoAdd the ".recovery" command to the shell tool. For recovering the maximum amount...
dan [Sat, 20 Apr 2019 20:57:28 +0000 (20:57 +0000)] 
Add the ".recovery" command to the shell tool. For recovering the maximum amount data from corrupt databases. Still needs work.

FossilOrigin-Name: 7461d2e120f2149315ddac2676d51d7445bcdb8e97543effd9c30603517ef9da

6 years agoMark a single branch as no longer reachable.
drh [Fri, 19 Apr 2019 23:05:56 +0000 (23:05 +0000)] 
Mark a single branch as no longer reachable.

FossilOrigin-Name: 4f35b3b78a461b0617a5cd04f60d2ab277bcc7c994dae463851a3cb5d041a723

6 years agoIncrease the version number to 3.29 for the next development cycle.
drh [Fri, 19 Apr 2019 22:01:10 +0000 (22:01 +0000)] 
Increase the version number to 3.29 for the next development cycle.

FossilOrigin-Name: 6cf16703fd4a835c249c947006ae4a4bf81873c8ca1803945453c9845f882dc1

6 years agoImproved optimization of the AND and OR operators.
drh [Fri, 19 Apr 2019 17:26:19 +0000 (17:26 +0000)] 
Improved optimization of the AND and OR operators.

FossilOrigin-Name: 0fbd154eb419b57b9c064c1f47346835d6324388b966b73f8a0122de065f08b1

6 years agoFix a problem with renaming a table that starts with "sqlite". Fix for ticket [f00d7b65].
dan [Fri, 19 Apr 2019 16:34:22 +0000 (16:34 +0000)] 
Fix a problem with renaming a table that starts with "sqlite". Fix for ticket [f00d7b65].

FossilOrigin-Name: a2ead8aa4517b63cda7bf84464326e9cb5e228224caa603568c0e04ea44e6588

6 years agoUse macros to determine if an expression is always true or always false.
drh [Fri, 19 Apr 2019 16:21:51 +0000 (16:21 +0000)] 
Use macros to determine if an expression is always true or always false.

FossilOrigin-Name: 6de980a09c3a7adf71f2c9a63a242673b5e1f246e8ee071b26844275f0dad0fc

6 years agoStreamline the processing of the AND operator. Slightly smaller and faster.
drh [Fri, 19 Apr 2019 13:38:34 +0000 (13:38 +0000)] 
Streamline the processing of the AND operator.  Slightly smaller and faster.

FossilOrigin-Name: 7713996aa99ce6dd35b5a2db74dd26658fb8d9817169b2a7531cdef6edb41403

6 years agoAdd the sqlite_dbptr virtual table to the dbdata extension. For querying the links...
dan [Thu, 18 Apr 2019 21:14:11 +0000 (21:14 +0000)] 
Add the sqlite_dbptr virtual table to the dbdata extension. For querying the links between b-tree pages.

FossilOrigin-Name: 3213a15f2133afbb0a4fec3b8f6e0eeca8c0befafd6658c41074e84f589d5d32

6 years agoMinor simplification of NULL value handling for STAT4. nullStat4
mistachkin [Thu, 18 Apr 2019 19:21:19 +0000 (19:21 +0000)] 
Minor simplification of NULL value handling for STAT4.

FossilOrigin-Name: 5718a9d5fc3fdfc89db869501c81fda39b3ec5c7e11fa0038fc258e316f5d8a1

6 years agoAdd the experimental dbdata extension.
dan [Wed, 17 Apr 2019 21:17:22 +0000 (21:17 +0000)] 
Add the experimental dbdata extension.

FossilOrigin-Name: a3ab58832935e1399ecc7e4d8daefa3a6afa6b301792ce7176bc5d7c173510fb

6 years agoSmall performance and size optimization in sqlite3WalFindFrame().
drh [Wed, 17 Apr 2019 21:12:05 +0000 (21:12 +0000)] 
Small performance and size optimization in sqlite3WalFindFrame().

FossilOrigin-Name: 03f2e78899fad99b0a0951b3a408268276954d4cd785389ed9a0192c9217f6fe

6 years agoFix a typo in the CLI help output for the ".dump" command.
drh [Wed, 17 Apr 2019 13:58:07 +0000 (13:58 +0000)] 
Fix a typo in the CLI help output for the ".dump" command.

FossilOrigin-Name: 57638248de147efe8d663b3ae1389f590c7b2b7225ecfe295699d68c2893cd09

6 years agoIn the "pgidx" report from "showdb", also show the number of rows on each
drh [Wed, 17 Apr 2019 13:23:28 +0000 (13:23 +0000)] 
In the "pgidx" report from "showdb", also show the number of rows on each
database btree page.

FossilOrigin-Name: 2bda9dc41c07092ae37d0c6001c1271e0622bfff7151201fc2bb4c95422c087b

6 years agoIn the "pgidx" command of the showdb utility, try to identify orphaned pages
drh [Wed, 17 Apr 2019 12:29:45 +0000 (12:29 +0000)] 
In the "pgidx" command of the showdb utility, try to identify orphaned pages
and show when pages have been zeroed out.

FossilOrigin-Name: eed701ef919c70d891727250be6a1b626aeb894c562d221e319ae6d74fc71d3d

6 years agoSmall performance improvement on the variable-length integer decoder:
drh [Wed, 17 Apr 2019 12:07:08 +0000 (12:07 +0000)] 
Small performance improvement on the variable-length integer decoder:
sqlite3GetVarint().

FossilOrigin-Name: 5df2bf62fcd4dfdaa195062dddbd5ce5420bc239b2649ac8f547e0db34e7f0bb

6 years agoFaster and smaller implementation of sqlite3StrICmp().
drh [Wed, 17 Apr 2019 11:34:44 +0000 (11:34 +0000)] 
Faster and smaller implementation of sqlite3StrICmp().

FossilOrigin-Name: 7ac500fb5abfe1ad60f2ffdcc8fbe5ccc1c641bbeed53f00940e9ff78788e53d

6 years agoVersion 3.28.0 version-3.28.0
drh [Tue, 16 Apr 2019 19:49:53 +0000 (19:49 +0000)] 
Version 3.28.0

FossilOrigin-Name: 884b4b7e502b4e991677b53971277adfaf0a04a284f8e483e2553d0f83156b50

6 years agoAvoid a sanitizer error (pointer arithmatic overflow) in vdbesort.c.
dan [Tue, 16 Apr 2019 11:21:13 +0000 (11:21 +0000)] 
Avoid a sanitizer error (pointer arithmatic overflow) in vdbesort.c.

FossilOrigin-Name: af61a2fc45a0fa1277d7453779238b77de4c298a9f60714b7dc62ddca5874f80

6 years agoAvoid a sanitizer error in test1.c. Have releasetest.tcl/wapptest.tcl create a file...
dan [Tue, 16 Apr 2019 10:51:29 +0000 (10:51 +0000)] 
Avoid a sanitizer error in test1.c. Have releasetest.tcl/wapptest.tcl create a file called "makecommand.sh" that can be used to rerun a test from the command line.

FossilOrigin-Name: 4de4480ffdea1e923c4b964692ccde92d713c8b6c056bb04bddf1ff55ee891ec

6 years agoFix a bug in test module test_fs.c causing a segfault on OpenBSD.
dan [Mon, 15 Apr 2019 19:17:50 +0000 (19:17 +0000)] 
Fix a bug in test module test_fs.c causing a segfault on OpenBSD.

FossilOrigin-Name: ee886600297c2a03d9d1d10db88d3d107b48e5d4de5e5d91b0ab16cc7c447ede

6 years agoFix a problem with the user-auth extension and deserializing in-memory databases.
dan [Mon, 15 Apr 2019 15:41:33 +0000 (15:41 +0000)] 
Fix a problem with the user-auth extension and deserializing in-memory databases.

FossilOrigin-Name: 09fa0b3c4adf7f81a777975762029ad43dbdc76b02dc32d2307e1c42465213c9

6 years agoFix a test script problem in fts5corrupt3.test.
dan [Mon, 15 Apr 2019 13:59:08 +0000 (13:59 +0000)] 
Fix a test script problem in fts5corrupt3.test.

FossilOrigin-Name: 734192d876e0489cb34e454aaa4a9c6858145791a49959b31dee2917a8e41a7d

6 years agoUpdate tool/symbols.sh to ignore symbols from sessions and rebaser and to not
drh [Mon, 15 Apr 2019 13:51:27 +0000 (13:51 +0000)] 
Update tool/symbols.sh to ignore symbols from sessions and rebaser and to not
try to compile with ICU which is not available on all platforms.

FossilOrigin-Name: 0bab4ece6e81916d0f7255a8e553b8ca040cb8a96ab21e294212e232119f8ddc

6 years agoRemove a stray tab from the source code.
drh [Sun, 14 Apr 2019 00:40:29 +0000 (00:40 +0000)] 
Remove a stray tab from the source code.

FossilOrigin-Name: 0ada58e9303d53aba8bdc37abe5904aa40e91f80e247eb51cb1192387b0d661c

6 years agoFix an obsolete comment and other minor issues from code inspection.
drh [Sun, 14 Apr 2019 00:34:20 +0000 (00:34 +0000)] 
Fix an obsolete comment and other minor issues from code inspection.

FossilOrigin-Name: cd084427319394386844d6651479256a2fd57a412fccb79ba53172ce76693eb1

6 years agoFix a harmless compiler warning in test logic.
drh [Sat, 13 Apr 2019 16:50:21 +0000 (16:50 +0000)] 
Fix a harmless compiler warning in test logic.

FossilOrigin-Name: c3932e66040bf4c82727a26a976291fab219e8bc8a6d7579e19304538cc6df18

6 years agoFix the fts3varint.test script so that it works even on versions of TCL
drh [Sat, 13 Apr 2019 16:43:58 +0000 (16:43 +0000)] 
Fix the fts3varint.test script so that it works even on versions of TCL
for which Tcl_GetWideIntFromObj() does not work.

FossilOrigin-Name: 53f787ad298756027f630bfefade98b46f01539eb152f7e359b280335c77379e

6 years agoFix a test script problem in fts5corrupt3.test.
dan [Sat, 13 Apr 2019 16:35:02 +0000 (16:35 +0000)] 
Fix a test script problem in fts5corrupt3.test.

FossilOrigin-Name: 858f62274eb727109d0452ad2d80c0e0acab0f569494b1218c404501e103ed39

6 years agoPartially revert the test file changes in [4371a0c46e]. It is no longer required...
dan [Sat, 13 Apr 2019 15:07:00 +0000 (15:07 +0000)] 
Partially revert the test file changes in [4371a0c46e]. It is no longer required following [93ae382e97c23c90].

FossilOrigin-Name: 593a7e6e20a2f91fe3497edd7effad50ac876f7f03c9222e332dfeb43d26882e

6 years agoFix additional compiler warnings introduced by the previous check-in and found
drh [Sat, 13 Apr 2019 14:17:09 +0000 (14:17 +0000)] 
Fix additional compiler warnings introduced by the previous check-in and found
by MSVC.

FossilOrigin-Name: 6fc0deffa4eed902fd13eefe6d2765f338f3dadc5b29f7cae5064e135417746b

6 years agoFixes for harmless compiler warnings.
drh [Sat, 13 Apr 2019 14:07:57 +0000 (14:07 +0000)] 
Fixes for harmless compiler warnings.

FossilOrigin-Name: c28c973ad6debd63f13e5d4d3da036f680baaec9d863eda039f2747db9f1cfd5

6 years agoUse the 64-bit memory allocator interfaces in extensions, whenever possible.
drh [Sat, 13 Apr 2019 04:38:32 +0000 (04:38 +0000)] 
Use the 64-bit memory allocator interfaces in extensions, whenever possible.

FossilOrigin-Name: 07ee06fd390bfebebc014b47583d489747b0423bb96c810bed5c605ce0e3be71

6 years agoEnforce the SQLITE_LIMIT_COLUMN limit on virtual tables.
drh [Sat, 13 Apr 2019 04:01:12 +0000 (04:01 +0000)] 
Enforce the SQLITE_LIMIT_COLUMN limit on virtual tables.

FossilOrigin-Name: 0b6ae032c28e7fe34d81d1769f6e2901addbd1b95cd9a255dcef274061fb0164

6 years agoTest case changes so that they work with both Tcl8.6 and Tcl8.7.
drh [Fri, 12 Apr 2019 16:25:42 +0000 (16:25 +0000)] 
Test case changes so that they work with both Tcl8.6 and Tcl8.7.

FossilOrigin-Name: 7b771405a9adc3ec191156be4ebe7122f4c698d88d69ae2134c75acb8d8feebb

6 years agoTweaks to wapptest.tcl: Ensure that the "Debug" checkbox is disabled unless the app...
dan [Fri, 12 Apr 2019 13:40:54 +0000 (13:40 +0000)] 
Tweaks to wapptest.tcl: Ensure that the "Debug" checkbox is disabled unless the app is in "config" state, and have Debug variants run "test" instead of "fulltest".

FossilOrigin-Name: dd248c186a157b5ed60bbdae669b31237b8354c1a7e6ed64d377904043bd57ee

6 years agoFix minor problems in tcl test scripts.
dan [Fri, 12 Apr 2019 12:10:03 +0000 (12:10 +0000)] 
Fix minor problems in tcl test scripts.

FossilOrigin-Name: 56b664185e3e56ad22e0c16a5b946fc8204d4d33221b6b4269d6d650dfd9969c

6 years agoAdd the test/wapptest.tcl script, an alternative to releasetest.tcl that uses wapp...
dan [Thu, 11 Apr 2019 19:07:17 +0000 (19:07 +0000)] 
Add the test/wapptest.tcl script, an alternative to releasetest.tcl that uses wapp to provide the user-interface.

FossilOrigin-Name: edd87cd606ce264f181c16bbe889adeb8b27e90914f914c0f5d7b68c2dc2d7bd

6 years agoMerge trunk changes into this branch. wapptest
dan [Thu, 11 Apr 2019 19:04:01 +0000 (19:04 +0000)] 
Merge trunk changes into this branch.

FossilOrigin-Name: d805fc0cf1c4ef07a7bc947f75828931e3788d0e64730caab3b42ae58009a194

6 years agoFurther tweaks to wapptest.tcl. Add the ability to run the extra (n)debug tests that...
dan [Thu, 11 Apr 2019 19:03:15 +0000 (19:03 +0000)] 
Further tweaks to wapptest.tcl. Add the ability to run the extra (n)debug tests that releasetest.tcl runs.

FossilOrigin-Name: ec9c4f6d8da25dcc834812c2bb24bda1017833b1c572bdbbf87f0191e1310706

6 years agoRemove the vfslog.c extension from the testfixture target in main.mk, as
drh [Thu, 11 Apr 2019 17:06:54 +0000 (17:06 +0000)] 
Remove the vfslog.c extension from the testfixture target in main.mk, as
that extension has no TCL bindings and is inaccessible.

FossilOrigin-Name: d71f8bbc4efd8af935671c4e7626862d6e5a4c2e51527b9e82b2f0c94ddf6e93

6 years agoFix RBU so that it does not write rows that should be excluded into partial indexes...
dan [Thu, 11 Apr 2019 16:54:20 +0000 (16:54 +0000)] 
Fix RBU so that it does not write rows that should be excluded into partial indexes (corrupting the database).

FossilOrigin-Name: 31eb27f438ad727b095a518bfe0f7ed37cb806fc1e6929b821eddcc6cc9de260

6 years agoFix the checksymbols target in Makefile.in.
dan [Thu, 11 Apr 2019 06:50:52 +0000 (06:50 +0000)] 
Fix the checksymbols target in Makefile.in.

FossilOrigin-Name: 1956eb348170a9a873878b522f377fa7303cdb3beca41f5515b6b9da1b1f544d

6 years agoHave wapptest.tcl display the name, OS and architecture of the host.
dan [Wed, 10 Apr 2019 19:45:19 +0000 (19:45 +0000)] 
Have wapptest.tcl display the name, OS and architecture of the host.

FossilOrigin-Name: c47e53b4d0f29628bd20ba3daf7e759c4bfed07710d982c095445c01376d57f5

6 years agoVarious fixes for the wapptest.tcl script.
dan [Wed, 10 Apr 2019 18:56:30 +0000 (18:56 +0000)] 
Various fixes for the wapptest.tcl script.

FossilOrigin-Name: cbf423656047f0cb5200be6981a205e0ae206eef8263aa686f4a3621fb07fb57

6 years agoUpdate the list of OMIT options in the omittest.tcl script.
drh [Wed, 10 Apr 2019 18:29:40 +0000 (18:29 +0000)] 
Update the list of OMIT options in the omittest.tcl script.

FossilOrigin-Name: f294cfc173c5653ef161dbff63b7838dbccdcad797f5163c49b3173f9f35ab0f

6 years agoFurther refinement of the sqlite3VdbeMEmExpandBlob() fix of check-in
drh [Wed, 10 Apr 2019 13:24:35 +0000 (13:24 +0000)] 
Further refinement of the sqlite3VdbeMEmExpandBlob() fix of check-in
[df58774e994bd] to prevent a reference to an unused variable - problem
discovered by Valgrind.

FossilOrigin-Name: 09435b5700a2650816ad9ffa628be5fa19da62369c30329801feb5e840463c7e

6 years agoChange the name of some internal testing interfaces to avoid a name
drh [Wed, 10 Apr 2019 12:02:55 +0000 (12:02 +0000)] 
Change the name of some internal testing interfaces to avoid a name
conflict in AIX.

FossilOrigin-Name: c1cae7e7f0a612508c8f82b334d9ebc423f443e99b13092d52e26b348c7cbc5e

6 years agoDo not place arbitrary restrictions on the length of the failure message
drh [Wed, 10 Apr 2019 00:58:07 +0000 (00:58 +0000)] 
Do not place arbitrary restrictions on the length of the failure message
for a uniqueness constraint.

FossilOrigin-Name: 037da798fa5510ba7c776831ebcd683a85dca28e25bc657ff17bb2b08c3d406e

6 years agoNew test case for SQLITE_TOOBIG errors.
drh [Tue, 9 Apr 2019 21:37:27 +0000 (21:37 +0000)] 
New test case for SQLITE_TOOBIG errors.

FossilOrigin-Name: 4c77fbbe5d54248821161d708d0631fab65659bef31f95a61af681d4639f5918

6 years agoImproved reporting of SQLITE_TOOBIG errors while parsing.
drh [Tue, 9 Apr 2019 21:32:46 +0000 (21:32 +0000)] 
Improved reporting of SQLITE_TOOBIG errors while parsing.

FossilOrigin-Name: ea2d4b65e20e44e19219c821bf68e97ff3af1760b3b4762250d020ba2a5a6343

6 years agoFix a problem caused by a small SQLITE_LIMIT_LENGTH value and a CREATE TABLE with... toobig-fix
dan [Tue, 9 Apr 2019 20:50:44 +0000 (20:50 +0000)] 
Fix a problem caused by a small SQLITE_LIMIT_LENGTH value and a CREATE TABLE with a very large name.

FossilOrigin-Name: 9b5d408864920b302f2d21abcae1d90f1e0cd68b18262136554ba0e6219d6025

6 years agoAdd test/wapptest.tcl, a wapp alternative to releasetest.tcl.
dan [Tue, 9 Apr 2019 19:53:32 +0000 (19:53 +0000)] 
Add test/wapptest.tcl, a wapp alternative to releasetest.tcl.

FossilOrigin-Name: a4af0c2fee05aaa2e95ae6a5c847ff2d363e24f325f4ffdcf51bc264b9bf5e2d

6 years agoUse an unsigned integer to count free pages in btree.c:freePage2().
drh [Tue, 9 Apr 2019 01:26:31 +0000 (01:26 +0000)] 
Use an unsigned integer to count free pages in btree.c:freePage2().

FossilOrigin-Name: 8820408597341344b308277ce6ef41b47c7514d6c613520789b05ee52cbedae8

6 years agoMake the testcase() macro added in the previous check-in reachable for
drh [Sun, 7 Apr 2019 18:21:12 +0000 (18:21 +0000)] 
Make the testcase() macro added in the previous check-in reachable for
testing.

FossilOrigin-Name: 80704a16f6dbbeacc65fa36a3623df10292a28aeacf9e2c1d2891258479e3b89

6 years agoFix a faulty assert() in the sqlite3VdbeMemExpandBlob() routine.
drh [Sun, 7 Apr 2019 18:04:57 +0000 (18:04 +0000)] 
Fix a faulty assert() in the sqlite3VdbeMemExpandBlob() routine.

FossilOrigin-Name: df58774e994bd306b1a2e1f259e7e4408f01c5b1dc104673698168bbf8a63ce5

6 years agoFix two assert() statements in fts5 that are only true if the database is not corrupt.
dan [Sat, 6 Apr 2019 15:38:46 +0000 (15:38 +0000)] 
Fix two assert() statements in fts5 that are only true if the database is not corrupt.

FossilOrigin-Name: edb095a9a679c8c702abd0a487e55ed4b09110b54bcd7d5275020576f2713a39

6 years agoRemove some stale references to the addopcodes.tcl script from documentation.
drh [Fri, 5 Apr 2019 21:17:11 +0000 (21:17 +0000)] 
Remove some stale references to the addopcodes.tcl script from documentation.

FossilOrigin-Name: c0381b0bc90aa3c2415c4b3ac338cfe6d308bb5d4247bc6f2b6e919f549c254c

6 years agoEliminate the tool/addopcodes.tcl script. The purpose of that script was to
drh [Fri, 5 Apr 2019 20:56:46 +0000 (20:56 +0000)] 
Eliminate the tool/addopcodes.tcl script.  The purpose of that script was to
keep the number of parser codes below 256 in order to save parser table space.
But we have long since blown through that ceiling so the addopcodes.tcl script
was just needless complexity. There is no longer any reason to keep it around.

FossilOrigin-Name: d272819298083ebbde57962a2938925b1aaa1caf03e48bb3ea26ad91e0461d84

6 years agoAdd further tests so that veryquick.test covers all vdbe branches.
dan [Fri, 5 Apr 2019 20:47:15 +0000 (20:47 +0000)] 
Add further tests so that veryquick.test covers all vdbe branches.

FossilOrigin-Name: cbc67de5a3937fa65811ed7c13e870699c895660dc2132cf9d3cf5d83364e344

6 years agoImproved comment on the sqlite3FaultSim() function. No changes to code.
drh [Fri, 5 Apr 2019 17:22:50 +0000 (17:22 +0000)] 
Improved comment on the sqlite3FaultSim() function.  No changes to code.

FossilOrigin-Name: 08b29672c552e5a6a3874746c6cc7025295e0e44dec43a1bfba3022acce849ff

6 years agoIn the test_vfs.c VFS, if a Tcl xWrite script returns "SQLITE_OMIT", silently omit...
dan [Fri, 5 Apr 2019 16:52:45 +0000 (16:52 +0000)] 
In the test_vfs.c VFS, if a Tcl xWrite script returns "SQLITE_OMIT", silently omit the write() call.

FossilOrigin-Name: 8b5a621e2ee3bb9d7d4f905217872e7e59153be9477aaa626cea287d56710b5b

6 years agoAdd the ability to override the new corruption detection logic
drh [Fri, 5 Apr 2019 16:38:12 +0000 (16:38 +0000)] 
Add the ability to override the new corruption detection logic
of the previous checkin, in order to exercise downstream corruption
detection during testing.

FossilOrigin-Name: e859d3184606dd453b9fc4ee388922d7be4b61aad84a66ac82107935ffd56f3a

6 years agoIn the xfer-optimization, do early detection of when the source and destination
drh [Fri, 5 Apr 2019 15:44:55 +0000 (15:44 +0000)] 
In the xfer-optimization, do early detection of when the source and destination
index share the same btree, to avoid a long delay prior to reporting the
database corruption.

FossilOrigin-Name: af1e5873d44d31466023ae145bdfc6b4191eb48b62e5752c6e683bcf571980e7

6 years agoAdd further test cases to improve VDBE branch coverage.
dan [Thu, 4 Apr 2019 20:55:37 +0000 (20:55 +0000)] 
Add further test cases to improve VDBE branch coverage.

FossilOrigin-Name: 51a95e52fc58d8be2c9c51576dff7258c705735b66d203948f80db017b4c10d2

6 years agoFix a typo in the documentation for sqlite3_value_frombind(). Also add a new
drh [Thu, 4 Apr 2019 19:21:45 +0000 (19:21 +0000)] 
Fix a typo in the documentation for sqlite3_value_frombind().  Also add a new
hyperlink to that same documentation.  No code changes.

FossilOrigin-Name: bf3cd9364fdfc951feb04f78728eb8e0dae12b3dc5702a36bb6e69c0abab8864

6 years agoMinor fixes to requirements marks.
drh [Thu, 4 Apr 2019 18:20:25 +0000 (18:20 +0000)] 
Minor fixes to requirements marks.

FossilOrigin-Name: 02ebc60b9bbc1736f4989eb56f8d31ca97fe90c930841d10986c618381ceb8b4

6 years agoAdd test cases to improve coverage of VDBE branches. Still some to go.
dan [Thu, 4 Apr 2019 17:58:34 +0000 (17:58 +0000)] 
Add test cases to improve coverage of VDBE branches. Still some to go.

FossilOrigin-Name: 4cef609d61de272cfdc2b39e1d49c7cd56ec834086bd63095116ff98f4d402bd

6 years agoCorrectly initialize the loadable extension thunk.
drh [Thu, 4 Apr 2019 17:39:54 +0000 (17:39 +0000)] 
Correctly initialize the loadable extension thunk.

FossilOrigin-Name: 4fca46ded7873d4939d7c6bff363ded41667f2255a4ab624a1a24bebbae733eb

6 years agoSimplification of the recent VACUUM changes that make the code more like
drh [Thu, 4 Apr 2019 15:25:52 +0000 (15:25 +0000)] 
Simplification of the recent VACUUM changes that make the code more like
what it was before the change.  Also, make the VACUUM command a no-inline
procedure to work around a performance regression.

FossilOrigin-Name: 9cac5ac145d62117c918539baaa8a3c124230e031842e35fa1ba59f658c99518

6 years agoFix an incorrect comment on a test case for rowid renumbering in VACUUM.
drh [Thu, 4 Apr 2019 14:36:02 +0000 (14:36 +0000)] 
Fix an incorrect comment on a test case for rowid renumbering in VACUUM.

FossilOrigin-Name: 0d293fb43f2eb64026ac1e0422f54d4839b101898cc9913fc7746760c08ed41f

6 years agoOnly preserve rowid values for VACUUM INTO. Keep the legacy behavior of
drh [Thu, 4 Apr 2019 14:00:23 +0000 (14:00 +0000)] 
Only preserve rowid values for VACUUM INTO.  Keep the legacy behavior of
renumbering rowids for ordinary VACUUM.

FossilOrigin-Name: 13a0ea6466b051ea5281865ed5285b8b5a99ec4307f400c5f7b03692723f1cd1

6 years agoAdd a defense-in-depth NEVER() test to the WAL cleanup code.
drh [Wed, 3 Apr 2019 17:48:10 +0000 (17:48 +0000)] 
Add a defense-in-depth NEVER() test to the WAL cleanup code.

FossilOrigin-Name: 8d3af2010f4f652865f5c0d18e3bc793de05f8e75e75cc77786f61004b2ad28f

6 years agoFix a couple of problems with "RANGE BETWEEN <expr> PRECEDING AND <expr> PRECEDING...
dan [Wed, 3 Apr 2019 16:27:44 +0000 (16:27 +0000)] 
Fix a couple of problems with "RANGE BETWEEN <expr> PRECEDING AND <expr> PRECEDING" frames.

FossilOrigin-Name: 39225cc77579896214dceb93b7f224b4b3bc95b3505a2e19b41b0b18b184fbc4