]> git.ipfire.org Git - thirdparty/sqlite.git/log
thirdparty/sqlite.git
19 years agoRemove a stray C++ style comment causing problems for some compilers. (CVS 2621)
drh [Wed, 24 Aug 2005 16:54:05 +0000 (16:54 +0000)] 
Remove a stray C++ style comment causing problems for some compilers. (CVS 2621)

FossilOrigin-Name: aa7dd3f2c72335fe7778c021e4b6bbbc4ec322df

19 years agoFix a bug in DELETE that might cause a segfault when deleting more
drh [Wed, 24 Aug 2005 16:13:51 +0000 (16:13 +0000)] 
Fix a bug in DELETE that might cause a segfault when deleting more
than 40940 rows of data all at once. (CVS 2620)

FossilOrigin-Name: 7c599bae33ba4eb10fc486ae3dab76330ce69936

19 years agoVersion 3.2.4 (CVS 2619)
drh [Wed, 24 Aug 2005 11:14:46 +0000 (11:14 +0000)] 
Version 3.2.4 (CVS 2619)

FossilOrigin-Name: 8cef2c1ae728970a38d794f9903115da5d0fcd55

19 years agoIncrease the version number and update the change log prior to release. (CVS 2618)
drh [Wed, 24 Aug 2005 11:07:19 +0000 (11:07 +0000)] 
Increase the version number and update the change log prior to release. (CVS 2618)

FossilOrigin-Name: 139a28d231875e72538fd6842168c458441ad1d0

19 years agoAfter calling realloc() on an array to resize it, be sure not to use pointers
drh [Wed, 24 Aug 2005 03:52:18 +0000 (03:52 +0000)] 
After calling realloc() on an array to resize it, be sure not to use pointers
into the old array.  Ticket #1376. (CVS 2617)

FossilOrigin-Name: 9f9a257123274779150cbc290b9f86a09b3b2c03

19 years agoAllow floating point literals to being or end with a decimal point.
drh [Tue, 23 Aug 2005 11:31:26 +0000 (11:31 +0000)] 
Allow floating point literals to being or end with a decimal point.
Ticket #1371. (CVS 2616)

FossilOrigin-Name: a715e7001247e84e0982335570593f0802774635

19 years agoHandle empty blob constants correctly. Ticket #1373. (CVS 2615)
drh [Tue, 23 Aug 2005 11:17:58 +0000 (11:17 +0000)] 
Handle empty blob constants correctly.  Ticket #1373. (CVS 2615)

FossilOrigin-Name: 5cada745ac9bf18a65d21705a398b2bb8bd1aaa2

19 years agoFix another documentation typo. (CVS 2614)
drh [Tue, 23 Aug 2005 11:03:02 +0000 (11:03 +0000)] 
Fix another documentation typo. (CVS 2614)

FossilOrigin-Name: 55f4b14e1958ff3d2b0c99749f0c01192bafbf37

19 years agoFix typos in syntax documentation. Ticket #1374 and a report on the mailing
drh [Tue, 23 Aug 2005 11:00:39 +0000 (11:00 +0000)] 
Fix typos in syntax documentation.  Ticket #1374 and a report on the mailing
list. (CVS 2613)

FossilOrigin-Name: 990d1f3a5b13cadc2930334c4bd7007e3645e75b

19 years agoUpdate the download page of the website to handle TEA builds and starkits. (CVS 2612)
drh [Mon, 22 Aug 2005 02:10:46 +0000 (02:10 +0000)] 
Update the download page of the website to handle TEA builds and starkits. (CVS 2612)

FossilOrigin-Name: 1fab599b6f89534152c53b820b5e6ee1ba30c059

19 years agoClean up possible locking problem in multithreaded applications that take
drh [Sun, 21 Aug 2005 21:45:01 +0000 (21:45 +0000)] 
Clean up possible locking problem in multithreaded applications that take
a malloc failure. (CVS 2611)

FossilOrigin-Name: 545e702a23c7a6b09e10441d4137efe5a9618a84

19 years agoVersion 3.2.3 (CVS 2610)
drh [Sun, 21 Aug 2005 18:54:48 +0000 (18:54 +0000)] 
Version 3.2.3 (CVS 2610)

FossilOrigin-Name: f620319b440dab9f8a0ad9ada3e6ee5560d5c623

19 years agoIncrease the version number and adjust documentation prior to the next release. ...
drh [Sun, 21 Aug 2005 18:40:20 +0000 (18:40 +0000)] 
Increase the version number and adjust documentation prior to the next release. (CVS 2609)

FossilOrigin-Name: b15ed7db4d5186d8b22c0b51cd44c4d9d7001318

19 years agoDisable malloc tests when not compiled with SQLITE_DEBUG. (CVS 2608)
drh [Sun, 21 Aug 2005 18:21:50 +0000 (18:21 +0000)] 
Disable malloc tests when not compiled with SQLITE_DEBUG. (CVS 2608)

FossilOrigin-Name: f372682fa375c22213da0e4cd8413eab3c6ac85b

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

20 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

20 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

20 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

20 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

20 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

20 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

20 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

20 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

20 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

20 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

20 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

20 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

20 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

20 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

20 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

20 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

20 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

20 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

20 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

20 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

20 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

20 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

20 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

20 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

20 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

20 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

20 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

20 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