]> git.ipfire.org Git - thirdparty/sqlite.git/log
thirdparty/sqlite.git
18 years agoCatch an IO error code that was being ignored in OP_RowData. (CVS 3688)
danielk1977 [Thu, 15 Mar 2007 12:05:35 +0000 (12:05 +0000)] 
Catch an IO error code that was being ignored in OP_RowData. (CVS 3688)

FossilOrigin-Name: 760ebf8076b9cedb614bdc88c72d871c30cc7b94

18 years agoEnhanced temp-file security under unix. There are no known attacks against
drh [Thu, 15 Mar 2007 01:16:47 +0000 (01:16 +0000)] 
Enhanced temp-file security under unix.  There are no known attacks against
prior versions - this check-in is just an added precaution. (CVS 3687)

FossilOrigin-Name: 5af61402f65bddc4040a20470f267c9404cba631

18 years agoModify the behaviour of writable_schema to ignore schema parsing errors. (CVS 3686)
danielk1977 [Wed, 14 Mar 2007 15:37:04 +0000 (15:37 +0000)] 
Modify the behaviour of writable_schema to ignore schema parsing errors. (CVS 3686)

FossilOrigin-Name: a8d6d935fbe32a759a55c1ef90adda7fe534acc1

18 years agoAdd hyperlink anchors to the lockingv3.html document. (CVS 3685)
drh [Tue, 13 Mar 2007 16:33:42 +0000 (16:33 +0000)] 
Add hyperlink anchors to the lockingv3.html document. (CVS 3685)

FossilOrigin-Name: 3e66ea6f61abc0f95af3bb46ebc0e10b4dcd069b

