]> git.ipfire.org Git - thirdparty/sqlite.git/log
thirdparty/sqlite.git
17 years agoTest file containing minimal example of bug #2832. (CVS 4614)
danielk1977 [Wed, 12 Dec 2007 14:46:58 +0000 (14:46 +0000)] 
Test file containing minimal example of bug #2832. (CVS 4614)

FossilOrigin-Name: ed2e61a9fab6a9a102031c10bc6f89e78b4c7447

17 years agoFix database corrupting code generation error for UPDATE OR REPLACE.
drh [Wed, 12 Dec 2007 12:25:21 +0000 (12:25 +0000)] 
Fix database corrupting code generation error for UPDATE OR REPLACE.
ticket #2832.  Still need to add test cases and additional defensive
logic to avoid future occurrences of similar problems. (CVS 4613)

FossilOrigin-Name: 18e10f816782ca7842f651e9b2a23da1aab645c8

17 years agoAdd a new OP_StackDepth opcode to help detect VDBE stack leaks early,
drh [Wed, 12 Dec 2007 12:00:45 +0000 (12:00 +0000)] 
Add a new OP_StackDepth opcode to help detect VDBE stack leaks early,
before they cause damage.  For diagnostics in ticket #2832. (CVS 4612)

FossilOrigin-Name: 3fd6a267533cedcca9b8ba3533c107d7341a06c6

17 years agoFix test numbering in tkt2822.test. Ticket #2830. (CVS 4611)
danielk1977 [Wed, 12 Dec 2007 04:38:26 +0000 (04:38 +0000)] 
Fix test numbering in tkt2822.test. Ticket #2830. (CVS 4611)

FossilOrigin-Name: 8fe8e9c460e0f8ebc4267de96b0c971cb6370861

17 years agoFix a comment on the SQLITE_SQL_MAX_LENGTH definition. (CVS 4610)
drh [Tue, 11 Dec 2007 20:04:14 +0000 (20:04 +0000)] 
Fix a comment on the SQLITE_SQL_MAX_LENGTH definition. (CVS 4610)

FossilOrigin-Name: 9335c940504f5979066b70ec445b57acfb251713

17 years agoBuild the CLI using the amalgamation. Relax the limit on SQL statement
drh [Tue, 11 Dec 2007 19:34:44 +0000 (19:34 +0000)] 
Build the CLI using the amalgamation.  Relax the limit on SQL statement
length when building the CLI. (CVS 4609)

FossilOrigin-Name: a5d81cd371913dff4b1337a9586645f967371ab9

17 years agoFix a 'const' issue in trimFunc(). (CVS 4608)
danielk1977 [Tue, 11 Dec 2007 04:23:19 +0000 (04:23 +0000)] 
Fix a 'const' issue in trimFunc(). (CVS 4608)

FossilOrigin-Name: 64787d78b99a549a87bc2baeff8ae87691612b77

17 years agoMake sure the windows driver responds correctly to the
drh [Mon, 10 Dec 2007 21:11:31 +0000 (21:11 +0000)] 
Make sure the windows driver responds correctly to the
SQLITE_OPEN_DELETEONCLOSE flag.  Ticket #2829. (CVS 4607)

FossilOrigin-Name: 19db91fd683c465b8c8a862143a01178682da445

17 years agoFurther modifications to do with ORDER BY and compound SELECT queries. Related to...
danielk1977 [Mon, 10 Dec 2007 18:51:47 +0000 (18:51 +0000)] 
Further modifications to do with ORDER BY and compound SELECT queries. Related to ticket #2822. (CVS 4606)

FossilOrigin-Name: 0d9b0e6e3a8f8a66956878084085842e94c3cb2f

17 years agoFix a macro in func.c that causes problems for the amalgamation. (CVS 4605)
drh [Mon, 10 Dec 2007 18:07:20 +0000 (18:07 +0000)] 
Fix a macro in func.c that causes problems for the amalgamation. (CVS 4605)

FossilOrigin-Name: 6adbe91efffc6b3f53dae87494430ede61d40ecc

17 years agoFix a bug in the compilation procedures for the Linux shared library
drh [Mon, 10 Dec 2007 17:55:16 +0000 (17:55 +0000)] 
Fix a bug in the compilation procedures for the Linux shared library
that includes the TCL bindings. (CVS 4604)

FossilOrigin-Name: d384810a95c97b868a87d090f8dcb903cc82cbf7

17 years agoFix compilation/testing with OMIT_SUBQUERY defined. Ticket #2828. (CVS 4603)
danielk1977 [Mon, 10 Dec 2007 05:03:46 +0000 (05:03 +0000)] 
Fix compilation/testing with OMIT_SUBQUERY defined. Ticket #2828. (CVS 4603)

FossilOrigin-Name: 0b34a18651764e650faba983be8593992ab2f4a9

17 years agoBetter resolution of ORDER BY terms in compound queries. Candidate
drh [Sat, 8 Dec 2007 21:10:20 +0000 (21:10 +0000)] 
Better resolution of ORDER BY terms in compound queries.  Candidate
solution for ticket #2822.  Needs more testing and documentation
before going final. (CVS 4602)

