]> git.ipfire.org Git - thirdparty/sqlite.git/log
thirdparty/sqlite.git
18 years agoAll the use of MySQL-style quoting in the FTS modules. Ticket #2446. (CVS 4119)
drh [Mon, 25 Jun 2007 12:49:05 +0000 (12:49 +0000)] 
All the use of MySQL-style quoting in the FTS modules.  Ticket #2446. (CVS 4119)

FossilOrigin-Name: 3be2a6d1c342454d93b05c38f3d9a960ab15dae2

18 years agoAdd a test that calls fts2_tokenizer() with an argument set via C code. (CVS 4118)
danielk1977 [Mon, 25 Jun 2007 12:05:40 +0000 (12:05 +0000)] 
Add a test that calls fts2_tokenizer() with an argument set via C code. (CVS 4118)

FossilOrigin-Name: fbcf2d75cd2b88d175c122477aa483f0771870e5

18 years agoAdd some tests for the fts2 icu tokenizer. (CVS 4117)
danielk1977 [Mon, 25 Jun 2007 11:24:38 +0000 (11:24 +0000)] 
Add some tests for the fts2 icu tokenizer. (CVS 4117)

FossilOrigin-Name: b79ced3e0a26b0db13613073c847c2d2ba7e174e

18 years agoAdd some documentation for user-defined fts2 tokenizers. (CVS 4116)
danielk1977 [Mon, 25 Jun 2007 09:52:31 +0000 (09:52 +0000)] 
Add some documentation for user-defined fts2 tokenizers. (CVS 4116)

FossilOrigin-Name: 5a9eee86587219a68655d548864d129edec969ae

18 years agoMake the auto_vacuum mode peristent in all cases. (CVS 4115)
danielk1977 [Mon, 25 Jun 2007 08:16:58 +0000 (08:16 +0000)] 
Make the auto_vacuum mode peristent in all cases. (CVS 4115)

FossilOrigin-Name: 5b0408ddd0f1c825f402d0f5a3088a61b5ecd2c3

18 years agoFix for #2451. Code comment changes only. (CVS 4114)
danielk1977 [Sun, 24 Jun 2007 16:11:03 +0000 (16:11 +0000)] 
Fix for #2451. Code comment changes only. (CVS 4114)

FossilOrigin-Name: bc61dcbf64af56d4a1394c8ff46e91245dc16d15

18 years agoMake setting "PRAGMA auto_vacuum = incremental" persistent if it is executed before...
danielk1977 [Sun, 24 Jun 2007 10:14:00 +0000 (10:14 +0000)] 
Make setting "PRAGMA auto_vacuum = incremental" persistent if it is executed before the database file is created. (CVS 4113)

FossilOrigin-Name: c666fad151f25ab8365c497cd0967f4a5a2adb90

18 years agoAdd the "(database.)freelist_count" PRAGMA. For querying the size of the
danielk1977 [Sun, 24 Jun 2007 08:00:42 +0000 (08:00 +0000)] 
Add the "(database.)freelist_count" PRAGMA. For querying the size of the
database free-list. (CVS 4112)

FossilOrigin-Name: 1fb4251a707d0b79d250d6ea2022913b371d5f14

18 years agoWhen expanding '*' in the result set of a SELECT, quote the expanded identifiers...
danielk1977 [Sun, 24 Jun 2007 06:32:17 +0000 (06:32 +0000)] 
When expanding '*' in the result set of a SELECT, quote the expanded identifiers. Fix for #2450. (CVS 4111)

FossilOrigin-Name: d5b7224f37db1729dd042d48765d7a79247e1bde

18 years agofix linking failure on OS/2 that happens with the amalgamation and the high memory...
pweilbacher [Fri, 22 Jun 2007 20:17:37 +0000 (20:17 +0000)] 
fix linking failure on OS/2 that happens with the amalgamation and the high memory option enabled (CVS 4110)

FossilOrigin-Name: f35e20e19633d7b114fdf145820ca5d61b5aa925

18 years agofix compilation failure on OS/2 with the amalgamation (CVS 4109)
pweilbacher [Fri, 22 Jun 2007 20:04:36 +0000 (20:04 +0000)] 
fix compilation failure on OS/2 with the amalgamation (CVS 4109)

FossilOrigin-Name: 12327ca049e62922bfb3c2a14e42554fd58265e8

18 years agoExtend fts2 so that user defined tokenizers may be added. Add a tokenizer that uses...
danielk1977 [Fri, 22 Jun 2007 15:21:15 +0000 (15:21 +0000)] 
Extend fts2 so that user defined tokenizers may be added. Add a tokenizer that uses the ICU library if available. Documentation and tests to come. (CVS 4108)

FossilOrigin-Name: 68677e420c744b39ea9d7399819e0f376748886d

