]> git.ipfire.org Git - thirdparty/sqlite.git/log
thirdparty/sqlite.git
19 years agoHandle NULL database names in ATTACH and DETACH as if they were empty
drh [Thu, 25 May 2006 11:52:37 +0000 (11:52 +0000)] 
Handle NULL database names in ATTACH and DETACH as if they were empty
strings.  Ticket #1825. (CVS 3191)

FossilOrigin-Name: 79a818bb05bc95c4c83375a679955dd18659b2b8

19 years agoWhen opening a new connection on a shared cache, be careful not to
drh [Wed, 24 May 2006 12:43:26 +0000 (12:43 +0000)] 
When opening a new connection on a shared cache, be careful not to
overwrite the encoding flag on the shared cache.  Ticket #1824. (CVS 3190)

FossilOrigin-Name: c8e5ceedee087098c04e3b6b8b82710de0563e77

19 years agoAdditional tests for ticket #1821. (CVS 3189)
drh [Tue, 23 May 2006 23:25:09 +0000 (23:25 +0000)] 
Additional tests for ticket #1821. (CVS 3189)

FossilOrigin-Name: b93e3fb02aeff7fe6cae56c3a45c43ffdb2f030b

19 years agoFix type coercion rules for the IN operator. Ticket #1821. (CVS 3188)
drh [Tue, 23 May 2006 23:22:29 +0000 (23:22 +0000)] 
Fix type coercion rules for the IN operator.  Ticket #1821. (CVS 3188)

FossilOrigin-Name: 6e5a49762166a942e1b2c3beae8a30c07187eb10

19 years agoIf an sqlite3_mprintf() call uses a disallowed internal-use-only conversion
drh [Mon, 22 May 2006 22:04:00 +0000 (22:04 +0000)] 
If an sqlite3_mprintf() call uses a disallowed internal-use-only conversion
character, then abort the call with a -1 error code.  Ticket #1818. (CVS 3187)

FossilOrigin-Name: 9d7297b9ef6ca2f35116e37f993bb029cf03d4f0

19 years agoAdjust the default weights on indices so that an index that matches more
drh [Thu, 11 May 2006 23:14:59 +0000 (23:14 +0000)] 
Adjust the default weights on indices so that an index that matches more
terms of the where clause wins (by default) over one that matches fewer.
Ticket #1808. (CVS 3186)

FossilOrigin-Name: 249b579f83b2922e3e03037186a9402af951e6d1

19 years agoFix documentation typo: The name of the competing database engine is
drh [Thu, 11 May 2006 13:33:14 +0000 (13:33 +0000)] 
Fix documentation typo:  The name of the competing database engine is
"Firebird", not "Firefox". (CVS 3185)

FossilOrigin-Name: 8be6a39d7108839b0fb298a2d536d68ebca86d66

19 years agoCorrectly handle multi-column indices where multiple columns are constrained
drh [Thu, 11 May 2006 13:26:25 +0000 (13:26 +0000)] 
Correctly handle multi-column indices where multiple columns are constrained
by IN operators with subqueries on the right-hand side.  Ticket #1807. (CVS 3184)

FossilOrigin-Name: b16541ba5e6a9514f9f317888117c68b6818f9cb

19 years agoFix comments on the implementation of the SUM() function. (CVS 3183)
drh [Thu, 11 May 2006 13:25:39 +0000 (13:25 +0000)] 
Fix comments on the implementation of the SUM() function. (CVS 3183)

FossilOrigin-Name: a8909f3e5fc67ac1ba7d1abd7fb0f4004fec5984

19 years agoOut-of-memory checks added to tclsqlite.c and shell.c. Tickets #1805 and #1806....
drh [Wed, 10 May 2006 14:39:13 +0000 (14:39 +0000)] 
Out-of-memory checks added to tclsqlite.c and shell.c.  Tickets #1805 and #1806. (CVS 3182)

FossilOrigin-Name: 364031d6e512b992a7147bbc8e046c20c0c5335a

19 years agoFix error processing in Lemon. SQLite does not use this feature of lemon
drh [Mon, 8 May 2006 15:14:19 +0000 (15:14 +0000)] 
Fix error processing in Lemon.  SQLite does not use this feature of lemon
so it is uneffected. (CVS 3181)

FossilOrigin-Name: 864cac960390a31c240d34ffd62bb084ab780267

19 years agoAutomatically increase the size of the pager hash table as the number
drh [Sun, 7 May 2006 17:49:38 +0000 (17:49 +0000)] 
Automatically increase the size of the pager hash table as the number
of in-memory pages increases.  Tickets #1790 and #1799. (CVS 3180)

FossilOrigin-Name: ef8e9886f40c8528604264308f5e4734ae6706c5