FossilOrigin-Name: 62a78d212c53a9cb1759d03134653a75f3a086b6

17 years agoStrengthen the tests for aggregate functions in GROUP BY clauses.
drh [Sat, 8 Dec 2007 18:01:30 +0000 (18:01 +0000)] 
Strengthen the tests for aggregate functions in GROUP BY clauses.
Changes to test cases only.  No changes to code. (CVS 4601)

FossilOrigin-Name: 4be8e6765bf8bc48747b2542f2ed77066fb9dcb9

17 years agoFix a bug in the debugging printf logic. (CVS 4600)
drh [Sat, 8 Dec 2007 17:55:35 +0000 (17:55 +0000)] 
Fix a bug in the debugging printf logic. (CVS 4600)

FossilOrigin-Name: 1d6a9f5fafb862fb31c8589fa118a5672bad6abd

17 years agoChange prefix search from O(N*M) to O(NlogM). The previous code
shess [Fri, 7 Dec 2007 23:47:53 +0000 (23:47 +0000)] 
Change prefix search from O(N*M) to O(NlogM).  The previous code
linearly merged the doclists, so as the accumulated list got large,
things got slow (the M term, a fucntion of the number of documents in
the index).  This change does pairwise merges until a single doclist
remains.  A test search of 't*' against a database of RFC text
improves from 1m16s to 4.75s. (CVS 4599)

FossilOrigin-Name: feef1b15d645d638b4a05742f214b0445fa7e176

17 years agoIn shared-cache mode, make sure the busy hander invoked is the
drh [Fri, 7 Dec 2007 18:55:28 +0000 (18:55 +0000)] 
In shared-cache mode, make sure the busy hander invoked is the
busy handler associated with the database connection that caused
the lock contention in the first place. (CVS 4598)

FossilOrigin-Name: c9eb65912f61ce0a6b66fe253652a1827e46b12a

17 years agoGet the LIKE and GLOB operators working again on systems using the
drh [Fri, 7 Dec 2007 18:39:04 +0000 (18:39 +0000)] 
Get the LIKE and GLOB operators working again on systems using the
EBCDIC character set. (CVS 4597)

FossilOrigin-Name: 754298a74e3d889f3767daba058262613d20a601

17 years agoFix a leaking database connection in the vacuum2 test script.
drh [Thu, 6 Dec 2007 17:41:27 +0000 (17:41 +0000)] 
Fix a leaking database connection in the vacuum2 test script.
Ticket #2827. (CVS 4596)

FossilOrigin-Name: f29deb5f0bfcd6d00795aeb66dece717a6c1768a

17 years agoUse the specified buffer length, not the maximum buffer length in
drh [Thu, 6 Dec 2007 13:26:20 +0000 (13:26 +0000)] 
Use the specified buffer length, not the maximum buffer length in
unixFullPathname() and related functions. (CVS 4595)

FossilOrigin-Name: f015a38771d98996366d66787b9b066f9ef5e248

17 years agoContinuing work on the C/C++ interface requirements that appears as
drh [Thu, 6 Dec 2007 02:42:07 +0000 (02:42 +0000)] 
Continuing work on the C/C++ interface requirements that appears as
comments in sqlite.h.in. (CVS 4594)

FossilOrigin-Name: 2130e7125187ca46df3f65237f933b0e568a36ed

17 years agoBegin adding requirements numbers to the C/C++ interface documentation. (CVS 4593)
drh [Wed, 5 Dec 2007 18:05:16 +0000 (18:05 +0000)] 
Begin adding requirements numbers to the C/C++ interface documentation. (CVS 4593)

FossilOrigin-Name: ae1936aadf00bec91750d41be7507cf1b81fc411

17 years agoAdd the ability to change the autovacuum status of an existing database
drh [Wed, 5 Dec 2007 01:38:23 +0000 (01:38 +0000)] 
Add the ability to change the autovacuum status of an existing database
by setting the auto_vacuum pragma then running the VACUUM command. (CVS 4592)

FossilOrigin-Name: bdfc19e838b369a8c5d5d23663fad690f55ba3d7

17 years agoMake sure statement journals are initiated when doing DROP operations
drh [Tue, 4 Dec 2007 16:54:52 +0000 (16:54 +0000)] 
Make sure statement journals are initiated when doing DROP operations
(since the DROP might fail after sqlite_master changes).  Also make
sure statement journals are initiated if there are pending SELECT
statements.  Ticket #2820. (CVS 4591)

FossilOrigin-Name: bf34284ff0c60ae6e735e09bb29cd48b158e8dce

17 years agoFix a bug in the TCL code for sqlite3_analyzer. (CVS 4590)
drh [Tue, 4 Dec 2007 13:41:51 +0000 (13:41 +0000)] 
Fix a bug in the TCL code for sqlite3_analyzer. (CVS 4590)

FossilOrigin-Name: 7c2cf4542852a81daf29a930ab103c52bb678326