18 years agoClarify documentation of the column metadata APIs. Make sure that the
drh [Thu, 21 Jun 2007 15:25:05 +0000 (15:25 +0000)] 
Clarify documentation of the column metadata APIs.  Make sure that the
new documentation claims are tested. (CVS 4107)

FossilOrigin-Name: 2dafe08a91b5328a9d0df5ab29c3ff2d94ad5f6f

18 years agoUpdate the URL to mailing list archives. (CVS 4106)
drh [Thu, 21 Jun 2007 13:30:39 +0000 (13:30 +0000)] 
Update the URL to mailing list archives. (CVS 4106)

FossilOrigin-Name: af4b914a2152ce021401b6f78bb88a5323aa6fc2

18 years agoUse NAWK everywhere in Makefile.in. Ticket #2437. (CVS 4105)
drh [Wed, 20 Jun 2007 16:20:36 +0000 (16:20 +0000)] 
Use NAWK everywhere in Makefile.in.  Ticket #2437. (CVS 4105)

FossilOrigin-Name: 314669b6cc76ab8984857c3591aa1910aac97694

18 years agoA column name preceded by a unary "+" operator is considered to be
drh [Wed, 20 Jun 2007 16:13:23 +0000 (16:13 +0000)] 
A column name preceded by a unary "+" operator is considered to be
a column name when computing the collating sequence to be used by
a comparison operator or ORDER BY clause. (CVS 4104)

FossilOrigin-Name: 99a20f6a427b5e0e0a793f59ebca9d17bc633437

18 years agoRemove the dependency on libm for isnan(). Ticket #2436. (CVS 4103)
drh [Wed, 20 Jun 2007 15:29:25 +0000 (15:29 +0000)] 
Remove the dependency on libm for isnan().  Ticket #2436. (CVS 4103)

FossilOrigin-Name: 406675bb1c954dae95b9059f7f533ed57e3947d9

18 years agoRemove an unused variable from btree.c. (CVS 4102)
drh [Wed, 20 Jun 2007 15:14:10 +0000 (15:14 +0000)] 
Remove an unused variable from btree.c. (CVS 4102)

FossilOrigin-Name: cb47a8297fd91becdc4e1c50fd84b3efedd3951f

18 years agoFix comment typo in analyze.c. Ticket #2434. (CVS 4101)
drh [Wed, 20 Jun 2007 13:37:31 +0000 (13:37 +0000)] 
Fix comment typo in analyze.c.  Ticket #2434. (CVS 4101)

FossilOrigin-Name: df9957b94737b76ed7b1de77bb22bb27c7ae2dcf

18 years agoFix a bug in the command-line shell that prevents the
drh [Wed, 20 Jun 2007 13:10:00 +0000 (13:10 +0000)] 
Fix a bug in the command-line shell that prevents the
reading of the ".sqliterc" file.  Ticket #2433. (CVS 4100)

FossilOrigin-Name: 6eaf29f5e1e99b066825a1ccf34c82c9da6da826

18 years agoDisallow empty GROUP BY clauses. Ticket #2431. (CVS 4099)
drh [Wed, 20 Jun 2007 12:18:31 +0000 (12:18 +0000)] 
Disallow empty GROUP BY clauses.  Ticket #2431. (CVS 4099)

FossilOrigin-Name: 9581e7a4a4d74b08ce5380b49862957c804e46bb

18 years agoAdditional changes for ticket #2426. (CVS 4098)
drh [Wed, 20 Jun 2007 11:56:51 +0000 (11:56 +0000)] 
Additional changes for ticket #2426. (CVS 4098)

FossilOrigin-Name: 79debf95cdccdc1f18b6f0fcd213f514e327181c

18 years agoFix for #2432 and partial fix for #2427 (documentation change only). (CVS 4097)
danielk1977 [Wed, 20 Jun 2007 09:09:47 +0000 (09:09 +0000)] 
Fix for #2432 and partial fix for #2427 (documentation change only). (CVS 4097)

FossilOrigin-Name: f025a745319486d858e2831178a86265fd5fcf32

18 years agoChange main.mk to make it easier to build testfixture and sqlite3 with the icu or...
danielk1977 [Wed, 20 Jun 2007 08:49:05 +0000 (08:49 +0000)] 
Change main.mk to make it easier to build testfixture and sqlite3 with the icu or fts2 extensions linked in. (CVS 4096)

FossilOrigin-Name: 91719cc8eaf62f64099ff9eb2b48cef6c9c688f7

18 years agoFix snippet generation when the left-most column of an fts2 table is used in the...
danielk1977 [Wed, 20 Jun 2007 06:23:54 +0000 (06:23 +0000)] 
Fix snippet generation when the left-most column of an fts2 table is used in the MATCH clause. Fix for ticket #2429. (CVS 4095)

FossilOrigin-Name: fec56ad2ede53e3e202d9ad869a059eeb315796f