19 years agoFix a typo on a webpage. Ticket #1792. (CVS 3179)
drh [Wed, 3 May 2006 23:39:36 +0000 (23:39 +0000)] 
Fix a typo on a webpage.  Ticket #1792. (CVS 3179)

FossilOrigin-Name: 2702205277f45aadd2f07d51f71af4efd266228f

19 years agoFaster :memory: database COMMITs. Ticket #1790. (CVS 3178)
drh [Wed, 3 May 2006 23:34:05 +0000 (23:34 +0000)] 
Faster :memory: database COMMITs.  Ticket #1790. (CVS 3178)

FossilOrigin-Name: 8f820e435272c0a4861421508c7e6f2979c2750f

19 years agoGet LIMIT 0 working on subqueries. Ticket #1784. (CVS 3177)
drh [Wed, 26 Apr 2006 17:39:34 +0000 (17:39 +0000)] 
Get LIMIT 0 working on subqueries.  Ticket #1784. (CVS 3177)

FossilOrigin-Name: 7f3ef7ddba22d69a23e656836ba76738c9652b4d

19 years agoAdditional information about index sorting in EXPLAIN QUERY PLAN. (CVS 3176)
drh [Fri, 21 Apr 2006 09:38:36 +0000 (09:38 +0000)] 
Additional information about index sorting in EXPLAIN QUERY PLAN. (CVS 3176)

FossilOrigin-Name: 39dd969527a107b2a6bb94dfc35d93850917faa8

19 years agoRemove a superfluous call to access() in the unix driver. Error spotted
drh [Wed, 19 Apr 2006 01:24:53 +0000 (01:24 +0000)] 
Remove a superfluous call to access() in the unix driver.  Error spotted
by Coverity. (CVS 3175)

FossilOrigin-Name: 4f195aa1ebef5129e6f912e78b3d5f97b393a06c

19 years agoAllocate enough memory for the worst-case UTF-16 to UTF-8 conversion.
drh [Sun, 16 Apr 2006 12:05:03 +0000 (12:05 +0000)] 
Allocate enough memory for the worst-case UTF-16 to UTF-8 conversion.
Ticket #1773. (CVS 3174)

FossilOrigin-Name: 2a0120c0f06d17185ede773729d97c93f90923ff

19 years agoAllow constant terms in the ORDER BY or GROUP BY clauses. Ticket #1768. (CVS 3173)
drh [Tue, 11 Apr 2006 14:16:21 +0000 (14:16 +0000)] 
Allow constant terms in the ORDER BY or GROUP BY clauses.  Ticket #1768. (CVS 3173)

FossilOrigin-Name: d83e0230c0c4909cb035e266beffc0967526d9c1

19 years agoFollow-up to check-in (3164). Make sure SQLITE_NOMEM is returned after
drh [Mon, 10 Apr 2006 13:37:47 +0000 (13:37 +0000)] 
Follow-up to check-in (3164).  Make sure SQLITE_NOMEM is returned after
a memory allocation failure.  It is not sufficent to return an "out of memory"
error message.  The return code needs to be SQLITE_NOMEM. (CVS 3172)

FossilOrigin-Name: 9d95750e8556aef20a637a815652d547ed2f887c

19 years agoVariable declarations should come before code. Ticket #1763. (CVS 3171)
drh [Sat, 8 Apr 2006 19:14:53 +0000 (19:14 +0000)] 
Variable declarations should come before code.  Ticket #1763. (CVS 3171)

FossilOrigin-Name: 9682f84401f7e21630246e1c37351425b78b7afa

19 years agoReorder code so that it compiles with SQLITE_OMIT_MEMORYDB. Ticket #1754. (CVS 3170)
drh [Fri, 7 Apr 2006 13:54:46 +0000 (13:54 +0000)] 
Reorder code so that it compiles with SQLITE_OMIT_MEMORYDB.  Ticket #1754. (CVS 3170)

FossilOrigin-Name: 1929e37d5e691f9d2bec01deb7bdbbbb6f5ace01

19 years agoReturn the correct declared column type, origin column name, origin database
drh [Fri, 7 Apr 2006 13:50:37 +0000 (13:50 +0000)] 
Return the correct declared column type, origin column name, origin database
name, etc. from aggregate queries.  Ticket #1726 and #1755. (CVS 3169)

FossilOrigin-Name: e64809f0ae98ce9d152cf030cae72bf3df3e2403

19 years agoAvoid the use of atof(). Ticket #1756. (CVS 3168)
drh [Fri, 7 Apr 2006 13:26:42 +0000 (13:26 +0000)] 
Avoid the use of atof().  Ticket #1756. (CVS 3168)

FossilOrigin-Name: 76aef93c3e113b0077f534a437a339be2b15ca3d