18 years agoDo not crash when a corrupt database contains two indices with the same name. (CVS...
danielk1977 [Tue, 13 Mar 2007 16:32:25 +0000 (16:32 +0000)] 
Do not crash when a corrupt database contains two indices with the same name. (CVS 3684)

FossilOrigin-Name: 48b2a40008a09881ed9da3548095495a3d4a6647

18 years agoClarify the use of loop variables in a expr.c. (CVS 3683)
drh [Mon, 12 Mar 2007 23:48:52 +0000 (23:48 +0000)] 
Clarify the use of loop variables in a expr.c. (CVS 3683)

FossilOrigin-Name: e20e76f6d8578f4faab0b101b6d4deb2a8987454

18 years agoFix another typo in copyright.html (CVS 3682)
drh [Sat, 10 Mar 2007 20:50:18 +0000 (20:50 +0000)] 
Fix another typo in copyright.html (CVS 3682)

FossilOrigin-Name: 92f158643cc3f9fa913ed80e4eef325c33e4bf06

18 years agoAmplify and clarify reasons for wanting to get a license to use
drh [Sat, 10 Mar 2007 20:47:50 +0000 (20:47 +0000)] 
Amplify and clarify reasons for wanting to get a license to use
SQLite. (CVS 3681)

FossilOrigin-Name: 05bae0204d2387201be4783a11d54b220a4a40e8

18 years agoFix typos in the copyright.html webpage. Ticket #2267 (CVS 3680)
drh [Sat, 10 Mar 2007 18:30:31 +0000 (18:30 +0000)] 
Fix typos in the copyright.html webpage.  Ticket #2267 (CVS 3680)

FossilOrigin-Name: 74a4bfce46534330cb749ce2337ef39d51d693e7

18 years agoUpdates to the copyright.html page to address concerns some users have
drh [Sat, 10 Mar 2007 13:47:01 +0000 (13:47 +0000)] 
Updates to the copyright.html page to address concerns some users have
SQLite have about copyright issues.  A links to the wikipedia article
on public domain and a public domain icon. (CVS 3679)

FossilOrigin-Name: 6ce39f30063bbee3271a428f284235b0a84b9229

18 years agoRemove extra heading accidentally added to lang.tcl by (3677). (CVS 3678)
danielk1977 [Fri, 9 Mar 2007 14:43:25 +0000 (14:43 +0000)] 
Remove extra heading accidentally added to lang.tcl by (3677). (CVS 3678)

FossilOrigin-Name: 570533c1ef4640670227481cf72b782d320a65ba

18 years agoAdd a few "class" attributes to the html generated by lang.tcl to support conversion...
danielk1977 [Fri, 9 Mar 2007 14:40:58 +0000 (14:40 +0000)] 
Add a few "class" attributes to the html generated by lang.tcl to support conversion to pdf. (CVS 3677)

FossilOrigin-Name: 485c52ddc0f3c24f624825904cea3566f83f0e68

18 years agoChange the documentation to be more specific about the restriction on
drh [Thu, 8 Mar 2007 12:23:34 +0000 (12:23 +0000)] 
Change the documentation to be more specific about the restriction on
the use of keywords.  Ticket #2264. (CVS 3676)

FossilOrigin-Name: d03d480544e1f782ca796e4cfb83ff6894ed9147

18 years agoCatch an out-of-memory condition in vacuum code. (Bug in (3373)). (CVS 3675)
danielk1977 [Tue, 6 Mar 2007 16:03:55 +0000 (16:03 +0000)] 
Catch an out-of-memory condition in vacuum code. (Bug in (3373)). (CVS 3675)

FossilOrigin-Name: 302ec768579e2f7c17a33749e685289a041aeb11

18 years agoFixes to the overflow-chain optization of (3672). (CVS 3674)
drh [Tue, 6 Mar 2007 15:53:44 +0000 (15:53 +0000)] 
Fixes to the overflow-chain optization of (3672). (CVS 3674)

FossilOrigin-Name: d6986d1e7cba1d114fa06c5560ffc6bb1feb7389

18 years agoUse heap instead of stack for large buffers in the pager. Fix for #2262. (CVS 3673)
danielk1977 [Tue, 6 Mar 2007 13:45:59 +0000 (13:45 +0000)] 
Use heap instead of stack for large buffers in the pager. Fix for #2262. (CVS 3673)

FossilOrigin-Name: dfe1dffa4515ed6494055887d351863fe0cdb87f

18 years agoDo not read the last page of a overflow chain when deleting that chain.
drh [Tue, 6 Mar 2007 11:42:19 +0000 (11:42 +0000)] 
Do not read the last page of a overflow chain when deleting that chain.
Just add the page to the freelist.  This reduces I/O. (CVS 3672)

FossilOrigin-Name: 6db945f7a7587c8c7adada92f94ac7936b901cf1

18 years agoChanges to the btree and pager that reduce the amount of I/O when dealing
drh [Sun, 4 Mar 2007 13:15:27 +0000 (13:15 +0000)] 
Changes to the btree and pager that reduce the amount of I/O when dealing
with the freelist.  (1) Avoid journaling pages of a table that is being
deleted.  (2) Do not read the original content of pages being pulled off
of the freelist. (CVS 3671)

FossilOrigin-Name: 2ba5be311945a4c15b6dce7c01efefb513b9a973

18 years agoHandle the case where the estimated cost of a virtual table scan is larger than SQLIT...
danielk1977 [Fri, 2 Mar 2007 08:12:22 +0000 (08:12 +0000)] 
Handle the case where the estimated cost of a virtual table scan is larger than SQLITE_BIG_DBL. Ticket #2253. (CVS 3670)

FossilOrigin-Name: 52885ed8b76a06588acf202a38b4feabfca1cfd1

18 years agoDisable the "SELECT max(rowid) ..." optimization for virtual tables. Ticket #2250...
danielk1977 [Fri, 2 Mar 2007 07:27:00 +0000 (07:27 +0000)] 
Disable the "SELECT max(rowid) ..." optimization for virtual tables. Ticket #2250. (CVS 3669)

FossilOrigin-Name: ddb4d0af5770c7030fe6e92119972c9508724b9a

18 years agoMinor fixes so that testfixture builds without IO tracing enabled. (CVS 3668)
danielk1977 [Fri, 2 Mar 2007 06:24:19 +0000 (06:24 +0000)] 
Minor fixes so that testfixture builds without IO tracing enabled. (CVS 3668)

FossilOrigin-Name: 8d3829cdb35f41bc7a2e6f945e9aa83987513104

18 years agoAdditional I/O Tracing support. (CVS 3667)
drh [Thu, 1 Mar 2007 00:29:13 +0000 (00:29 +0000)] 
Additional I/O Tracing support. (CVS 3667)

FossilOrigin-Name: ed915f579a8e5b75681a9a6012b5041500cad36c

18 years agoWork around incompatibilities in the windows printf() routine within the
drh [Wed, 28 Feb 2007 06:14:25 +0000 (06:14 +0000)] 
Work around incompatibilities in the windows printf() routine within the
new I/O tracing logic. (CVS 3666)

FossilOrigin-Name: ceb3a07f559b5160232c8bce5446f4d0e8aab92b

18 years agoAdd the undocumented and experimental I/O tracing interface. This
drh [Wed, 28 Feb 2007 04:47:26 +0000 (04:47 +0000)] 
Add the undocumented and experimental I/O tracing interface.  This
interface is likely to change and may be completely abandoned in the
near future. (CVS 3665)

FossilOrigin-Name: 007ca283892a66dd8b9e0dfece4f75d0d08a4300

18 years agoImprovements to OS layer tracing on the unix backend. (CVS 3664)
drh [Tue, 27 Feb 2007 02:01:14 +0000 (02:01 +0000)] 
Improvements to OS layer tracing on the unix backend. (CVS 3664)

FossilOrigin-Name: 3ad96dbe09b99bd5f623de0de3072a25e9e2bc17

18 years agoAdd comments to sqlite3ExprCompare() to clarify its operation. Ticket #2216. (CVS...
drh [Sat, 24 Feb 2007 15:29:03 +0000 (15:29 +0000)] 
Add comments to sqlite3ExprCompare() to clarify its operation. Ticket #2216. (CVS 3663)

FossilOrigin-Name: fba0a1e50820677081bc7cf01f97bf953065f7c4

18 years agoAdditional test cases added. Improvements to the INSERT transfer
drh [Sat, 24 Feb 2007 15:18:49 +0000 (15:18 +0000)] 
Additional test cases added.  Improvements to the INSERT transfer
optimization. (CVS 3662)

FossilOrigin-Name: 2bf5475bde763f73f7f4dd9cac7d13a631a7d2aa

18 years agoAdditional tests and some improvements to the INSERT transfer
drh [Sat, 24 Feb 2007 13:53:05 +0000 (13:53 +0000)] 
Additional tests and some improvements to the INSERT transfer
optimization.  More testing is needed. (CVS 3661)

FossilOrigin-Name: 830985814345f71ba2def3c206e36aabe9e1ee7c

18 years agoMake sure the INSERT xfer optimization does not trigger if the CHECK
drh [Sat, 24 Feb 2007 13:23:51 +0000 (13:23 +0000)] 
Make sure the INSERT xfer optimization does not trigger if the CHECK
constraints on the two tables are not identical.  Ticket #2252. (CVS 3660)

FossilOrigin-Name: 6fc18275230563437f2985eac3795e4dfe8eb9de

18 years agoMake sure that integer values are converted to real when pulled from
drh [Sat, 24 Feb 2007 11:52:52 +0000 (11:52 +0000)] 
Make sure that integer values are converted to real when pulled from
a REAL table column by GROUP BY.  Ticket #2251.  Also make sure default
values are correctly expanded.  There may be other places in the code
where this issue comes up - we need to look further. (CVS 3659)

FossilOrigin-Name: e11bbf174c5a2fa75e3d1dd450c8b2a18f40e4da

18 years agoDisable the OR optimization if it would conflict with column
drh [Fri, 23 Feb 2007 23:13:33 +0000 (23:13 +0000)] 
Disable the OR optimization if it would conflict with column
affinity coercions.  Ticket #2249.  Additional cleanup and testing
of the OR optimization. (CVS 3658)

FossilOrigin-Name: 908daaa9ab86e0bd1da6d0807d6aaba240c3cee0

18 years agoClarifications to the datatype3.html document. (CVS 3657)
drh [Fri, 23 Feb 2007 14:20:38 +0000 (14:20 +0000)] 
Clarifications to the datatype3.html document. (CVS 3657)

FossilOrigin-Name: 4692a85edbe27d512f1830b8fb3e2b05b92a0cb5

18 years agoClarify the documentation on how comparisons occur in an IN operator.
drh [Fri, 23 Feb 2007 03:00:44 +0000 (03:00 +0000)] 
Clarify the documentation on how comparisons occur in an IN operator.
Fix the comparison operators when both sides of an IN operator are
expressions (ticket #2248).
Changes to main.mk for adding FTS2 into the standard build also
got mixed in with this check-in by mistake. (CVS 3656)

FossilOrigin-Name: da81725ca1cd894b3f2d734767e10cc0dc329566

18 years agoFix typos in test naming (was using 'e' instead of 'f'). (CVS 3655)
shess [Fri, 23 Feb 2007 00:14:05 +0000 (00:14 +0000)] 
Fix typos in test naming (was using 'e' instead of 'f'). (CVS 3655)

FossilOrigin-Name: 16cb00adeb3b68220ba2567b86b230bbbf2a0330

18 years agoMake the depth of the pushdown automaton stack generated by lemon
drh [Thu, 22 Feb 2007 23:06:58 +0000 (23:06 +0000)] 
Make the depth of the pushdown automaton stack generated by lemon
changable at compile-time using -DYYSTACKDEPTH=<number>. (CVS 3654)

FossilOrigin-Name: d8845ac1fbf8c3f483d47c35f908817ea37128ec

18 years agoModify the fix for #2244 to avoid using a vdbe label. (CVS 3653)
danielk1977 [Wed, 21 Feb 2007 17:04:04 +0000 (17:04 +0000)] 
Modify the fix for #2244 to avoid using a vdbe label. (CVS 3653)

FossilOrigin-Name: f7ce74b22ab739b8c8599cdc605aa9da1f5b5be5

18 years agoFix for an UPDATE on a virtual table when the WHERE clause matches zero rows.
danielk1977 [Wed, 21 Feb 2007 16:52:12 +0000 (16:52 +0000)] 
Fix for an UPDATE on a virtual table when the WHERE clause matches zero rows.
Ticket #2244. (CVS 3652)

FossilOrigin-Name: 43bf797842f00a104f5c5619ad3215edddfc641b

18 years agoAdd comments to the top of keywordhash.h. (CVS 3651)
drh [Wed, 21 Feb 2007 16:44:33 +0000 (16:44 +0000)] 
Add comments to the top of keywordhash.h. (CVS 3651)

FossilOrigin-Name: 0aa9ed5bbfb756967a6f761c5fc2f274a5466e2d

18 years agoEnhance the documentation to clarify that SQLite is not reentrant through
drh [Tue, 20 Feb 2007 15:21:05 +0000 (15:21 +0000)] 
Enhance the documentation to clarify that SQLite is not reentrant through
the authorization callback function.  Ticket #2242. (CVS 3650)

FossilOrigin-Name: b18a758a8fbd4b286ae3475af26f290d8cd583f0

18 years agomerge the second portion of the cross-compile cleanup (CVS 3649)
vapier [Sat, 17 Feb 2007 14:59:17 +0000 (14:59 +0000)] 
merge the second portion of the cross-compile cleanup (CVS 3649)

FossilOrigin-Name: 309f2de62f34160fa24a5e1a3de0d653aabfb52b

18 years agoregenerate (CVS 3648)
vapier [Sat, 17 Feb 2007 14:46:31 +0000 (14:46 +0000)] 
regenerate (CVS 3648)

FossilOrigin-Name: 20ac0f364059feba5ad95dbe82db30a9aa86be78

18 years agopunt custom handling of cross-compile logic and move towards the standard autotool...
vapier [Sat, 17 Feb 2007 14:31:55 +0000 (14:31 +0000)] 
punt custom handling of cross-compile logic and move towards the standard autotool way of things (CVS 3647)

FossilOrigin-Name: 9817b433da36c78513ca278ae28e8ca8ce1cf00b

18 years agomake the readline checks more flexible and handle cross-compiling logic (CVS 3646)
vapier [Sat, 17 Feb 2007 14:28:26 +0000 (14:28 +0000)] 
make the readline checks more flexible and handle cross-compiling logic (CVS 3646)

FossilOrigin-Name: 4626c84bae1a11d3cdad4901b19caf44406bd62a

18 years agoIn the corrupt2.test script,
drh [Wed, 14 Feb 2007 12:32:13 +0000 (12:32 +0000)] 
In the corrupt2.test script,
change uses of (open ... a) to (open ... RDWR) to work around
inconsistencies in behavior across various platforms. (CVS 3645)

FossilOrigin-Name: 50e86b0368ae0268e7f07e44a746e13ad86a3b8b

18 years agoUse OP_VColumn instead of OP_Column when querying virtual tables for values to save...
danielk1977 [Wed, 14 Feb 2007 09:19:36 +0000 (09:19 +0000)] 
Use OP_VColumn instead of OP_Column when querying virtual tables for values to save in aggregate context records. #2230. (CVS 3644)

FossilOrigin-Name: cb78f7cb0f0bf0c799a929fd6ea30f25e2a7b5d0

18 years agoAdd a new algorithm for handling INSERT which reduces fragmentation on
drh [Tue, 13 Feb 2007 15:01:11 +0000 (15:01 +0000)] 
Add a new algorithm for handling INSERT which reduces fragmentation on
a VACUUM.  Ticket #2075.  More testing needed. (CVS 3643)

FossilOrigin-Name: 9f56a878cbbc715262b3a48ee696148dbd7bf1d2

18 years agoChanges to the script that generates download.html so that it recognizes
drh [Tue, 13 Feb 2007 14:11:46 +0000 (14:11 +0000)] 
Changes to the script that generates download.html so that it recognizes
FTS2 modules. (CVS 3642)

FossilOrigin-Name: 06c22de25472eba439d7f05879eb13756c4e34a8

18 years agoVersion 3.3.13 (CVS 3641)
drh [Tue, 13 Feb 2007 13:04:54 +0000 (13:04 +0000)] 
Version 3.3.13 (CVS 3641)

FossilOrigin-Name: 286c4eb30dfe1e8ef110cd2a214d71612a78b8cc

18 years agoExpand the cursor index in SrcList_item to 32-bits to accomodate really
drh [Tue, 13 Feb 2007 12:49:24 +0000 (12:49 +0000)] 
Expand the cursor index in SrcList_item to 32-bits to accomodate really
huge VDBE programs resulting from deeply nested triggers.  This is an
interim fix until we rework triggers to use subroutines. (CVS 3640)

FossilOrigin-Name: 22769e2d37f4912ad388d2ed79f93571d0279fb8

18 years agoChanged my mind. Convert "GUID" back to "UUID". (CVS 3639)
drh [Tue, 13 Feb 2007 02:12:02 +0000 (02:12 +0000)] 
Changed my mind.  Convert "GUID" back to "UUID". (CVS 3639)

FossilOrigin-Name: c258840515de6ab16725d98dab6ae654d50bcc3c

18 years agoChange "UUID" to "GUID" in the documentation. (CVS 3638)
drh [Tue, 13 Feb 2007 02:07:37 +0000 (02:07 +0000)] 
Change "UUID" to "GUID" in the documentation. (CVS 3638)

FossilOrigin-Name: dddd31f4e09f1b83d9c8fb9280cdc5aff13855ca

18 years agoChanges in preparation for version 3.3.13. (CVS 3637)
drh [Tue, 13 Feb 2007 02:03:23 +0000 (02:03 +0000)] 
Changes in preparation for version 3.3.13. (CVS 3637)

FossilOrigin-Name: 7799a0b63dd4ab6f422f138e5b423d6fb00529fb

18 years agoExplanation of the "fragmentation" line is added to the help message at
drh [Tue, 13 Feb 2007 01:41:52 +0000 (01:41 +0000)] 
Explanation of the "fragmentation" line is added to the help message at
the end of the output of sqlite3_analyzer. (CVS 3636)

FossilOrigin-Name: 31e5073c58f43b84d26218d70e6f6558c406803e

18 years agoAdditional fixes to the new fragmentation feature of sqlite3_analyzer. (CVS 3635)
drh [Tue, 13 Feb 2007 01:38:31 +0000 (01:38 +0000)] 
Additional fixes to the new fragmentation feature of sqlite3_analyzer. (CVS 3635)

FossilOrigin-Name: 82aed271a4a69e3dad6013b83cc7d492b7fed164

18 years agoChanges to support fragmentation analysis in sqlite3_analyzer. (CVS 3634)
drh [Sat, 10 Feb 2007 19:22:35 +0000 (19:22 +0000)] 
Changes to support fragmentation analysis in sqlite3_analyzer. (CVS 3634)

FossilOrigin-Name: bd6bc3b8f06919000fb082087dff7bbd335d07e9

18 years agoExplicit collations always override implicit collations. This is
drh [Wed, 7 Feb 2007 13:09:45 +0000 (13:09 +0000)] 
Explicit collations always override implicit collations.  This is
backwards compatible since SQLite has not previously supported
explicit collations. Need to add tests of this new behavior. (CVS 3633)

FossilOrigin-Name: 3638823a629164e4158f76d03ff2cea1eab34e9d

18 years agoChange the coding of PRAGMA count_changes so that it uses memory cells
drh [Wed, 7 Feb 2007 01:06:52 +0000 (01:06 +0000)] 
Change the coding of PRAGMA count_changes so that it uses memory cells
of the VM rather than the stack, to avoid problems with leftovers on the
stack interfering with other operations.  Ticket #2217. (CVS 3632)

FossilOrigin-Name: 2bd4b62a20219f939ac2ac22440dc7fc0449f766

18 years agohttp://www.sqlite.org/cvstrac/tktview?tn=2219
shess [Wed, 7 Feb 2007 01:01:17 +0000 (01:01 +0000)] 
http://www.sqlite.org/cvstrac/tktview?tn=2219

When creating fts tables in an attached database, the backing tables
are created in database 'main'.  This change propagates the
appropriate database name to the routines which build sql statements.

Note that I propagate the database name and table name separately.  I
briefly considered just making the table name be "db.table", but it
didn't fit so well in the model used to store the table name and other
information, and having the db name passed separately seemed a bit
more transparent. (CVS 3631)

FossilOrigin-Name: 283385d20724f0144f38de89bd179715ee5e738b

18 years agoAdditional tests to give full coverage testing to ticket #2211. (CVS 3630)
drh [Tue, 6 Feb 2007 23:41:34 +0000 (23:41 +0000)] 
Additional tests to give full coverage testing to ticket #2211. (CVS 3630)

FossilOrigin-Name: ecb1f2fd7b96797459287eaab95693ae17ec2079

18 years agoWhen optimizing out an ORDER BY clause due to uniqueness constraints, make
drh [Tue, 6 Feb 2007 13:26:32 +0000 (13:26 +0000)] 
When optimizing out an ORDER BY clause due to uniqueness constraints, make
sure unused terms to the right in the ORDER BY clause to not reference other
tables in a join.  Ticket #2211.  Additional test cases needed before
closing this ticket. (CVS 3629)

FossilOrigin-Name: 912faf18d86416b1a36660851f8a4554e6746875

18 years agoCheck the return value of lseek() in os_unix.c to make sure it really worked. (CVS...
drh [Tue, 6 Feb 2007 11:11:08 +0000 (11:11 +0000)] 
Check the return value of lseek() in os_unix.c to make sure it really worked. (CVS 3628)

FossilOrigin-Name: e4408dd1fd32e6c5057cce0fdfa70eb2d9bd2531

18 years agoSet the MEM_Term flag when an internal string has a nul-terminator appended to it...
danielk1977 [Mon, 5 Feb 2007 14:21:47 +0000 (14:21 +0000)] 
Set the MEM_Term flag when an internal string has a nul-terminator appended to it. Fix for #2213. (CVS 3627)

FossilOrigin-Name: fc969ad991e5114c3612f4796e342a6db2d79cd5

18 years agoMinor tweaks to collating sequences. We'll hold of making major changes
drh [Fri, 2 Feb 2007 12:44:37 +0000 (12:44 +0000)] 
Minor tweaks to collating sequences.  We'll hold of making major changes
until 3.4.0, since we'll likely end up with some minor technical
imcompatibilities. (CVS 3626)

FossilOrigin-Name: 9740aa95a3f848fc663c88263a911fbc76ada243

18 years agoFix typos in the pragma documentation. Ticket #2210. (CVS 3625)
drh [Fri, 2 Feb 2007 12:33:16 +0000 (12:33 +0000)] 
Fix typos in the pragma documentation.  Ticket #2210. (CVS 3625)

FossilOrigin-Name: f0c66ad8e9bc303e3173438a56e47802c8fdde05

18 years agoFirst cut at adding the COLLATE operator. Regression tests pass (or at least
drh [Thu, 1 Feb 2007 23:02:45 +0000 (23:02 +0000)] 
First cut at adding the COLLATE operator.  Regression tests pass (or at least
the quick set does) and a few new tests have been added.  But many more
tests are needed.  Rules for combining collations need to be worked out. (CVS 3624)

FossilOrigin-Name: 85cca7cd252d46ba71d302a89bc67c56146ec552

18 years agoFix a bug in the copy method of the TCL interface. Ticket #2201. (CVS 3623)
drh [Thu, 1 Feb 2007 01:53:44 +0000 (01:53 +0000)] 
Fix a bug in the copy method of the TCL interface.  Ticket #2201. (CVS 3623)

FossilOrigin-Name: 936263966ea70792e8abb712730f78cafa1fdbad

18 years agoAllow up to 64 tables in a join (the number of bits in a long long int).
drh [Thu, 1 Feb 2007 01:40:44 +0000 (01:40 +0000)] 
Allow up to 64 tables in a join (the number of bits in a long long int).
The old limit was 32 tables. (CVS 3622)

FossilOrigin-Name: 505dce8f4e8717341e04f49f6f382719c3c704f1

18 years agoFixed incorrect typecast for flock structure ptr in fcntl() call in sqlite3TestLockin...
aswift [Wed, 31 Jan 2007 23:37:07 +0000 (23:37 +0000)] 
Fixed incorrect typecast for flock structure ptr in fcntl() call in sqlite3TestLockingStyle()
Restored previous fullfsync behavior, try fsync() if fcntl(fd, F_FULLFSYNC, 0) returns an error. (CVS 3621)

FossilOrigin-Name: f044c5f49f116ede8ab2d5ab43caa5ca9dd54ffe

18 years agoReplace the randomHex() function with separate functions
drh [Mon, 29 Jan 2007 17:58:28 +0000 (17:58 +0000)] 
Replace the randomHex() function with separate functions
randomBlob() and hex(). (CVS 3620)

FossilOrigin-Name: f5ad74a9bc57e83c11beb3cf46bb6cd8c9de3f86

18 years agoAdd the randomhex() function as a built-in. (CVS 3619)
drh [Mon, 29 Jan 2007 15:50:05 +0000 (15:50 +0000)] 
Add the randomhex() function as a built-in. (CVS 3619)

FossilOrigin-Name: a6001589ab1349f7a6b4af941e9e0fd73d13c1c0

18 years agoImplement the platform specific part of the shared library interface on OS/2 (CVS...
pweilbacher [Sun, 28 Jan 2007 21:42:08 +0000 (21:42 +0000)] 
Implement the platform specific part of the shared library interface on OS/2 (CVS 3618)

FossilOrigin-Name: 027251a6fc9971b337172436137fabdafec1d264

18 years agoAdapt returns of the os2Read() function to those of other platforms using checkin...
pweilbacher [Sun, 28 Jan 2007 21:12:13 +0000 (21:12 +0000)] 
Adapt returns of the os2Read() function to those of other platforms using checkin (3549) to prevent possible corruption (CVS 3617)

FossilOrigin-Name: ba76107cd1fc1898f5357b20b339727e2e034e23

18 years agoVersion 3.3.12 (CVS 3616)
drh [Sat, 27 Jan 2007 14:30:14 +0000 (14:30 +0000)] 
Version 3.3.12 (CVS 3616)

FossilOrigin-Name: fc66070393b48f8022500c45e063068e801c05d7

18 years agoAdjustments to the pragma test for OS-X. (CVS 3615)
drh [Sat, 27 Jan 2007 14:26:07 +0000 (14:26 +0000)] 
Adjustments to the pragma test for OS-X. (CVS 3615)

FossilOrigin-Name: 4d0d2063df2191155b290dc426b502bc7e1959c7

18 years agoMore adjustments to the pragma test for windows. (CVS 3614)
drh [Sat, 27 Jan 2007 14:11:41 +0000 (14:11 +0000)] 
More adjustments to the pragma test for windows. (CVS 3614)

FossilOrigin-Name: 79a65436d1cd10ed6318edfaa7d76e2b99c7c879

18 years agoAdjustment to tests for PRAGMA integrity_check so that they run under windows. (CVS...
drh [Sat, 27 Jan 2007 14:04:13 +0000 (14:04 +0000)] 
Adjustment to tests for PRAGMA integrity_check so that they run under windows. (CVS 3613)

FossilOrigin-Name: a79914ccbc9e33a1dbc9be3de805f99ab3b61c78

18 years agoIncrement the version number in preparation for the 3.3.12 release. (CVS 3612)
drh [Sat, 27 Jan 2007 13:38:25 +0000 (13:38 +0000)] 
Increment the version number in preparation for the 3.3.12 release. (CVS 3612)

FossilOrigin-Name: 24e465af92505589ecde1747fb29d4f449c1a12c

18 years agoFix a documentation comment in vdbe.c. Ticket #2188. (CVS 3611)
drh [Sat, 27 Jan 2007 13:37:22 +0000 (13:37 +0000)] 
Fix a documentation comment in vdbe.c.  Ticket #2188. (CVS 3611)

FossilOrigin-Name: 3eec703beb91be44ded629335001c238052480e7

18 years agoParser changes to allow parenthesized numerical arguments to pragmas,
drh [Sat, 27 Jan 2007 02:38:29 +0000 (02:38 +0000)] 
Parser changes to allow parenthesized numerical arguments to pragmas,
in support of the integrity_check enhancement of check-in (3609)
and ticket #2176. (CVS 3610)

FossilOrigin-Name: ab6322bf9398c2989b648b24c1ebdf09493accdf

18 years agoLimit the number of errors returned by PRAGMA integrity_check to 100 by
drh [Sat, 27 Jan 2007 02:24:54 +0000 (02:24 +0000)] 
Limit the number of errors returned by PRAGMA integrity_check to 100 by
default.  Specify an alternative limit using an argument to the pragma.
Ticket #2176. (CVS 3609)

FossilOrigin-Name: d564a039f27be2bb2c3973e79dc99b25869139da

18 years agoMake sure the vdbeInt.h file is not #included multiple times. Ticket #2194. (CVS...
drh [Fri, 26 Jan 2007 21:08:04 +0000 (21:08 +0000)] 
Make sure the vdbeInt.h file is not #included multiple times.  Ticket #2194. (CVS 3608)

FossilOrigin-Name: 93edd3b0565d08383b3034c57f221073fde6de4b

18 years agoFix prototypes for the parser. Syntactic change only - no effect on
drh [Fri, 26 Jan 2007 19:31:00 +0000 (19:31 +0000)] 
Fix prototypes for the parser.  Syntactic change only - no effect on
object code.  Ticket #2193. (CVS 3607)

FossilOrigin-Name: 02990fabd1c68fb51afc91a1b720802ef86bfec6

18 years agoAdd code to select.c for printing the contents of parse-tree structures.
drh [Fri, 26 Jan 2007 19:23:33 +0000 (19:23 +0000)] 
Add code to select.c for printing the contents of parse-tree structures.
The code is normally omitted.  You must compile with -DSQLITE_TEST
or -DSQLITE_DEBUG to enable it. (CVS 3606)

FossilOrigin-Name: 1b26d6875612a0ed25d6e293f005ea4966692759

18 years agoFix a (harmless) assertion fault on nested views where the inner views
drh [Fri, 26 Jan 2007 19:04:00 +0000 (19:04 +0000)] 
Fix a (harmless) assertion fault on nested views where the inner views
are compound selects.  Ticket #2192. (CVS 3605)

FossilOrigin-Name: 942e7193bbf1ffe9a703891d175e016631e2ad5c

18 years agoMake sure the loadext.c module works even if all SQLITE_OMIT macros are
drh [Fri, 26 Jan 2007 13:08:24 +0000 (13:08 +0000)] 
Make sure the loadext.c module works even if all SQLITE_OMIT macros are
defined.  Tickets #2184 and #2069. (CVS 3604)

FossilOrigin-Name: e1fae43c89253fe5ca85bd149cd7697234f9aa91

18 years agoWork around issues with certain C++ compilers by adding a typedef
drh [Fri, 26 Jan 2007 00:51:43 +0000 (00:51 +0000)] 
Work around issues with certain C++ compilers by adding a typedef
to sqlite3.h.  Ticket #2191. (CVS 3603)

FossilOrigin-Name: 31e8cf7f30afe14f0866ea71eebbda9755ddedf8

18 years agoFix an additional problem with the IS NULL optimization on LEFT JOINs.
drh [Thu, 25 Jan 2007 16:56:06 +0000 (16:56 +0000)] 
Fix an additional problem with the IS NULL optimization on LEFT JOINs.
Ticket #2189.  See also ticket #2177. (CVS 3602)

FossilOrigin-Name: 358dd82d3a921228155e2cf9e22aedd2b651ca9c

18 years agoDo not run the fts2i.test unless the FTS2 module is available. (CVS 3601)
drh [Wed, 24 Jan 2007 03:46:35 +0000 (03:46 +0000)] 
Do not run the fts2i.test unless the FTS2 module is available. (CVS 3601)

FossilOrigin-Name: 310f68585188ae49b603af9bdef4ee7738ae37c0

18 years agoDo not run test fts1i.test if FTS1 is not installed. (CVS 3600)
drh [Wed, 24 Jan 2007 03:43:20 +0000 (03:43 +0000)] 
Do not run test fts1i.test if FTS1 is not installed. (CVS 3600)

FossilOrigin-Name: 810c0176f8413995a78963c453e4377f11b293b5

18 years agoVersion 3.3.11 (CVS 3599)
drh [Mon, 22 Jan 2007 13:07:36 +0000 (13:07 +0000)] 
Version 3.3.11 (CVS 3599)

FossilOrigin-Name: 66cbbe0442a0d270ec968a9c5bca735bd238768a

18 years agoPrepare for the release of version 3.3.11 (CVS 3598)
drh [Mon, 22 Jan 2007 13:06:02 +0000 (13:06 +0000)] 
Prepare for the release of version 3.3.11 (CVS 3598)

FossilOrigin-Name: daf288302407b103051d8440df371e4cb79769eb

18 years agoFix a pragma test so that it works in directories that have spaces in
drh [Mon, 22 Jan 2007 13:02:24 +0000 (13:02 +0000)] 
Fix a pragma test so that it works in directories that have spaces in
their names. (CVS 3597)

FossilOrigin-Name: 071c957a5dcd236139113d7c0dc1d58b54180eb7

18 years agohttp://www.sqlite.org/cvstrac/tktview?tn=2166,35
shess [Fri, 19 Jan 2007 22:59:56 +0000 (22:59 +0000)] 
http://www.sqlite.org/cvstrac/tktview?tn=2166,35

Calling UPDATE against an fts table in a UTF-16 database inserts
corrupted data into the database.  The UTF-8 data is being inserted
directly.  This appears to happen because sqlite3_ value_text()
destructively coerces a value to UTF-8, and it's never converted back
when updating the table. This works around the problem by rearranging
things so that the update happens before the coercion. (CVS 3596)

FossilOrigin-Name: 4f2ab4b6320ffc621900049b41f50bc30d76d7f5

18 years agoMake sure the IS NULL optimization introduced by check-in (3494) correctly
drh [Fri, 19 Jan 2007 01:06:01 +0000 (01:06 +0000)] 
Make sure the IS NULL optimization introduced by check-in (3494) correctly
handles a LEFT JOIN where the a term from the right table of the join uses
an IS NULL constraint.  Ticket #2177.  This check-in also adds the new test
cases that were suppose to have been added with (3494) but which were
mistakenly omitted. (CVS 3595)

FossilOrigin-Name: 335863e4d16113fb9ecebce35d2db043771d98b1

18 years agoAdditional memory initialization in lemon - bug reported from wireshark.
drh [Tue, 16 Jan 2007 18:19:12 +0000 (18:19 +0000)] 
Additional memory initialization in lemon - bug reported from wireshark.
Ticket #2172.  Note this problem only comes up with certain grammars,
and does not impact SQLite.  On the other hand, it might cause SQLite
to run slower.  So we might want to revisit this change at some point. (CVS 3594)

FossilOrigin-Name: d537aa5edecb5c7b84d8eb876453f385f6f3d91a

18 years agoMake sure the parser generated by lemon always calls destructors on
drh [Tue, 16 Jan 2007 03:09:02 +0000 (03:09 +0000)] 
Make sure the parser generated by lemon always calls destructors on
unused symbols, even if there is no action following the rule.
Ticket #2171. (CVS 3593)

FossilOrigin-Name: 0c5c1b931dfdc163f300f458e4b305c9f50e17f8

18 years agoFix a bug in sqlite3_prepare_v2() introduced by checkin (3578) and reported
drh [Fri, 12 Jan 2007 23:43:42 +0000 (23:43 +0000)] 
Fix a bug in sqlite3_prepare_v2() introduced by checkin (3578) and reported
on the mailing list. (CVS 3592)

FossilOrigin-Name: 87248470362f444f2339fee18d3624e8544f5256

18 years agoFix a bug in lemon. The code in which the error appears might well be
drh [Fri, 12 Jan 2007 23:09:23 +0000 (23:09 +0000)] 
Fix a bug in lemon.  The code in which the error appears might well be
unreachable.  The changes does not effect the code that is generated for
the SQLite parser.  Ticket #2164. (CVS 3591)

FossilOrigin-Name: f4ee5d83e177e7ed9f180454c01d46a395a5715d

18 years agoMake the AreFileApisANSI() call a macro with a value of 1 on wince.
drh [Wed, 10 Jan 2007 18:56:15 +0000 (18:56 +0000)] 
Make the AreFileApisANSI() call a macro with a value of 1 on wince.
Ticket #2163. (CVS 3590)

FossilOrigin-Name: a72c950cdbb7ad14572ccdf9b94ceac8ea0a2588

18 years agoMore homepage typo fixes. (CVS 3589)
drh [Wed, 10 Jan 2007 13:34:18 +0000 (13:34 +0000)] 
More homepage typo fixes. (CVS 3589)

FossilOrigin-Name: 85b5d446b03cd0eb06a41a755f97295c98991a75