18 years agoChange the TCL bindings so that @aaa always treats the variable aaa as
drh [Tue, 19 Jun 2007 23:01:41 +0000 (23:01 +0000)] 
Change the TCL bindings so that @aaa always treats the variable aaa as
a bytearray and binds the value as a BLOB.  This change is backwards
compatible since the $ behavior is unchanged and @ was not accepted
until the current round of changes. (CVS 4094)

FossilOrigin-Name: 6f7d55acedc92eeaf988425c719addd56209187f

18 years agoCleanup the TCL interface source code and add documentation for recently
drh [Tue, 19 Jun 2007 17:48:57 +0000 (17:48 +0000)] 
Cleanup the TCL interface source code and add documentation for recently
added methods on the SQLite object of TCL. (CVS 4093)

FossilOrigin-Name: d88b79818a6a9e0413b9560687ec3c79fcb3dacc

18 years agoIn the TCL bindings, if a TCL variable has a bytearray representation and
drh [Tue, 19 Jun 2007 17:15:46 +0000 (17:15 +0000)] 
In the TCL bindings, if a TCL variable has a bytearray representation and
the host parameter starts with @ instead of $, then always store the
content as a BLOB not as a string even if a string representation is also
available. (CVS 4092)

FossilOrigin-Name: dcb104bd41f5e992d4c84b8947cb5099ae746891

18 years agoChange the name of the "limits.h" source file to "sqliteLimit.h".
drh [Tue, 19 Jun 2007 15:23:48 +0000 (15:23 +0000)] 
Change the name of the "limits.h" source file to "sqliteLimit.h".
Ticket #2428. (CVS 4091)

FossilOrigin-Name: 64bcc41f12e902fd025c9ba36c09dd6e4cf25923

18 years agoDo not segfault even if sqlite is misused by requesting query results
drh [Tue, 19 Jun 2007 10:58:24 +0000 (10:58 +0000)] 
Do not segfault even if sqlite is misused by requesting query results
after the query has been reset.  ticket #2426. (CVS 4090)

FossilOrigin-Name: 783f19be387561fbca3ac7e223bdb7dedb5450c8

18 years agoCast the 2nd parameter of ftruncate to off_t to work around bugs in
drh [Tue, 19 Jun 2007 10:50:38 +0000 (10:50 +0000)] 
Cast the 2nd parameter of ftruncate to off_t to work around bugs in
some unix implementations.  Ticket #2425. (CVS 4089)

FossilOrigin-Name: 0b20a69609c64af922bedab381f7d075e9da4fc5

18 years agoAnother attempt to fix the build process for TCL windows bindings. (CVS 4088)
drh [Mon, 18 Jun 2007 17:44:16 +0000 (17:44 +0000)] 
Another attempt to fix the build process for TCL windows bindings. (CVS 4088)

FossilOrigin-Name: 1fd2a358d6361768981d0c7efbcf30b47c52a732

18 years agoBring the pager_datahash() macro into sync with its function definition.
drh [Mon, 18 Jun 2007 17:25:17 +0000 (17:25 +0000)] 
Bring the pager_datahash() macro into sync with its function definition.
Ticket #2422. (CVS 4087)

FossilOrigin-Name: ba967bbb62ccf29438db352c573773ae741d0daf

18 years agoFix the build scripts so that they generate Tcl bindings for windows
drh [Mon, 18 Jun 2007 16:06:20 +0000 (16:06 +0000)] 
Fix the build scripts so that they generate Tcl bindings for windows
correctly. (CVS 4086)

FossilOrigin-Name: c7be8b419fdfe6561331485f5f866610457e44ad

18 years agoVersion 3.4.0 (CVS 4085)
drh [Mon, 18 Jun 2007 13:33:58 +0000 (13:33 +0000)] 
Version 3.4.0 (CVS 4085)

FossilOrigin-Name: 2647980fba92a453ef8afb48c80405d023177ab6

18 years agoDocumentation updates prior to release 3.4.0. Enhanced support for
drh [Mon, 18 Jun 2007 12:22:43 +0000 (12:22 +0000)] 
Documentation updates prior to release 3.4.0.  Enhanced support for
soak testing in the test scripts. (CVS 4084)

FossilOrigin-Name: eec387103869940697487ec5226eaed0b51ede7a

18 years agoFix a faulty assert() in the pager. (CVS 4083)
drh [Sat, 16 Jun 2007 18:39:41 +0000 (18:39 +0000)] 
Fix a faulty assert() in the pager. (CVS 4083)

FossilOrigin-Name: 4cff47b06132768e92ba2235cab5c17d1082f8f9

18 years agoModify the tests in exclusive2.test to account for the fact that the pager cache...
danielk1977 [Sat, 16 Jun 2007 14:43:51 +0000 (14:43 +0000)] 
Modify the tests in exclusive2.test to account for the fact that the pager cache may be very small by default. These tests are only valid if the entire database fitting in the cache. (CVS 4082)

FossilOrigin-Name: 04a13fe43e61bd0dbff42c448e763078503b00bf