19 years agoVersion 3.3.5 (CVS 3167)
drh [Wed, 5 Apr 2006 13:16:48 +0000 (13:16 +0000)] 
Version 3.3.5 (CVS 3167)

FossilOrigin-Name: a091a61d8832ad3454231f480ec605101bb9363a

19 years agoFix typos in the previous check-in. (CVS 3166)
drh [Wed, 5 Apr 2006 12:50:08 +0000 (12:50 +0000)] 
Fix typos in the previous check-in. (CVS 3166)

FossilOrigin-Name: 119ec402281c142359cfe5ccf1416bf69eed103f

19 years agoPreparing for the release of version 3.3.5. (CVS 3165)
drh [Wed, 5 Apr 2006 12:15:11 +0000 (12:15 +0000)] 
Preparing for the release of version 3.3.5. (CVS 3165)

FossilOrigin-Name: 159fb92bd5290098986709f5d9ff8183e9059d53

19 years agoMake sure SQLITE_NOMEM is reported out on a malloc failure in an ATTACH
drh [Wed, 5 Apr 2006 11:57:37 +0000 (11:57 +0000)] 
Make sure SQLITE_NOMEM is reported out on a malloc failure in an ATTACH
even if the malloc failure reports within a nested calls to sqlite3_prepare(). (CVS 3164)

FossilOrigin-Name: 3538a4e30fb5131b461bb0cf72cada63e9724e14

19 years agoAdd documentation on new sqlite_authorizer callback types. Ticket #1744. (CVS 3163)
drh [Wed, 5 Apr 2006 01:08:35 +0000 (01:08 +0000)] 
Add documentation on new sqlite_authorizer callback types. Ticket #1744. (CVS 3163)

FossilOrigin-Name: fdbff3f145296d5dcba8987c25629e27353e2ab0

19 years agoDocumentation typos. Tickets #1749 and #1750. (CVS 3162)
drh [Wed, 5 Apr 2006 01:02:08 +0000 (01:02 +0000)] 
Documentation typos.  Tickets #1749 and #1750. (CVS 3162)

FossilOrigin-Name: 51b35ace203a33f6f04f1139ca8ab652c5c76f9a