17 years agoClarify the operation of sqlite3_blob_close() in the API documentation.
drh [Tue, 4 Dec 2007 13:22:43 +0000 (13:22 +0000)] 
Clarify the operation of sqlite3_blob_close() in the API documentation.
Ticket #2815. (CVS 4589)

FossilOrigin-Name: 78f359dffa6f4af4d5b7e4523f451e0e405350c0

17 years agoDo not require os_other.h if compiling with -DOS_OTHER=1. (CVS 4588)
drh [Mon, 3 Dec 2007 21:52:09 +0000 (21:52 +0000)] 
Do not require os_other.h if compiling with -DOS_OTHER=1. (CVS 4588)

FossilOrigin-Name: 96ec39031e0b0b9a69e7b5647580326a87f94d2e

17 years agoWhen parsing CREATE INDEX statements from the sqlite_master table, do not search...
danielk1977 [Sun, 2 Dec 2007 11:46:34 +0000 (11:46 +0000)] 
When parsing CREATE INDEX statements from the sqlite_master table, do not search the temp database schema for the corresponding table. Only consider the database for which the schema is being parsed. Ticket #2817. (CVS 4587)

FossilOrigin-Name: e6f02aa5ae6da0befdf98fdd5884345f3cb7f5ea

17 years agoAnother fix to Makefile.in for mingw. (CVS 4586)
drh [Sat, 1 Dec 2007 19:25:17 +0000 (19:25 +0000)] 
Another fix to Makefile.in for mingw. (CVS 4586)

FossilOrigin-Name: cfaeb02554ab86fffbfb8eb2a78c7d8a59a9cba5

17 years agoBeginning attempts at casting the sqlite.h.in documentation into
drh [Sat, 1 Dec 2007 19:23:19 +0000 (19:23 +0000)] 
Beginning attempts at casting the sqlite.h.in documentation into
formal requirements. (CVS 4585)

FossilOrigin-Name: 2ea78d2cbd86edda6f998fbb364800d3ecf76479

17 years agoBug fix to Makefile.in to allow it to work with mingw. (CVS 4584)
drh [Sat, 1 Dec 2007 09:32:53 +0000 (09:32 +0000)] 
Bug fix to Makefile.in to allow it to work with mingw. (CVS 4584)

FossilOrigin-Name: fdca98d1eb44c05ffb3c42acb9f87f57460c4cc8

17 years agoAdd a few function requirements numbers to interfaces in the comments
drh [Fri, 30 Nov 2007 01:06:16 +0000 (01:06 +0000)] 
Add a few function requirements numbers to interfaces in the comments
of sqlite3.h.in.  This is experimental. (CVS 4583)

FossilOrigin-Name: b829a64515e88e83aecd339342bad3b140c86bb0

17 years agoMake sure we never try to "truncate" a file to a larger size. (CVS 4582)
drh [Thu, 29 Nov 2007 18:44:27 +0000 (18:44 +0000)] 
Make sure we never try to "truncate" a file to a larger size. (CVS 4582)

FossilOrigin-Name: 7d2f6a1d6c5ab89a3b65fbcaf172abf6d81e206b

17 years agoAdd the optional (and experimental) mmap() memory allocator in the
drh [Thu, 29 Nov 2007 18:36:49 +0000 (18:36 +0000)] 
Add the optional (and experimental) mmap() memory allocator in the
mem4.c module. (CVS 4581)

FossilOrigin-Name: cfd683ac80fd043343e0f0af90805058daa3818d

17 years agoWhen using an index to scan a database table, read column data from the index in...
danielk1977 [Thu, 29 Nov 2007 17:43:27 +0000 (17:43 +0000)] 
When using an index to scan a database table, read column data from the index in preference to the table. This increases the likelihood that the table will not be required at all. (CVS 4580)

FossilOrigin-Name: 061608c72ac0a96eacf3b64d638235e4739f96ba

17 years agoOptimisations for expressions of the form "<value> IN (SELECT <column> FROM <table...
danielk1977 [Thu, 29 Nov 2007 17:05:18 +0000 (17:05 +0000)] 
Optimisations for expressions of the form "<value> IN (SELECT <column> FROM <table>)". (CVS 4579)

FossilOrigin-Name: 56d0e32677744df8570b519fae1c04da4ea4984d

17 years agoAdd the {quote: StrAccum} object
drh [Wed, 28 Nov 2007 22:36:40 +0000 (22:36 +0000)] 
Add the {quote: StrAccum} object
 for accumulating strings.  Revamp xprintf to use
the new object.  Rewrite the group_concat() function to use the new object.
Productize and test the group_concat() function. (CVS 4578)

FossilOrigin-Name: 221aee72be040769e8026b91648f03c6366a8821

17 years agoChange the BTree so that it uses the Pagers temporary page space when
drh [Wed, 28 Nov 2007 16:19:56 +0000 (16:19 +0000)] 
Change the BTree so that it uses the Pagers temporary page space when
reorganizing the rows on a page, rather than mallocing for space of
its own.  In this way, we avoid having to deal with a malloc failure
deep down inside the page reorganizer.  Ticket #2806 (CVS 4577)

