]> git.ipfire.org Git - thirdparty/sqlite.git/log
thirdparty/sqlite.git
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

18 years agoThe xFilter method is not optional. (CVS 3539)
drh [Wed, 20 Dec 2006 14:53:38 +0000 (14:53 +0000)] 
The xFilter method is not optional. (CVS 3539)

FossilOrigin-Name: 6fdbd3bc91559ed95314842c0df33adbf276913e

18 years agoInitialize a variable to avoid compiler warnings and human confusion.
drh [Wed, 20 Dec 2006 14:31:24 +0000 (14:31 +0000)] 
Initialize a variable to avoid compiler warnings and human confusion.
Ticket #2117. (CVS 3538)

FossilOrigin-Name: 951af8d5c57d665ee2ad3ee09ce34c023aa9e771

18 years agoPatch to get extension loading working on wince. Ticket #2023. (CVS 3537)
drh [Wed, 20 Dec 2006 03:37:34 +0000 (03:37 +0000)] 
Patch to get extension loading working on wince.  Ticket #2023. (CVS 3537)

FossilOrigin-Name: a81f3ddfd0626ae642c5ffd27a23c568d06f58dc

18 years agoThe query optimizer does a better job of optimizing out ORDER BY clauses
drh [Wed, 20 Dec 2006 03:24:19 +0000 (03:24 +0000)] 
The query optimizer does a better job of optimizing out ORDER BY clauses
that contain the rowid or which use indices that contain the rowid.
Ticket #2116. (CVS 3536)

FossilOrigin-Name: f245f5c2c2d337fe6458824beb7f9e721837765f

18 years agoAllow constraint names on DEFAULT values in a table definition.
drh [Wed, 20 Dec 2006 02:15:00 +0000 (02:15 +0000)] 
Allow constraint names on DEFAULT values in a table definition.
Ticket #2109. (CVS 3535)

FossilOrigin-Name: 893d58c23da2a9b900a13eaa5202d94429862136

18 years agoBuild without warnings and pass all tests with SQLITE_OMIT_LOAD_EXTENSION.
drh [Tue, 19 Dec 2006 18:57:11 +0000 (18:57 +0000)] 
Build without warnings and pass all tests with SQLITE_OMIT_LOAD_EXTENSION.
Ticket #2113. (CVS 3534)

FossilOrigin-Name: c3d118b40811b201e4a98b62549c5439d7d5098d

18 years agoFix a typo in shell.c. Ticket #2111. (CVS 3533)
drh [Tue, 19 Dec 2006 18:47:41 +0000 (18:47 +0000)] 
Fix a typo in shell.c.  Ticket #2111. (CVS 3533)

FossilOrigin-Name: 6f8a56231c4d0d990c54365f0ff0544bd8b3caf8

18 years agoUse sqlite3_mprintf() instead of strdup() to reduce libc dependencies.
drh [Tue, 19 Dec 2006 18:46:08 +0000 (18:46 +0000)] 
Use sqlite3_mprintf() instead of strdup() to reduce libc dependencies.
Ticket #2114. (CVS 3532)

FossilOrigin-Name: bf4a78cb315c0b1fca31c6f596ff0a8ece96860f

18 years agoSpeed improvement: do not journal or rollback pages that are pulled out of
drh [Mon, 18 Dec 2006 18:34:51 +0000 (18:34 +0000)] 
Speed improvement: do not journal or rollback pages that are pulled out of
the freelist. (CVS 3531)

FossilOrigin-Name: 4dffc4c3c9c4ccc024669cec204c68e953333563

18 years agoUpdates to the "Distinctive Features" document. (CVS 3530)
drh [Mon, 18 Dec 2006 14:12:21 +0000 (14:12 +0000)] 
Updates to the "Distinctive Features" document. (CVS 3530)

FossilOrigin-Name: c734585e1a801bec2d393d000c323ba842c2292d

18 years agoQuery optimizer enhancement: In "FROM a,b,c left join d" allow the C table
drh [Sat, 16 Dec 2006 16:25:15 +0000 (16:25 +0000)] 
Query optimizer enhancement: In "FROM a,b,c left join d" allow the C table
to be reordered with A and B.  This used to be the case but the capability
was removed by (3203) and (3052) in response to ticket #1652.  This change
restores the capability. (CVS 3529)

FossilOrigin-Name: 7393c81b8cb9d4344ae744de9eabcb3af64f1db8

18 years agoFix a bug in lemon that leads to an assertion fault given an invalid
drh [Thu, 14 Dec 2006 01:06:22 +0000 (01:06 +0000)] 
Fix a bug in lemon that leads to an assertion fault given an invalid
grammar.  The bug and this fix do not effect on SQLite.  Ticket #2107. (CVS 3528)

FossilOrigin-Name: f2ad230f6dce98d664370d77845b5f585de20f08

18 years agoChange the table_info pragma so that it returns NULL for the default
drh [Thu, 30 Nov 2006 13:06:37 +0000 (13:06 +0000)] 
Change the table_info pragma so that it returns NULL for the default
value if there is no default value.  Ticket #2078. (CVS 3527)

FossilOrigin-Name: 5f21c3a5f02b4f2c4550f5904e9d0e1e2eafb0f3

18 years agoImprovements to the new performance tests. (CVS 3526)
drh [Thu, 30 Nov 2006 13:06:00 +0000 (13:06 +0000)] 
Improvements to the new performance tests. (CVS 3526)

FossilOrigin-Name: 27f56c20514030e009fc3aa7e060d2e6276ddb83

18 years agoFix indentation typo in btree.c. (CVS 3525)
drh [Thu, 30 Nov 2006 13:05:29 +0000 (13:05 +0000)] 
Fix indentation typo in btree.c. (CVS 3525)

FossilOrigin-Name: 5d61486f0fbd21ef992879b39d4e563fbfe46596