]> git.ipfire.org Git - thirdparty/sqlite.git/log
thirdparty/sqlite.git
9 years agoTighter description of I/O stats in the shell. Show I/O stats on speedtest1.c.
drh [Sat, 27 Feb 2016 19:19:22 +0000 (19:19 +0000)] 
Tighter description of I/O stats in the shell.  Show I/O stats on speedtest1.c.

FossilOrigin-Name: f681d800340e0e710f73d0f7c09101f899249183

9 years agoEnhance the ".stats" command in sqlite3.exe to show one-time stats information
drh [Sat, 27 Feb 2016 17:12:36 +0000 (17:12 +0000)] 
Enhance the ".stats" command in sqlite3.exe to show one-time stats information
if invoked with one argument.  Also show /proc/PID/io information if run on
Linux.

FossilOrigin-Name: 3c36948f16b58fe8042c37d0df634308b4e48217

9 years agoFix a requirement mark to conform to a typo fix in the documentation.
drh [Sat, 27 Feb 2016 14:04:27 +0000 (14:04 +0000)] 
Fix a requirement mark to conform to a typo fix in the documentation.

FossilOrigin-Name: d1392c627934b89cdb86d82e73d56e8f76952b30

9 years agoEnhance documentation of sqlite3_snapshot_open() to explain that the database
drh [Sat, 27 Feb 2016 14:00:07 +0000 (14:00 +0000)] 
Enhance documentation of sqlite3_snapshot_open() to explain that the database
connection must have participated in at least one read operation prior to
the beginning of the transaction for which the snapshot is to be opened.
Add test cases for this fact.

FossilOrigin-Name: 33dd671cb9c17f08dbc61aed91e80eaeb84bfaf5

9 years agoAdd 'Replace.exe' to the MSVC clean target.
mistachkin [Sat, 27 Feb 2016 00:21:44 +0000 (00:21 +0000)] 
Add 'Replace.exe' to the MSVC clean target.

FossilOrigin-Name: c2277fab12d2aecf9e0f69683741a194df17e854

9 years agoFix typo in ICU error message.
mistachkin [Sat, 27 Feb 2016 00:21:16 +0000 (00:21 +0000)] 
Fix typo in ICU error message.

FossilOrigin-Name: 00c8fffd47cec763857389e1e91c026ba3179182

9 years agoMake sure the Replace.cs file is included in the autoconf tarball.
drh [Sat, 27 Feb 2016 00:07:18 +0000 (00:07 +0000)] 
Make sure the Replace.cs file is included in the autoconf tarball.

FossilOrigin-Name: b850df483d4dfc677ec61b119d8c1162b6a823d6

9 years agoSupport generating the '.def' file using the autoconf Makefile for MSVC.
mistachkin [Fri, 26 Feb 2016 23:13:16 +0000 (23:13 +0000)] 
Support generating the '.def' file using the autoconf Makefile for MSVC.

FossilOrigin-Name: 3617564cb630ed418badf43d2c0291c11c166d12

9 years agoFix a potential buffer overflow in the ICU upper() function.
drh [Fri, 26 Feb 2016 21:20:57 +0000 (21:20 +0000)] 
Fix a potential buffer overflow in the ICU upper() function.

FossilOrigin-Name: b8dc1b9f5d413000387bfe784b69f5d0ee5c0489

9 years agoFurther refinements to the MSVC batch build process.
mistachkin [Fri, 26 Feb 2016 21:03:16 +0000 (21:03 +0000)] 
Further refinements to the MSVC batch build process.

FossilOrigin-Name: cf4e4fbdb6a29b7fbd5150958ab4f8f2a1cd7f21

9 years agoFurther refinements to the MSVC batch build process.
mistachkin [Fri, 26 Feb 2016 21:01:37 +0000 (21:01 +0000)] 
Further refinements to the MSVC batch build process.

FossilOrigin-Name: 4e54e9c0fefe417f94a2d95921acf61b1dda5ca4

9 years agoFix the ICU extension LIKE function so that it does not read past the end of a buffer...
dan [Fri, 26 Feb 2016 16:03:29 +0000 (16:03 +0000)] 
Fix the ICU extension LIKE function so that it does not read past the end of a buffer if it it passed malformed utf-8.

FossilOrigin-Name: 424b7aee3310b9782bd312589dc3d9f287aa04b8

