]> git.ipfire.org Git - thirdparty/sqlite.git/log
thirdparty/sqlite.git
18 years agoBackport the stack-size reduction patch in (3673) to version 3.3.13. (CVS 3979) branch_3_3_13
drh [Thu, 10 May 2007 21:31:39 +0000 (21:31 +0000)] 
Backport the stack-size reduction patch in (3673) to version 3.3.13. (CVS 3979)

FossilOrigin-Name: e91012b603014765523cda77a4dda93f938c7358

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

18 years agoFix a typo on the homepage. (CVS 3588)
drh [Wed, 10 Jan 2007 13:32:43 +0000 (13:32 +0000)] 
Fix a typo on the homepage. (CVS 3588)

FossilOrigin-Name: a0b429914b14c5c9a6169ced8b83fdb87e7bdfec

18 years agoVersion 3.3.10 (CVS 3587)
drh [Wed, 10 Jan 2007 12:58:11 +0000 (12:58 +0000)] 
Version 3.3.10 (CVS 3587)

FossilOrigin-Name: 204a212a285c0ba9a0a43ecb1919a10b01dd9308

18 years agoCorrections to the documentation on sqlite3_exec(). Ticket #2161. (CVS 3586)
drh [Wed, 10 Jan 2007 12:57:29 +0000 (12:57 +0000)] 
Corrections to the documentation on sqlite3_exec().  Ticket #2161. (CVS 3586)

FossilOrigin-Name: afd33f62ecf9f14255f5593ea87636b9deab7b92

18 years agoCorrections to the documentation for sqlite3_busy_handler(). Ticket #2160. (CVS...
drh [Wed, 10 Jan 2007 12:54:51 +0000 (12:54 +0000)] 
Corrections to the documentation for sqlite3_busy_handler().  Ticket #2160. (CVS 3585)

FossilOrigin-Name: 9614c0f99f27e8c6576a1a3ec5573b9bc414e8a8

18 years agoDocumentation updates prior to version 3.3.10. Among the changes is a
drh [Tue, 9 Jan 2007 23:13:06 +0000 (23:13 +0000)] 
Documentation updates prior to version 3.3.10.  Among the changes is a
fix for ticket #2148 (CVS 3584)

FossilOrigin-Name: 686beffa6956654fc43a2e3f1ea2896b86533774

18 years agoFix the windows OS layer so that it returns detailed IOERR error codes. (CVS 3583)
drh [Tue, 9 Jan 2007 17:18:19 +0000 (17:18 +0000)] 
Fix the windows OS layer so that it returns detailed IOERR error codes. (CVS 3583)

FossilOrigin-Name: 4b36de46c42e2e42d611b38ff18949bea55c803b

18 years agoWork around win2k problems so that single-character filenames can be
drh [Tue, 9 Jan 2007 15:32:17 +0000 (15:32 +0000)] 
Work around win2k problems so that single-character filenames can be
used.  Ticket #2151. (CVS 3582)

FossilOrigin-Name: c4eb2100c39356e1816cc6514d65155e47ea1a1d

18 years agoDocumentation and tests to show that the cause of a parsing error is
drh [Tue, 9 Jan 2007 15:06:41 +0000 (15:06 +0000)] 
Documentation and tests to show that the cause of a parsing error is
available on sqlite3_errmsg after sqlite3_step return SQLITE_SCHEMA. (CVS 3581)

FossilOrigin-Name: 31a661d424d0fe03eaf78f98031e360102dafeff

18 years agoUpdates tests and documentation to justify the behavior observed in
drh [Tue, 9 Jan 2007 15:02:03 +0000 (15:02 +0000)] 
Updates tests and documentation to justify the behavior observed in
ticket #2158.  No changes to code. (CVS 3580)

FossilOrigin-Name: e1f7cf065d2c4ca53e233a4506759a1899ad0560

18 years agoDo not use the symbol "interrupt" since that is a reserved word in
drh [Tue, 9 Jan 2007 14:37:17 +0000 (14:37 +0000)] 
Do not use the symbol "interrupt" since that is a reserved word in
OpenWatcom.  Ticket #2159. (CVS 3579)

FossilOrigin-Name: 9960ba576827f8ced6eac101313a481f2a2f4b69

18 years agoWhen an automatic re-prepare occurs, take care not to reset the internal
drh [Tue, 9 Jan 2007 14:01:13 +0000 (14:01 +0000)] 
When an automatic re-prepare occurs, take care not to reset the internal
schema symbol table.  Ticket #2156.  This change also includes some debugging
enhancements. (CVS 3578)

FossilOrigin-Name: 43fe7fc1c38f8d9b3c1346cb1d890c2e25cefe15