FossilOrigin-Name: 98960132dc082da61652201f4bd2b559725350c0

17 years agoReorganize the code for the homegrown recursive mutexes. Fix a place
drh [Wed, 28 Nov 2007 14:04:57 +0000 (14:04 +0000)] 
Reorganize the code for the homegrown recursive mutexes.  Fix a place
in the previous check-in where the #ifdef label was incorrect.
Ticket #2804. (CVS 4576)

FossilOrigin-Name: 542e11f954983ae26fef4ea850c8b2a20f738edd

17 years agoClarify the conditions under which homegrown recursive mutexes work
drh [Wed, 28 Nov 2007 13:55:55 +0000 (13:55 +0000)] 
Clarify the conditions under which homegrown recursive mutexes work
(they require a coherent cache) and only enable them if there is an
explicit #define so as to avoid accidental use on platforms that do
not meet the constraints.  Ticket #2805. (CVS 4575)

FossilOrigin-Name: 80299eebddba9aac4c1bc36ffa2b440bffbf1751

17 years agoPreset the legacy_file_format pragma to the value of the primary
drh [Wed, 28 Nov 2007 13:43:16 +0000 (13:43 +0000)] 
Preset the legacy_file_format pragma to the value of the primary
database so that a VACUUM will not unknowingly alter the setting.
Ticket #2804. (CVS 4574)

FossilOrigin-Name: f731fa6bb398d8af621af17dc0677dd0f715c4a7

17 years agoAdd an implementation of recursive mutexes for unix systems that
drh [Wed, 28 Nov 2007 00:51:34 +0000 (00:51 +0000)] 
Add an implementation of recursive mutexes for unix systems that
lack pthreads recursive mutexes (ex: Solaris 2.6).  Modern unix
systems continue to use the recursive mutexes provided by pthreads. (CVS 4573)

FossilOrigin-Name: f366a776c1b2dda42b4f10fdb8be66029165d084

17 years agoAdd test cases to verify that the file format is preserved across
drh [Tue, 27 Nov 2007 23:36:59 +0000 (23:36 +0000)] 
Add test cases to verify that the file format is preserved across
VACUUM.  Ticket #2804. (CVS 4572)

FossilOrigin-Name: 57400f50c600a59b56ba6eadfdc740235c194cd6

17 years agoUse the hexio test utility rather than TCL's binary I/O to avoid
drh [Tue, 27 Nov 2007 23:11:45 +0000 (23:11 +0000)] 
Use the hexio test utility rather than TCL's binary I/O to avoid
32/64-bit problems in io.test.  Ticket #2803.  (This is a change
to the test harness only - not to SQLite.) (CVS 4571)

FossilOrigin-Name: 07f7dde8a636aa05b917daa6b248c6f98654aab8

17 years agoRemove superfluous -lpthread from publish_osx.sh. Ticket #2801.
drh [Tue, 27 Nov 2007 21:44:30 +0000 (21:44 +0000)] 
Remove superfluous -lpthread from publish_osx.sh. Ticket #2801.
Fix a bug in mkdll.sh. (CVS 4570)

FossilOrigin-Name: 8d6e8fd381d26b9f14464f545c37363218206391

17 years agoOmit the superfluous -lpthread option in publish.sh. Ticket #2800. (CVS 4569)
drh [Tue, 27 Nov 2007 18:45:31 +0000 (18:45 +0000)] 
Omit the superfluous -lpthread option in publish.sh.  Ticket #2800. (CVS 4569)

FossilOrigin-Name: 4f09f233f0603696aac80f1a4f86bcc803a00daf

17 years agoAdd the publish_osx.sh script for building binaries for OSX (CVS 4568)
drh [Tue, 27 Nov 2007 18:30:38 +0000 (18:30 +0000)] 
Add the publish_osx.sh script for building binaries for OSX (CVS 4568)

FossilOrigin-Name: 9bd7c31496d1d2959761c09a4cfa94662891b81c

