]> git.ipfire.org Git - thirdparty/sqlite.git/log
thirdparty/sqlite.git
19 years agoDo not create an error message if there is no error. (CVS 2607)
drh [Sun, 21 Aug 2005 17:48:46 +0000 (17:48 +0000)] 
Do not create an error message if there is no error. (CVS 2607)

FossilOrigin-Name: 3aa47c5587819a5fc3e2cb53a7fbc79ba65f0c3b

19 years agoDo not overwrite small files (less than 1024 bytes) that are not databases.
drh [Sun, 21 Aug 2005 16:54:25 +0000 (16:54 +0000)] 
Do not overwrite small files (less than 1024 bytes) that are not databases.
Ticket #1370. (CVS 2606)

FossilOrigin-Name: 7f4302686e55f22b281d98a8a3b89300f4ce4eb6

19 years agoMore test coverage improvements. (CVS 2605)
drh [Sat, 20 Aug 2005 13:47:41 +0000 (13:47 +0000)] 
More test coverage improvements. (CVS 2605)

FossilOrigin-Name: e559e810a51427def6928763ae0d6f7347366d04

19 years agoIncreased test coverage. Some malloc tests now fail though this is believed
drh [Sat, 20 Aug 2005 03:03:04 +0000 (03:03 +0000)] 
Increased test coverage.  Some malloc tests now fail though this is believed
to be an instrumentation problem not a real error. (CVS 2604)

FossilOrigin-Name: f786f37a5e31f42aaf81b3ad4a734f12855da69e

19 years agoIncrease test coverage of alter.c to 100%. Fix bugs found in the process. (CVS 2603)
drh [Fri, 19 Aug 2005 19:14:12 +0000 (19:14 +0000)] 
Increase test coverage of alter.c to 100%.  Fix bugs found in the process. (CVS 2603)

FossilOrigin-Name: b550d04d43a92f33a01438ae03df14678db3cdee

19 years agoAdditional tests for better coverage. (CVS 2602)
drh [Fri, 19 Aug 2005 03:03:51 +0000 (03:03 +0000)] 
Additional tests for better coverage. (CVS 2602)

FossilOrigin-Name: 4281a838f2f531af24b008d2834e8318798472c5

19 years agoIncreased test coverage on trigger.c and printf.c. (CVS 2601)
drh [Fri, 19 Aug 2005 02:26:27 +0000 (02:26 +0000)] 
Increased test coverage on trigger.c and printf.c. (CVS 2601)

FossilOrigin-Name: 842a80bd8f18d6fd046604f9a057bcd738234f1f

19 years agoMore test coverage enhancements. (CVS 2600)
drh [Fri, 19 Aug 2005 01:07:15 +0000 (01:07 +0000)] 
More test coverage enhancements. (CVS 2600)

FossilOrigin-Name: 0b6cd5acc0ede3367623f40ccfaa96116e686824

19 years agoBring testing coverage of the analyze.c file up to 100%. Bugs found and
drh [Fri, 19 Aug 2005 00:14:42 +0000 (00:14 +0000)] 
Bring testing coverage of the analyze.c file up to 100%.  Bugs found and
fixed in the process. (CVS 2599)

FossilOrigin-Name: 2fe0ac4fa4d5911e266979021fa7e413d96c558d

19 years agoComment fixes. No changes to the underlying code. (CVS 2598)
drh [Thu, 18 Aug 2005 18:15:05 +0000 (18:15 +0000)] 
Comment fixes.  No changes to the underlying code. (CVS 2598)

FossilOrigin-Name: b865e243ee772f009dbf466d69525f2cdef78c0e

19 years agoFix typo in documentation. (CVS 2597)
drh [Tue, 16 Aug 2005 14:44:48 +0000 (14:44 +0000)] 
Fix typo in documentation. (CVS 2597)

FossilOrigin-Name: 32efcd24612908516fb5bc58ab3fe4790586a220

19 years agoNull-terminate the strings array passed to Tcl_GetIndexFromObj. Bug
drh [Tue, 16 Aug 2005 11:11:34 +0000 (11:11 +0000)] 
Null-terminate the strings array passed to Tcl_GetIndexFromObj.  Bug
reported on the mailing list. (CVS 2596)

FossilOrigin-Name: 3a7918a66bf98368c2520f94e505a21a1df3383c

19 years agoGeneral code cleanup resulting in smaller footprint. (CVS 2595)
drh [Sun, 14 Aug 2005 20:47:16 +0000 (20:47 +0000)] 
General code cleanup resulting in smaller footprint. (CVS 2595)

FossilOrigin-Name: 98338abf9e8cfbf8efa81cff0e40ea37e34fd9b2