18 years agoAdditional tests of sqlite3_prepare_v2. (CVS 3577)
drh [Mon, 8 Jan 2007 22:40:32 +0000 (22:40 +0000)] 
Additional tests of sqlite3_prepare_v2. (CVS 3577)

FossilOrigin-Name: b0650aa6cfcb4c59fd8556b8f5523573538bd7e5

18 years agoFix a critical bug in sqlite3_prepare_v2 that can lead to segfaults when
drh [Mon, 8 Jan 2007 21:07:17 +0000 (21:07 +0000)] 
Fix a critical bug in sqlite3_prepare_v2 that can lead to segfaults when
the schema changes and the statement is recompiled automatically.
Ticket #2154. (CVS 3576)

FossilOrigin-Name: 3401388dba6c150f788397a4dfbcdb01313247e2

18 years agoFix another round-off problem in strftime(). Ticket #2153. (CVS 3574)
drh [Mon, 8 Jan 2007 16:19:07 +0000 (16:19 +0000)] 
Fix another round-off problem in strftime().  Ticket #2153. (CVS 3574)

FossilOrigin-Name: d49ddc5ff05dd65e73edfa76db7e1af36967d81a

18 years agoUpdates to the sqlite3 command-line shell documentation. Ticket #2144. (CVS 3573)
drh [Mon, 8 Jan 2007 14:31:35 +0000 (14:31 +0000)] 
Updates to the sqlite3 command-line shell documentation.  Ticket #2144. (CVS 3573)

FossilOrigin-Name: 3a422bb9eedf5357ce4d3bed68981c000eb96ee4

18 years agoAdd the $(BEXE) suffix to every mention of "lemon" in the Makefile.in,
drh [Mon, 8 Jan 2007 13:40:36 +0000 (13:40 +0000)] 
Add the $(BEXE) suffix to every mention of "lemon" in the Makefile.in,
so that the build will work on OS/2.  Ticket #2149. (CVS 3571)

FossilOrigin-Name: f5989a0bd3c218b13332896d94ef85e96befd16f

18 years agoFix a round-off error in the %W and %j conversions of the strftime() function.
drh [Mon, 8 Jan 2007 13:07:30 +0000 (13:07 +0000)] 
Fix a round-off error in the %W and %j conversions of the strftime() function.
Ticket #2150. (CVS 3570)

FossilOrigin-Name: 52067937803e6b36afc8f11c5d24059414208b77

18 years agoAnother typo fixed in changes.html (CVS 3569)
drh [Sat, 6 Jan 2007 13:11:35 +0000 (13:11 +0000)] 
Another typo fixed in changes.html (CVS 3569)

FossilOrigin-Name: 70033a0ea41e698237e886c7ab010a360ea53bb5

18 years agoFix the makefile to correctly install sqlite3ext.h. Ticket #2145 (CVS 3568)
drh [Sat, 6 Jan 2007 13:10:30 +0000 (13:10 +0000)] 
Fix the makefile to correctly install sqlite3ext.h.  Ticket #2145 (CVS 3568)

FossilOrigin-Name: be410fee681554653756d170e45ce00f0c9477ab

18 years agoFix typo in changes.html. (CVS 3567)
drh [Sat, 6 Jan 2007 13:05:34 +0000 (13:05 +0000)] 
Fix typo in changes.html. (CVS 3567)

FossilOrigin-Name: cc1df49b7a54fb11ccaa83e70f8a024d733744a5

18 years agoClear a compiler warning when compiling with -DSQLITE_OMIT_VIRTUALTABLE. (CVS 3566)
drh [Fri, 5 Jan 2007 16:39:43 +0000 (16:39 +0000)] 
Clear a compiler warning when compiling with -DSQLITE_OMIT_VIRTUALTABLE. (CVS 3566)

FossilOrigin-Name: 520f6583e3467b964dcdba873857ace5a9c4ee19

18 years agoRemove redundant variable. (CVS 3565)
drh [Fri, 5 Jan 2007 14:41:06 +0000 (14:41 +0000)] 
Remove redundant variable. (CVS 3565)

FossilOrigin-Name: 2a7f5aaf8245026edf9cd8f6abc90e87cd7747b2

18 years agoSuppress compiler warnings. Fix a bug in IO error detection on windows. (CVS 3564)
drh [Fri, 5 Jan 2007 14:38:54 +0000 (14:38 +0000)] 
Suppress compiler warnings.  Fix a bug in IO error detection on windows. (CVS 3564)

FossilOrigin-Name: daed2bab00ea3952d2d4e5182ca07653b9d80ac2