19 years agoChanges to get SQLite running on machines that use the EBCDIC character set. (CVS...
drh [Tue, 4 Apr 2006 01:54:55 +0000 (01:54 +0000)] 
Changes to get SQLite running on machines that use the EBCDIC character set. (CVS 3161)

FossilOrigin-Name: 4342b4997199241cafd6120c6abda665770e270c

19 years agoDo not strip windows DLLs because this prevents them from being relocatable.
drh [Sun, 2 Apr 2006 11:57:12 +0000 (11:57 +0000)] 
Do not strip windows DLLs because this prevents them from being relocatable.
Ticket #1474. (CVS 3160)

FossilOrigin-Name: 94054cd997a67541547cf593bfbba7da4f9e31ce

19 years agoRemove mention of the REVERSE collating sequence from the documentation. (CVS 3159)
drh [Sat, 1 Apr 2006 14:38:41 +0000 (14:38 +0000)] 
Remove mention of the REVERSE collating sequence from the documentation. (CVS 3159)

FossilOrigin-Name: bd6876a1a946a9b266b31d776081464de7c7f437

19 years agoProperly record the names of triggers even if the name is quoted.
drh [Wed, 29 Mar 2006 00:24:06 +0000 (00:24 +0000)] 
Properly record the names of triggers even if the name is quoted.
Ticket #1737. (CVS 3158)

FossilOrigin-Name: 4ba280ddd66d5cbf617263d6300b7582f65d47a9

19 years agoCompile-time option to use only 32-bit integers. (CVS 3157)
drh [Tue, 28 Mar 2006 23:57:17 +0000 (23:57 +0000)] 
Compile-time option to use only 32-bit integers. (CVS 3157)

FossilOrigin-Name: aedadfc3e47efa28ff81d7789b54fba9fcc128db

19 years agoJoin optimizer enhancements. (CVS 3156)
drh [Tue, 28 Mar 2006 23:55:57 +0000 (23:55 +0000)] 
Join optimizer enhancements. (CVS 3156)

FossilOrigin-Name: 0039888f9132dc7461af4ae448292a0ce9adf804

19 years agoExtra asserts to prove that certain reported errors in btree.c are not really
drh [Tue, 28 Mar 2006 00:24:44 +0000 (00:24 +0000)] 
Extra asserts to prove that certain reported errors in btree.c are not really
errors. (CVS 3155)

FossilOrigin-Name: c64542d0e8efd6daecb037009474f4448793e4c0

19 years agoWork around a bug in GCC 4.0.2. (CVS 3154)
drh [Sun, 26 Mar 2006 20:49:17 +0000 (20:49 +0000)] 
Work around a bug in GCC 4.0.2. (CVS 3154)

FossilOrigin-Name: fe0920c7922bfdbefbc0107fb9170d98bec2dcef

19 years agoSQLite now always chooses the column names for compound selects using
drh [Sun, 26 Mar 2006 01:21:22 +0000 (01:21 +0000)] 
SQLite now always chooses the column names for compound selects using
the left-most select.  This makes SQLite work like other SQL database,
but it also is a change from historical behavior and may break some
scripts.  Ticket #1721. (CVS 3153)

FossilOrigin-Name: 80cda9f7ce83f2de6cd2fdaf6150bbc35b670fee

19 years agoAdd code to report an error on a recursive trigger, but leave it
drh [Sat, 25 Mar 2006 15:52:19 +0000 (15:52 +0000)] 
Add code to report an error on a recursive trigger, but leave it
commented out - turning it on will likely break a lot of code. (CVS 3152)

FossilOrigin-Name: c83ec81d53f756660cafbbdaf9cf92e9e4bab4ad

19 years agoAdd a note to the API documentation emphasizing that the filename argument
drh [Sat, 25 Mar 2006 14:03:42 +0000 (14:03 +0000)] 
Add a note to the API documentation emphasizing that the filename argument
to sqlite3_open() must be UTF-8.  Tickets #1713, #1533. (CVS 3151)

FossilOrigin-Name: b0111f43e4f82f0c3144d1e6348d9e5fae504d95

19 years agoMake sure the rootpage values in the symbol table are correctly updated
drh [Fri, 24 Mar 2006 03:36:26 +0000 (03:36 +0000)] 
Make sure the rootpage values in the symbol table are correctly updated
when dropping tables and indices in autocommit mode.  Ticket #1728. (CVS 3150)

FossilOrigin-Name: 1c582dd11304f4421da2fa451f52b313b541270e

19 years agoImprovements to comments in build.c. (CVS 3149)
drh [Thu, 23 Mar 2006 23:33:26 +0000 (23:33 +0000)] 
Improvements to comments in build.c. (CVS 3149)

FossilOrigin-Name: 986208a364ce0ba81456b54e6561a277fb19309c

19 years agoGet autovacuum and in-memory databases working together. Ticket #1727. (CVS 3148)
drh [Thu, 23 Mar 2006 23:29:04 +0000 (23:29 +0000)] 
Get autovacuum and in-memory databases working together.  Ticket #1727. (CVS 3148)

FossilOrigin-Name: 21446df6420df00468867f1131c28604a1ae91a3

19 years agoUse the pread()/pwrite() interface on Posix if compiled with -DUSE_PREAD=1.
drh [Thu, 23 Mar 2006 22:42:20 +0000 (22:42 +0000)] 
Use the pread()/pwrite() interface on Posix if compiled with -DUSE_PREAD=1.
Note that on Linux this is slower and does not work for large files. (CVS 3147)

FossilOrigin-Name: 5a24f61981df4d8b696f03372eba2d37228906d9

19 years agoImprovements to comments. No changes to code. (CVS 3146)
drh [Thu, 23 Mar 2006 14:03:00 +0000 (14:03 +0000)] 
Improvements to comments.   No changes to code. (CVS 3146)

FossilOrigin-Name: 01e164da67fde3a89abeadd5973ead7a74e23a51

19 years agoGet the build to run with -DSQLITE_OMIT_SHARED_CACHE. (CVS 3145)
drh [Wed, 22 Mar 2006 22:10:07 +0000 (22:10 +0000)] 
Get the build to run with -DSQLITE_OMIT_SHARED_CACHE. (CVS 3145)

FossilOrigin-Name: 15e3b183bc554f729ce99c7daa5e36cdbcfa93fa

19 years agoIncrease test coverage to above 98%. (CVS 3144)
drh [Sun, 19 Mar 2006 13:00:25 +0000 (13:00 +0000)] 
Increase test coverage to above 98%. (CVS 3144)

FossilOrigin-Name: 8ae6ccc715b081cd422e847cd9e5cc22b04d8512

19 years agoMiscellaneous code cleanup. (CVS 3143)
drh [Fri, 17 Mar 2006 13:56:34 +0000 (13:56 +0000)] 
Miscellaneous code cleanup. (CVS 3143)

FossilOrigin-Name: 8f60139f688903f0e635b0a904ab9ca401fbe71f

19 years agoCode and comment cleanup for the sorting optimization of the previous check-in. ...
drh [Fri, 17 Mar 2006 00:25:59 +0000 (00:25 +0000)] 
Code and comment cleanup for the sorting optimization of the previous check-in. (CVS 3142)

FossilOrigin-Name: f3fbe72733b49264a6e0a91bf65c7fd80c7b65ea

19 years agoMuch faster sorting when there are a large number of columns in the
drh [Fri, 17 Mar 2006 00:04:03 +0000 (00:04 +0000)] 
Much faster sorting when there are a large number of columns in the
result set. (CVS 3141)

FossilOrigin-Name: 6b3717aeb4ac45a433f2a30bdd0264ed728676e1

19 years agoFix some compiler warnings. (CVS 3140)
drh [Thu, 16 Mar 2006 16:19:56 +0000 (16:19 +0000)] 
Fix some compiler warnings. (CVS 3140)

FossilOrigin-Name: 6c5175bc0f98e4ce715b099394f3fdc878ed82e8

19 years agoMake provisions in the code to support Provisions to support caching of
drh [Thu, 16 Mar 2006 14:05:14 +0000 (14:05 +0000)] 
Make provisions in the code to support Provisions to support caching of
serialized statements in the SSE extension. (CVS 3139)

FossilOrigin-Name: 5048fae04227857c064c0ba48eb11bedeb467df0

19 years agoPerformance improvement in sqlite3VdbeAddOp(). (CVS 3138)
drh [Wed, 15 Mar 2006 22:44:36 +0000 (22:44 +0000)] 
Performance improvement in sqlite3VdbeAddOp(). (CVS 3138)

FossilOrigin-Name: 6bcbe8fcad35de6e9b90e7776bd262fdf7cbc28e

19 years agoFix CHECK constraints to use alternative conflict resolution. Ticket #1717. (CVS...
drh [Wed, 15 Mar 2006 16:26:10 +0000 (16:26 +0000)] 
Fix CHECK constraints to use alternative conflict resolution.  Ticket #1717. (CVS 3137)

FossilOrigin-Name: c0d20fa97f94313e6b7ee5b4baa236ef5b664d76

19 years agoSet and clear the full_column_name flag using direct invocation rather than
drh [Tue, 14 Mar 2006 13:10:42 +0000 (13:10 +0000)] 
Set and clear the full_column_name flag using direct invocation rather than
the execsql tcl command so that the select1 test works with the serialized
statement extension. (CVS 3136)

FossilOrigin-Name: 4d70013a6a42a58bc7af3a87bf79c131a0070e96

19 years agoMove the PENDING_PAGE to a very large value if disk I/O is omitted. (CVS 3135)
drh [Tue, 14 Mar 2006 12:59:10 +0000 (12:59 +0000)] 
Move the PENDING_PAGE to a very large value if disk I/O is omitted. (CVS 3135)

FossilOrigin-Name: f07181739f82b0d23f934f51b97e67c32efe6f42

19 years agoMake sure sqlite3FindCollSeq() returns NULL after a malloc() failure. (CVS 3134)
drh [Tue, 14 Mar 2006 11:08:27 +0000 (11:08 +0000)] 
Make sure sqlite3FindCollSeq() returns NULL after a malloc() failure. (CVS 3134)

FossilOrigin-Name: 0e05355f3ca795f0ab959553e6c9462e5483c3b2

19 years agoGet parserless builds working again. (CVS 3133)
drh [Mon, 13 Mar 2006 15:06:05 +0000 (15:06 +0000)] 
Get parserless builds working again. (CVS 3133)

FossilOrigin-Name: 5ddc09a5e4d81a73228cd8038c6dc345b1fdf4af

19 years agoFix documentation to show the correct return type from sqlite3_db_handle().
drh [Mon, 13 Mar 2006 14:31:39 +0000 (14:31 +0000)] 
Fix documentation to show the correct return type from sqlite3_db_handle().
Ticket #1716. (CVS 3132)

FossilOrigin-Name: f4fb047d0a0939ab6a25b75999501f5956e9f67c

19 years agoChanges to get the Serialized Statement Extension working again. (CVS 3131)
drh [Mon, 13 Mar 2006 14:28:05 +0000 (14:28 +0000)] 
Changes to get the Serialized Statement Extension working again. (CVS 3131)

FossilOrigin-Name: 255fdbe6fa31ce276a8e6511af4ec6c36a741c20

19 years agoAdditional changes due to Coverity scans. (CVS 3130)
drh [Mon, 13 Mar 2006 12:54:09 +0000 (12:54 +0000)] 
Additional changes due to Coverity scans. (CVS 3130)

FossilOrigin-Name: a69f697d50124f2c0c654d56390ae83a4ac5e9e8

19 years agoAdd an assert() to demonstrate that Klockworks is wrong about an aleged bug. (CVS...
drh [Sat, 11 Mar 2006 12:04:18 +0000 (12:04 +0000)] 
Add an assert() to demonstrate that Klockworks is wrong about an aleged bug. (CVS 3129)

FossilOrigin-Name: 0910022be3ec8ce540e0e6adce2eed7a7cd28fd3

19 years agoCorrect names returned from a query against a view. Ticket #1709, #1688, #1711....
drh [Thu, 9 Mar 2006 17:28:12 +0000 (17:28 +0000)] 
Correct names returned from a query against a view.  Ticket #1709, #1688, #1711. (CVS 3128)

FossilOrigin-Name: 36830fafa405c9eae4795045efc6843394c67555

19 years agoRemove all reference to EXTERN from tclsqlite.c. Ticket #1687. (CVS 3127)
drh [Mon, 6 Mar 2006 23:30:51 +0000 (23:30 +0000)] 
Remove all reference to EXTERN from tclsqlite.c.  Ticket #1687. (CVS 3127)

FossilOrigin-Name: b4d3e0d528c7d17fa3d05956a188cd4d431204b2

19 years agoCode changes resulting from Coverity analysis.
drh [Mon, 6 Mar 2006 20:55:46 +0000 (20:55 +0000)] 
Code changes resulting from Coverity analysis.
http://scan.coverity.com/  Found 1 potential segfault in sqlite3_mprintf().
Also 2 failures to fclose() following a malloc() failure.  And lots of
cases where unnecessary conditionals could be removed from the code. (CVS 3126)

FossilOrigin-Name: e510e6dd9d6261f33b853af3b32d155b9d6b63b3

19 years agoPager performance enhancements. (CVS 3125)
drh [Mon, 6 Mar 2006 18:23:16 +0000 (18:23 +0000)] 
Pager performance enhancements. (CVS 3125)

FossilOrigin-Name: 9c26570743d878dee963e37728969fb30a2fb436

19 years agoFix typo in documentation. Ticket #1578. (CVS 3124)
drh [Fri, 3 Mar 2006 21:39:54 +0000 (21:39 +0000)] 
Fix typo in documentation.  Ticket #1578. (CVS 3124)

FossilOrigin-Name: cb2e009f1748e8c4945e85a3d36b4435003412f0

19 years agoEXPLAIN sets the length of its text return values correctly. Ticket #1583. (CVS...
drh [Fri, 3 Mar 2006 21:38:03 +0000 (21:38 +0000)] 
EXPLAIN sets the length of its text return values correctly.  Ticket #1583. (CVS 3123)

FossilOrigin-Name: 34b560e81170b33b766a6a7cd462a227425c15d9

19 years agoThe table_info pragma shows column affinity as "" if there is no column
drh [Fri, 3 Mar 2006 21:20:16 +0000 (21:20 +0000)] 
The table_info pragma shows column affinity as "" if there is no column
affinity.  Ticket #1570. (CVS 3122)

FossilOrigin-Name: 5cae8d63d9c83f481bd2fbbcfed69df631062651

19 years agoMake sure the default busy handler uses usleep() when available.
drh [Fri, 3 Mar 2006 20:54:41 +0000 (20:54 +0000)] 
Make sure the default busy handler uses usleep() when available.
Ticket #1684. (CVS 3121)

FossilOrigin-Name: 43e5462608819e9c2c8bcb4860d4c2d6ecda600c

19 years agoThe --enable-debug option on configure enables verbose explain and vdbe_trace.
drh [Fri, 3 Mar 2006 20:37:52 +0000 (20:37 +0000)] 
The --enable-debug option on configure enables verbose explain and vdbe_trace.
Ticket #1680. (CVS 3120)

FossilOrigin-Name: ee2f706800849a95cc74a08ba0f25d3728dbe3ec

19 years agoFix tclsqlite.c to better support Mingw. Ticket #1687. (CVS 3119)
drh [Fri, 3 Mar 2006 20:32:18 +0000 (20:32 +0000)] 
Fix tclsqlite.c to better support Mingw.  Ticket #1687. (CVS 3119)

FossilOrigin-Name: da0e843c05fc708d48e396aaab00fb6247180b51

19 years agoIgnore leading spaces on text to numeric conversions. Ticket #1662.
drh [Fri, 3 Mar 2006 19:12:29 +0000 (19:12 +0000)] 
Ignore leading spaces on text to numeric conversions.  Ticket #1662.
Fixes to test cases broken by the recent changes to round(). (CVS 3118)

FossilOrigin-Name: cdca3383c54b33aeafbbdbbb4ae7c90796cf66e5

19 years agoAllow WHERE clause terms on the left table of a LEFT OUTER JOIN to
drh [Thu, 2 Mar 2006 04:44:23 +0000 (04:44 +0000)] 
Allow WHERE clause terms on the left table of a LEFT OUTER JOIN to
contain aggregate subqueries.  Ticket #1697. (CVS 3117)

FossilOrigin-Name: a286e54e26f9a364127649eeea160d5fa8928faf

19 years agoChange the ROUND() function to return a REAL value instead of TEXT.
drh [Thu, 2 Mar 2006 03:02:48 +0000 (03:02 +0000)] 
Change the ROUND() function to return a REAL value instead of TEXT.
Ticket #1699. (CVS 3116)

FossilOrigin-Name: 9dbadfb2111f7d7f971e1832db3992ed5851d8b1

19 years agoReduce the size of a memory allocation in the windows driver to the
drh [Mon, 27 Feb 2006 23:44:35 +0000 (23:44 +0000)] 
Reduce the size of a memory allocation in the windows driver to the
minimum needed.  Ticket #1690. (CVS 3115)

FossilOrigin-Name: 1fe9ca078b77b79ac738a095d8d4c82ae0926286

19 years agoAdd a test to make sure parser stack overflow is detected and reported. (CVS 3114)
drh [Mon, 27 Feb 2006 23:19:20 +0000 (23:19 +0000)] 
Add a test to make sure parser stack overflow is detected and reported. (CVS 3114)

FossilOrigin-Name: 201ab3b5238c4afeb9a9f254f9ed3632b106066d

19 years agoThe parser now permits very large triggers - triggers with 10000 or more
drh [Mon, 27 Feb 2006 22:22:27 +0000 (22:22 +0000)] 
The parser now permits very large triggers - triggers with 10000 or more
statements. (CVS 3113)

FossilOrigin-Name: b4fa96d0e92182cd8792e88b4540b95912bb9f95

19 years agoDetect stack overflow in the parser and report an error. (CVS 3112)
drh [Mon, 27 Feb 2006 21:58:07 +0000 (21:58 +0000)] 
Detect stack overflow in the parser and report an error. (CVS 3112)

FossilOrigin-Name: bd2c38f4670d1243284f2431b5e0712a6d1de1d7

19 years agoAdditional compiler warnings suppressed. (CVS 3111)
drh [Fri, 24 Feb 2006 03:09:37 +0000 (03:09 +0000)] 
Additional compiler warnings suppressed. (CVS 3111)

FossilOrigin-Name: a359b1817e85a9c5f31085817ae70e3e0b8ac7a7

19 years agoRemove unused parameters on internal APIs. Suppress warnings from
drh [Fri, 24 Feb 2006 02:53:49 +0000 (02:53 +0000)] 
Remove unused parameters on internal APIs.  Suppress warnings from
CodeWarrior. (CVS 3110)

FossilOrigin-Name: 4b22e4b847f8d5c29830baea541194ef3a0c4811

19 years agoMake sure the random() function always returns a value that can be passed
drh [Thu, 23 Feb 2006 21:51:12 +0000 (21:51 +0000)] 
Make sure the random() function always returns a value that can be passed
to abs(). (CVS 3109)

FossilOrigin-Name: 5d2e7ea01989fc9ba2c79d192760bc29f8cab463

19 years agoDetect integer overflow in the abs() function. The random() function
drh [Thu, 23 Feb 2006 21:43:55 +0000 (21:43 +0000)] 
Detect integer overflow in the abs() function.  The random() function
now provides 64 bits of randomness instead of just 32.  Fix bugs in
testing logic of test4.c. (CVS 3108)

FossilOrigin-Name: 942c509595a2a300e798e6b048ad7fc3bc54af43

19 years agoNew compile-time option SQLITE_SECURE_DELETE takes care to overwrite deleted data...
drh [Wed, 22 Feb 2006 03:08:32 +0000 (03:08 +0000)] 
New compile-time option SQLITE_SECURE_DELETE takes care to overwrite deleted data with zeros. (CVS 3107)

FossilOrigin-Name: 614fac906807b8c75e04effc01666874d13ce636

19 years agoAlways generate code, even if it is a no-op, for CREATE and DROP statements
drh [Sat, 18 Feb 2006 16:36:45 +0000 (16:36 +0000)] 
Always generate code, even if it is a no-op, for CREATE and DROP statements
that use the IF EXISTS or IF NOT EXISTS clause. (CVS 3106)

FossilOrigin-Name: f8173e6aea8e90f64f5907f3f7ff4f34281f40da

19 years agoFix bug preventing compliation without MEMDEBUG when ENABLE_MEMORY_MANAGE is defined...
danielk1977 [Fri, 17 Feb 2006 15:01:36 +0000 (15:01 +0000)] 
Fix bug preventing compliation without MEMDEBUG when ENABLE_MEMORY_MANAGE is defined. (CVS 3105)

FossilOrigin-Name: 76912b33b1a15ee4baea9f7c8685933b4d551e91

19 years agoEnsure temp db is open before executing a pragma like "temp.cachesize = xxx". Fix...
danielk1977 [Fri, 17 Feb 2006 12:25:14 +0000 (12:25 +0000)] 
Ensure temp db is open before executing a pragma like "temp.cachesize = xxx". Fix for #1682. (CVS 3104)

FossilOrigin-Name: 1e4644b2369547da65fcaa9a3c8ddd206a3c82ae

19 years agoOr the SQLITE_UTF16_ALIGNED with the encoding field in
drh [Thu, 16 Feb 2006 18:16:36 +0000 (18:16 +0000)] 
Or the SQLITE_UTF16_ALIGNED with the encoding field in
sqlite3_create_collation and UTF16 strings will always be aligned
on an even byte boundary when passed into the comparison function. (CVS 3103)

FossilOrigin-Name: 7a1701e8c562087d364dff28cd7cad7ca4cdb5ae

19 years agoFix more typos in the file format document. (CVS 3102)
drh [Thu, 16 Feb 2006 00:32:37 +0000 (00:32 +0000)] 
Fix more typos in the file format document. (CVS 3102)

FossilOrigin-Name: d7495be8060fe9e8fa2d2f81e215833d7085888b

19 years agoFix a typo in the file format document. (CVS 3101)
drh [Thu, 16 Feb 2006 00:31:01 +0000 (00:31 +0000)] 
Fix a typo in the file format document. (CVS 3101)

FossilOrigin-Name: fac0d202e1d9fcc33dc69006a369034ee003e183

19 years agoGet the build working again. Fix for check-in (3093) (CVS 3100)
drh [Wed, 15 Feb 2006 21:19:01 +0000 (21:19 +0000)] 
Get the build working again.  Fix for check-in (3093) (CVS 3100)

FossilOrigin-Name: 4e6b74b290282fd10fae97df8dfa643a1b7ef0c6

19 years agoMention the NOT unary operator in the documentation. (CVS 3099)
drh [Wed, 15 Feb 2006 17:30:31 +0000 (17:30 +0000)] 
Mention the NOT unary operator in the documentation. (CVS 3099)

FossilOrigin-Name: 3eca2d98683eb1b3b99604b07337347ad45e42f6

19 years agoUpdate the configure script to use AC_HELP_STRING. (CVS 3098)
drh [Wed, 15 Feb 2006 02:00:25 +0000 (02:00 +0000)] 
Update the configure script to use AC_HELP_STRING. (CVS 3098)

FossilOrigin-Name: 92be79debf328b9b2aac6509ed1dd94528306d3b

19 years agotest_async.c: Writer-thread should not relinquish mutex when writing a file for which...
danielk1977 [Tue, 14 Feb 2006 14:46:41 +0000 (14:46 +0000)] 
test_async.c: Writer-thread should not relinquish mutex when writing a file for which only one file handle is open (fixes bug introduced in (3093)). (CVS 3097)

FossilOrigin-Name: f0c45b7eab219ee812dbd2eb5e1c39fdf52a0ff2

19 years agoAccount for a malloc failure in the asynchronous writer thread in test_async.c (CVS...
danielk1977 [Tue, 14 Feb 2006 14:02:08 +0000 (14:02 +0000)] 
Account for a malloc failure in the asynchronous writer thread in test_async.c (CVS 3096)

FossilOrigin-Name: 2f2a8a69cb380dc30b85a792c369020fec3c79a5

19 years agoFix bug in test_async.c version of OsFileSize(). (CVS 3095)
danielk1977 [Tue, 14 Feb 2006 13:48:33 +0000 (13:48 +0000)] 
Fix bug in test_async.c version of OsFileSize(). (CVS 3095)

FossilOrigin-Name: 239e53b4f29b4faf2dbdc2aebd2332ad25b14286

19 years agoAdd simple io error tests for test_async.c. (CVS 3094)
danielk1977 [Tue, 14 Feb 2006 13:25:43 +0000 (13:25 +0000)] 
Add simple io error tests for test_async.c. (CVS 3094)

FossilOrigin-Name: 528dfb71801bb7b8a66944db6f32cc3dc0054118

19 years agoChanges so that test_async.c works with memory management turned on. (CVS 3093)
danielk1977 [Tue, 14 Feb 2006 10:48:39 +0000 (10:48 +0000)] 
Changes so that test_async.c works with memory management turned on. (CVS 3093)

FossilOrigin-Name: f4150c29df2774b4422d4296d913cdbcee62c859

19 years agoDisable the /./ and /../ collapser logic in sqlite3OsFullPathname under Unix. (CVS...
drh [Mon, 13 Feb 2006 18:42:21 +0000 (18:42 +0000)] 
Disable the /./ and /../ collapser logic in sqlite3OsFullPathname under Unix. (CVS 3092)

FossilOrigin-Name: 111a426b3e2fae77c9e6c3cd903fd80652b23720