19 years agoSplit the sqlite3_complete() API out into a separate source file so that
drh [Sun, 14 Aug 2005 17:53:20 +0000 (17:53 +0000)] 
Split the sqlite3_complete() API out into a separate source file so that
in static links where it is not used it will not take up space in the
resulting binary. (CVS 2594)

FossilOrigin-Name: 62b87751dea56c565bcc2aca88a2edda7dfc2a57

19 years agoDeclare local-use functions as static. Ticket #1363. (CVS 2593)
drh [Sun, 14 Aug 2005 01:34:19 +0000 (01:34 +0000)] 
Declare local-use functions as static.  Ticket #1363. (CVS 2593)

FossilOrigin-Name: 94efd7908880c7d99c08ebc9a3437cfbefc42f7e

19 years agoThe case_sensitive_like pragma added.
drh [Sun, 14 Aug 2005 01:20:37 +0000 (01:20 +0000)] 
The case_sensitive_like pragma added.
Test cases added for the LIKE optimization. (CVS 2592)

FossilOrigin-Name: 72ee21c05e618b6f46f5460f8c85779c72fe32d7

19 years agoProvide grave accent quoting of identifiers for MySQL compatibility.
drh [Sat, 13 Aug 2005 18:15:42 +0000 (18:15 +0000)] 
Provide grave accent quoting of identifiers for MySQL compatibility.
Ticket #1337. (CVS 2591)

FossilOrigin-Name: 6b7a4e97528a4e179e0bbae69469cb1a3d1f794b