18 years agoIn the btree.c, when releasing the page1 lock, first make sure the
drh [Fri, 5 Jan 2007 02:00:47 +0000 (02:00 +0000)] 
In the btree.c, when releasing the page1 lock, first make sure the
pager has not reset and released the lock already.  This fixes a bug
introduced by (3549). (CVS 3563)

FossilOrigin-Name: 36a2db96efa7f227c0a39e58fd83d56cc491472b

18 years agoGet threadtest2.c working again after being long neglected. (CVS 3562)
drh [Fri, 5 Jan 2007 01:58:26 +0000 (01:58 +0000)] 
Get threadtest2.c working again after being long neglected. (CVS 3562)

FossilOrigin-Name: 06216d0d3be38bfabda9f5f450a5eaccd20b52b9

18 years agoFix a test case that changed due to (3560). Ticket #2143 (CVS 3561)
drh [Fri, 5 Jan 2007 00:14:27 +0000 (00:14 +0000)] 
Fix a test case that changed due to (3560).  Ticket #2143 (CVS 3561)

FossilOrigin-Name: c28664d314b8caa2844072ee9e5a50901996dc1e

18 years agoFix the user_version and schema_version pragmas so that they set a result
drh [Thu, 4 Jan 2007 22:13:41 +0000 (22:13 +0000)] 
Fix the user_version and schema_version pragmas so that they set a result
column name.  Ticket #2143. (CVS 3560)

FossilOrigin-Name: f81c4227c26a4d43993904ab05c1eb9f988e3b66

18 years agoFix the trigger4 test so that it runs on windows. (CVS 3559)
drh [Thu, 4 Jan 2007 22:13:02 +0000 (22:13 +0000)] 
Fix the trigger4 test so that it runs on windows. (CVS 3559)

FossilOrigin-Name: 5e4e65ea15c51e75e9f003fbfde3fe87e22b889b

18 years agoPut a missing double-quote into the changes.html page. (CVS 3558)
drh [Thu, 4 Jan 2007 18:01:41 +0000 (18:01 +0000)] 
Put a missing double-quote into the changes.html page. (CVS 3558)

FossilOrigin-Name: 277f8faae4f014b0162713369b074520b628a465

18 years agoVersion 3.3.9 (CVS 3557)
drh [Thu, 4 Jan 2007 17:01:19 +0000 (17:01 +0000)] 
Version 3.3.9 (CVS 3557)

FossilOrigin-Name: 8bf19a6a41ad1235b7baae28957538e800de9a80

18 years agoIncrease the version number to 3.3.9. Documentation changes prior to the
drh [Thu, 4 Jan 2007 16:37:40 +0000 (16:37 +0000)] 
Increase the version number to 3.3.9.  Documentation changes prior to the
release of version 3.3.9. (CVS 3556)

FossilOrigin-Name: 7e2832978f69cad105699259247581514ee7bd33

18 years agoDisable the alter2.test on utf16 since the results of that test only
drh [Thu, 4 Jan 2007 16:37:03 +0000 (16:37 +0000)] 
Disable the alter2.test on utf16 since the results of that test only
work for utf8. (CVS 3555)

FossilOrigin-Name: 87f350f35be64cdaa128bde35fbe93251b107025

18 years agoFix a memory leak introduced by the latest changes to pager.c. (CVS 3554)
drh [Thu, 4 Jan 2007 14:58:14 +0000 (14:58 +0000)] 
Fix a memory leak introduced by the latest changes to pager.c. (CVS 3554)

FossilOrigin-Name: 8cad5d671be9be3f7dd7dab99ad65c0fa21931ad

18 years agoReactivate disabled "alter2" tests. (CVS 3553)
drh [Thu, 4 Jan 2007 14:36:01 +0000 (14:36 +0000)] 
Reactivate disabled "alter2" tests. (CVS 3553)

FossilOrigin-Name: 093467a099bb205897a58c1eeb734e1d13fba405

18 years agoFix for ticket #2141. (CVS 3552)
drh [Thu, 4 Jan 2007 01:20:28 +0000 (01:20 +0000)] 
Fix for ticket #2141. (CVS 3552)

FossilOrigin-Name: 70f5f3b85f30bbec0ddc59ba364e1229c09ed636

18 years agoAdd a comment to vdbe.c to explain the use of an uninitialized variable. (CVS 3551)
drh [Thu, 4 Jan 2007 01:20:11 +0000 (01:20 +0000)] 
Add a comment to vdbe.c to explain the use of an uninitialized variable. (CVS 3551)

FossilOrigin-Name: 1773eb7badf105b0e23316d4236903049c354c71