17 years agoUpdate the "publish.sh" scripts used to build the binaries for the website. (CVS...
drh [Tue, 27 Nov 2007 17:38:14 +0000 (17:38 +0000)] 
Update the "publish.sh" scripts used to build the binaries for the website. (CVS 4567)

FossilOrigin-Name: 2f748318fbb8ac4614c07629506b3955ce4fe20d

17 years agoVersion 3.5.3 (CVS 4566)
drh [Tue, 27 Nov 2007 17:12:10 +0000 (17:12 +0000)] 
Version 3.5.3 (CVS 4566)

FossilOrigin-Name: a39007d5b1f0d8925153ab3aac44fd655ed2536e

17 years agoFix a bug that can cause a segfault on win32 systems following an
drh [Tue, 27 Nov 2007 16:55:07 +0000 (16:55 +0000)] 
Fix a bug that can cause a segfault on win32 systems following an
I/O error. (CVS 4565)

FossilOrigin-Name: eeec8d27c4533f62b4f7e739d9c895552ddb69ff

17 years agoBug fix in the configure script. Ticket #2799.
drh [Tue, 27 Nov 2007 14:50:06 +0000 (14:50 +0000)] 
Bug fix in the configure script.  Ticket #2799.
The configure script is a real mess and
needs to be completely rewritten. (CVS 4564)

FossilOrigin-Name: 9d15f0330d685e62fbf4a1a1ad18dfecdc511bf8

17 years agoUpdate the version number to 3.5.3. Fix some minor testing problems. (CVS 4563)
drh [Tue, 27 Nov 2007 14:46:41 +0000 (14:46 +0000)] 
Update the version number to 3.5.3.  Fix some minor testing problems. (CVS 4563)

FossilOrigin-Name: f4c8f2d1918f24514f02cae9172c77f6957d32c1

17 years agoAdd likely() and unlikely() macros to the header file. They are not
drh [Tue, 27 Nov 2007 02:38:00 +0000 (02:38 +0000)] 
Add likely() and unlikely() macros to the header file.  They are not
yet used for anything. (CVS 4562)

FossilOrigin-Name: 485add38a1ef224732575f9998f06466dcc9742d

17 years agoUse macro __DARWIN__ rather than __MACOS__ for conditional
drh [Mon, 26 Nov 2007 22:54:27 +0000 (22:54 +0000)] 
Use macro __DARWIN__ rather than __MACOS__ for conditional
compilation of MacOSX specific features.  Ticket #2780. (CVS 4561)

FossilOrigin-Name: d0a4c2a36385c03dfadbb844823d0ed2458bf619

17 years agoAdditional out-of-memory testing. Fix bugs caused by malloc failures in
drh [Mon, 26 Nov 2007 13:36:00 +0000 (13:36 +0000)] 
Additional out-of-memory testing.  Fix bugs caused by malloc failures in
where.c.  Tickets #2794, #2795, #2796, and #2797. (CVS 4560)

FossilOrigin-Name: 5e02dbabcfa42173adff234c086df1e962824c92

17 years agoDeclare the invalidateCursorsOnModifiedBtrees function to be static.
drh [Sat, 24 Nov 2007 10:23:44 +0000 (10:23 +0000)] 
Declare the invalidateCursorsOnModifiedBtrees function to be static.
Ticket #2792. (CVS 4559)

FossilOrigin-Name: 94f25fc1129c7fb8697a67e509ab9de54a173a58

17 years agoThe FTS3 amalgamation can now be appended to the SQLite amalgamation to
drh [Sat, 24 Nov 2007 00:41:52 +0000 (00:41 +0000)] 
The FTS3 amalgamation can now be appended to the SQLite amalgamation to
generate a single source file that contains both components. (CVS 4558)

FossilOrigin-Name: 0fc61f99b54bd269fcc011f448b9b971e902cb01

17 years agoFix a typo in a change to all.test from earlier today. (CVS 4557)
drh [Fri, 23 Nov 2007 18:19:22 +0000 (18:19 +0000)] 
Fix a typo in a change to all.test from earlier today. (CVS 4557)

FossilOrigin-Name: 8c0b2157f2a2f8ecfa641a041279faf21aedd4e0

17 years agoDo not require SQLITE_ENABLE_BROKEN_FTS2 if FTS2 is not enabled.
drh [Fri, 23 Nov 2007 18:06:23 +0000 (18:06 +0000)] 
Do not require SQLITE_ENABLE_BROKEN_FTS2 if FTS2 is not enabled.
The same for FTS1.  Ticket #2777. (CVS 4556)

FossilOrigin-Name: f94cdcfd1171fd110ed9cd4c47f1fb5fa7e99ca9

17 years agoAdd a #include of sqlite3.h to fts3_hash.c. Tickets #2762 and #2777. (CVS 4555)
drh [Fri, 23 Nov 2007 18:01:07 +0000 (18:01 +0000)] 
Add a #include of sqlite3.h to fts3_hash.c.  Tickets #2762 and #2777. (CVS 4555)

FossilOrigin-Name: c8485eb8bc62c810ec9f73e103468c57116fd94c

17 years agoChanges fts3 to use only sqlite3_malloc() and not system malloc.
drh [Fri, 23 Nov 2007 17:31:17 +0000 (17:31 +0000)] 
Changes fts3 to use only sqlite3_malloc() and not system malloc.
Ticket #2762. (CVS 4554)

FossilOrigin-Name: 460af6bb668094c99a1d4dc1540b44b6d1d036b6

17 years agoRemove most documentation from the source code repository.
drh [Fri, 23 Nov 2007 15:12:44 +0000 (15:12 +0000)] 
Remove most documentation from the source code repository.
Documentation configuration management is now handled by a
separate repository at http://www.sqlite.org/docsrc. (CVS 4553)

FossilOrigin-Name: b20f3a6fed1027fc8faf886c8998dcb5dc0917c6

17 years agoMake sure that INSERT INTO ... SELECT ... always uses an ephemeral
drh [Fri, 23 Nov 2007 15:02:19 +0000 (15:02 +0000)] 
Make sure that INSERT INTO ... SELECT ... always uses an ephemeral
intermediate table if the SELECT clause refers to the destination table,
even if the SELECT clause is compound or uses the destination table
in a subquery.  This fixes a long-standing bug that can cause an
infinite loop for some SQL statements. (CVS 4552)

FossilOrigin-Name: 492b39b6a8bf4ad8792d7a7949f77827a5047fd8

17 years agoAvoid a double-free in an out-of-memory situation with a USING
drh [Fri, 23 Nov 2007 13:42:51 +0000 (13:42 +0000)] 
Avoid a double-free in an out-of-memory situation with a USING
clause or NATURAL JOIN.  Ticket #2789. (CVS 4551)

FossilOrigin-Name: 596694752c5935ae50ad38d3b41bbda39ca999d8

17 years agoChange to sqlite3.pc.in recommended by ticket #2786. (CVS 4550)
drh [Thu, 22 Nov 2007 00:47:41 +0000 (00:47 +0000)] 
Change to sqlite3.pc.in recommended by ticket #2786. (CVS 4550)

FossilOrigin-Name: 247fa2eac0789be48cae3587643ab07576ae7b76

17 years agoHandle out-of-memory situations inside the query flattener.
drh [Wed, 21 Nov 2007 15:24:00 +0000 (15:24 +0000)] 
Handle out-of-memory situations inside the query flattener.
Ticket #2784. (CVS 4549)

FossilOrigin-Name: 2655a3f2d18fe16a36a6cf3776261ee0507e6912

17 years agoFix a bug in the grammar. We were giving the ones-complement operator ~
drh [Sat, 17 Nov 2007 22:23:27 +0000 (22:23 +0000)] 
Fix a bug in the grammar.  We were giving the ones-complement operator ~
the same precedence as the NOT operator, which is incorrect. (CVS 4548)

FossilOrigin-Name: b48a4bfd3288906dfb7659c37f76d345011c91a0

17 years agoFix a crash that can occur after a malloc failure. Ticket #2775. (CVS 4547)
danielk1977 [Fri, 16 Nov 2007 14:55:46 +0000 (14:55 +0000)] 
Fix a crash that can occur after a malloc failure. Ticket #2775. (CVS 4547)

FossilOrigin-Name: c91bc8d33306881cb2501070dccced92c82cf165

17 years agoDon't do anything when input doclists are both empty. Ticket #2774 (CVS 4546)
shess [Fri, 16 Nov 2007 00:23:07 +0000 (00:23 +0000)] 
Don't do anything when input doclists are both empty.  Ticket #2774 (CVS 4546)

FossilOrigin-Name: 75cb46f82a6a95dbe9e279dede299bafa2e91cae

17 years agoReturn SQLITE_MISUSE instead of crashing if NULL is (incorrectly) passed to sqlite3_s...
danielk1977 [Thu, 15 Nov 2007 16:04:15 +0000 (16:04 +0000)] 
Return SQLITE_MISUSE instead of crashing if NULL is (incorrectly) passed to sqlite3_step(). Ticket #2773. (CVS 4545)

FossilOrigin-Name: 3bfee76fa6191c6e3aaa4632949b53253c612f36

17 years agoFix a segfault that can occur after a malloc failure in an ANALYZE statement. Ticket...
danielk1977 [Thu, 15 Nov 2007 13:10:22 +0000 (13:10 +0000)] 
Fix a segfault that can occur after a malloc failure in an ANALYZE statement. Ticket #2772. (CVS 4544)

FossilOrigin-Name: d05eb67dd6e171cfe8b9528aa3c7c953780d8c82

17 years agoAdd an experimental API for retrieving the SQL source from a compiled statement:...
danielk1977 [Wed, 14 Nov 2007 06:48:48 +0000 (06:48 +0000)] 
Add an experimental API for retrieving the SQL source from a compiled statement: sqlite3_sql(). Ticket #2769. (CVS 4543)

FossilOrigin-Name: d31f1e0d74a871d66cf7d3ef35faae5171d5cbc3

17 years agoModify the Tcl interface to use sqlite3_prepare_v2(). (CVS 4542)
danielk1977 [Tue, 13 Nov 2007 10:30:24 +0000 (10:30 +0000)] 
Modify the Tcl interface to use sqlite3_prepare_v2(). (CVS 4542)

FossilOrigin-Name: 7bb00c7df672cb8988121f30e3bbdea9ad951603

17 years agoVarious changes to enable compilation of SQLite library and command
chw [Mon, 12 Nov 2007 21:09:10 +0000 (21:09 +0000)] 
Various changes to enable compilation of SQLite library and command
line shell with the Windows CE cross compiler from cegcc.sourceforge.net (CVS 4541)

FossilOrigin-Name: 8ad0ab8cb374bd34e47af9e71b2aad9dd9af0d1b

17 years agoAnother attempt at fixing a memory leak in the TCL interface.
drh [Mon, 12 Nov 2007 17:56:42 +0000 (17:56 +0000)] 
Another attempt at fixing a memory leak in the TCL interface.
See check-in (4338) for the first attempt.  Ticket #2597. (CVS 4540)

FossilOrigin-Name: 68a43c99f1b02b8a93bfdcd5c8426b2b4199d68f

17 years agoFix a code comment in select.c. No code changes. (CVS 4539)
danielk1977 [Mon, 12 Nov 2007 15:40:41 +0000 (15:40 +0000)] 
Fix a code comment in select.c. No code changes. (CVS 4539)

FossilOrigin-Name: cf41d6a00f658d2cd64ff9811a3b1270ad1a580b

17 years agoWhere possible, transform the DISTINCT qualifier to a GROUP BY clause. GROUP BY claus...
danielk1977 [Mon, 12 Nov 2007 15:29:18 +0000 (15:29 +0000)] 
Where possible, transform the DISTINCT qualifier to a GROUP BY clause. GROUP BY clauses may be optimized by indices, DISTINCT qualifiers cannot. (CVS 4538)

FossilOrigin-Name: e56331234791cf3d830a30e4cfa66682bdf2eed1

17 years agoAllow collation sequence names to be quoted. Ticket #2744. (CVS 4537)
danielk1977 [Mon, 12 Nov 2007 09:50:26 +0000 (09:50 +0000)] 
Allow collation sequence names to be quoted. Ticket #2744. (CVS 4537)

FossilOrigin-Name: 06749ac7afeea4adbdeb9315f3819d5224534c66

17 years agoModify the order of assert() macros in vdbe.c as per the suggestion in #2768. (CVS...
danielk1977 [Mon, 12 Nov 2007 08:09:34 +0000 (08:09 +0000)] 
Modify the order of assert() macros in vdbe.c as per the suggestion in #2768. (CVS 4536)

FossilOrigin-Name: af5af5dc2608f369f0f4274ca06974b365424e72

17 years agoFix the code generation for UPDATE and DELETE so that
drh [Sun, 11 Nov 2007 18:36:34 +0000 (18:36 +0000)] 
Fix the code generation for UPDATE and DELETE so that
BEFORE triggers that use RAISE(IGNORE) do not leave extra
values on the stack.  Ticket #2767 (CVS 4535)

FossilOrigin-Name: 3391f4139ccfe62cc27739a06567c422ddae9c69

17 years agoAdd asserts on sqlite3_mutex_held() to the zero-malloc memory allocator,
drh [Wed, 7 Nov 2007 15:13:25 +0000 (15:13 +0000)] 
Add asserts on sqlite3_mutex_held() to the zero-malloc memory allocator,
in order to prove that the mutex is held when it is needed. (CVS 4534)

FossilOrigin-Name: 31eb4abc89e9c0fd90fde5486d4008f9d09fdf4e

17 years agoChanges the asynchronous I/O test module so that it can be appended to the
drh [Wed, 7 Nov 2007 01:23:12 +0000 (01:23 +0000)] 
Changes the asynchronous I/O test module so that it can be appended to the
end of the amalgamation. (CVS 4533)

FossilOrigin-Name: c1fe27de7b6f0080466cc3f827979db9997e22a4

17 years agoIn the windows VFS, make sure we do not return an error if attempting
drh [Wed, 7 Nov 2007 01:19:07 +0000 (01:19 +0000)] 
In the windows VFS, make sure we do not return an error if attempting
to delete a file that does not exist. (CVS 4532)

FossilOrigin-Name: 08a685abc149cd29c3595a61c9bc1a04e6d95c4d

17 years agoVersion 3.5.2 (CVS 4531)
drh [Mon, 5 Nov 2007 20:49:21 +0000 (20:49 +0000)] 
Version 3.5.2 (CVS 4531)

FossilOrigin-Name: 60da01630ab3668541aea7d303fc5d52fe3ee281

17 years agoPreparing documentation for the release of version 3.5.2. (CVS 4530)
drh [Mon, 5 Nov 2007 18:11:17 +0000 (18:11 +0000)] 
Preparing documentation for the release of version 3.5.2. (CVS 4530)

FossilOrigin-Name: b985328ad98669cbf2fb9a56b015a1db35657004

17 years agoDrop support for the SQLITE_OMIT_MEMORY_ALLOCATION compile-time option. (CVS 4529)
drh [Mon, 5 Nov 2007 17:54:17 +0000 (17:54 +0000)] 
Drop support for the SQLITE_OMIT_MEMORY_ALLOCATION compile-time option. (CVS 4529)

FossilOrigin-Name: b57c89fed0b74c2e8fb68ccfdf5e5e7d4b2603a1

17 years agoReset the writer-thread halt criteria after halting the thread. (CVS 4528)
danielk1977 [Mon, 5 Nov 2007 17:01:08 +0000 (17:01 +0000)] 
Reset the writer-thread halt criteria after halting the thread. (CVS 4528)

FossilOrigin-Name: ecbff972a1f5c7d846c322c435fa73584655b7f0

17 years agoFix some minor problems with malloc failure and in-memory databases. (CVS 4527)
danielk1977 [Mon, 5 Nov 2007 15:30:12 +0000 (15:30 +0000)] 
Fix some minor problems with malloc failure and in-memory databases. (CVS 4527)

FossilOrigin-Name: b752906e708e1c8c76084152f5829e16e8988ef2

17 years agoFix a bug in the misc1 test script. (CVS 4526)
drh [Mon, 5 Nov 2007 14:58:23 +0000 (14:58 +0000)] 
Fix a bug in the misc1 test script. (CVS 4526)

FossilOrigin-Name: fa16996d99cdce9f652508e3a70b7e5747810823

17 years agoMake sure the default page size never exceeds the maximum page size. (CVS 4525)
drh [Mon, 5 Nov 2007 14:30:22 +0000 (14:30 +0000)] 
Make sure the default page size never exceeds the maximum page size. (CVS 4525)

FossilOrigin-Name: 9c2731f143d52f8bf27f309612c38a1be22e3019

17 years agoUse malloc to obtain space for sqlite3_aggregate_context(). Ticket #2751. (CVS 4524)
danielk1977 [Mon, 5 Nov 2007 12:46:04 +0000 (12:46 +0000)] 
Use malloc to obtain space for sqlite3_aggregate_context(). Ticket #2751. (CVS 4524)

FossilOrigin-Name: bf75058f5777ce4b03f2287406805236470f70d0

17 years agoHandle "IS NULL" constraints on virtual table scans. IS NULL constraints are not...
danielk1977 [Mon, 5 Nov 2007 05:12:53 +0000 (05:12 +0000)] 
Handle "IS NULL" constraints on virtual table scans. IS NULL constraints are not passed to the virtual table layer. Ticket #2759. (CVS 4523)

FossilOrigin-Name: 7027368c15b3270a139bea5612d7c03c2288dcc4

17 years agoAdd the ".timer" command to the CLI. (CVS 4522)
drh [Fri, 2 Nov 2007 12:53:03 +0000 (12:53 +0000)] 
Add the ".timer" command to the CLI. (CVS 4522)

FossilOrigin-Name: 56680360d3b14a66a077ebb735f4594ed524a4bb

17 years agoFix building of sqlite3_analyzer on Mac. (CVS 4521)
drh [Fri, 2 Nov 2007 12:52:39 +0000 (12:52 +0000)] 
Fix building of sqlite3_analyzer on Mac. (CVS 4521)

FossilOrigin-Name: a616b6cb646a35a68bebc7d013c13185a9a6f47d

17 years agoAdd some assert() statements to the asychronous backend demo to enforce the strategy...
danielk1977 [Fri, 2 Nov 2007 09:07:57 +0000 (09:07 +0000)] 
Add some assert() statements to the asychronous backend demo to enforce the strategy used to avoid deadlock. Also a minor change to avoid a potential deadlock. (CVS 4520)

FossilOrigin-Name: 6340ca5eee3d398a9ef4f37a442efad37c9bf547

17 years agoAdd a prototype "group_concat()" aggregate function to func.c.
drh [Thu, 1 Nov 2007 17:38:30 +0000 (17:38 +0000)] 
Add a prototype "group_concat()" aggregate function to func.c.
Disabled by default.  No documentation nor test cases.  No effort
to make it efficient. (CVS 4519)

FossilOrigin-Name: 61987a89d1c4af59c745d1c5f17bab3301588b6c

17 years agoAvoid leaking a file descriptor after a malloc failure on unix. (CVS 4518)
danielk1977 [Tue, 30 Oct 2007 17:28:51 +0000 (17:28 +0000)] 
Avoid leaking a file descriptor after a malloc failure on unix. (CVS 4518)

FossilOrigin-Name: c249d5da721b32f6fe409a5b55a5d49a58994fec

17 years agoRemove a debugging assert() that went in by accident with the previous commit. (CVS...
danielk1977 [Tue, 30 Oct 2007 15:38:12 +0000 (15:38 +0000)] 
Remove a debugging assert() that went in by accident with the previous commit. (CVS 4517)

FossilOrigin-Name: 4ad60bdba0f1aa068dcc42fb58b80d7912e36b1b

17 years agoFix a race condtion in test_async.c. (CVS 4516)
danielk1977 [Tue, 30 Oct 2007 15:29:42 +0000 (15:29 +0000)] 
Fix a race condtion in test_async.c. (CVS 4516)

FossilOrigin-Name: 5e3f7c3dec3e8d92b28a74293387b390fe6fc1fa

17 years agoClarify the behavior of sqlite3_last_insert_rowid() when using
drh [Sat, 27 Oct 2007 16:25:16 +0000 (16:25 +0000)] 
Clarify the behavior of sqlite3_last_insert_rowid() when using
INSERT OR IGNORE. (CVS 4515)

FossilOrigin-Name: c0fa0c8ba80f4cd60bd06da7a032c6424ffd16f8