]> git.ipfire.org Git - thirdparty/sqlite.git/log
thirdparty/sqlite.git
22 years agoAdd tests to insure VACUUM works in the presence of I/O errors. Fix some
drh [Fri, 25 Apr 2003 15:37:57 +0000 (15:37 +0000)] 
Add tests to insure VACUUM works in the presence of I/O errors.  Fix some
problems that came to light by these tests. (CVS 935)

FossilOrigin-Name: 8d3e879349fc9523c72cb46111e0058b57ce9341

22 years agoWork around a name collision problem on windows. (CVS 934)
drh [Fri, 25 Apr 2003 13:28:02 +0000 (13:28 +0000)] 
Work around a name collision problem on windows. (CVS 934)

FossilOrigin-Name: c3b1f84dfce13b2523c9923e4270577862ca0595

22 years agoMake VACUUM work even if multiple processes have the database open at once. (CVS...
drh [Fri, 25 Apr 2003 13:22:51 +0000 (13:22 +0000)] 
Make VACUUM work even if multiple processes have the database open at once. (CVS 933)

FossilOrigin-Name: caa960289f3d1f5e8f35a94e9e4321996c211ed2

22 years agoExplicit casts to squelch bogus warnings for vc++. Ticket #194. (CVS 932)
drh [Fri, 25 Apr 2003 03:13:25 +0000 (03:13 +0000)] 
Explicit casts to squelch bogus warnings for vc++.  Ticket #194. (CVS 932)

FossilOrigin-Name: cb808c14bc14e7bd1cfff134ae5206ace451f2df

22 years agoGet VACUUM working again - with test cases. Some other minor cleanups. (CVS 931)
drh [Fri, 25 Apr 2003 02:43:08 +0000 (02:43 +0000)] 
Get VACUUM working again - with test cases.  Some other minor cleanups. (CVS 931)

FossilOrigin-Name: 5afb88008fed253e6d1fc0ed5172370b61d3727b

22 years agoFix some issues with INSTEAD OF triggers. (CVS 930)
drh [Thu, 24 Apr 2003 01:45:04 +0000 (01:45 +0000)] 
Fix some issues with INSTEAD OF triggers. (CVS 930)

FossilOrigin-Name: 206b17397b1d2b55179c935927ff1d8215728c32

22 years agoRemove the begin_hook and commit_hook APIs. They were a bad idea. Add a
drh [Wed, 23 Apr 2003 12:25:23 +0000 (12:25 +0000)] 
Remove the begin_hook and commit_hook APIs.  They were a bad idea.  Add a
"trace" method to the TCL interface. (CVS 929)

FossilOrigin-Name: 6289b863590ecc5de3d1efaaa60aa6f3f64fefb3

22 years agoUpdate the authorizer API so that it reports the database that table and
drh [Tue, 22 Apr 2003 20:30:37 +0000 (20:30 +0000)] 
Update the authorizer API so that it reports the database that table and
indices belong to and so that it reports when actions are taken in response
to a trigger. (CVS 928)

FossilOrigin-Name: c675a5504138f34cae6def782b5d3add2c67d2bc

22 years agoCheck for readline libs now adds appropriate curses or termcap lib when needed (CVS...
paul [Tue, 22 Apr 2003 08:04:49 +0000 (08:04 +0000)] 
Check for readline libs now adds appropriate curses or termcap lib when needed (CVS 927)

FossilOrigin-Name: 393dd91c252531bb5abfe424b86a5f7eb20edcfc

22 years agoAdd support for TEMPORARY triggers. Such triggers can write temporary or
drh [Mon, 21 Apr 2003 18:48:45 +0000 (18:48 +0000)] 
Add support for TEMPORARY triggers.  Such triggers can write temporary or
permanent tables. (CVS 926)

FossilOrigin-Name: 58ddd587b0f5d565ae3b0ba3a1fa5c20d459f3fc

22 years agoAdd more tests for the in-memory database. (CVS 925)
drh [Sun, 20 Apr 2003 23:45:23 +0000 (23:45 +0000)] 
Add more tests for the in-memory database. (CVS 925)

FossilOrigin-Name: 11cab41c4f02cdddc4fd3f57555573ac2814a81b

22 years agoAdded tests for the in-memory database backend. Also updated some comments
drh [Sun, 20 Apr 2003 17:29:23 +0000 (17:29 +0000)] 
Added tests for the in-memory database backend.  Also updated some comments
in other modules. (CVS 924)

FossilOrigin-Name: fb89adf4d1325c5ea471759ebfd8df7faa4f9a80

22 years agoAlign config vars controlling in-memory DB with code (CVS 923)
paul [Sun, 20 Apr 2003 11:46:34 +0000 (11:46 +0000)] 
Align config vars controlling in-memory DB with code (CVS 923)

FossilOrigin-Name: 921656db9e3df865aea6b1abe1bc40b1acbeeb47

22 years agoReset pCur->eSkip on a MoveTo (CVS 922)
paul [Sun, 20 Apr 2003 11:41:04 +0000 (11:41 +0000)] 
Reset pCur->eSkip on a MoveTo (CVS 922)

FossilOrigin-Name: d983accf4a702158f03742fb11959d0fd035a4b4

22 years agoUpdate comments. Remove unused field from the Index structure. (CVS 921)
drh [Sun, 20 Apr 2003 00:00:23 +0000 (00:00 +0000)] 
Update comments.  Remove unused field from the Index structure. (CVS 921)

FossilOrigin-Name: 7084e05093e72f6e5b65ff0b574336898396826f

22 years agoModify the optimizer so that it does not assume that functions are
drh [Sat, 19 Apr 2003 17:27:24 +0000 (17:27 +0000)] 
Modify the optimizer so that it does not assume that functions are
constant. (CVS 920)

FossilOrigin-Name: 767f1af236d115e8388e1dcc28a4df1be48d6c85

22 years agoBug in WHERE clause processing fixed. Ticket #298. (CVS 919)
drh [Sat, 19 Apr 2003 16:34:04 +0000 (16:34 +0000)] 
Bug in WHERE clause processing fixed.  Ticket #298. (CVS 919)

FossilOrigin-Name: 9b619c98b586a207a87942640d3a94220ff8ab02

22 years agofix a memory leak in btree_rb.c. (CVS 918)
drh [Fri, 18 Apr 2003 22:52:38 +0000 (22:52 +0000)] 
fix a memory leak in btree_rb.c. (CVS 918)

FossilOrigin-Name: 1e3d0d094776c2a429fa2a3eebc036a0b6374862

22 years agoFix for ticket #297 - bug in sqliteSortCompare(). (CVS 917)
drh [Fri, 18 Apr 2003 17:45:14 +0000 (17:45 +0000)] 
Fix for ticket #297 - bug in sqliteSortCompare(). (CVS 917)

FossilOrigin-Name: 4ded1965eb83dee0f28c27ba935d615c77331571

22 years agoThe VACUUM command is now functioning (again). Need to do more testing. (CVS 916)
drh [Fri, 18 Apr 2003 02:31:04 +0000 (02:31 +0000)] 
The VACUUM command is now functioning (again).  Need to do more testing. (CVS 916)

FossilOrigin-Name: 6e948d9aaea109c683ac4fcc4714e335b545d22b

22 years agoFix triggers to work in an ATTACHed database. Ticket #295. (CVS 915)
drh [Thu, 17 Apr 2003 22:57:53 +0000 (22:57 +0000)] 
Fix triggers to work in an ATTACHed database.  Ticket #295. (CVS 915)

FossilOrigin-Name: 1e5e00fb73c308378efd034cb291caf338c9fe84

22 years agoMake sure the min() and max() optimizations work on empty indexed tables.
drh [Thu, 17 Apr 2003 12:44:23 +0000 (12:44 +0000)] 
Make sure the min() and max() optimizations work on empty indexed tables.
Ticket #296. (CVS 914)

FossilOrigin-Name: 98ef6110068e5ed3cd77a14b004f890b79b731f7

22 years agoChange the shell to use the sqliteIsNumber() routine for determining if
drh [Thu, 17 Apr 2003 02:54:13 +0000 (02:54 +0000)] 
Change the shell to use the sqliteIsNumber() routine for determining if
values are numeric.  Modified os.c so that it should now work with DJGPP -
though I have no way of testing this. (CVS 913)

FossilOrigin-Name: 35caefe31750fd103b5f0231ad36f375771063eb

22 years agoRollback if a commit hook fails. (CVS 912)
drh [Wed, 16 Apr 2003 21:03:13 +0000 (21:03 +0000)] 
Rollback if a commit hook fails. (CVS 912)

FossilOrigin-Name: 5cea7554ae9d36434cd7261b5b40f3d467b836f1

22 years agoFix the authorizer so that it correctly interprets attempts to read the
drh [Wed, 16 Apr 2003 20:24:52 +0000 (20:24 +0000)] 
Fix the authorizer so that it correctly interprets attempts to read the
OLD and NEW pseudo-tables of a trigger. (CVS 911)

FossilOrigin-Name: f04bd43254b3ba3fccc842214115d4c298e28138

22 years agoSimplify the number processing code. Fix for ticket #281. (CVS 910)
drh [Wed, 16 Apr 2003 02:17:35 +0000 (02:17 +0000)] 
Simplify the number processing code.  Fix for ticket #281. (CVS 910)

FossilOrigin-Name: 4326b52a39cad4632dc2db37aa53a285a31af138

22 years agoRemove some unnecessary code and complication from the btree interface. (CVS 909)
drh [Wed, 16 Apr 2003 01:28:16 +0000 (01:28 +0000)] 
Remove some unnecessary code and complication from the btree interface. (CVS 909)

FossilOrigin-Name: 35cc7c7d37d9ca486e7f300efe80a78a7f1064e2

22 years agoGet triggers working on tables with INTEGER PRIMARY KEYs. Ticket #291.
drh [Tue, 15 Apr 2003 19:22:22 +0000 (19:22 +0000)] 
Get triggers working on tables with INTEGER PRIMARY KEYs.  Ticket #291.
This may also fix #159.  Still need to add tests so both bugs remain open
for the time being. (CVS 908)

FossilOrigin-Name: 0b996959b8d8bc2c82eab9cccc190befd0056505

22 years agoAdded btree_rb.c (CVS 907)
paul [Tue, 15 Apr 2003 17:22:30 +0000 (17:22 +0000)] 
Added  btree_rb.c (CVS 907)

FossilOrigin-Name: 93eb6c52aca8de15a88247ec986c36245527ec7b

22 years agoDo not record the inserted rowid on when doing an INSERT within a trigger.
drh [Tue, 15 Apr 2003 14:01:43 +0000 (14:01 +0000)] 
Do not record the inserted rowid on when doing an INSERT within a trigger.
Ticket #290. (CVS 906)

FossilOrigin-Name: 96a717661a3b7108fe0cacb588d81fd8e91eb640

22 years agoChange lemon to use <stdarg.h> instead of <varargs.h> because GCC no longer
drh [Tue, 15 Apr 2003 01:49:48 +0000 (01:49 +0000)] 
Change lemon to use <stdarg.h> instead of <varargs.h> because GCC no longer
supports varargs.h.  Tickets #288 and #280.  Ironically, lemon originally
used varargs.h because stdarg.h was not supported by the compiler I was
using in 1989 (which was gcc if I recall correctly.) (CVS 905)

FossilOrigin-Name: 7902e4778ec86e25ad949ae7a6d55b63ac0e85f3

22 years agoChange some variable names and comments in the new in-memory database file
drh [Tue, 15 Apr 2003 01:19:47 +0000 (01:19 +0000)] 
Change some variable names and comments in the new in-memory database file
implementation.  Partial (non-working) implementation of the VACUUM command. (CVS 904)

FossilOrigin-Name: e76787f877c456abdc8bc88bfefc50eaeed68744

22 years agoSupport in-memory databases for temp tables (CVS 903)
paul [Sun, 13 Apr 2003 18:26:49 +0000 (18:26 +0000)] 
Support in-memory databases for temp tables (CVS 903)

FossilOrigin-Name: 96336bffde6c441af197a521ee9e56fdfd7efff8

22 years agoSplit the implementation of COPY, PRAGMA, and ATTACH into separate
drh [Sun, 6 Apr 2003 21:08:24 +0000 (21:08 +0000)] 
Split the implementation of COPY, PRAGMA, and ATTACH into separate
source code files. (CVS 902)

FossilOrigin-Name: 73359037ea639abb066c74db9c19e84bf1104006

22 years agoMove the implementation of VACUUM into a separate source file. (CVS 901)
drh [Sun, 6 Apr 2003 20:52:32 +0000 (20:52 +0000)] 
Move the implementation of VACUUM into a separate source file. (CVS 901)

FossilOrigin-Name: b123c165fd3d0a5a86ee8a7baa669105dafb481a

22 years agoSimplify the BTree interface by shortening names. Added two new methods
drh [Sun, 6 Apr 2003 20:44:45 +0000 (20:44 +0000)] 
Simplify the BTree interface by shortening names.  Added two new methods
for accessing the current filename and for changing the name of the
database file. (CVS 900)

FossilOrigin-Name: 185d8dc8d0c26cef36aeba6992823e5124af4056

22 years agoMore testing of ATTACH and DETACH. (CVS 899)
drh [Sat, 5 Apr 2003 16:56:28 +0000 (16:56 +0000)] 
More testing of ATTACH and DETACH. (CVS 899)

FossilOrigin-Name: 51f515f28cb1cc3e8f0c3531724dc8876b25f18e

22 years agoBegin testing the new ATTACH and DETACH commands. (CVS 898)
drh [Sat, 5 Apr 2003 03:42:26 +0000 (03:42 +0000)] 
Begin testing the new ATTACH and DETACH commands. (CVS 898)

FossilOrigin-Name: 7a0f8024a1323a15d0c83afe9302400736f01fe8

22 years agoFix for ticket #276. (CVS 897)
drh [Thu, 3 Apr 2003 19:35:02 +0000 (19:35 +0000)] 
Fix for ticket #276. (CVS 897)

FossilOrigin-Name: 452128c6fd9a0d82bfab21374fc2041638d264db

22 years agoAdded experimental APIs: sqlite_begin_hook() and sqlite_commit_hook(). (CVS 896)
drh [Thu, 3 Apr 2003 15:46:04 +0000 (15:46 +0000)] 
Added experimental APIs: sqlite_begin_hook() and sqlite_commit_hook(). (CVS 896)

FossilOrigin-Name: 5efbf62313519d0a6e8b8f5dbb29d3ef428d73e8

22 years agoUse a intermediate table when inserting a TEMP table from a SELECT that
drh [Thu, 3 Apr 2003 01:50:44 +0000 (01:50 +0000)] 
Use a intermediate table when inserting a TEMP table from a SELECT that
reads from that same TEMP table.  Ticket #275. (CVS 895)

FossilOrigin-Name: 087d1e83af12b3a9aedd4945f02774a1043b1eb4

22 years agoAdd infrastructure to suport multiple btree implementations (CVS 894)
paul [Tue, 1 Apr 2003 21:16:41 +0000 (21:16 +0000)] 
Add infrastructure to suport multiple btree implementations (CVS 894)

FossilOrigin-Name: 79b3aed2a74a67cbad631c4e2e4a43469d80c162

22 years agoMinor follow-on changes to the recent ATTACH patch. (CVS 893)
drh [Mon, 31 Mar 2003 13:36:09 +0000 (13:36 +0000)] 
Minor follow-on changes to the recent ATTACH patch. (CVS 893)

FossilOrigin-Name: 11378c5bf988412f8564cdc0314fc241793b292e

22 years agoMinor follow-on changes to the recent ATTACH patch. (CVS 892)
drh [Mon, 31 Mar 2003 13:36:09 +0000 (13:36 +0000)] 
Minor follow-on changes to the recent ATTACH patch. (CVS 892)

FossilOrigin-Name: e80afe75b33d4eacb40ef6128cf688f7c3253984

22 years agoAdd the sqliteErrorMsg() function and use it to generate error message
drh [Mon, 31 Mar 2003 02:12:46 +0000 (02:12 +0000)] 
Add the sqliteErrorMsg() function and use it to generate error message
text during parsing and code generation.  This simplifies the code
somewhat and makes it easier to handle names with a database prefix. (CVS 891)

FossilOrigin-Name: 1d3fc977211abdc7ba3fd51d661863e8ce5aef69

22 years agoThe ATTACH and DETACH statements are now coded but are still mostly untested. (CVS...
drh [Mon, 31 Mar 2003 00:30:47 +0000 (00:30 +0000)] 
The ATTACH and DETACH statements are now coded but are still mostly untested. (CVS 890)

FossilOrigin-Name: c7c5e927a54f0fbc2ca625754787aff4d9c4eff1

22 years agoRemove the experimental sqlite_open_aux_file() API. It will soon be replaced
drh [Sun, 30 Mar 2003 19:17:02 +0000 (19:17 +0000)] 
Remove the experimental sqlite_open_aux_file() API.  It will soon be replaced
by ATTACH and DETACH SQL commands. (CVS 1732)

FossilOrigin-Name: 0a358844e40020557c1aeea5779b194670350930

22 years agoRemove the experimental sqlite_open_aux_file() API. It will soon be replaced
drh [Sun, 30 Mar 2003 19:17:01 +0000 (19:17 +0000)] 
Remove the experimental sqlite_open_aux_file() API.  It will soon be replaced
by ATTACH and DETACH SQL commands. (CVS 889)

FossilOrigin-Name: b6d6e07f3a5cb493f2cf0675bc6061c5afe5c078

22 years agoRemove the obsolete documentation on how to crosscompile version 1.0 of
drh [Sun, 30 Mar 2003 18:58:58 +0000 (18:58 +0000)] 
Remove the obsolete documentation on how to crosscompile version 1.0 of
SQLite. (CVS 888)

FossilOrigin-Name: ac0622bf5fca9c8907319a20158e991efdaa6402

22 years agoDetect when a child node of a btree page has zero entries and report that
drh [Sun, 30 Mar 2003 18:41:22 +0000 (18:41 +0000)] 
Detect when a child node of a btree page has zero entries and report that
as a case of database corruption. (CVS 887)

FossilOrigin-Name: 66c80ae232a78ecb010280ab1aa684cb78b0662f

22 years agoFix a memory leak in triggers and update tests to show the latest error
drh [Sun, 30 Mar 2003 00:19:49 +0000 (00:19 +0000)] 
Fix a memory leak in triggers and update tests to show the latest error
message text. (CVS 886)

FossilOrigin-Name: b90d9de32d10a71fe81f5bfd0cf57faae8c5c3b4

22 years agoRegression tests now work - except for some changes in error message
drh [Thu, 27 Mar 2003 13:50:00 +0000 (13:50 +0000)] 
Regression tests now work - except for some changes in error message
text.  The library is now safe to use for experimental work. (CVS 885)

FossilOrigin-Name: 8a593e9c2d57e758739a7ef54fa40ca6a0071a9a

22 years agoFix a segfault in the trigger code. (CVS 884)
drh [Thu, 27 Mar 2003 13:01:28 +0000 (13:01 +0000)] 
Fix a segfault in the trigger code. (CVS 884)

FossilOrigin-Name: 7672914b196cd55744edda8e5d8f1b7b86f898f9

22 years agoChanges to the "sqlite" structure that allow simultaneous operations on
drh [Thu, 27 Mar 2003 12:51:25 +0000 (12:51 +0000)] 
Changes to the "sqlite" structure that allow simultaneous operations on
multiple database files.  Many regession tests pass - but not all of them.
Do not use this version except for debugging SQLite itself. (CVS 1731)

FossilOrigin-Name: 9ac71c329e17a0934d2a824eacc33e9a2ebce7c3

22 years agoChanges to the "sqlite" structure that allow simultaneous operations on
drh [Thu, 27 Mar 2003 12:51:24 +0000 (12:51 +0000)] 
Changes to the "sqlite" structure that allow simultaneous operations on
multiple database files.  Many regession tests pass - but not all of them.
Do not use this version except for debugging SQLite itself. (CVS 883)

FossilOrigin-Name: d2fb2bb50cf1e13feb90995079f291384abd6ba9

22 years agoRe-generated. (CVS 882)
a.rottmann [Mon, 24 Mar 2003 09:42:16 +0000 (09:42 +0000)] 
Re-generated. (CVS 882)

FossilOrigin-Name: f0c5bcf72cf393ea4c5cd126d085cb959eebd5f2

22 years agoUpdated libtool. (CVS 881)
a.rottmann [Mon, 24 Mar 2003 09:40:34 +0000 (09:40 +0000)] 
Updated libtool. (CVS 881)

FossilOrigin-Name: b1ca4e13dcab92cc532f4051f24bf5b1be251463

22 years agoAdded pkg-config support. (CVS 880)
a.rottmann [Mon, 24 Mar 2003 09:39:32 +0000 (09:39 +0000)] 
Added pkg-config support. (CVS 880)

FossilOrigin-Name: ec1c5a611307047dd0049353e989e75dcaffaa45

22 years agoRecord the database name in addition to the table name for DELETE, INSERT,
drh [Thu, 20 Mar 2003 01:16:58 +0000 (01:16 +0000)] 
Record the database name in addition to the table name for DELETE, INSERT,
and UPDATE statements. (CVS 879)

FossilOrigin-Name: a5d8fc95ee58dc3205a0bbbcadaa3b9c902a941b

22 years agoModifications to the VDBE to support more than one database file. (CVS 878)
drh [Wed, 19 Mar 2003 03:14:00 +0000 (03:14 +0000)] 
Modifications to the VDBE to support more than one database file. (CVS 878)

FossilOrigin-Name: 875da9eed981bfa27b98e95025f9fdbed74b4098

22 years agoDo not allow an empty string to be inserted into an INTEGER PRIMARY KEY. (CVS 877)
drh [Fri, 7 Mar 2003 19:50:07 +0000 (19:50 +0000)] 
Do not allow an empty string to be inserted into an INTEGER PRIMARY KEY. (CVS 877)

FossilOrigin-Name: 2aba40bea5fc1c4aef8cfd4c790d40808821ca14

22 years agoAdd more tests to make sure that sqlite_changes() works when using the
drh [Sat, 1 Mar 2003 19:53:15 +0000 (19:53 +0000)] 
Add more tests to make sure that sqlite_changes() works when using the
non-callback API.  Ticket #250. (CVS 876)

FossilOrigin-Name: 13e501d190e327cc6fc16e182819ea9d7bb9c566

22 years agoGet the non-callback API working with the EXPLAIN keyword and for PRAGMAs.
drh [Sat, 1 Mar 2003 19:45:34 +0000 (19:45 +0000)] 
Get the non-callback API working with the EXPLAIN keyword and for PRAGMAs.
Tickets #258 and #257.  Update the API documentation on the sqlite_changes()
routine to explain how it works with the non-callback API.  Ticket #250. (CVS 875)

FossilOrigin-Name: 620e1065e978545dd7bf6fa6fad1e6b93918dbf8

22 years agoFix a memory leak associated with PRIMARY KEY in a CREATE TABLE statement
drh [Wed, 26 Feb 2003 13:52:52 +0000 (13:52 +0000)] 
Fix a memory leak associated with PRIMARY KEY in a CREATE TABLE statement
that fails.  Ticket #249. (CVS 874)

FossilOrigin-Name: 8e9dc567996c3301c14a1f055ff2265770cbc3e1

22 years agoFix a memory leak associated with PRIMARY KEY in a CREATE TABLE statement
drh [Wed, 26 Feb 2003 13:52:51 +0000 (13:52 +0000)] 
Fix a memory leak associated with PRIMARY KEY in a CREATE TABLE statement
that fails.  Ticket #249. (CVS 1730)

FossilOrigin-Name: 66158843dfa073ffb8779a5170e091cebc018855

22 years agoWhen the right table in a LEFT OUTER JOIN contains an INTEGER PRIMARY KEY
drh [Thu, 20 Feb 2003 01:48:12 +0000 (01:48 +0000)] 
When the right table in a LEFT OUTER JOIN contains an INTEGER PRIMARY KEY
make sure that key is NULL if there is no row in the right table that
matches the current row in the left table.  Tickets #246 and #247. (CVS 873)

FossilOrigin-Name: 6a45fe3bd7e19cf9c20fc6cb65b0269cdd704490

22 years agoFix the parsing of the LIMIT clause when the limit and offset are separated
drh [Thu, 20 Feb 2003 00:44:52 +0000 (00:44 +0000)] 
Fix the parsing of the LIMIT clause when the limit and offset are separated
by a comma.  The offset comes before the limit in that case. Ticket #245. (CVS 872)

FossilOrigin-Name: 6ef91a364b2922f078b7de81816bca3f2ca0fe46

22 years agoVersion 2.8.0 (CVS 870)
drh [Sun, 16 Feb 2003 22:49:47 +0000 (22:49 +0000)] 
Version 2.8.0 (CVS 870)

FossilOrigin-Name: 5db98b3f4048fc8cd28d8fd225f2b0221ccf1d17

22 years agoCouple of last-minute changes before 2.8.0. (CVS 871)
drh [Sun, 16 Feb 2003 22:48:12 +0000 (22:48 +0000)] 
Couple of last-minute changes before 2.8.0. (CVS 871)

FossilOrigin-Name: 8192c937d524fef703d7ba2eb608c3d74e20440f

22 years agoUpdate the speed comparison documentation to show the improved performance
drh [Sun, 16 Feb 2003 22:36:03 +0000 (22:36 +0000)] 
Update the speed comparison documentation to show the improved performance
of PostgreSQL after performance tuning. (CVS 869)

FossilOrigin-Name: 73c904e57a158820705daf5737e0fc825cfe1aea

22 years agoAdded test code to check for file descriptor leaks. All regression tests pass
drh [Sun, 16 Feb 2003 22:21:32 +0000 (22:21 +0000)] 
Added test code to check for file descriptor leaks.  All regression tests pass
now on both win2k and linux. (CVS 868)

FossilOrigin-Name: 75ba78280f7ab6b6acce5878859312f3223ee898

22 years agoFix more bugs. The new rollback journal implementation now passes all
drh [Sun, 16 Feb 2003 19:13:36 +0000 (19:13 +0000)] 
Fix more bugs.  The new rollback journal implementation now passes all
regression tests under Linux. (CVS 867)

FossilOrigin-Name: d10adc1c5727d76320d5919be55e86d030e9c8bc

22 years agoFix the pager so that correct rollbacks occur when synchronous is turned off.
drh [Sat, 15 Feb 2003 23:09:17 +0000 (23:09 +0000)] 
Fix the pager so that correct rollbacks occur when synchronous is turned off.
This check-in also included unrelated documentation updates. (CVS 866)

FossilOrigin-Name: 3ef0ad8a4f2696a58aff9d812f90038c2c63f3fc

22 years agoUpdate the documentation for the new journal format to be introduced in
drh [Thu, 13 Feb 2003 02:54:03 +0000 (02:54 +0000)] 
Update the documentation for the new journal format to be introduced in
version 2.8.0. (CVS 1729)

FossilOrigin-Name: dc53d92141c931fb133149355c3a1ea64030e676

22 years agoUpdate the documentation for the new journal format to be introduced in
drh [Thu, 13 Feb 2003 02:54:03 +0000 (02:54 +0000)] 
Update the documentation for the new journal format to be introduced in
version 2.8.0. (CVS 865)

FossilOrigin-Name: e05a7a552f694158ee449d8682f5c137f1c2f2ac

22 years agoFix a bug in the rollback logic for the new journal format. (CVS 864)
drh [Thu, 13 Feb 2003 01:58:20 +0000 (01:58 +0000)] 
Fix a bug in the rollback logic for the new journal format. (CVS 864)

FossilOrigin-Name: 7c22aa3f817e737cfd943d903856756468e8678b

22 years agoAdded the new FULL option to the SYNCHRONOUS pragma. Still need to test it. (CVS...
drh [Wed, 12 Feb 2003 14:09:43 +0000 (14:09 +0000)] 
Added the new FULL option to the SYNCHRONOUS pragma.  Still need to test it. (CVS 1728)

FossilOrigin-Name: 8968bc063607856775ad63b6594d40c55cf288c0

22 years agoAdded the new FULL option to the SYNCHRONOUS pragma. Still need to test it. (CVS...
drh [Wed, 12 Feb 2003 14:09:42 +0000 (14:09 +0000)] 
Added the new FULL option to the SYNCHRONOUS pragma.  Still need to test it. (CVS 863)

FossilOrigin-Name: 792a9e157dd066fcaffd4f5b373010151fb4ca61

22 years agoFix a bug in the legacy journal format writing logic. (CVS 862)
drh [Wed, 12 Feb 2003 02:10:15 +0000 (02:10 +0000)] 
Fix a bug in the legacy journal format writing logic. (CVS 862)

FossilOrigin-Name: 6c927dd36c19ebb8bb8222b4d18ed67f4fe733e8

22 years agoModify the journal format to be more robust against garbage that might appear
drh [Tue, 11 Feb 2003 14:55:40 +0000 (14:55 +0000)] 
Modify the journal format to be more robust against garbage that might appear
in the file after a power failure.  The changes are mostly working but more
testing is still required.  This check-in is to checkpoint the changes so far. (CVS 861)

FossilOrigin-Name: 8ec5632536eea31197a3b1fd6abc57881a0cf1d7

22 years agoMake the shell run much faster for inputs where a single SQL statement spans
drh [Wed, 5 Feb 2003 14:06:20 +0000 (14:06 +0000)] 
Make the shell run much faster for inputs where a single SQL statement spans
thousands of lines by avoiding the call to sqlite_complete() unless the
input ends in a semicolon. (CVS 860)

FossilOrigin-Name: e21afb82b53eade9ee267a97c58db0606f0c0a41

22 years agoMake the GROUP BY clause work even if there are no aggregate functions. (CVS 859)
drh [Sun, 2 Feb 2003 12:41:25 +0000 (12:41 +0000)] 
Make the GROUP BY clause work even if there are no aggregate functions. (CVS 859)

FossilOrigin-Name: b68792315883eed8523f5e11856ec8378dc972c1

22 years agoWhen a CREATE TABLE ... AS SELECT statement fails, make sure the table name
drh [Sat, 1 Feb 2003 13:53:28 +0000 (13:53 +0000)] 
When a CREATE TABLE ... AS SELECT statement fails, make sure the table name
is removed from the internal hash tables.  Ticket #238. (CVS 858)

FossilOrigin-Name: 65264780c553e8a00ec7a40cf76b89a11b245faf

22 years agoThe sqlite_exec() function now returns SQLITE_AUTH when authorization fails.
drh [Fri, 31 Jan 2003 17:21:49 +0000 (17:21 +0000)] 
The sqlite_exec() function now returns SQLITE_AUTH when authorization fails.
Ticket #231. (CVS 857)

FossilOrigin-Name: d93c1aeb544a5b1056424945eb43854213b30e50

22 years agoAllow double-quoted strings as string constants in the IN operator. As a
drh [Fri, 31 Jan 2003 17:16:36 +0000 (17:16 +0000)] 
Allow double-quoted strings as string constants in the IN operator.  As a
side-efffect, allow the GROUP BY clause to refer to columns by their integer
column number.  Ticket #237. (CVS 856)

FossilOrigin-Name: 187d9c405891e543fc706f8ddb41f3966a842214

22 years agoAdditional testing and bug fixing with the non-callback API. Updated the
drh [Wed, 29 Jan 2003 22:58:26 +0000 (22:58 +0000)] 
Additional testing and bug fixing with the non-callback API.  Updated the
C/C++ interface document to describe the non-callback API. (CVS 855)

FossilOrigin-Name: af1e9299468aa70d7d91e7a5445ba391ccc8ff8b

22 years agoBetter error messages on constraint violations. Additional tests and bug fixes
drh [Wed, 29 Jan 2003 18:46:51 +0000 (18:46 +0000)] 
Better error messages on constraint violations.  Additional tests and bug fixes
for the callback-free API. (CVS 854)

FossilOrigin-Name: ccc82f1ab4539a60ee5cc2625743c5389f9ccd8e

22 years agoThe callback-free API is now working, though much more testing is need. (CVS 853)
drh [Wed, 29 Jan 2003 14:06:07 +0000 (14:06 +0000)] 
The callback-free API is now working, though much more testing is need. (CVS 853)

FossilOrigin-Name: 162b259188e6967fe9c3722da26b81aab5655d83

22 years agoFirst code for the new callback-free API. All regression tests pass but the
drh [Tue, 28 Jan 2003 23:13:10 +0000 (23:13 +0000)] 
First code for the new callback-free API.  All regression tests pass but the
new API is mostly untested and is unlikely to work. (CVS 852)

FossilOrigin-Name: 065fa818ffc8d7562889172acea16e4e44e773ef

22 years agoAdded section on comments.
jplyon [Sun, 26 Jan 2003 15:28:18 +0000 (15:28 +0000)] 
Added section on comments.
Corrected broken </p> end tags. (CVS 851)

FossilOrigin-Name: c957f4f0c6b486f25bc567dafeed186f91c8c315

22 years agoVersion 2.7.6 (CVS 850)
drh [Sat, 25 Jan 2003 16:32:13 +0000 (16:32 +0000)] 
Version 2.7.6 (CVS 850)

FossilOrigin-Name: bdba796f3b89690ab5d53a9e16924383ef72657c

22 years agoFix a bug in the rollback validation logic (code that only runs during
drh [Sat, 25 Jan 2003 15:43:22 +0000 (15:43 +0000)] 
Fix a bug in the rollback validation logic (code that only runs during
debugging).  The problem was introduced by check-in (835). (CVS 849)

FossilOrigin-Name: b6ea0da76a27a4a67a3978c53405840518de2379

22 years agoRemove an unused variable. (CVS 848)
drh [Sat, 25 Jan 2003 14:34:23 +0000 (14:34 +0000)] 
Remove an unused variable. (CVS 848)

FossilOrigin-Name: 18f4ffaa2ed89784a1ea3c61c864d20e18fa1e9f

22 years agoPreparations for the release of version 2.7.6. (CVS 847)
drh [Sat, 25 Jan 2003 14:32:03 +0000 (14:32 +0000)] 
Preparations for the release of version 2.7.6. (CVS 847)

FossilOrigin-Name: 5143d4814df1dd440a362a90dd3f328c84527565

22 years agoUpdate the speed.html documentation. Recent optimizations have made the
drh [Sat, 25 Jan 2003 14:25:42 +0000 (14:25 +0000)] 
Update the speed.html documentation.  Recent optimizations have made the
library much faster. (CVS 846)

FossilOrigin-Name: ed47d162a072a2f98b633cc14f2be1474288d90b

22 years agoAdd asserts to btree.c that check for the correct size of various typedefs
drh [Fri, 24 Jan 2003 12:14:20 +0000 (12:14 +0000)] 
Add asserts to btree.c that check for the correct size of various typedefs
and structures.  Ticket #233. (CVS 845)

FossilOrigin-Name: c7e647d011b086a6e57420850f6bc4f28fcb23ee

22 years agoMinor refinements to the pager. (CVS 844)
drh [Wed, 22 Jan 2003 01:26:44 +0000 (01:26 +0000)] 
Minor refinements to the pager. (CVS 844)

FossilOrigin-Name: 19221dee5fee4c8800cbae309f009964c8d646a2

22 years agofix a typo on the quickstart.html page. (CVS 843)
drh [Tue, 21 Jan 2003 23:06:57 +0000 (23:06 +0000)] 
fix a typo on the quickstart.html page. (CVS 843)

FossilOrigin-Name: 61869bb51b981a47d783cc8739833cc0c4733b0a

22 years agoIn the pager, cache a pointer to the first page on the freelist that does not
drh [Tue, 21 Jan 2003 02:39:36 +0000 (02:39 +0000)] 
In the pager, cache a pointer to the first page on the freelist that does not
need to be synced.  This makes a fetch of a page that is not in cache go a
lot faster when the cache is full.  This check-in also adds some performance
instrumentation to the OS layer. (CVS 842)

FossilOrigin-Name: 00f08fc0b5b6b9c5efbf15a62f9a1cc1cfa71283

22 years agoUpdate comments. No changes to code. (CVS 841)
drh [Sun, 19 Jan 2003 03:59:45 +0000 (03:59 +0000)] 
Update comments.  No changes to code. (CVS 841)

FossilOrigin-Name: f6a8706872c43cee3003b48bb427c7b74b1f89e7