18 years agoClean up memory leaks and uninitialized variables detected by valgrind.
drh [Wed, 3 Jan 2007 23:37:28 +0000 (23:37 +0000)] 
Clean up memory leaks and uninitialized variables detected by valgrind.
Identify all tests where we deliberately derefence freed memory by adding
a "-misuse" tag. (CVS 3550)

FossilOrigin-Name: 70a862702d6dfcfe73bdeef8f0502c6c50e32a3a

18 years agoAdditional changes in the pager and os interface layers to fix problems that
drh [Wed, 3 Jan 2007 23:36:22 +0000 (23:36 +0000)] 
Additional changes in the pager and os interface layers to fix problems that
might be contributing to recently observed database corruption. (CVS 3549)

FossilOrigin-Name: a593d5743eab12c0f93a7bc436f0d69dfab0c387

18 years agoMake sure that the database size cache in the pager is invalidated whenever
drh [Wed, 3 Jan 2007 15:34:29 +0000 (15:34 +0000)] 
Make sure that the database size cache in the pager is invalidated whenever
the database is unlocked.  A stale value in the database size cache can
result in database corruption on a heavily loaded system running
autovacuum. (CVS 3548)

FossilOrigin-Name: 6806b9ecb5e3b90e793c5862404e76485df33b25

18 years agoUpdate the vtab_err test to check for -DSQLITE_MEMDEBUG=1 and skip the tests
drh [Tue, 2 Jan 2007 18:41:54 +0000 (18:41 +0000)] 
Update the vtab_err test to check for -DSQLITE_MEMDEBUG=1 and skip the tests
if missing.  Pager is more careful to clear its file size cache.  Remove
an assert() in VDBE that might fail on a corrupt database file. (CVS 3547)

FossilOrigin-Name: bf1afd016ad71dac90e58540122108f92e77ce3d

18 years agoOS/2 change: add safeguard to be able to use SQLite loaded into high memory on OS...
pweilbacher [Fri, 22 Dec 2006 20:33:13 +0000 (20:33 +0000)] 
OS/2 change: add safeguard to be able to use SQLite loaded into high memory on OS/2 when compiled with GCC 3.3 or later. Currently, this is only used when building within the Mozilla source tree. (CVS 3546)

FossilOrigin-Name: 720189b8fafa61e5b712b409e76c368079b4bf96

18 years agoDisable extension loading by default. At some point we should change
drh [Thu, 21 Dec 2006 22:38:23 +0000 (22:38 +0000)] 
Disable extension loading by default.  At some point we should change
the configure script to detect the presence of dlopen() automatically
and add the appropriate library to the link.  But that requires a
working version of autoconf, which I do not have.  Ticket #2124. (CVS 3545)

FossilOrigin-Name: 87a9ee077aa53f1677667983f4566d61ea68b500

18 years agoMore fixes to the microsoft code-page nightmare... (CVS 3544)
drh [Thu, 21 Dec 2006 03:20:40 +0000 (03:20 +0000)] 
More fixes to the microsoft code-page nightmare... (CVS 3544)

FossilOrigin-Name: 0b47d88060069781e7e184806d6ecaeff9b9e5d1

18 years agoUse GetProcAddressA() on wince. Ticket #2123 (CVS 3543)
drh [Thu, 21 Dec 2006 02:21:56 +0000 (02:21 +0000)] 
Use GetProcAddressA() on wince.  Ticket #2123 (CVS 3543)

FossilOrigin-Name: e3dddd1cef5877c009852fd7f484973843e26e00

18 years agoReduce the number of utf8->unicode conversions required in wince. Ticket #2122 ...
drh [Thu, 21 Dec 2006 01:37:39 +0000 (01:37 +0000)] 
Reduce the number of utf8->unicode conversions required in wince.  Ticket #2122 (CVS 3542)

FossilOrigin-Name: 6d2ff0962dff0477fe2af0323032dc16337f42ab

18 years agoMove the shared-library loading routines into the OS portability layer,
drh [Thu, 21 Dec 2006 01:29:22 +0000 (01:29 +0000)] 
Move the shared-library loading routines into the OS portability layer,
thus enabling the os_win.c code to handle the character encoding
confusion of win95/nt/ce.  Ticket #2023. (CVS 3541)

FossilOrigin-Name: a1bcc6de578992b28924c1cf974ea58251454e2d

18 years agoChange a parameter type from "int" to "DWORD" in the windows interface.
drh [Thu, 21 Dec 2006 00:46:42 +0000 (00:46 +0000)] 
Change a parameter type from "int" to "DWORD" in the windows interface.
Ticket #2122. (CVS 3540)

FossilOrigin-Name: cca1eb3dfaa67d64ced3e49e7ddbd8db27a5526a