9 years agoProvide the new SQLITE_DBCONFIG_ENABLE_FTS3_TOKENIZER option to
drh [Fri, 26 Feb 2016 15:38:24 +0000 (15:38 +0000)] 
Provide the new SQLITE_DBCONFIG_ENABLE_FTS3_TOKENIZER option to
sqlite3_db_config() that can be used to activate the two-argument version
of fts3_tokenizer() for a specific database connection at run-time.

FossilOrigin-Name: 374b5108087a2eae03676c0f3469b37a272145bf

9 years agoFix a typo in a comment (though an important comment in that it is used
drh [Fri, 26 Feb 2016 13:22:21 +0000 (13:22 +0000)] 
Fix a typo in a comment (though an important comment in that it is used
to generate documentation).

FossilOrigin-Name: ff3d7f845e1875d6729f64f5231db1c376892f31

9 years agoEphemeral tables used to hold manifested views may not be unordered since
drh [Fri, 26 Feb 2016 04:13:39 +0000 (04:13 +0000)] 
Ephemeral tables used to hold manifested views may not be unordered since
they might be subject to an ordered comparison if they are part of a join.

FossilOrigin-Name: 3ef6a3153267d5328202fea24fd29ff4d5409295

9 years agoRemove a debuggin "exit" command mistakenly left in the "where.test" module.
drh [Fri, 26 Feb 2016 04:04:07 +0000 (04:04 +0000)] 
Remove a debuggin "exit" command mistakenly left in the "where.test" module.

FossilOrigin-Name: beda0b8c76c2c7328a44156257c978cf8f5df59b

9 years agoAdd some comments in the VSIX test tool.
mistachkin [Thu, 25 Feb 2016 23:27:02 +0000 (23:27 +0000)] 
Add some comments in the VSIX test tool.

FossilOrigin-Name: c871473ffee6dbb0f5b47f1c1329c84b902368ae

9 years agoAdd tool for smoke-testing the UWP VSIX package.
mistachkin [Thu, 25 Feb 2016 23:25:00 +0000 (23:25 +0000)] 
Add tool for smoke-testing the UWP VSIX package.

FossilOrigin-Name: d27f32c6d72182198ae6d6cf8e385be76335dc65

9 years agoEnhance checking of prerequisites in the vsixtest tool. vsixTest
mistachkin [Thu, 25 Feb 2016 23:22:26 +0000 (23:22 +0000)] 
Enhance checking of prerequisites in the vsixtest tool.

FossilOrigin-Name: 799d5f09ed058898167e43bd9c8d1bf8c5df23ba

9 years agoFix an incorrect cost computation for sorting (introduced just a few
drh [Thu, 25 Feb 2016 23:21:41 +0000 (23:21 +0000)] 
Fix an incorrect cost computation for sorting (introduced just a few
check-ins ago).  Should be NlogN, not NloglogN.

FossilOrigin-Name: 2459d3238853951bc3a507dd975e7ec921cf8446

9 years agoSmall optimization in FK handling.
mistachkin [Thu, 25 Feb 2016 21:38:28 +0000 (21:38 +0000)] 
Small optimization in FK handling.

FossilOrigin-Name: e0d25913b73a813f5987aa70b364b00f19351663

9 years agoChange the srcck1.c utility program to use only unsigned characters.
drh [Thu, 25 Feb 2016 21:27:03 +0000 (21:27 +0000)] 
Change the srcck1.c utility program to use only unsigned characters.

FossilOrigin-Name: d64d005eb5df2e3eb1248fc8eff8b1b683e48c74

9 years agoChange the "PRAGMA stats" command to report size values in LogEst units.
drh [Thu, 25 Feb 2016 21:19:03 +0000 (21:19 +0000)] 
Change the "PRAGMA stats" command to report size values in LogEst units.
The eliminates the need for sqlite3LogEstToInt() unless non-standard
compile-time options are used, so leave it out except in those cases.

FossilOrigin-Name: 832c237fcbe83dd4f5a18a06acb0aeb7e2b9e712

9 years agoDisable the RESTRICT foreign key action if "PRAGMA defer_foreign_keys" is set.
dan [Thu, 25 Feb 2016 20:17:55 +0000 (20:17 +0000)] 
Disable the RESTRICT foreign key action if "PRAGMA defer_foreign_keys" is set.

FossilOrigin-Name: 9ffff484bb4b67c29dda6180d7d766ad13988fe1

9 years agoQuery planner improvements: Take the LIMIT into account when estimated the
drh [Thu, 25 Feb 2016 18:40:18 +0000 (18:40 +0000)] 
Query planner improvements:  Take the LIMIT into account when estimated the
cost of an ORDER BY.  Avoid automatic indexes on query loops that are expected
to run less than twice.

FossilOrigin-Name: bf46179d4484376909dce40ffcc06fecb19b3544

9 years agoImprovement on the previous check-in: disallow automatic indexes for any planner-improvements
drh [Thu, 25 Feb 2016 18:22:09 +0000 (18:22 +0000)] 
Improvement on the previous check-in:  disallow automatic indexes for any
loop that is expected to run less than twice.

FossilOrigin-Name: aab53a21894ba51d325fd8f8f4bb4163ece74391

9 years agoDo not use an automatic index on an outer loop that only runs once.
drh [Thu, 25 Feb 2016 18:03:38 +0000 (18:03 +0000)] 
Do not use an automatic index on an outer loop that only runs once.

FossilOrigin-Name: 5957e793414ff80ed01a7a67e70c3fd096a3f6e0

9 years agoTake the LIMIT clause into account when estimating the cost of sorting.
drh [Thu, 25 Feb 2016 16:04:59 +0000 (16:04 +0000)] 
Take the LIMIT clause into account when estimating the cost of sorting.

FossilOrigin-Name: d491745cab951e0de70f1f79b7640ea8aff6e8bb

9 years agoIn the command-line shell: When the ".import" command is creating a new
drh [Thu, 25 Feb 2016 13:33:02 +0000 (13:33 +0000)] 
In the command-line shell:  When the ".import" command is creating a new
table using column names from the first row of CSV input, make sure
double-quotes in the name are properly escaped.

FossilOrigin-Name: 2e67a1c823c7003e7d2619c7d8b6db6ce046c527

9 years agoImprove readability and logging of the vsixtest script.
mistachkin [Thu, 25 Feb 2016 08:02:16 +0000 (08:02 +0000)] 
Improve readability and logging of the vsixtest script.

FossilOrigin-Name: 4fe7c4e90b7adbb1630b4aa15709968a1fcc7d83

9 years agoEnable all steps and add/update comments.
mistachkin [Thu, 25 Feb 2016 02:56:53 +0000 (02:56 +0000)] 
Enable all steps and add/update comments.

FossilOrigin-Name: 788f99f47f40be42f30d3f324983f39e84d8cfbb

9 years agoMore work. Install and build steps are now tested.
mistachkin [Thu, 25 Feb 2016 02:49:58 +0000 (02:49 +0000)] 
More work.  Install and build steps are now tested.

FossilOrigin-Name: 0ab74373bd37d48d6afa7aecb67885afcd3a85b1

9 years agoFix typo. Improve interim debugging.
mistachkin [Wed, 24 Feb 2016 23:31:14 +0000 (23:31 +0000)] 
Fix typo.  Improve interim debugging.

FossilOrigin-Name: e0029bdf20df90abd8b81e5b08133866665b1c87

9 years agoTest build all supported configurations and platforms during VSIX testing.
mistachkin [Wed, 24 Feb 2016 23:25:23 +0000 (23:25 +0000)] 
Test build all supported configurations and platforms during VSIX testing.

FossilOrigin-Name: cce40a0b8ee792482fb7031113eb190ad316d01a

9 years agoInitial work on an automated VSIX testing tool. Not working or tested yet.
mistachkin [Wed, 24 Feb 2016 21:42:03 +0000 (21:42 +0000)] 
Initial work on an automated VSIX testing tool.  Not working or tested yet.

FossilOrigin-Name: 496e4ac984b2548dd5f2f969cd34656b586cfcfe

9 years agoExtend [3e9ed1ae] so that covering indexes on WITHOUT ROWID tables are also identified.
dan [Wed, 24 Feb 2016 20:16:28 +0000 (20:16 +0000)] 
Extend [3e9ed1ae] so that covering indexes on WITHOUT ROWID tables are also identified.

FossilOrigin-Name: e721975faa0925be4029330550ff2a9666041ff7

9 years agoChange a char* to const char* in order to suppress some harmless
drh [Wed, 24 Feb 2016 19:57:11 +0000 (19:57 +0000)] 
Change a char* to const char* in order to suppress some harmless
compiler warnings.

FossilOrigin-Name: 56f62e34ae9d5c7db07367f0007df258b2e76bd2

9 years agoWhen an index complete covers a table, it can be used as a covering index
drh [Wed, 24 Feb 2016 17:18:51 +0000 (17:18 +0000)] 
When an index complete covers a table, it can be used as a covering index
even if columns past the 63rd column are indexed and accessed.

FossilOrigin-Name: 3e9ed1aea43e8ce2eb74bb845ea2c05b5882e36e

9 years agoFix a problem with handling identifiers that start with "x" if SQLITE_OMIT_BLOB_LITER...
dan [Wed, 24 Feb 2016 16:14:07 +0000 (16:14 +0000)] 
Fix a problem with handling identifiers that start with "x" if SQLITE_OMIT_BLOB_LITERAL is defined.

FossilOrigin-Name: b65217c69c59cbe9cd1494e2eb42ecf22c336399

9 years agoIdentify indexes that complete cover their table. covering-index
drh [Wed, 24 Feb 2016 15:43:05 +0000 (15:43 +0000)] 
Identify indexes that complete cover their table.

FossilOrigin-Name: 71d488b599cbde817de369efac4412569a55b43d

10 years agoAdd the SQLITE_BITMASK_TYPE compile-time option.
drh [Tue, 23 Feb 2016 16:28:34 +0000 (16:28 +0000)] 
Add the SQLITE_BITMASK_TYPE compile-time option.

FossilOrigin-Name: 0064a8c77b2b048c71277d1cfd1ba3975b513b70

10 years agoRemove code not needed now that synchronous=OFF database files no longer
drh [Mon, 22 Feb 2016 23:44:42 +0000 (23:44 +0000)] 
Remove code not needed now that synchronous=OFF database files no longer
trigger the use of a master journal.

FossilOrigin-Name: aa9f4c622af191edbeb6a535942944f8c91f5c37

10 years agoAvoid an unnecessary seek operation some corner-case skip-scan operations.
drh [Mon, 22 Feb 2016 23:14:11 +0000 (23:14 +0000)] 
Avoid an unnecessary seek operation some corner-case skip-scan operations.

FossilOrigin-Name: 2a6003a937a210dfc279e393d3a0b49d1f3ac92e

10 years agoClearer presentation of the logic. No functional changes. skip-scan-improvement
drh [Mon, 22 Feb 2016 21:19:54 +0000 (21:19 +0000)] 
Clearer presentation of the logic.  No functional changes.

FossilOrigin-Name: a3dcf6db76cc09bdfedb1bbeba3b359b77762cbe

10 years agoAvoid an unnecessary seek operation on some corner-case skip-scans.
drh [Mon, 22 Feb 2016 20:52:26 +0000 (20:52 +0000)] 
Avoid an unnecessary seek operation on some corner-case skip-scans.

FossilOrigin-Name: 38e837e605076124b73235e1fd832838d9545cb2

10 years agoAlways use the sqlite3VdbeDeleteAuxdata() routine for clearing auxdata on
drh [Mon, 22 Feb 2016 16:04:31 +0000 (16:04 +0000)] 
Always use the sqlite3VdbeDeleteAuxdata() routine for clearing auxdata on
function parameter, rather than having a separate deleteAuxdataFromFrame()
for doing the job for trigger frames.

FossilOrigin-Name: 64386fa339adb91439da979d74062f67a6ec68fd

10 years agoAvoid creating a master journal unless two or more databases in the
drh [Mon, 22 Feb 2016 14:57:38 +0000 (14:57 +0000)] 
Avoid creating a master journal unless two or more databases in the
transaction can actually benefit from that master journal.

FossilOrigin-Name: 3ed1890612bd45bd9c72f670d2cbb0b8fbd35d92

10 years agoChange magic numbers associated with synchronous settings to named constants.
drh [Mon, 22 Feb 2016 13:23:16 +0000 (13:23 +0000)] 
Change magic numbers associated with synchronous settings to named constants.

FossilOrigin-Name: 9230ba6c01f4a550d92a0cbbf36dbe81af14fbfc

10 years agoAdd an extra test case for the change in commit [c4295725].
dan [Mon, 22 Feb 2016 09:45:27 +0000 (09:45 +0000)] 
Add an extra test case for the change in commit [c4295725].

FossilOrigin-Name: a48ac4c347813bd2b416b1cb06c3cbf1f4b3781a

10 years agoFurther enhancements to the MSVC batch build tool.
mistachkin [Fri, 19 Feb 2016 19:46:58 +0000 (19:46 +0000)] 
Further enhancements to the MSVC batch build tool.

FossilOrigin-Name: 06f1495f4b7465e3992f524f56d97847643a9895

10 years agoUse the arguments to NMAKE consistently in the MSVC batch build tool.
mistachkin [Fri, 19 Feb 2016 19:29:44 +0000 (19:29 +0000)] 
Use the arguments to NMAKE consistently in the MSVC batch build tool.

FossilOrigin-Name: 480e5049486b8b047f533d78b040daa47dd6b946

10 years agoEnhance clean target in the MSVC makefiles.
mistachkin [Fri, 19 Feb 2016 19:03:04 +0000 (19:03 +0000)] 
Enhance clean target in the MSVC makefiles.

FossilOrigin-Name: 66a9ad4a6df513f4c35c3d337d4e2e80cd38d586

10 years agoUse a separate list of aux-data structures for each trigger program at the VDBE level...
dan [Fri, 19 Feb 2016 18:54:29 +0000 (18:54 +0000)] 
Use a separate list of aux-data structures for each trigger program at the VDBE level. Fix for [dc9b1c91].

FossilOrigin-Name: c4295725015d394f01b8563f47236e0890f1cc0d

10 years agoEnhance speedtest1 to display the particular version of SQLite under test.
drh [Fri, 19 Feb 2016 16:19:23 +0000 (16:19 +0000)] 
Enhance speedtest1 to display the particular version of SQLite under test.

FossilOrigin-Name: 0cb728c15c66f1bf09cc1e0731a95ba937c6c71c

10 years agoFix a couple of harmless warnings generated by clang.
drh [Fri, 19 Feb 2016 15:17:53 +0000 (15:17 +0000)] 
Fix a couple of harmless warnings generated by clang.

FossilOrigin-Name: a1a3ff1f53145c5a9fbf29398cf4a453729e71f0

10 years agoFix a harmless uninitialized variable access.
drh [Fri, 19 Feb 2016 14:20:46 +0000 (14:20 +0000)] 
Fix a harmless uninitialized variable access.

FossilOrigin-Name: 398522e686b34e7f82a62e62d8b0a0ea924de064

10 years agoMake sure WhereClause objects are fully initialized before use when
drh [Fri, 19 Feb 2016 14:10:44 +0000 (14:10 +0000)] 
Make sure WhereClause objects are fully initialized before use when
planning OR queries.

FossilOrigin-Name: 162053021795ff40c447498a76de4d31d58aa808

10 years agoFix (harmless) compiler warnings in some of the TCL-based test code.
drh [Fri, 19 Feb 2016 13:29:52 +0000 (13:29 +0000)] 
Fix (harmless) compiler warnings in some of the TCL-based test code.

FossilOrigin-Name: 7c26d2b47025edaa289bd4a383b5c1536482ec11

10 years agoAdd an SQLITE_DISABLE_INTRINSIC #ifdef to the sqlite3Put4Byte() function.
drh [Fri, 19 Feb 2016 13:20:02 +0000 (13:20 +0000)] 
Add an SQLITE_DISABLE_INTRINSIC #ifdef to the sqlite3Put4Byte() function.

FossilOrigin-Name: ba9c6827d0890aaed9168c221fefbdbe89f4f9d3

10 years agoOmit the unused yyzerominor constant.
drh [Fri, 19 Feb 2016 13:19:22 +0000 (13:19 +0000)] 
Omit the unused yyzerominor constant.

FossilOrigin-Name: 60ad68a9f569d2446d76a6453be4fa1c4ed2cd93

10 years agoAdd an "#ifndef SQLITE_AMALGAMATION" guard around a typedef in fts5_test_mi.c to...
dan [Fri, 19 Feb 2016 10:18:36 +0000 (10:18 +0000)] 
Add an "#ifndef SQLITE_AMALGAMATION" guard around a typedef in fts5_test_mi.c to avoid redefining "u32" if it is compiled as part of the amalgamation.

FossilOrigin-Name: f9c49ba1edf13cb8c48d73f1b2e3f80c46b3c030

10 years agoModify the MSVC batch build tool to support the MSVC autoconf Makefile.
mistachkin [Fri, 19 Feb 2016 05:07:56 +0000 (05:07 +0000)] 
Modify the MSVC batch build tool to support the MSVC autoconf Makefile.

FossilOrigin-Name: 72b10e5e7d2db436c7b03cc3735a2e9d0e53ab5d

10 years agoFurther improvements to the MSVC batch build tool.
mistachkin [Fri, 19 Feb 2016 00:48:23 +0000 (00:48 +0000)] 
Further improvements to the MSVC batch build tool.

FossilOrigin-Name: b9626b5954068ae2e7733dd14f906a1f6d7090a5

10 years agoFurther improvements to the MSVC batch build tool.
mistachkin [Fri, 19 Feb 2016 00:47:18 +0000 (00:47 +0000)] 
Further improvements to the MSVC batch build tool.

FossilOrigin-Name: 90dd6eb1fec22460473d670519d0e730bb37067d

10 years agoCorrect the install location for the UWP VSIX package.
mistachkin [Thu, 18 Feb 2016 21:15:12 +0000 (21:15 +0000)] 
Correct the install location for the UWP VSIX package.

FossilOrigin-Name: f74de325ffb01a1ca8ddd4f011188e38296c3402

10 years agoCorrect the install location for the UWP VSIX package.
mistachkin [Thu, 18 Feb 2016 21:00:29 +0000 (21:00 +0000)] 
Correct the install location for the UWP VSIX package.

FossilOrigin-Name: b47d03027e973e3c8d77246a2d2100881f6a9bd2

10 years agoAvoid a potential buffer overrun if an SQL statement being parsed ends
drh [Thu, 18 Feb 2016 14:49:28 +0000 (14:49 +0000)] 
Avoid a potential buffer overrun if an SQL statement being parsed ends
with an illegal "!" token.  (This problem was detected by fuzzcheck
running under valgrind. The problem was introduced by check-in [9570b6b43df3].)

FossilOrigin-Name: 2a8d97e7c8976df0312e1294e8c1da8b15686654

10 years agoImproved handling of the -v option on the fuzzcheck test program.
drh [Thu, 18 Feb 2016 14:03:15 +0000 (14:03 +0000)] 
Improved handling of the -v option on the fuzzcheck test program.

FossilOrigin-Name: c8cd7804dc905b2b20cd7c0192bcfaceaaa7e2a8

10 years agoRemove an unnecessary "include <tcl.h>" line from fts5_test_mi.c.
dan [Thu, 18 Feb 2016 13:32:34 +0000 (13:32 +0000)] 
Remove an unnecessary "include <tcl.h>" line from fts5_test_mi.c.

FossilOrigin-Name: 31d8b69e9e0747e573516570bfe2770384e99134

10 years agoAdd extra API armor on the sqlite3_bind_blob() interface.
drh [Thu, 18 Feb 2016 01:29:12 +0000 (01:29 +0000)] 
Add extra API armor on the sqlite3_bind_blob() interface.

FossilOrigin-Name: 80de1ad5eb4c3839756b6467d5b8195b4abfb1f8

10 years agoWhen VDBE opcodes fail, they cause an immediate exit from the loop, rather
drh [Wed, 17 Feb 2016 20:47:24 +0000 (20:47 +0000)] 
When VDBE opcodes fail, they cause an immediate exit from the loop, rather
than depending on the rc==SQLITE_OK test at the top of the loop.  This is
faster and smaller.

FossilOrigin-Name: 24c7151c1aabeaffcb8bb5836404e70a3ec4681b

10 years agoFix up all VDBE opcodes so that they cause an immediate exit on any kind of vdbe-performance
drh [Wed, 17 Feb 2016 18:44:11 +0000 (18:44 +0000)] 
Fix up all VDBE opcodes so that they cause an immediate exit on any kind of
error, and thereby eliminate the need to test "rc" at the top of the loop.
Resulting code is a little smaller and faster.

FossilOrigin-Name: a444633a827642bcf4d02a461e7e5f66769d39fd

10 years agoBump the version number to 3.12.0.
drh [Wed, 17 Feb 2016 15:01:18 +0000 (15:01 +0000)] 
Bump the version number to 3.12.0.

FossilOrigin-Name: c17d7276b8c114df5fe6e9ea14d59758443c281b

10 years agoRemove the "#ifdef SQLITE_TEST" condition from fts5_test_mi.c. Update fts5_main.c...
dan [Wed, 17 Feb 2016 14:48:26 +0000 (14:48 +0000)] 
Remove the "#ifdef SQLITE_TEST" condition from fts5_test_mi.c. Update fts5_main.c so that if SQLITE_FTS5_TEST_MI is defined when it is built the fts5_test_mi.c entry point is automatically called. This makes it easier to build versions of fts5 that include the matchinfo() demo by default.

FossilOrigin-Name: 87e6e225aea3a4d10476d16eab4a6403a4a128c9

10 years agoImprove test coverage of demo code in fts5_test_mi.c.
dan [Wed, 17 Feb 2016 14:11:06 +0000 (14:11 +0000)] 
Improve test coverage of demo code in fts5_test_mi.c.

FossilOrigin-Name: 8a78050dc0e374a0df0f29716df60250e2c4b4f7

10 years agoEnhance Lemon to generate more compact and efficient code for yy_reduce().
drh [Wed, 17 Feb 2016 13:24:12 +0000 (13:24 +0000)] 
Enhance Lemon to generate more compact and efficient code for yy_reduce().
Update the main SQL grammar to take advantage of the new capabilities.

FossilOrigin-Name: 53fd040c98d9647ea135d43c493777bf8da4aebd

10 years agoMore agressive use of /*A-overwrites-X*/ in the parser. Fix an off-by-one parser-performance
drh [Wed, 17 Feb 2016 12:34:03 +0000 (12:34 +0000)] 
More agressive use of /*A-overwrites-X*/ in the parser.  Fix an off-by-one
error in parser stack overflow detection.

FossilOrigin-Name: 417e777701bbf4bd67626d4ca3bc2c5d847f6cd0

10 years agoDocumentation typo on sqlite3_wal_hook(). No changes to code.
drh [Wed, 17 Feb 2016 11:13:20 +0000 (11:13 +0000)] 
Documentation typo on sqlite3_wal_hook().  No changes to code.

FossilOrigin-Name: fc2043ebaa3f106529500164936bb82f9b921b1c

10 years agoEnhance Lemon so that if reduce code contains a comment of the form
drh [Wed, 17 Feb 2016 04:33:10 +0000 (04:33 +0000)] 
Enhance Lemon so that if reduce code contains a comment of the form
"/*A-overwrites-X*/" then a LHS label A is allowed to overwrite the
RHS label X.

FossilOrigin-Name: 5cfe9545d478a2c500083613dd20e14b2ffce645

10 years agoFurther improvements to the Lemon-generated code for yy_reduce().
drh [Wed, 17 Feb 2016 01:46:19 +0000 (01:46 +0000)] 
Further improvements to the Lemon-generated code for yy_reduce().

FossilOrigin-Name: ef95a7d6490e33a9af4bc7b4b622de7328742ca7

10 years agoIn Lemon, add the ability for the left-most RHS label to be the same as the
drh [Wed, 17 Feb 2016 01:18:33 +0000 (01:18 +0000)] 
In Lemon, add the ability for the left-most RHS label to be the same as the
LHS label, causing the LHS values to be written directly into the stack.

FossilOrigin-Name: 4bb94c7c4c3cb3ccad72c2451d88684130dde845

10 years agoExperimental changes to Lemon for improved parser performance.
drh [Tue, 16 Feb 2016 21:19:49 +0000 (21:19 +0000)] 
Experimental changes to Lemon for improved parser performance.

FossilOrigin-Name: a65d583ce97b8c08157268bd054479cda3957a94

10 years agoMinor simplification to the tokenizer. Slightly smaller and faster.
drh [Tue, 16 Feb 2016 13:04:19 +0000 (13:04 +0000)] 
Minor simplification to the tokenizer.  Slightly smaller and faster.

FossilOrigin-Name: 9570b6b43df3bc5ce314cded20bca8be9e968efe

10 years agoImprove the Lemon parser template (lempar.c) so that it avoids unnecessary
drh [Tue, 16 Feb 2016 01:01:43 +0000 (01:01 +0000)] 
Improve the Lemon parser template (lempar.c) so that it avoids unnecessary
work when the grammer defines YYNOERRORRECOVERY (as SQLite does).  Slightly
smaller and faster code results.

FossilOrigin-Name: 9235b0cf6a37712ae9e5deeb1e5ee064dd5511fa

10 years agoFix a harmless compiler warning in FTS5.
drh [Mon, 15 Feb 2016 23:46:36 +0000 (23:46 +0000)] 
Fix a harmless compiler warning in FTS5.

FossilOrigin-Name: e52c90758c53cbb0f74e0d8582e4c3c1bee04150

10 years agoReadability improvements for winRandomness.
mistachkin [Mon, 15 Feb 2016 22:37:18 +0000 (22:37 +0000)] 
Readability improvements for winRandomness.

FossilOrigin-Name: 1640f814c7a5210f08c81e52e5a3fb89ac26f4d4

10 years agoFix comment. No changes to code.
mistachkin [Mon, 15 Feb 2016 22:28:50 +0000 (22:28 +0000)] 
Fix comment.  No changes to code.

FossilOrigin-Name: 2e1f2eff27e25280fe626c07b6260b0a7aa903d3

10 years agoRevise compiler checks for the rand_s() function.
mistachkin [Mon, 15 Feb 2016 22:01:24 +0000 (22:01 +0000)] 
Revise compiler checks for the rand_s() function.

FossilOrigin-Name: 287f508dd6abc1b9ffdbec6a685ebe79eeac992b

10 years agoOn windows systems when rand_s() is available, use it to obtain additional
drh [Mon, 15 Feb 2016 21:31:51 +0000 (21:31 +0000)] 
On windows systems when rand_s() is available, use it to obtain additional
seed material in winRandomness().

FossilOrigin-Name: 139081bef9f63c3ebbe9e992408597b1349bdf37

10 years agoImproved entropy gathering for the implementation of winRandomness().
drh [Mon, 15 Feb 2016 20:41:56 +0000 (20:41 +0000)] 
Improved entropy gathering for the implementation of winRandomness().

FossilOrigin-Name: fea3705e7750d276a8c8300b7a82dfae2d5979c0

10 years agoAdd working -q and --help options to testfixture.
drh [Mon, 15 Feb 2016 19:38:17 +0000 (19:38 +0000)] 
Add working -q and --help options to testfixture.

FossilOrigin-Name: 404494e52b6385671ccde1c83b7b868986645536

10 years agoIn the tool/warning.sh script, disable Android-specific compiler warning tests
drh [Mon, 15 Feb 2016 18:58:37 +0000 (18:58 +0000)] 
In the tool/warning.sh script, disable Android-specific compiler warning tests
when not running on Linux.

FossilOrigin-Name: 153f01a821e9844d0a2e418eb83c60f6c7695c8d

10 years agoFix harmless compiler warnings previously seen in 64-bit MSVC builds.
drh [Mon, 15 Feb 2016 18:47:26 +0000 (18:47 +0000)] 
Fix harmless compiler warnings previously seen in 64-bit MSVC builds.

FossilOrigin-Name: 7026246300392a83cc23817dbc54c2c66bf1f2b3

10 years agoAdd the SQLITE_NOMEM_BKPT macro to enhance the ability to debug OOM errors.
drh [Mon, 15 Feb 2016 18:15:15 +0000 (18:15 +0000)] 
Add the SQLITE_NOMEM_BKPT macro to enhance the ability to debug OOM errors.
Only effective with compiling with SQLITE_DEBUG.

FossilOrigin-Name: 9b3454762d142113f5923d754ca6bd2edefbd362

10 years agoMinor code simplifications.
drh [Mon, 15 Feb 2016 18:02:13 +0000 (18:02 +0000)] 
Minor code simplifications.

FossilOrigin-Name: c3b38efd50c3c07b6dee5dea4c1f95b37d1c0994

10 years agoMake the application-defined SQL function logic more compact and faster,
drh [Mon, 15 Feb 2016 17:56:35 +0000 (17:56 +0000)] 
Make the application-defined SQL function logic more compact and faster,
especially faster for the case where an application defines thousands of
new SQL functions.

FossilOrigin-Name: 7d49ed32a7262ec95d72ce520ab75402633386a1

10 years agoVersion 3.11.0 version-3.11.0
drh [Mon, 15 Feb 2016 17:29:24 +0000 (17:29 +0000)] 
Version 3.11.0

FossilOrigin-Name: 3d862f207e3adc00f78066799ac5a8c282430a5f

10 years agoMake sure the codec is invoked when overwriting existing frames of the
drh [Mon, 15 Feb 2016 15:06:47 +0000 (15:06 +0000)] 
Make sure the codec is invoked when overwriting existing frames of the
WAL file.  Yikes!

FossilOrigin-Name: f694e60a79024967a3f4574e3928f0b28589d381

10 years agoImprovements to the application-defined function mechanism so that it is many-app-functions
drh [Mon, 15 Feb 2016 00:34:16 +0000 (00:34 +0000)] 
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

10 years agoUpdate a comment. noMemBkpt
mistachkin [Sun, 14 Feb 2016 00:14:35 +0000 (00:14 +0000)] 
Update a comment.

FossilOrigin-Name: e9753d9a2c1269050f886e6cb9bc9cba0a8df6ce