18 years agoAdd another scenario to the soak1.tcl script. (CVS 4081)
drh [Sat, 16 Jun 2007 14:19:36 +0000 (14:19 +0000)] 
Add another scenario to the soak1.tcl script. (CVS 4081)

FossilOrigin-Name: 10e6822d4f1e0a94d5033b7b9efc1d8ed1e957d1

18 years agoA minor logic correction in the previous check-in. Also added a lengthy
drh [Sat, 16 Jun 2007 11:17:45 +0000 (11:17 +0000)] 
A minor logic correction in the previous check-in.  Also added a lengthy
comment describing the meanings of various flags in the
{quote: PgHdr} structure. (CVS 4080)

FossilOrigin-Name: 57bf8204cde47dfeb31c064f2b128b9a8d94189f

18 years agoFix a database corruption problem that can occur in auto-vacuum mode when
drh [Sat, 16 Jun 2007 04:42:12 +0000 (04:42 +0000)] 
Fix a database corruption problem that can occur in auto-vacuum mode when
a malloc() failure causes a statement rollback, additional statements
are run in the same transaction, then the total transaction rolls back. (CVS 4079)

FossilOrigin-Name: c9dcf2b926c99ff9cee68589f364461ab2a1d11f

18 years agoAdditional debugging instrumentation added to the pager. (CVS 4078)
drh [Sat, 16 Jun 2007 03:06:27 +0000 (03:06 +0000)] 
Additional debugging instrumentation added to the pager. (CVS 4078)

FossilOrigin-Name: dcdb20f81ae923f6f56d75c7b8b89a0b3abff954

18 years agoMake arrangements to optionally print a debug message at the point
drh [Fri, 15 Jun 2007 20:29:20 +0000 (20:29 +0000)] 
Make arrangements to optionally print a debug message at the point
of a simulated malloc() failure when SQLITE_MEMDEBUG is defined. (CVS 4077)

FossilOrigin-Name: 7d3c1f08a34fcf2ca5c79d6e58f713ae6a4b34e8

18 years agoFix more documentation typos. Ticket #2416. (CVS 4076)
drh [Fri, 15 Jun 2007 18:59:08 +0000 (18:59 +0000)] 
Fix more documentation typos.  Ticket #2416. (CVS 4076)

FossilOrigin-Name: b55318b12d026abd5a32469a19c36abbd6250137

18 years agoRemove a C++ism from the test harness. Get the TCL interface working with
drh [Fri, 15 Jun 2007 18:53:14 +0000 (18:53 +0000)] 
Remove a C++ism from the test harness.  Get the TCL interface working with
older versions of TCL. (CVS 4075)

FossilOrigin-Name: c8beb8674e5a1effc2785f205124628fbdaf57e0

18 years agoAdd a script for "soak" testing. (CVS 4074)
drh [Fri, 15 Jun 2007 18:43:37 +0000 (18:43 +0000)] 
Add a script for "soak" testing. (CVS 4074)

FossilOrigin-Name: d4ea1287a8b013a97fcb55bb7f7feba427222bab

18 years agoFix a race condition in test_server.c/test7.c (test changes only). (CVS 4073)
danielk1977 [Fri, 15 Jun 2007 17:50:04 +0000 (17:50 +0000)] 
Fix a race condition in test_server.c/test7.c (test changes only). (CVS 4073)

FossilOrigin-Name: d0de32e4c630c43ecd9d5e5296ae84aeff80c083

18 years agoFix typo in change comments for 3.4.0. Ticket #2416 (CVS 4072)
drh [Fri, 15 Jun 2007 17:04:37 +0000 (17:04 +0000)] 
Fix typo in change comments for 3.4.0.  Ticket #2416 (CVS 4072)

FossilOrigin-Name: 1f6f0330000ca564e75cd930afb9f9ce23551d89

18 years agoFix a memory leak in the parser that can occur following a malloc failure. (CVS 4071)
drh [Fri, 15 Jun 2007 17:03:14 +0000 (17:03 +0000)] 
Fix a memory leak in the parser that can occur following a malloc failure. (CVS 4071)

FossilOrigin-Name: d0b6e9a07e99cc1a7d7f61877918c9a247899996

18 years agoFix an obscure memory leak in the SQL compiler.. (CVS 4070)
danielk1977 [Fri, 15 Jun 2007 16:37:29 +0000 (16:37 +0000)] 
Fix an obscure memory leak in the SQL compiler.. (CVS 4070)

FossilOrigin-Name: d4ab94288b1e3d3d069ccc75d0fc2fbe6c1383c5

18 years agoFix a memory leak that was discovered by the tests that were added to
drh [Fri, 15 Jun 2007 15:31:49 +0000 (15:31 +0000)] 
Fix a memory leak that was discovered by the tests that were added to
cover ticket #2339. (CVS 4069)