19 years agoGive the same access permissions to journal files as is given to databases. (CVS...
drh [Sat, 13 Aug 2005 17:17:01 +0000 (17:17 +0000)] 
Give the same access permissions to journal files as is given to databases. (CVS 2590)

FossilOrigin-Name: 7961ec0ccbc99d890689013b9602635941f308a6

19 years agoDisable an overzealous optimization the omitted sorting on a join if the first
drh [Sat, 13 Aug 2005 16:13:04 +0000 (16:13 +0000)] 
Disable an overzealous optimization the omitted sorting on a join if the first
table gave a unique result.  The sort can only be omitted if all tables in
the join are unique.  Ticket #1358. (CVS 2589)

FossilOrigin-Name: 4f07661279fb11a06b3ddffeda672f077c0d306a

19 years agoFix a comment in printf. (CVS 2588)
drh [Sat, 13 Aug 2005 13:40:42 +0000 (13:40 +0000)] 
Fix a comment in printf. (CVS 2588)

FossilOrigin-Name: 1054685f15095ef147d9e9a32bd56b0eaaf9fa54

19 years agoAdditional cleanup and optimization of the printf function. (CVS 2587)
drh [Sat, 13 Aug 2005 13:39:02 +0000 (13:39 +0000)] 
Additional cleanup and optimization of the printf function. (CVS 2587)

FossilOrigin-Name: 240bb049001b0d1419d72b6ef909236e12bd5949

19 years agoAdd the "!" flag to the "%g" mprintf conversion parameter to force a
drh [Sat, 13 Aug 2005 12:59:14 +0000 (12:59 +0000)] 
Add the "!" flag to the "%g" mprintf conversion parameter to force a
decimal point.  This prevents floating point values from appearing as
integers.  Use this flag when converting floating point to text.
Ticket #1362. (CVS 2586)

FossilOrigin-Name: 4b98dace6b90abf4a6fe1cd51e6392fd213358c4

19 years agoMake the round() function work correctly on numbers with very large exponents.
drh [Sat, 13 Aug 2005 03:07:47 +0000 (03:07 +0000)] 
Make the round() function work correctly on numbers with very large exponents.
Ticket #1340. (CVS 2585)

FossilOrigin-Name: 4f47c3c884e38b810450b6127ab33c7b86e6743c

19 years agoFix a memory leak that occurs when a CREATE TABLE that contains a
drh [Sat, 13 Aug 2005 00:56:27 +0000 (00:56 +0000)] 
Fix a memory leak that occurs when a CREATE TABLE that contains a
DEFAULT VALUE fails due to a name conflict.  Tickets #1356 and #1357. (CVS 2584)

FossilOrigin-Name: 25cfe9390dda79bb2a7740b3d7380f517a4e8d1b

19 years ago3rd argument to sqlite3Error() should always be a format string, never
drh [Fri, 12 Aug 2005 23:20:53 +0000 (23:20 +0000)] 
3rd argument to sqlite3Error() should always be a format string, never
user-supplied error message text.  Ticket #1354. (CVS 2583)

FossilOrigin-Name: d6146a542aacd10d349d432fe343cc17cc3b3ab5

19 years agoImproved error message when a #NNN parameter appears on user input.
drh [Fri, 12 Aug 2005 22:58:53 +0000 (22:58 +0000)] 
Improved error message when a #NNN parameter appears on user input.
Additional coverage testing. (CVS 2582)

FossilOrigin-Name: 3c00f5982ae61dfcd26c33ccdb81736628dbfce5

19 years agoOptimize LIKE and GLOB operators in the WHERE clause. Code passes all
drh [Fri, 12 Aug 2005 22:56:09 +0000 (22:56 +0000)] 
Optimize LIKE and GLOB operators in the WHERE clause.  Code passes all
regression tests but still needs additional tests. (CVS 2581)

FossilOrigin-Name: 3edbe8d6217fd1180883e6b9f1e5b9011a39f80d

19 years agoImprove the error message associated with SQLITE_FULL. Ticket #1353.
drh [Thu, 11 Aug 2005 02:10:18 +0000 (02:10 +0000)] 
Improve the error message associated with SQLITE_FULL.  Ticket #1353.
Also remove error messages for obsolete error codes SQLITE_INTERNAL,
SQLITE_NOTFOUND, and SQLITE_TOOBIG. (CVS 2580)

FossilOrigin-Name: fa7403c7d9948cc4a6c6ed00a614e3d6a3682e78

19 years agoAdd 2005 open source award badge and news announcement. (CVS 2579)
drh [Thu, 11 Aug 2005 01:25:22 +0000 (01:25 +0000)] 
Add 2005 open source award badge and news announcement. (CVS 2579)

FossilOrigin-Name: 8e007f8c06748c5f02068c1f244bc8e3026e16fd

19 years agoMake sure the .import command strips newlines off the end of the last
drh [Fri, 5 Aug 2005 18:50:51 +0000 (18:50 +0000)] 
Make sure the .import command strips newlines off the end of the last
field in each line imported.  Ticket #1348 (CVS 2578)

FossilOrigin-Name: 73fafd2148b8cd0f92747fca03e3df5778e1070f

19 years agoComment out the use of memory high-water marks when not compiling with
drh [Tue, 2 Aug 2005 21:42:16 +0000 (21:42 +0000)] 
Comment out the use of memory high-water marks when not compiling with
SQLITE_MEMDEBUG. (CVS 2577)

FossilOrigin-Name: fb7a258fd35fdf81772b9d47711d30a30dfa4564

19 years agoMinor refactoring of the new optimizer code. (CVS 2576)
drh [Tue, 2 Aug 2005 17:48:22 +0000 (17:48 +0000)] 
Minor refactoring of the new optimizer code. (CVS 2576)

FossilOrigin-Name: 868322f7b7176486dfb4b54d99cf6662b79e639d

19 years agoUpdate the documentation for the new transaction method on the TCL interface. (CVS...
drh [Tue, 2 Aug 2005 17:38:19 +0000 (17:38 +0000)] 
Update the documentation for the new transaction method on the TCL interface. (CVS 2575)

FossilOrigin-Name: 3dc823a0ac12f640a3c54fe1eb7be878d2738529

19 years agoTests and bug fixes on the new transaction method in the TCL interface. (CVS 2574)
drh [Tue, 2 Aug 2005 17:15:14 +0000 (17:15 +0000)] 
Tests and bug fixes on the new transaction method in the TCL interface. (CVS 2574)

FossilOrigin-Name: 68dd0ed5e312ecd5e98ee0fa1c21b70ff330f711

19 years agoFix a bug in the btree balancer. ticket #1346. (CVS 2573)
drh [Tue, 2 Aug 2005 17:13:09 +0000 (17:13 +0000)] 
Fix a bug in the btree balancer. ticket #1346. (CVS 2573)

FossilOrigin-Name: 3af69a49289f52f321ccd365e92d22b820c3139e

19 years agoAdd the "transaction" coommand to the TCL interface. Untested. (CVS 2572)
drh [Tue, 2 Aug 2005 12:21:08 +0000 (12:21 +0000)] 
Add the "transaction" coommand to the TCL interface.  Untested. (CVS 2572)

FossilOrigin-Name: a5ce6c58c3bfc0e1c9953fe4ad4991ac56a4fb87

19 years agoFix problems caused by over-agressive optimization of ORDER BY in joins.
drh [Fri, 29 Jul 2005 19:43:58 +0000 (19:43 +0000)] 
Fix problems caused by over-agressive optimization of ORDER BY in joins.
Lots more testing needed. (CVS 2571)

FossilOrigin-Name: 1a4e526d46280970b43505a5c8a4090767c63043

19 years agoFix authentication so that it works with AS aliases. Ticket #1338. (CVS 2570)
drh [Fri, 29 Jul 2005 15:36:14 +0000 (15:36 +0000)] 
Fix authentication so that it works with AS aliases.  Ticket #1338. (CVS 2570)

FossilOrigin-Name: cc7ae73ed01f0b89e31dd8de48b913bbd83887b8

19 years agoOptimizer now converts OR-connected WHERE-clause terms into an IN operator so
drh [Fri, 29 Jul 2005 15:10:17 +0000 (15:10 +0000)] 
Optimizer now converts OR-connected WHERE-clause terms into an IN operator so
that they can be used with indices.  There are known problems with the
ORDER BY optimization in this and in several prior check-ins.  This
check-in is not recommended for production use. (CVS 2569)

FossilOrigin-Name: d23c8bf81e508722e92ff1b9c8bc98dc026a31f2

19 years agoThe BETWEEN operator in a WHERE clause is now able to use indices. (CVS 2568)
drh [Thu, 28 Jul 2005 23:12:08 +0000 (23:12 +0000)] 
The BETWEEN operator in a WHERE clause is now able to use indices. (CVS 2568)

FossilOrigin-Name: cdf8c9584b945212e065e044df801c207aedb675

19 years agoTest cases and tuning of the new optimizer code. (CVS 2567)
drh [Thu, 28 Jul 2005 20:51:19 +0000 (20:51 +0000)] 
Test cases and tuning of the new optimizer code. (CVS 2567)

FossilOrigin-Name: 4b02703dec71aa78e5f8d8cab5b950966a4c6abc

19 years agoThe new optimizer now passes all regression tests. (CVS 2566)
drh [Thu, 28 Jul 2005 16:51:51 +0000 (16:51 +0000)] 
The new optimizer now passes all regression tests. (CVS 2566)

FossilOrigin-Name: a21212843359fb9fdbd60799ae50ad3566f4399a

19 years agoMore work on the new optimizer. Fewer tests fail now. (CVS 2565)
drh [Wed, 27 Jul 2005 20:41:43 +0000 (20:41 +0000)] 
More work on the new optimizer.  Fewer tests fail now. (CVS 2565)

FossilOrigin-Name: ee3a08e353f563c36e904479393fcb56f96ee975

19 years agoA new optimizer that breaks a lot of tests. But none of them critically, I
drh [Sat, 23 Jul 2005 22:59:55 +0000 (22:59 +0000)] 
A new optimizer that breaks a lot of tests.  But none of them critically, I
think.  Nevertheless, there is a lot of work ahead to stabilize the code. (CVS 2564)

FossilOrigin-Name: 86ce56ccea8297b1fba2b9ee53b5f1a3f228662f

19 years agoStore the total number of rows as part of the ANALYZE statistics. (CVS 2563)
drh [Sat, 23 Jul 2005 14:52:12 +0000 (14:52 +0000)] 
Store the total number of rows as part of the ANALYZE statistics. (CVS 2563)

FossilOrigin-Name: 868279c78e056d27b2d1bea81127fe689b2ce478

19 years agoThe results of ANALYZE are now loaded into internal data structures where
drh [Sat, 23 Jul 2005 03:18:40 +0000 (03:18 +0000)] 
The results of ANALYZE are now loaded into internal data structures where
they can be used.  But they are not actually used yet. (CVS 2562)

FossilOrigin-Name: 1996bacfb97180965304e2a6d6784b6ecbbf8575

19 years agoFull-coverage testing and documentation for the ANALYZE command. The
drh [Sat, 23 Jul 2005 02:17:03 +0000 (02:17 +0000)] 
Full-coverage testing and documentation for the ANALYZE command.  The
results of analysis are still not loaded or used, however. (CVS 2561)

FossilOrigin-Name: bd7583a5d63412785a9c5de54d25b509da241605

19 years agoFirst code for the ANALYZE command. Mostly untested. The analysis is
drh [Sat, 23 Jul 2005 00:41:48 +0000 (00:41 +0000)] 
First code for the ANALYZE command.  Mostly untested.  The analysis is
not loaded into the symbol tables and is not used by the optimizer. (CVS 2560)

FossilOrigin-Name: a4886b114d2ccb3841d3d219f6b97f67745b13c2

19 years agoClarify the meaning of the TEMP keyword on CREATE TABLE. (CVS 2559)
drh [Fri, 22 Jul 2005 23:56:49 +0000 (23:56 +0000)] 
Clarify the meaning of the TEMP keyword on CREATE TABLE. (CVS 2559)

FossilOrigin-Name: 1a573619f558d1d67775d17aabb9d704f82ad1a8

19 years agoCorrect the documentation to show that sqlite3_column_text() returns
drh [Fri, 22 Jul 2005 22:53:15 +0000 (22:53 +0000)] 
Correct the documentation to show that sqlite3_column_text() returns
a NULL pointer (not an empty string) when the column value is NULL.
The same goes for sqlite3_column_blob().  Ticket #1334. (CVS 2558)

FossilOrigin-Name: fd1e013a14710ed2ecabddedc0d110562cfdbfc2

19 years agoBegin adding code to support multiple IN constraints on the same index. (CVS 2557)
drh [Fri, 22 Jul 2005 00:31:39 +0000 (00:31 +0000)] 
Begin adding code to support multiple IN constraints on the same index. (CVS 2557)

FossilOrigin-Name: 103f8ccb9013689a480766ebffbf570d4aa8bac5

19 years agoSplit the OP_Integer opcode into OP_Integer and OP_Int64. This allows
drh [Thu, 21 Jul 2005 18:23:20 +0000 (18:23 +0000)] 
Split the OP_Integer opcode into OP_Integer and OP_Int64.  This allows
comments to be added to OP_Integer.  Cleanup in the optimizer.  Allow
terms of the FROM clause to be reordered automatically. (CVS 2556)

FossilOrigin-Name: e2f822ac82d0a5a59de0b63cce65d4fd6c178ff1

19 years agoAdd comments to test cases. Improvements to the query plan test variable. (CVS 2555)
drh [Thu, 21 Jul 2005 03:48:20 +0000 (03:48 +0000)] 
Add comments to test cases.  Improvements to the query plan test variable. (CVS 2555)

FossilOrigin-Name: ef3a157f469d72cbd2f713f997598ddf47f340d2

19 years agoIn where.c, split out the code that selects an index into a separate
drh [Thu, 21 Jul 2005 03:14:59 +0000 (03:14 +0000)] 
In where.c, split out the code that selects an index into a separate
subroutine. (CVS 2554)

FossilOrigin-Name: c30cbba9ead1b4d07f225b1e8a65d5d5230ea45d

19 years agoExtra memory usage instrumentation added. (CVS 2553)
drh [Wed, 20 Jul 2005 14:31:53 +0000 (14:31 +0000)] 
Extra memory usage instrumentation added. (CVS 2553)

FossilOrigin-Name: ac669f56c0759a7e3eaa6f0018c8fb9d614e7d69

19 years agoMore refactoring in where.c. (CVS 2552)
drh [Tue, 19 Jul 2005 22:22:12 +0000 (22:22 +0000)] 
More refactoring in where.c. (CVS 2552)

FossilOrigin-Name: a35bd50af8961133adc66e40c38402e81a02bb56

19 years agoRefactoring of the query optimizer in advance of adding better optimization. (CVS...
drh [Tue, 19 Jul 2005 17:38:22 +0000 (17:38 +0000)] 
Refactoring of the query optimizer in advance of adding better optimization. (CVS 2551)

FossilOrigin-Name: 57c6bd3760163c174be4a2ece58f414e82b55938

20 years agoAllow an unlimited number of terms in the WHERE clause. The old limit was 100. ...
drh [Sat, 16 Jul 2005 13:33:20 +0000 (13:33 +0000)] 
Allow an unlimited number of terms in the WHERE clause.  The old limit was 100. (CVS 2550)

FossilOrigin-Name: ca69f36832d57775e73ac5cdbe0a32d7b759432b

20 years agoFix bugs in the new query plan instrumention logic. (CVS 2549)
drh [Fri, 15 Jul 2005 23:24:23 +0000 (23:24 +0000)] 
Fix bugs in the new query plan instrumention logic. (CVS 2549)

FossilOrigin-Name: 578490c91331a386f84652db0b3bfd74c82046e1

20 years agoAdd test instrumentation that will be needed during the development of
drh [Fri, 15 Jul 2005 13:05:21 +0000 (13:05 +0000)] 
Add test instrumentation that will be needed during the development of
forthcoming optimizer enhancements. (CVS 2548)

FossilOrigin-Name: dfd5fd77b0764853f847eeee3c1fe047d60fee7e

20 years agoAdd remark in the changelog that mentions 64-bit alignment fixes in 3.2.2. (CVS 2547)
drh [Sat, 9 Jul 2005 23:11:22 +0000 (23:11 +0000)] 
Add remark in the changelog that mentions 64-bit alignment fixes in 3.2.2. (CVS 2547)

FossilOrigin-Name: ead583cfad7c6ea84c3685d89f40104f4d33bc81

20 years agoFix a comment error. No changes to code. Ticket #1320. (CVS 2546)
drh [Sat, 9 Jul 2005 02:39:40 +0000 (02:39 +0000)] 
Fix a comment error. No changes to code.  Ticket #1320. (CVS 2546)

FossilOrigin-Name: e050af70adcdac8f9c9d8cffd1658f7fb2ebd362

20 years agoUse the internal sqlite3_snprintf function instead of sprintf to avoid
drh [Sat, 9 Jul 2005 02:38:06 +0000 (02:38 +0000)] 
Use the internal sqlite3_snprintf function instead of sprintf to avoid
cross-platform incompatibilities.  Ticket #1316. (CVS 2545)

FossilOrigin-Name: 431999da7bf0079e0d514483b3bfd9f8471cba7d

20 years agoPatch to Makefile.in so that it works with OS X. Ticket #1292. (CVS 2544)
drh [Sat, 9 Jul 2005 02:23:24 +0000 (02:23 +0000)] 
Patch to Makefile.in so that it works with OS X.  Ticket #1292. (CVS 2544)

FossilOrigin-Name: 0dfabca641371690027634213632c914ad6f2b8b

20 years agoMake sure there is only one busy counter. Ticket #1315. (CVS 2543)
drh [Sat, 9 Jul 2005 02:16:02 +0000 (02:16 +0000)] 
Make sure there is only one busy counter.  Ticket #1315. (CVS 2543)

FossilOrigin-Name: af2a0ba4a38abf208db1ff6f018cf756de2afd5b

20 years agoAllow the IN operator to take a list of arbitrary expressions on its
drh [Fri, 8 Jul 2005 18:25:26 +0000 (18:25 +0000)] 
Allow the IN operator to take a list of arbitrary expressions on its
right-hand side.  The expressions no longer need to be constant.  The
current implementation seems to work but needs more testing and optimization. (CVS 2542)

FossilOrigin-Name: ba56478dd8bc2135749966ff55831fd497883781

20 years agoChange the name of the OpenTemp opcode to OpenVirtual which is more
drh [Fri, 8 Jul 2005 17:13:46 +0000 (17:13 +0000)] 
Change the name of the OpenTemp opcode to OpenVirtual which is more
descriptive of what it does. (CVS 2541)

FossilOrigin-Name: 3bb9ce5f20d0a6bc19df31df9b8e82044c3e6004

20 years agoAdd the EP_OptOnly flag on expressions for WHERE clause
drh [Fri, 8 Jul 2005 14:14:22 +0000 (14:14 +0000)] 
Add the EP_OptOnly flag on expressions for WHERE clause
terms that are added by the optimizer but should not be coded. (CVS 2540)

FossilOrigin-Name: f4a66ed04dfd8714746b766b4859682ea18e328f

20 years agoAdd the SQLITE_CASE_SENSITIVE_LIKE compile-time option. (CVS 2539)
drh [Fri, 8 Jul 2005 13:53:21 +0000 (13:53 +0000)] 
Add the SQLITE_CASE_SENSITIVE_LIKE compile-time option. (CVS 2539)

FossilOrigin-Name: b72bff81f9937378417a0af0610d8558279b67a7

20 years agoReplace OP_List with OP_Fifo. This is the first step toward allowing
drh [Fri, 8 Jul 2005 13:07:59 +0000 (13:07 +0000)] 
Replace OP_List with OP_Fifo.  This is the first step toward allowing
recursive delete triggers and later foreign keys with cascading deletes. (CVS 2538)

FossilOrigin-Name: 94c120bb782fed53142317d1755e70c858930486

20 years agoAdd infrastructure for the ANALYZE command. Does not yet actually
drh [Fri, 8 Jul 2005 12:13:04 +0000 (12:13 +0000)] 
Add infrastructure for the ANALYZE command.  Does not yet actually
do anything. (CVS 2537)

FossilOrigin-Name: 05b6ac9a76fd5765c50e81588f8e71c59fe35ce4

20 years agoFix a quoting problem in the configure script. (CVS 2536)
drh [Wed, 6 Jul 2005 13:51:27 +0000 (13:51 +0000)] 
Fix a quoting problem in the configure script. (CVS 2536)

FossilOrigin-Name: b34647a2ebec6f915f9914034e9370459873215e

20 years agoFix typos in comments. No changes to code. (CVS 2535)
drh [Fri, 1 Jul 2005 11:38:44 +0000 (11:38 +0000)] 
Fix typos in comments.  No changes to code. (CVS 2535)

FossilOrigin-Name: d3b03495a46e79a9d82525a61bad99eef9469ad1

20 years agoAllow the DEFAULT value of a column to be obtained by calling a
drh [Thu, 30 Jun 2005 17:04:21 +0000 (17:04 +0000)] 
Allow the DEFAULT value of a column to be obtained by calling a
function that has constant arguments, such as julianday('now'). (CVS 2534)

FossilOrigin-Name: d273766ef2442eb87971b07f9ecf5682c88298ee

20 years agoCheck for zero-byte allocations in sqlite3MallocRaw. (CVS 2533)
drh [Wed, 29 Jun 2005 17:24:23 +0000 (17:24 +0000)] 
Check for zero-byte allocations in sqlite3MallocRaw. (CVS 2533)

FossilOrigin-Name: 78cb8a9a17a29bb8d9ffb6298b25cc43f9cbfed9

20 years agoMake sqlite3Malloc always return NULL when the number of bytes to allocate
drh [Wed, 29 Jun 2005 15:33:00 +0000 (15:33 +0000)] 
Make sqlite3Malloc always return NULL when the number of bytes to allocate
is 0. (CVS 2532)

FossilOrigin-Name: 657d74ebc1d91c99e8ac6cd68fdac3864ebd8d71

20 years agoUpdate SQL syntax documentation to describe the new CAST expressions. (CVS 2531)
drh [Sun, 26 Jun 2005 20:00:46 +0000 (20:00 +0000)] 
Update SQL syntax documentation to describe the new CAST expressions. (CVS 2531)

FossilOrigin-Name: d5392866bfd6e06c6d072f649356050b82273a23

20 years agoTcl interface uses Tcl_Objs to implement user-defined functions, thus allowing
drh [Sun, 26 Jun 2005 17:55:33 +0000 (17:55 +0000)] 
Tcl interface uses Tcl_Objs to implement user-defined functions, thus allowing
BLOB values to be transferred correctly.  Ticket #1304. (CVS 2530)

FossilOrigin-Name: 514aaab3f99637ebb8b6e352f4e29738102579b4

20 years agoDocumentation fixes. Ticket #1306. (CVS 2529)
drh [Sat, 25 Jun 2005 19:42:37 +0000 (19:42 +0000)] 
Documentation fixes.  Ticket #1306. (CVS 2529)

FossilOrigin-Name: 3dcdb7942ea9a9e5d708a198ba5183103d5075d9

20 years agoThe TCL interface binds variables as BLOB only if they have a bytearray
drh [Sat, 25 Jun 2005 19:31:48 +0000 (19:31 +0000)] 
The TCL interface binds variables as BLOB only if they have a bytearray
representation but no text representation. Ticket #1287. (CVS 2528)

FossilOrigin-Name: 8c99dca60aebee0ec5de9ed11350de864bc76584

20 years agoRemove the blob(), text() and numeric() functions added in (2524) and
drh [Sat, 25 Jun 2005 18:42:14 +0000 (18:42 +0000)] 
Remove the blob(), text() and numeric() functions added in (2524) and
replace them with the standard CAST operator.
Ticket #1287. (CVS 2527)

FossilOrigin-Name: 17631785f9ee8ab280c82677eb53886912e085bc

20 years agoNULL values in a row of a unique index cause the row to be distinct.
drh [Fri, 24 Jun 2005 03:53:06 +0000 (03:53 +0000)] 
NULL values in a row of a unique index cause the row to be distinct.
Ticket #1301.  More testing and optimization needs to be done on this
before closing the ticket. (CVS 2526)

FossilOrigin-Name: 06a71b162b032fc5b56d18919a784d4ee94dde7c

20 years agoMake sure the String8 opcode always has a non-null P3 argument in
drh [Thu, 23 Jun 2005 03:15:07 +0000 (03:15 +0000)] 
Make sure the String8 opcode always has a non-null P3 argument in
the foreign_key_list pragma.  Ticket #1297. (CVS 2525)

FossilOrigin-Name: bcf62dc7a1e8e7a3180138cf9b8944eb8fbd5490

20 years agoAdd built-in functions numeric(), text(), and blob() that coerce types.
drh [Wed, 22 Jun 2005 10:53:59 +0000 (10:53 +0000)] 
Add built-in functions numeric(), text(), and blob() that coerce types.
Ticket #1287. (CVS 2524)

FossilOrigin-Name: affb0fa2e8c5ff497838ba3c2994cdb1f6f50c68

20 years agoAllow parameters to be introduced by characters ':', '$' and '#'. This
drh [Wed, 22 Jun 2005 08:48:06 +0000 (08:48 +0000)] 
Allow parameters to be introduced by characters ':', '$' and '#'.  This
is an experimental change. (CVS 2523)

FossilOrigin-Name: f3427a139c3bd4faf9134ec6290b3eb829c0a19f

20 years agoFix a bug in an assert found while investigating ticket #1287 but otherwise
drh [Wed, 22 Jun 2005 02:36:37 +0000 (02:36 +0000)] 
Fix a bug in an assert found while investigating ticket #1287 but otherwise
unrelated to that problem. (CVS 2522)

FossilOrigin-Name: 60f752ed1817e6710c13c2ce393c3bf51dae76ad

20 years agoChange the documentation to explain that a database handle can only be
drh [Thu, 16 Jun 2005 19:48:39 +0000 (19:48 +0000)] 
Change the documentation to explain that a database handle can only be
used in the same thread in which it was created.  Ticket #1272. (CVS 2521)

FossilOrigin-Name: 59c95731f70ed9b9e135584f62d0a2b0f1a3bb96

20 years agoFix the THREADSAFE macro in Makefile.in. We really need to rework the
drh [Thu, 16 Jun 2005 18:47:38 +0000 (18:47 +0000)] 
Fix the THREADSAFE macro in Makefile.in.  We really need to rework the
whole autoconf build system.... (CVS 2520)

FossilOrigin-Name: 98a4de76e0593ef1d1d3e8b785d420cd554a08e8

20 years agoChange to Makefile.in to fix a problem with the Borland linker.
drh [Thu, 16 Jun 2005 16:51:15 +0000 (16:51 +0000)] 
Change to Makefile.in to fix a problem with the Borland linker.
Ticket #1291. (CVS 2519)

FossilOrigin-Name: bc25397735c1485e3533507bed507250ea07534a

20 years agoFix to the "make doc" makefile target. Ticket #1289. (CVS 2518)
drh [Wed, 15 Jun 2005 18:07:39 +0000 (18:07 +0000)] 
Fix to the "make doc" makefile target.  Ticket #1289. (CVS 2518)

FossilOrigin-Name: 4713b1e1040f2e0645fa593638e392df44b5bfc1

20 years agoChanges to the unix OS layer aimed at finding and fixing tickets
drh [Wed, 15 Jun 2005 17:47:55 +0000 (17:47 +0000)] 
Changes to the unix OS layer aimed at finding and fixing tickets
#1272 and #1285. (CVS 2517)

FossilOrigin-Name: 006dda3119f025d703da4e0215c378206e20cfd0

20 years agoFix an NDEBUG versus SQLITE_DEBUG confusion issue. (CVS 2516)
drh [Tue, 14 Jun 2005 17:47:58 +0000 (17:47 +0000)] 
Fix an NDEBUG versus SQLITE_DEBUG confusion issue. (CVS 2516)

FossilOrigin-Name: 833c016023e9e17c226fdd722dcb10bc51ab6f9e

20 years agoProvide the SQLITE_FILE_HEADER command-line option for changing the text
drh [Tue, 14 Jun 2005 16:04:05 +0000 (16:04 +0000)] 
Provide the SQLITE_FILE_HEADER command-line option for changing the text
that appears at the beginning of databases. (CVS 2515)

FossilOrigin-Name: 3d7ee5b92d7e30f90cb7a8b3efd649b36480b61b

20 years agoFix a bug in the default busy handler for systems that lack usleep().
drh [Tue, 14 Jun 2005 02:24:31 +0000 (02:24 +0000)] 
Fix a bug in the default busy handler for systems that lack usleep().
Ticket #1284. (CVS 2514)

FossilOrigin-Name: a42cb81d1173532537aed4e71091d4cd3f3a88a0

20 years agoDo not record existance the sqlite_sequence table until it is actually
drh [Tue, 14 Jun 2005 02:12:46 +0000 (02:12 +0000)] 
Do not record existance the sqlite_sequence table until it is actually
created.  Ticket #1283. (CVS 2513)

FossilOrigin-Name: 95256d953c179372dcc5ead6c407672c8161a8c1

20 years agoFix documentation typo. Ticket #1282. (CVS 2512)
drh [Mon, 13 Jun 2005 00:47:59 +0000 (00:47 +0000)] 
Fix documentation typo.  Ticket  #1282. (CVS 2512)

FossilOrigin-Name: ce6b62fa46bc67085801c48d6a28944d4d373ba9

20 years agoVersion 3.2.2 (CVS 2511)
drh [Sun, 12 Jun 2005 23:17:23 +0000 (23:17 +0000)] 
Version 3.2.2 (CVS 2511)

FossilOrigin-Name: 0e190e9d9137e9d29fc53ce6f1136047d578bb55

20 years agoUpdate the EXPORT definitions list to include the latest additions to the API. (CVS...
drh [Sun, 12 Jun 2005 23:16:20 +0000 (23:16 +0000)] 
Update the EXPORT definitions list to include the latest additions to the API. (CVS 2510)

FossilOrigin-Name: 44e54b132e03d86e52055dc0a2815b653ec179e8

20 years agoUpdates in preparation for the release of version 3.2.2. (CVS 2509)
drh [Sun, 12 Jun 2005 22:23:40 +0000 (22:23 +0000)] 
Updates in preparation for the release of version 3.2.2. (CVS 2509)

FossilOrigin-Name: e9602c4a9d2b62a9b3a86b94f47971c56ee6733e

20 years agoFix documentation typos. (CVS 2508)
drh [Sun, 12 Jun 2005 22:12:39 +0000 (22:12 +0000)] 
Fix documentation typos. (CVS 2508)

FossilOrigin-Name: 41049062cdefdc111398589daff464a9a13600aa