FossilOrigin-Name: 1d10a489340718cc708e11e28e7bb31c67e00ad8

18 years agoFix a test suite bug. To accommadate the fact that handles returned by (db incrblob...
danielk1977 [Fri, 15 Jun 2007 15:08:08 +0000 (15:08 +0000)] 
Fix a test suite bug. To accommadate the fact that handles returned by (db incrblob) change for the second test suite iteration of full.test. (CVS 4068)

FossilOrigin-Name: 32218834b80b1ba900c52e43a2e59783a2553897

18 years agoFix for #2415. The progress handler should abandon only the current query, not all...
danielk1977 [Fri, 15 Jun 2007 14:53:53 +0000 (14:53 +0000)] 
Fix for #2415. The progress handler should abandon only the current query, not all active queries. (CVS 4067)

FossilOrigin-Name: 115e19fe22b9e79fcc400f3a59c80dd9828100e7

18 years agoDo not try to run the fuzz_malloc tests if SQLITE_MEMDEBUG is not enabled. (CVS 4066)
drh [Fri, 15 Jun 2007 13:57:19 +0000 (13:57 +0000)] 
Do not try to run the fuzz_malloc tests if SQLITE_MEMDEBUG is not enabled. (CVS 4066)

FossilOrigin-Name: 452115959f1bd22bfe64ed10724d6d08d4cbe3f5

18 years agoClean up a variable in tkt2409.test that would cause subsequent tests to fail. (CVS...
drh [Fri, 15 Jun 2007 12:41:02 +0000 (12:41 +0000)] 
Clean up a variable in tkt2409.test that would cause subsequent tests to fail. (CVS 4065)

FossilOrigin-Name: 0f944cb9fbe30c2a7ec36b7dc7e21fb39a60e810

18 years agoDocumentation updates in preparation for 3.4.0. (CVS 4064)
drh [Fri, 15 Jun 2007 12:16:31 +0000 (12:16 +0000)] 
Documentation updates in preparation for 3.4.0. (CVS 4064)

FossilOrigin-Name: 5232fd29d01d48d70b6d8f34ad5d0e2dde115fa0

18 years agoUpdate the btree file format description in btreeInt.h. (CVS 4063)
drh [Fri, 15 Jun 2007 12:06:58 +0000 (12:06 +0000)] 
Update the btree file format description in btreeInt.h. (CVS 4063)

FossilOrigin-Name: 1ac160d3dc0f8723a1e2007cf45351dd8242c8c2

18 years agoThe C-api reference documentation is now generated directly from
drh [Thu, 14 Jun 2007 20:57:18 +0000 (20:57 +0000)] 
The C-api reference documentation is now generated directly from
comments in the sqlite3.h header file. (CVS 4062)

FossilOrigin-Name: d93c41e9a97882bf90217d60744d62dece6d10d3

18 years agoHave queries interrupted by the progress-handler return SQLITE_INTERRUPT. Rollback...
danielk1977 [Wed, 13 Jun 2007 16:49:48 +0000 (16:49 +0000)] 
Have queries interrupted by the progress-handler return SQLITE_INTERRUPT. Rollback any active transaction if a DML statement returns SQLITE_INTERRUPT. (CVS 4061)

FossilOrigin-Name: 33454b5691637da7ded7d18d7f5726b796260c6b

18 years agoFix for #2409. Return SQLITE_IOERR_BLOCKED instead of SQLITE_BUSY in cases where...
danielk1977 [Wed, 13 Jun 2007 15:22:28 +0000 (15:22 +0000)] 
Fix for #2409. Return SQLITE_IOERR_BLOCKED instead of SQLITE_BUSY in cases where failure to obtain a database lock leaves the cache in an inconsistent state.
See additional information at CorruptionFollowingBusyError. (CVS 4060)

FossilOrigin-Name: ce2c9925d06315d73fb5fd0c7265fb4cd65665aa

18 years agoIn the "transaction" command of the TCL interface, if a COMMIT fails finish
drh [Tue, 12 Jun 2007 18:50:13 +0000 (18:50 +0000)] 
In the "transaction" command of the TCL interface, if a COMMIT fails finish
it with a rollback. (CVS 4059)

FossilOrigin-Name: 6da39fa4429400e21924074f5f219f4cb32415ff

18 years agoMinor comment edits from my prefix development client. No code changes. (CVS 4058)
shess [Tue, 12 Jun 2007 18:20:04 +0000 (18:20 +0000)] 
Minor comment edits from my prefix development client.  No code changes. (CVS 4058)

FossilOrigin-Name: 6953cd0935b5526756ab745545420e40adc3c56d

18 years agoFix typo in the limits.html document. Ticket #2410. (CVS 4057)
drh [Mon, 11 Jun 2007 23:23:24 +0000 (23:23 +0000)] 
Fix typo in the limits.html document.  Ticket #2410. (CVS 4057)

FossilOrigin-Name: d3fe186c330d74209ac291972b09883b06e0e143

18 years agoFix a bug in the LIKE optimization that was causing the pattern string
drh [Mon, 11 Jun 2007 12:56:15 +0000 (12:56 +0000)] 
Fix a bug in the LIKE optimization that was causing the pattern string
to be dequoted twice.  Ticket #2407. (CVS 4056)

FossilOrigin-Name: abf64d1d0ae3e84c4482b38198eeb44b62cc5d9e

18 years agoAdd a README.txt file for the ICU extension. (CVS 4055)
danielk1977 [Mon, 11 Jun 2007 08:00:00 +0000 (08:00 +0000)] 
Add a README.txt file for the ICU extension. (CVS 4055)

FossilOrigin-Name: 7b6927829f18d39052e67eebca4275e7aa496035

18 years agoDefine isnan() on windows. Ticket #2399. (CVS 4054)
drh [Sun, 10 Jun 2007 22:57:33 +0000 (22:57 +0000)] 
Define isnan() on windows.  Ticket #2399. (CVS 4054)

FossilOrigin-Name: fed9373e27b9d5338159a41772f8983420b902b0

18 years agoDocumentation updates, in particular in the new limits.html file is added. (CVS 4053)
drh [Sat, 9 Jun 2007 09:53:51 +0000 (09:53 +0000)] 
Documentation updates, in particular in the new limits.html file is added. (CVS 4053)

FossilOrigin-Name: 4ca6cdae94f6d0a2c95755d4a250f9f3bc7a0d7b

18 years agoUse C-sylte comments exclusively, never C++ comments. Ticket #2406. (CVS 4052)
drh [Fri, 8 Jun 2007 18:27:03 +0000 (18:27 +0000)] 
Use C-sylte comments exclusively, never C++ comments.  Ticket #2406. (CVS 4052)

FossilOrigin-Name: 8f5b789fea23d76128c10b37158de2525a54ce20

18 years agoAdditional test cases for comparisons against NULL in the WHERE clause
drh [Fri, 8 Jun 2007 08:43:10 +0000 (08:43 +0000)] 
Additional test cases for comparisons against NULL in the WHERE clause
and elsewhere in a SELECT. (CVS 4051)

FossilOrigin-Name: 72612a0373c7abf8aadfdeb46358c0b0ae7b07a0

18 years agoMake sure rowid comparisons against NULL work correctly. Ticket #2404. (CVS 4050)
drh [Fri, 8 Jun 2007 08:39:01 +0000 (08:39 +0000)] 
Make sure rowid comparisons against NULL work correctly.  Ticket #2404. (CVS 4050)

FossilOrigin-Name: 11ee8ea43f20f6146f4e4fcd9299468b3a99f998

18 years agoFix the query optimizer so that it correctly handles constant expressions
drh [Fri, 8 Jun 2007 00:20:47 +0000 (00:20 +0000)] 
Fix the query optimizer so that it correctly handles constant expressions
in the ON clause of a LEFT JOIN.  Ticket #2403. (CVS 4049)

FossilOrigin-Name: 46fdd195483787eef209a9b8ad108eba147be6fa

18 years agoMake sure zeroblob does reasonable things with a negative argument or
drh [Thu, 7 Jun 2007 19:08:32 +0000 (19:08 +0000)] 
Make sure zeroblob does reasonable things with a negative argument or
an argument that is larger than the maximum blob size. (CVS 4048)

FossilOrigin-Name: f40218434e549144ddb48303df30e5191d44d3fc

18 years agoFix an error in test file sqllimits1.test that was causing a test to fail when SQLITE...
danielk1977 [Thu, 7 Jun 2007 15:45:35 +0000 (15:45 +0000)] 
Fix an error in test file sqllimits1.test that was causing a test to fail when SQLITE_MAX_EXPR_DEPTH was defined. (CVS 4047)

FossilOrigin-Name: e66aa2c34a5c767554c022d01386a95558083e84

18 years agoAdd the SQLITE_MAX_COMPOUND_SELECT compile-time parameter for limiting
drh [Thu, 7 Jun 2007 10:55:35 +0000 (10:55 +0000)] 
Add the SQLITE_MAX_COMPOUND_SELECT compile-time parameter for limiting
the number of terms in a compound select statement.  Set the default limit
to 100. (CVS 4046)

FossilOrigin-Name: 0d71ad4591eae9de8749fb2da6455ac661587f7a

18 years agoFix a vdbe stack leak that could occur where one side of a WHERE clause inequality...
danielk1977 [Sat, 2 Jun 2007 07:54:37 +0000 (07:54 +0000)] 
Fix a vdbe stack leak that could occur where one side of a WHERE clause inequality evaluated to SQL null. (CVS 4045)

FossilOrigin-Name: 17152bf1a268e130f0c43046bb438b617a747ff5

18 years agoExtend out-of-memory testing with fuzzily generated sql some. One fix for a problem...
danielk1977 [Thu, 31 May 2007 08:20:43 +0000 (08:20 +0000)] 
Extend out-of-memory testing with fuzzily generated sql some. One fix for a problem found by the same. (CVS 4044)

FossilOrigin-Name: d2282e64f1320913797dfb4dae4db0428a15a200

18 years agoAdd some extra tests for malloc failure during expression parsing and execution using...
danielk1977 [Wed, 30 May 2007 10:36:47 +0000 (10:36 +0000)] 
Add some extra tests for malloc failure during expression parsing and execution using fuzzily generated SQL. (CVS 4043)

FossilOrigin-Name: 7522d2fb3204d107b8b4816d7f39c88741f20230

18 years agoAdd the start of the soak-test infrastructure. (CVS 4042)
danielk1977 [Wed, 30 May 2007 08:18:04 +0000 (08:18 +0000)] 
Add the start of the soak-test infrastructure. (CVS 4042)

FossilOrigin-Name: 5d0b247ca1667f5d773bda337cb6f58c3b14676a

18 years agoFix a problem with zeroblob() and CAST(...) expressions that could cause an assert...
danielk1977 [Wed, 30 May 2007 06:19:32 +0000 (06:19 +0000)] 
Fix a problem with zeroblob() and CAST(...) expressions that could cause an assert() to fail. (CVS 4041)

FossilOrigin-Name: 03750a2a6b5186689f7db6650c0a889429790b03

18 years agoConsider explicit collate clauses when matching WHERE constraints to indices. Fix...
danielk1977 [Tue, 29 May 2007 12:11:29 +0000 (12:11 +0000)] 
Consider explicit collate clauses when matching WHERE constraints to indices. Fix for #2391. (CVS 4040)

FossilOrigin-Name: f9a95e92dfaaa61ec0a44b9b7017b07929c94d26

18 years agoAdd some tests to verify that the parameter to the incremental_vacuum pragma is worki...
danielk1977 [Thu, 24 May 2007 10:18:22 +0000 (10:18 +0000)] 
Add some tests to verify that the parameter to the incremental_vacuum pragma is working. It is. (CVS 4039)

FossilOrigin-Name: 1abf784fe27cdc61b6b944b79d024ea98eb5289e

18 years agoFix a typo in comments in sqlite.h.in. No code changes. Ticket #2384. (CVS 4038)
danielk1977 [Thu, 24 May 2007 09:44:10 +0000 (09:44 +0000)] 
Fix a typo in comments in sqlite.h.in. No code changes. Ticket #2384. (CVS 4038)

FossilOrigin-Name: e8ae6214bfef4230096b6b56e688e9d4cd93f1b8

18 years agoRemove an assert() statement that may not be true if an IO or malloc error has occure...
danielk1977 [Thu, 24 May 2007 09:41:20 +0000 (09:41 +0000)] 
Remove an assert() statement that may not be true if an IO or malloc error has occured. (CVS 4037)

FossilOrigin-Name: 16c8e9c20cd2a7628c20a31c3e9605fe2d92ba2e

18 years agoFix a page reference leak that could occur after an IO error. (CVS 4036)
danielk1977 [Thu, 24 May 2007 09:20:16 +0000 (09:20 +0000)] 
Fix a page reference leak that could occur after an IO error. (CVS 4036)

FossilOrigin-Name: d00c8242c610476c15d6eb4dc53fecab3971fea1

18 years agoRemove an incorrect assert() statement that was being triggered by ioerr tests run...
danielk1977 [Thu, 24 May 2007 07:47:06 +0000 (07:47 +0000)] 
Remove an incorrect assert() statement that was being triggered by ioerr tests run in utf-16 mode. (CVS 4035)

FossilOrigin-Name: c6575173be13296fbe57932f2d24a568f6d552ff

18 years agoFix an assert() failure occuring in corrupt.test. (CVS 4034)
danielk1977 [Thu, 24 May 2007 07:22:42 +0000 (07:22 +0000)] 
Fix an assert() failure occuring in corrupt.test. (CVS 4034)

FossilOrigin-Name: 3c54cddf23e3b9f62815d1b825110563f78cc325

18 years agoAdd some code to MemTranslate() to prevent the READ_UTF8() macro from overreading...
danielk1977 [Wed, 23 May 2007 16:23:09 +0000 (16:23 +0000)] 
Add some code to MemTranslate() to prevent the READ_UTF8() macro from overreading a buffer. (CVS 4033)

FossilOrigin-Name: 0595319cd716611bb5a12eb952e395283ea749bb

18 years agoMake sure the database schema has been read before compiling an incrmental_vacuum...
danielk1977 [Wed, 23 May 2007 13:50:23 +0000 (13:50 +0000)] 
Make sure the database schema has been read before compiling an incrmental_vacuum pragma. (CVS 4032)

FossilOrigin-Name: efd7bcb34c1b4a0a3d4b954b90dfee93ac87bc86

18 years agoFix a leaked page reference that could occur after an IO error in auto-vacuum databas...
danielk1977 [Wed, 23 May 2007 13:34:32 +0000 (13:34 +0000)] 
Fix a leaked page reference that could occur after an IO error in auto-vacuum databases. Also modify incrvacuum.test to work with DEFAULT_AUTOVACUUM=1 builds. (CVS 4031)

FossilOrigin-Name: e691f2fa3d8c1bbb66d27eea299ae2fb1ea1a16d

18 years agoFix a database corrupting bug in the optimistic overflow chain. Exposed by running...
danielk1977 [Wed, 23 May 2007 09:52:41 +0000 (09:52 +0000)] 
Fix a database corrupting bug in the optimistic overflow chain. Exposed by running bigrow.test with auto-vacuum enabled. (CVS 4030)

FossilOrigin-Name: 10ee2d50cbcdcbbd8141ff2aba4fd2c0c0b70d67

18 years agoAdditional comments ono the SQLITE_MIXED_ENDIAN_64BIT_FLOAT issue. (CVS 4029)
drh [Wed, 23 May 2007 07:20:08 +0000 (07:20 +0000)] 
Additional comments ono the SQLITE_MIXED_ENDIAN_64BIT_FLOAT issue. (CVS 4029)

FossilOrigin-Name: dd48a31e671de09f59661b2ba1a20e7b9f09099a

18 years agoMake sure zeroblob() works with the concatenation operator. Ticket #2379. (CVS 4028)
drh [Wed, 23 May 2007 06:31:38 +0000 (06:31 +0000)] 
Make sure zeroblob() works with the concatenation operator.  Ticket #2379. (CVS 4028)

FossilOrigin-Name: 6e19ef758207cedd6db8b2796ef5d4d688cc0b62

18 years agoIncrease the number of repititions in crash.test. (CVS 4027)
danielk1977 [Wed, 23 May 2007 06:25:13 +0000 (06:25 +0000)] 
Increase the number of repititions in crash.test. (CVS 4027)

FossilOrigin-Name: f3c3412afa95e7e4b2e6477718785b51f5352c39

18 years agoFix overzealous fts2 assertions WRT rowid 0 or lower. Only check that
shess [Mon, 21 May 2007 21:59:18 +0000 (21:59 +0000)] 
Fix overzealous fts2 assertions WRT rowid 0 or lower.  Only check that
docids are ascending if there was a prior docid set for the doclist,
ignore the initial docid of 0. (CVS 4026)

FossilOrigin-Name: ed3a131f1d3fe51d1e79bdfe1bfafa55f825afa9

18 years agoAdd the larger SQLite icon to the repository. (CVS 4025)
drh [Sat, 19 May 2007 11:50:36 +0000 (11:50 +0000)] 
Add the larger SQLite icon to the repository. (CVS 4025)

FossilOrigin-Name: d7539c6e8b66d537307e70aac5f2001135151c78

18 years agoAdd a few extra words to the sqlite3_finalize() documentation. (CVS 4024)
danielk1977 [Sat, 19 May 2007 06:48:42 +0000 (06:48 +0000)] 
Add a few extra words to the sqlite3_finalize() documentation. (CVS 4024)

FossilOrigin-Name: 315dc71b921ffba514271a2ed571d5f4162c775f

18 years agoChange the way overflow pages are allocated from the free-list to increase the chance...
danielk1977 [Thu, 17 May 2007 18:28:11 +0000 (18:28 +0000)] 
Change the way overflow pages are allocated from the free-list to increase the chance that they are a contiguous block. Much more can still be done. (CVS 4023)

FossilOrigin-Name: b7391892041eb72b0ebcbb7a9a6721ae3482dd80

18 years agoBring the autoconf based build system up to date with the recent changes. #2366,...
danielk1977 [Thu, 17 May 2007 16:38:30 +0000 (16:38 +0000)] 
Bring the autoconf based build system up to date with the recent changes. #2366, #2367 and #2368. (CVS 4022)

FossilOrigin-Name: ae644bc7aad229f2d219ea20eb4774318feb3051

18 years agoFix a problem with casting blobs to numeric types. (CVS 4021)
danielk1977 [Thu, 17 May 2007 16:34:43 +0000 (16:34 +0000)] 
Fix a problem with casting blobs to numeric types. (CVS 4021)

FossilOrigin-Name: f2ce727c4d798c666e95876a2b67e8a305d82e3a

18 years agoAdd speed3.test file. For testing performance issues related to overflow pages. ...
danielk1977 [Thu, 17 May 2007 14:45:12 +0000 (14:45 +0000)] 
Add speed3.test file. For testing performance issues related to overflow pages. (CVS 4020)

FossilOrigin-Name: 684f765df3e8a4836f254717d175a4a7b5e7d15f