]> git.ipfire.org Git - thirdparty/sqlite.git/log
thirdparty/sqlite.git
19 years agoMake genericAllocationSize work on NULL pointers. (CVS 2842)
drh [Thu, 22 Dec 2005 13:47:49 +0000 (13:47 +0000)] 
Make genericAllocationSize work on NULL pointers. (CVS 2842)

FossilOrigin-Name: 326fc9cc11c86f2d96763537d60757200ce21a84

19 years agoBug fixes and additional testing of descending indices. (CVS 2841)
drh [Wed, 21 Dec 2005 18:36:45 +0000 (18:36 +0000)] 
Bug fixes and additional testing of descending indices. (CVS 2841)

FossilOrigin-Name: 5638a11ed5618dd833d3daffc1715951091d72b2

19 years agoBasic functionality for descending indices is in place. Lots more testing
drh [Wed, 21 Dec 2005 14:43:11 +0000 (14:43 +0000)] 
Basic functionality for descending indices is in place.  Lots more testing
needed. (CVS 2840)

FossilOrigin-Name: 7064433e5b06a4f858f39ce57650fba99fd72ffd

19 years agoProgress toward decending indices. (CVS 2839)
drh [Wed, 21 Dec 2005 03:16:42 +0000 (03:16 +0000)] 
Progress toward decending indices. (CVS 2839)

FossilOrigin-Name: 112a34b8dcceb39540cb0cd629e264a867400bfb

19 years agoInclude sqlite3_release_memory() code when SQLITE_MEMDEBUG is not defined. (CVS 2838)
danielk1977 [Tue, 20 Dec 2005 14:37:59 +0000 (14:37 +0000)] 
Include sqlite3_release_memory() code when SQLITE_MEMDEBUG is not defined. (CVS 2838)

FossilOrigin-Name: 77a37ceca7792e6cda6810e3387e6dda14a5c7ec

19 years agoAdd simple tests and fixes for sqlite3_soft_heap_limit() (CVS 2837)
danielk1977 [Tue, 20 Dec 2005 09:19:37 +0000 (09:19 +0000)] 
Add simple tests and fixes for sqlite3_soft_heap_limit() (CVS 2837)

FossilOrigin-Name: c2c5285442f4558dfca61b52f31b5a9cbefaed10

19 years agoWebsite changes in preparation for the release of 2.8.17. (CVS 2834)
drh [Mon, 19 Dec 2005 17:53:35 +0000 (17:53 +0000)] 
Website changes in preparation for the release of 2.8.17. (CVS 2834)

FossilOrigin-Name: a927696ba30da39cb94ba666a10b7311d46826c9

19 years agoWebsite changes for the release of 3.2.8. (CVS 2831)
drh [Mon, 19 Dec 2005 17:26:46 +0000 (17:26 +0000)] 
Website changes for the release of 3.2.8. (CVS 2831)

FossilOrigin-Name: 2f7ec117ded31f2c13f2e3ab9dd4e9a483434601

19 years agoTentative fix for ticket #1567: disable the sqlite3pager_dont_write()
drh [Mon, 19 Dec 2005 16:15:31 +0000 (16:15 +0000)] 
Tentative fix for ticket #1567:  disable the sqlite3pager_dont_write()
optimization when a statement transaction is active.  We continue to look
for a better fix. (CVS 2827)

FossilOrigin-Name: e6106cc133e5210bfa248d811122e9bf7d6f2b7c

19 years agoAdd some very simple test cases (and resulting bug fixes) for release_memory(). ...
danielk1977 [Mon, 19 Dec 2005 14:18:11 +0000 (14:18 +0000)] 
Add some very simple test cases (and resulting bug fixes) for release_memory(). (CVS 2826)

FossilOrigin-Name: 154282fca54bf03d310d6931660f99805bb5477f

19 years agoAdd the (untested) sqlite3_release_memory() function. (CVS 2825)
danielk1977 [Sun, 18 Dec 2005 08:51:22 +0000 (08:51 +0000)] 
Add the (untested) sqlite3_release_memory() function. (CVS 2825)

FossilOrigin-Name: 345addaa03d3bfa3429a59597fbd3addcff62e30

19 years agoVerify that the rollback-hook is invoked correctly when a malloc() failure occurs...
danielk1977 [Fri, 16 Dec 2005 15:24:28 +0000 (15:24 +0000)] 
Verify that the rollback-hook is invoked correctly when a malloc() failure occurs. (CVS 2824)

FossilOrigin-Name: 83c8ae5bee3b6bdb556d2e85fa260ba855742601

19 years agoAdd the sqlite3_rollback_hook() API. Still requires further testing. (CVS 2823)
danielk1977 [Fri, 16 Dec 2005 06:54:01 +0000 (06:54 +0000)] 
Add the sqlite3_rollback_hook() API. Still requires further testing. (CVS 2823)

FossilOrigin-Name: 3baa3ff32435b64e7ae7646b17a98fef9296aaa0

19 years agoInitial infrastructure for recognizing DESC indices and being able to read
drh [Fri, 16 Dec 2005 01:06:16 +0000 (01:06 +0000)] 
Initial infrastructure for recognizing DESC indices and being able to read
and write older databases that specify DESC indices but do not really use
them.  Nothing is close to working yet. (CVS 2822)

FossilOrigin-Name: cd110aa225b09591064405dd8952b3df37278c52

19 years agoFix the utf8 to utf16 conversion routine for short strings. Bug
drh [Thu, 15 Dec 2005 22:34:00 +0000 (22:34 +0000)] 
Fix the utf8 to utf16 conversion routine for short strings.  Bug
introduced by check-in (2817). (CVS 2821)

FossilOrigin-Name: 4fba2db38e0693be52ca7251e4958bd836607f05

19 years agoAdd the sqlite3_update_hook() API. (CVS 2820)
danielk1977 [Thu, 15 Dec 2005 15:22:08 +0000 (15:22 +0000)] 
Add the sqlite3_update_hook() API. (CVS 2820)

FossilOrigin-Name: 36229018817eebfbfca7a66d2285e4faf7b39845

19 years agoMove malloc(), free(), realloc() and allocationSize() into the Os vtbl. (CVS 2819)
danielk1977 [Thu, 15 Dec 2005 10:50:53 +0000 (10:50 +0000)] 
Move malloc(), free(), realloc() and allocationSize() into the Os vtbl. (CVS 2819)

FossilOrigin-Name: 81a41f66370ea7f6810dfb323ba5cea60f240edd

19 years agoAdd the sqlite3_os_routine_set()/get() functions. (CVS 2818)
danielk1977 [Thu, 15 Dec 2005 10:11:30 +0000 (10:11 +0000)] 
Add the sqlite3_os_routine_set()/get() functions. (CVS 2818)

FossilOrigin-Name: c1ed79f594fb85009c2e9e5e281cbe66a9d2fa17

19 years agoFix memory allocation problems on the utf-16 versions of collating function
drh [Thu, 15 Dec 2005 03:04:10 +0000 (03:04 +0000)] 
Fix memory allocation problems on the utf-16 versions of collating function
control routines. (CVS 2817)

FossilOrigin-Name: ad292e27336b8c5afc0acdf111944a456bd23c32

19 years agoAvoid using the transient value in the UTF-16 collation needed callback. (CVS 2816)
drh [Wed, 14 Dec 2005 22:51:16 +0000 (22:51 +0000)] 
Avoid using the transient value in the UTF-16 collation needed callback. (CVS 2816)

FossilOrigin-Name: ab6241af29b2e9f5f094b83c13afebe44a8ad6bc

19 years agoProperly zero-terminate UTF-16 collation names on an
drh [Wed, 14 Dec 2005 20:11:30 +0000 (20:11 +0000)] 
Properly zero-terminate UTF-16 collation names on an
sqlite3_collation_needed16 callback. (CVS 2815)

FossilOrigin-Name: 71a49d05bf174025c0d9141b8905c48f43e42541

19 years agoFix minor malloc() related problems and add sqlite3_soft_heap_limit() stubs. (CVS...
danielk1977 [Mon, 12 Dec 2005 06:53:03 +0000 (06:53 +0000)] 
Fix minor malloc() related problems and add sqlite3_soft_heap_limit() stubs. (CVS 2814)

FossilOrigin-Name: 1637f3796015d1582ed8c6bc8bdf8c067b4bade9

19 years agoAdd the "exists" method to the TCL interface. (CVS 2813)
drh [Sat, 10 Dec 2005 21:19:04 +0000 (21:19 +0000)] 
Add the "exists" method to the TCL interface. (CVS 2813)

FossilOrigin-Name: 8a355d7aade5c7a95ab08aeedf1ee1857c121c33

19 years agoNew bind tests (check-ins (2797) and (2798)) only work right on a UTF8
drh [Fri, 9 Dec 2005 20:54:34 +0000 (20:54 +0000)] 
New bind tests (check-ins (2797) and (2798)) only work right on a UTF8
database.  So make sure they are only run when the database is UTF8. (CVS 2812)

FossilOrigin-Name: 398037906956f0274ca35cbff6961f6df5149295

19 years agoMore annoying and pointless signedness warnings fixed. (CVS 2811)
drh [Fri, 9 Dec 2005 20:21:58 +0000 (20:21 +0000)] 
More annoying and pointless signedness warnings fixed. (CVS 2811)

FossilOrigin-Name: 590578bef88d0aa545f8138e8eec0db03c093861

19 years agoClean up annoying (and pointless) compiler warnings about differing signedness. ...
drh [Fri, 9 Dec 2005 20:02:05 +0000 (20:02 +0000)] 
Clean up annoying (and pointless) compiler warnings about differing signedness. (CVS 2810)

FossilOrigin-Name: 83a59151559d9496d4f546e03e65087ea974717d

19 years agoDefine the sqliteMalloc() macro differently to avoid a compiler warning. (CVS 2809)
danielk1977 [Fri, 9 Dec 2005 14:39:04 +0000 (14:39 +0000)] 
Define the sqliteMalloc() macro differently to avoid a compiler warning. (CVS 2809)

FossilOrigin-Name: 3d177bde71811391f79f4ab3bae054ef1bceb6a0

19 years agoMany small changes to ensure memory is not leaked after malloc() fails. (CVS 2808)
danielk1977 [Fri, 9 Dec 2005 14:25:08 +0000 (14:25 +0000)] 
Many small changes to ensure memory is not leaked after malloc() fails. (CVS 2808)

FossilOrigin-Name: 601c335463aaabc2e9918e4b9298cff6161be5c4

19 years agoAdd more stress testing to autovacuum in an (unsuccessful) attempt to
drh [Fri, 9 Dec 2005 02:35:53 +0000 (02:35 +0000)] 
Add more stress testing to autovacuum in an (unsuccessful) attempt to
reproduce a reported problem.  Even though these tests did not uncover
anything amiss, extra tests never hurt... (CVS 2807)

FossilOrigin-Name: d8a8933ff30b83c0483be214403d92c4dfa9a4af

19 years agoProvide a pragma to set the codec key. (CVS 2806)
drh [Thu, 8 Dec 2005 18:12:56 +0000 (18:12 +0000)] 
Provide a pragma to set the codec key. (CVS 2806)

FossilOrigin-Name: a7c9e8989c752f6b1148e7cc7bf59bbd8b402e87

19 years agoAdd some tests for malloc() failure within the column_name() and column_decl() APIs...
danielk1977 [Wed, 7 Dec 2005 06:27:43 +0000 (06:27 +0000)] 
Add some tests for malloc() failure within the column_name() and column_decl() APIs. (CVS 2805)

FossilOrigin-Name: 78f10ca0a6a02e9e8e6811489841a19e213f3afb

19 years agoAllow VACUUM to detach the auxillary database after malloc() fails. (CVS 2804)
danielk1977 [Tue, 6 Dec 2005 17:48:31 +0000 (17:48 +0000)] 
Allow VACUUM to detach the auxillary database after malloc() fails. (CVS 2804)

FossilOrigin-Name: 6824a78bc7b8582fc5c3a6ab05dd3ed996fc99b3

19 years agoModify ATTACH and DETACH to execute at runtime instead of compile time. (CVS 2803)
danielk1977 [Tue, 6 Dec 2005 17:19:11 +0000 (17:19 +0000)] 
Modify ATTACH and DETACH to execute at runtime instead of compile time. (CVS 2803)

FossilOrigin-Name: 5e04ec694add7a8331e3d6fbdfcaed51349ae7bc

19 years agoReport errors out of sqlite3_open16(). (CVS 2802)
drh [Tue, 6 Dec 2005 13:19:07 +0000 (13:19 +0000)] 
Report errors out of sqlite3_open16(). (CVS 2802)

FossilOrigin-Name: f5b58163d4520fa3e7137e8445a8ef19aae3e799

19 years agoAdd test file for new malloc() failure handling. (CVS 2801)
danielk1977 [Tue, 6 Dec 2005 12:57:58 +0000 (12:57 +0000)] 
Add test file for new malloc() failure handling. (CVS 2801)

FossilOrigin-Name: 0b82f9623cf25b1cb02f70628c992903a6e8ca1c

19 years agoSome elements of the new malloc() failure handling. Not all cases work properly yet...
danielk1977 [Tue, 6 Dec 2005 12:52:59 +0000 (12:52 +0000)] 
Some elements of the new malloc() failure handling. Not all cases work properly yet. Also, library is not threadsafe if malloc() fails right now. (CVS 2800)

FossilOrigin-Name: e1606658f1b4530e3001db4779b5669c8d13c853

19 years agoUpdate mailing list hyperlink on the support page. (CVS 2799)
drh [Mon, 5 Dec 2005 22:22:40 +0000 (22:22 +0000)] 
Update mailing list hyperlink on the support page. (CVS 2799)

FossilOrigin-Name: 41a7aeeeb427d59e3d7cc71c94a8c5be832bd0fa

19 years agoMake sure sqlite3_result_text can handle text strings with embedded '\000'
drh [Mon, 5 Dec 2005 13:20:01 +0000 (13:20 +0000)] 
Make sure sqlite3_result_text can handle text strings with embedded '\000'
characters. (CVS 2798)

FossilOrigin-Name: 9d6057cd141e7cdaf32ce68dea39e67c2c67a08d

19 years agoAdd a test to verify that binding text with embedded '\000' works. Also
drh [Fri, 2 Dec 2005 02:44:05 +0000 (02:44 +0000)] 
Add a test to verify that binding text with embedded '\000' works.  Also
comment changes in os.h. (CVS 2797)

FossilOrigin-Name: 31251a9098662ccf08af5bd5bc3afb282a149701

19 years agoDocumentation updates. (CVS 2796)
drh [Fri, 2 Dec 2005 01:57:42 +0000 (01:57 +0000)] 
Documentation updates. (CVS 2796)

FossilOrigin-Name: 2ffb90c39d0b60de9a692326ca3f2595c1fc97d0

19 years agoRestructure the OS interface yet again. This time make the OsFile object
drh [Wed, 30 Nov 2005 03:20:31 +0000 (03:20 +0000)] 
Restructure the OS interface yet again.  This time make the OsFile object
a virtual base class which is subclassed for unix, windows, and the crash
test simulator.  Add the new file "os.c" for common os layer code.  Move
all OS-specific routines into the sqlite3Os structure. (CVS 2795)

FossilOrigin-Name: bd8740d1aecba69e1b5d64d43db07e8ad8841f07

19 years agoThe crash test works now, at least on unix. Untested on windows. But it never
drh [Tue, 29 Nov 2005 19:56:32 +0000 (19:56 +0000)] 
The crash test works now, at least on unix.  Untested on windows. But it never
worked on windows before so if it still does not there is no big loss.  I am
still troubled by the current design of the OS overloading mechanism.  Expect
to see more changes. (CVS 2794)

FossilOrigin-Name: fa1d7ecfcc648fbe9fc6d92e080cf937bdc9c439

19 years agoMake the build work on windows again. Ticket #1544. (CVS 2793)
drh [Tue, 29 Nov 2005 19:50:24 +0000 (19:50 +0000)] 
Make the build work on windows again.  Ticket #1544. (CVS 2793)

FossilOrigin-Name: 59bdca2552b2e5c09d5ca2b7a02ee34460139d7b

19 years agoThe crash tests now compile, at least. But they get wrong results. The
drh [Tue, 29 Nov 2005 18:37:15 +0000 (18:37 +0000)] 
The crash tests now compile, at least.  But they get wrong results.  The
problem is fundamental and suggests I need to completely rethink how the
new OS backend should work. (CVS 2792)

FossilOrigin-Name: 966bc68e1bf4e0cc88407871c162ee3014160415

19 years agoMake the OsFile structure opaque with its internal structure known only to
drh [Tue, 29 Nov 2005 03:13:21 +0000 (03:13 +0000)] 
Make the OsFile structure opaque with its internal structure known only to
the appropriate os_*.c implementation.  Omit the os_unix.h and os_win.h
include files.  The crash tests are broken by this patch. (CVS 2791)

FossilOrigin-Name: 058f31753871b16b40fe4048e3adcee411e0f87d

19 years agoReplace a call to sprintf() with sqlite3MPrintf() since on some embedded
drh [Mon, 28 Nov 2005 12:36:35 +0000 (12:36 +0000)] 
Replace a call to sprintf() with sqlite3MPrintf() since on some embedded
platforms, sprintf() is busted.  Need to go through and do similar replacements
elsewhere in the code. (CVS 2790)

FossilOrigin-Name: 1b4f2d89bbe833359cefcea580783fd92aa7b8ab

19 years agoDisable the OR-clause optimization if it does not result in an index being
drh [Sat, 26 Nov 2005 14:24:40 +0000 (14:24 +0000)] 
Disable the OR-clause optimization if it does not result in an index being
used that would not have been used otherwise.  In other words, do not
convert OR clauses into an IN statement if it does not help the optimizer. (CVS 2789)

FossilOrigin-Name: 7e7cfce0f8ed2a6e04747736a2c68484f447cdfb

19 years agoMake sure left joins still work even when the OR clause optimization fires.
drh [Sat, 26 Nov 2005 14:08:07 +0000 (14:08 +0000)] 
Make sure left joins still work even when the OR clause optimization fires.
Ticket #1537. (CVS 2788)

FossilOrigin-Name: cbbeb9de0019a0b81318158711590078fcb7e98a

19 years agoRemove some vestiges of the old OS_TEST driver. (CVS 2787)
drh [Sat, 26 Nov 2005 03:51:18 +0000 (03:51 +0000)] 
Remove some vestiges of the old OS_TEST driver. (CVS 2787)

FossilOrigin-Name: 008f676f20c690255e5cb8ae01df47c5094ac240

19 years agoAdd an OS method for making copies of file descriptors. This fixes the
drh [Sat, 26 Nov 2005 03:43:23 +0000 (03:43 +0000)] 
Add an OS method for making copies of file descriptors.  This fixes the
crash tests. (CVS 2786)

FossilOrigin-Name: 57a674fc71512f11393b8eb595961ec9465ba4e1

19 years agoModify the OS layer so that I/O routines are called through a virtual function
drh [Sat, 26 Nov 2005 00:25:00 +0000 (00:25 +0000)] 
Modify the OS layer so that I/O routines are called through a virtual function
table.  The os_test.c module has been replaced by test6.c.  The crash tests
are busted now and need to be fixed. (CVS 2785)

FossilOrigin-Name: 1f69aec285dd8e26bd739d5e44bb50fe03a9682a

19 years agoEnsure a low system limit on the number of open files does not cause manydb.test...
danielk1977 [Fri, 25 Nov 2005 10:55:57 +0000 (10:55 +0000)] 
Ensure a low system limit on the number of open files does not cause manydb.test to fail. (CVS 2784)

FossilOrigin-Name: dba2cc0d0e0c648c1a4798bc72913e3b19acba6e

19 years agoAdd the compilation option SQLITE_DISABLE_DIRSYNC (CVS 2783)
danielk1977 [Fri, 25 Nov 2005 10:38:22 +0000 (10:38 +0000)] 
Add the compilation option SQLITE_DISABLE_DIRSYNC (CVS 2783)

FossilOrigin-Name: f9f5ecbb79f03ba8e7d6a036a562252319e82abc

19 years agoAdd the compilation option SQLITE_DISABLE_DIRSYNC (CVS 2782)
danielk1977 [Fri, 25 Nov 2005 10:38:22 +0000 (10:38 +0000)] 
Add the compilation option SQLITE_DISABLE_DIRSYNC (CVS 2782)

FossilOrigin-Name: f1298bb103aad46c737741d89d33c4c2904aec68

19 years agoIf SQLITE_DISABLE_LFS is defined, omit the bigfile tests. (CVS 2781)
danielk1977 [Fri, 25 Nov 2005 09:01:23 +0000 (09:01 +0000)] 
If SQLITE_DISABLE_LFS is defined, omit the bigfile tests. (CVS 2781)

FossilOrigin-Name: f882a516da18f45dbb668078d0d8240d930e1180

19 years agoCheck the return code of full_fsync() when used to sync a directory fd. (CVS 2780)
danielk1977 [Fri, 25 Nov 2005 08:47:57 +0000 (08:47 +0000)] 
Check the return code of full_fsync() when used to sync a directory fd. (CVS 2780)

FossilOrigin-Name: 84aae3b0ae7381710ff0bc9881cbde3559bb580b

19 years agoPreserve 64-bit last insert rowids across triggers. (CVS 2779)
drh [Fri, 25 Nov 2005 02:43:50 +0000 (02:43 +0000)] 
Preserve 64-bit last insert rowids across triggers. (CVS 2779)

FossilOrigin-Name: 4dd7cfaa587fd5f76a0b60db0f02d5f57f801564

19 years agoThe --enable-cross-thread-connect configuration option or the
drh [Thu, 24 Nov 2005 23:14:00 +0000 (23:14 +0000)] 
The --enable-cross-thread-connect configuration option or the
-DSQLITE_ALLOW_XTHREAD_CONNECT compile-time option permits database
connections to be moved across threads.  This will cause latch-ups
and failures on some linux systems such as RedHat-9.  Do not use these
options if you want a portable build. (CVS 2778)

FossilOrigin-Name: 84aa4d58001ed943295f21f429c58c3c99b771d8

19 years agoMake sure sqliteInt.h is included before any system includes.
drh [Thu, 24 Nov 2005 22:33:05 +0000 (22:33 +0000)] 
Make sure sqliteInt.h is included before any system includes.
This is required for QNX.  Ticket #1478. (CVS 2777)

FossilOrigin-Name: ab76453553bea7c2371b35e7643a98967bb04582

19 years agoReduce the number of distinct token symbols in the parser so that the parser
drh [Thu, 24 Nov 2005 22:22:29 +0000 (22:22 +0000)] 
Reduce the number of distinct token symbols in the parser so that the parser
can store tokens in a single byte and thus be smaller in size. (CVS 2776)

FossilOrigin-Name: 2dfc9863919c9eb1fd1064ab2817d752dd7f9293

19 years agoComment changes. No changes to code. (CVS 2775)
drh [Thu, 24 Nov 2005 14:34:36 +0000 (14:34 +0000)] 
Comment changes.  No changes to code. (CVS 2775)

FossilOrigin-Name: 786e23b2959c6103bfc0b45535afc49f22bc8a67

19 years agoFix a comment in btree.c. No code changes. (CVS 2774)
drh [Thu, 24 Nov 2005 14:24:28 +0000 (14:24 +0000)] 
Fix a comment in btree.c.  No code changes. (CVS 2774)

FossilOrigin-Name: 0d8bd133a7530fb56ecb742472865f5a72a0ea5e

19 years agoFix incorrect type conversions when copying from a table into itself.
drh [Thu, 24 Nov 2005 13:15:32 +0000 (13:15 +0000)] 
Fix incorrect type conversions when copying from a table into itself.
Ticket #1536. (CVS 2773)

FossilOrigin-Name: a2e55a3828d74d78b0b76f956a537a0d906f3191

19 years agoLess verbose output when EXPLAIN QUERY PLAN identifies use of the primary key. (CVS...
drh [Mon, 21 Nov 2005 12:48:24 +0000 (12:48 +0000)] 
Less verbose output when EXPLAIN QUERY PLAN identifies use of the primary key. (CVS 2772)

FossilOrigin-Name: 5045f09933f57e4ae897969710b19d09b7af6022

19 years agoThe EXPLAIN QUERY PLAN now identifies when tables use the integer primary key. (CVS...
drh [Mon, 21 Nov 2005 12:46:27 +0000 (12:46 +0000)] 
The EXPLAIN QUERY PLAN now identifies when tables use the integer primary key. (CVS 2771)

FossilOrigin-Name: 80721e2c9033abb2e9eed32892c4e486c293e1fa

19 years agoFix a problem with the sorting of literals in a compound query. Ticket #1501. (CVS...
drh [Wed, 16 Nov 2005 13:47:50 +0000 (13:47 +0000)] 
Fix a problem with the sorting of literals in a compound query. Ticket #1501. (CVS 2770)

FossilOrigin-Name: b3882b434a1ef7d8d636c7c5917b9e8f0d2952fb

19 years agoDo not allow aggregate functions in a WHERE clause. Ticket #1514. (CVS 2769)
drh [Wed, 16 Nov 2005 12:53:15 +0000 (12:53 +0000)] 
Do not allow aggregate functions in a WHERE clause.  Ticket #1514. (CVS 2769)

FossilOrigin-Name: bb866ed880c33ec9ce6ded8ebdbb459fedf9c257

19 years agoAvoid unnecessary strlen() calls in the OP_String opcode. (CVS 2768)
drh [Wed, 16 Nov 2005 04:34:32 +0000 (04:34 +0000)] 
Avoid unnecessary strlen() calls in the OP_String opcode. (CVS 2768)

FossilOrigin-Name: 2e195e96bcbad104da09ebe6cef617e0e9ef1884

19 years agoFix a bug in UTF-16 handling introduced by the previous check-in. (CVS 2767)
drh [Tue, 15 Nov 2005 02:14:00 +0000 (02:14 +0000)] 
Fix a bug in UTF-16 handling introduced by the previous check-in. (CVS 2767)

FossilOrigin-Name: 25fa16a2e1f324790f4b293df5d7142575034428

19 years agoCreate separate affinities for INTEGER and REAL. (CVS 2766)
drh [Mon, 14 Nov 2005 22:29:05 +0000 (22:29 +0000)] 
Create separate affinities for INTEGER and REAL. (CVS 2766)

FossilOrigin-Name: ce06c123d0c5663dbaf263c2e0aaf5d9cdeb2ccd

19 years agoFix documentation typo. (CVS 2765)
drh [Mon, 14 Nov 2005 11:51:45 +0000 (11:51 +0000)] 
Fix documentation typo. (CVS 2765)

FossilOrigin-Name: c9b413ea22d1da926621670b903c7a683921eef0

19 years agoAbout 0.5KiB of additional compression in the parser tables. (CVS 2764)
drh [Sun, 6 Nov 2005 04:06:59 +0000 (04:06 +0000)] 
About 0.5KiB of additional compression in the parser tables. (CVS 2764)

FossilOrigin-Name: f39974ebd81f274dc4cf6cf94e6e87ee7b4a0814

19 years agoWork around a bug in MSVC++. Ticket #1513. (CVS 2763)
drh [Sat, 5 Nov 2005 15:11:22 +0000 (15:11 +0000)] 
Work around a bug in MSVC++.  Ticket #1513. (CVS 2763)

FossilOrigin-Name: 6331860e7754be6e0d2a484d66427947c0781dd6

19 years agoRemove a C++-ism that slipped into the code during the recent CHECK
drh [Sat, 5 Nov 2005 15:07:55 +0000 (15:07 +0000)] 
Remove a C++-ism that slipped into the code during the recent CHECK
enhancements.  Ticket #1513. (CVS 2762)

FossilOrigin-Name: e66289b52f56c8242aa264a9365c834cd820e988

19 years agoImproved table compression in lemon reduces the overall library size
drh [Sat, 5 Nov 2005 15:03:59 +0000 (15:03 +0000)] 
Improved table compression in lemon reduces the overall library size
by about 1.5KiB. (CVS 2761)

FossilOrigin-Name: 86ac11476962727d2d40b62ce87d689c01969537

19 years agoVACUUM works even on an empty database. Ticket #1512. (CVS 2760)
drh [Fri, 4 Nov 2005 22:03:30 +0000 (22:03 +0000)] 
VACUUM works even on an empty database.  Ticket #1512. (CVS 2760)

FossilOrigin-Name: 1b6bf4188e8ebf55cf1972b7081f6d31bf525555

19 years agosqlite3_column_int() and similar routines return 0 or 0.0 on an
drh [Thu, 3 Nov 2005 14:29:55 +0000 (14:29 +0000)] 
sqlite3_column_int() and similar routines return 0 or 0.0 on an
out-of-memory condition, not some mysterious error code. (CVS 2759)

FossilOrigin-Name: 7780f5e9d504926f11bd0662c03c88c76fb1d416

19 years agoProhibit parameters in CHECK constraint expressions. (CVS 2758)
drh [Thu, 3 Nov 2005 12:33:28 +0000 (12:33 +0000)] 
Prohibit parameters in CHECK constraint expressions. (CVS 2758)

FossilOrigin-Name: bb94ef64b227839a0ef4156985e2f5a061a78e2c

19 years agoAdd the ignore_check_constraints pragma. VACUUM works even on a database
drh [Thu, 3 Nov 2005 02:15:02 +0000 (02:15 +0000)] 
Add the ignore_check_constraints pragma.  VACUUM works even on a database
that contains table entries that violate check constraints. (CVS 2757)

FossilOrigin-Name: be83bfee0211396a0038ffb125897199bea9a73f

19 years agoDisallow subqueries in CHECK constraints. (CVS 2756)
drh [Thu, 3 Nov 2005 02:03:13 +0000 (02:03 +0000)] 
Disallow subqueries in CHECK constraints. (CVS 2756)

FossilOrigin-Name: db27afc4cdc5b51c1fa0e83dbd6d4a4a69c5b642

19 years agoCHECK constraints that evaluate to NULL pass. (CVS 2755)
drh [Thu, 3 Nov 2005 01:22:30 +0000 (01:22 +0000)] 
CHECK constraints that evaluate to NULL pass. (CVS 2755)

FossilOrigin-Name: 55b314a22c69fbe129b024e953f3230b67eaaa87

19 years agoFirst cut at supporting CHECK constraints. Everything appears to work,
drh [Thu, 3 Nov 2005 00:41:17 +0000 (00:41 +0000)] 
First cut at supporting CHECK constraints.  Everything appears to work,
but much more testing is needed as well as documentation. (CVS 2754)

FossilOrigin-Name: 2313d912baeca0fd516d524f16708953de483729

19 years agoOmit the SQLITE_AFF_INTEGER type affinity. All numeric values are now
drh [Tue, 1 Nov 2005 15:48:24 +0000 (15:48 +0000)] 
Omit the SQLITE_AFF_INTEGER type affinity.  All numeric values are now
of type real, though an integer representation is still sometimes used
internally for efficiency. (CVS 2753)

FossilOrigin-Name: e0d6f61c7de2c03b8fd17ef37cf1a0add36ee618

19 years agoFix the shift operators so that they work with 64-bit quantities. (CVS 2752)
drh [Sat, 29 Oct 2005 15:48:30 +0000 (15:48 +0000)] 
Fix the shift operators so that they work with 64-bit quantities. (CVS 2752)

FossilOrigin-Name: 0d3357b5f65887f7db03db2ae021f28f480f90e4

19 years agoReport an error if the input SQL contains an unterminated string.
drh [Sun, 23 Oct 2005 11:29:40 +0000 (11:29 +0000)] 
Report an error if the input SQL contains an unterminated string.
Ticket #1497. (CVS 2751)

FossilOrigin-Name: c9c476dd836c49255eabc6cce83064974c079ce3

19 years agoChanges to prevent various compiler warnings. (CVS 2750)
drh [Thu, 20 Oct 2005 07:28:17 +0000 (07:28 +0000)] 
Changes to prevent various compiler warnings. (CVS 2750)

FossilOrigin-Name: e261b8b09a529a3e67dc27c3b83b660bcb32e195

19 years agoAttempt to fix the SQLite core so that no floating point operations are used
drh [Thu, 13 Oct 2005 02:09:49 +0000 (02:09 +0000)] 
Attempt to fix the SQLite core so that no floating point operations are used
anywhere if SQLITE_OMIT_FLOATING_POINT is defined at compile-time.  This
is useful to people who use SQLite on embedded processors that lack
floating point support. (CVS 2749)

FossilOrigin-Name: a0bdb584680ce6400d9e8c57db9d91197cc7b776

19 years agoMake the default TEMP_STORE=1 (TEMP tables stored on disk) in the configure
drh [Mon, 10 Oct 2005 00:05:50 +0000 (00:05 +0000)] 
Make the default TEMP_STORE=1 (TEMP tables stored on disk) in the configure
script. (CVS 2748)

FossilOrigin-Name: 9753af53494a14f7300f92f3d94e4ceb55619529

19 years agoMore efficient handling of the LIMIT clause. Scalar subqueries and EXISTS
drh [Thu, 6 Oct 2005 16:53:14 +0000 (16:53 +0000)] 
More efficient handling of the LIMIT clause.  Scalar subqueries and EXISTS
on compound SELECT statements now working properly.  Ticket #1473. (CVS 2747)

FossilOrigin-Name: edca8913ca012fc0c17343a27f819de95147b1bd

19 years agoCheck-in (2744) as incomplete and broke pragma integrity_check. This
drh [Thu, 6 Oct 2005 13:59:26 +0000 (13:59 +0000)] 
Check-in (2744) as incomplete and broke pragma integrity_check.  This
completes the change and fixes the problem. (CVS 2746)

FossilOrigin-Name: 4862eaafd875eb1069076864c7cad600a76620c7

19 years agoMake the SQLite logo on the website a hyperlink to the home page.
drh [Wed, 5 Oct 2005 22:31:49 +0000 (22:31 +0000)] 
Make the SQLite logo on the website a hyperlink to the home page.
Ticket #1471. (CVS 2745)

FossilOrigin-Name: 9709f0f6bcb2a1ed07e678b73cb518488b8ff333

19 years agoMake sure pragma integrity_check does not report "ok" after first finding
drh [Wed, 5 Oct 2005 11:41:48 +0000 (11:41 +0000)] 
Make sure pragma integrity_check does not report "ok" after first finding
a bunch of errors. (CVS 2744)

FossilOrigin-Name: efec04dedfff8b92527b42e59cc32b4f69031021

19 years agoFix an assert or memory leak that occurs when trying to EXPLAIN a statement
drh [Wed, 5 Oct 2005 11:35:09 +0000 (11:35 +0000)] 
Fix an assert or memory leak that occurs when trying to EXPLAIN a statement
other than a SELECT that outputs results.  Examples of such statements
include PRAGMA integrity_check or INSERT/DELETE/UPDATE with PRAGMA
count_changes=ON. (CVS 2743)

FossilOrigin-Name: 533a85eee2370aafe204ff3eed50eb7fc0149e83

19 years agoChanges to support TEA on cygwin. (CVS 2742)
drh [Wed, 5 Oct 2005 10:40:15 +0000 (10:40 +0000)] 
Changes to support TEA on cygwin. (CVS 2742)

FossilOrigin-Name: e80fecc986f1fe93e127398b081054766c5383cf

19 years agoAnother attempt to get fdatasync to be ignored on non-conforming posix systems.
drh [Wed, 5 Oct 2005 10:29:36 +0000 (10:29 +0000)] 
Another attempt to get fdatasync to be ignored on non-conforming posix systems.
Now a system has to opt-in for fdatasync instead of opt-out.
Ticket #1467. (CVS 2741)

FossilOrigin-Name: 115340d4e85f1bbbab657edbb504284343d86e2c

19 years agoAdd the SQLITE_OMIT_GET_TABLE compile-time flag. (CVS 2740)
drh [Wed, 5 Oct 2005 02:13:40 +0000 (02:13 +0000)] 
Add the SQLITE_OMIT_GET_TABLE compile-time flag. (CVS 2740)

FossilOrigin-Name: 6d4bc8f83b228b3804fffcb17ac57e1f754fa9cd

19 years agoAutomatically check for the fdatasync() function and replace it with fsync()
drh [Tue, 4 Oct 2005 18:38:49 +0000 (18:38 +0000)] 
Automatically check for the fdatasync() function and replace it with fsync()
if not found. (CVS 2739)

FossilOrigin-Name: 385a08afefaf552db221ae8bd30ecc7e7c07ee5b

19 years agoThe hash tables deallocate when empty in order to avoid nuisanse complaints
drh [Mon, 3 Oct 2005 15:11:08 +0000 (15:11 +0000)] 
The hash tables deallocate when empty in order to avoid nuisanse complaints
from valgrind.  Added tests to verify no hash table memory leaks in os_unix.c. (CVS 2738)

FossilOrigin-Name: 080eadca582a49a069a76ed113ec15e9bce2955a

19 years agoMake sure the default storage for virtual tables is the disk not memory
drh [Sun, 25 Sep 2005 01:13:09 +0000 (01:13 +0000)] 
Make sure the default storage for virtual tables is the disk not memory
while running conflict.test.  Ticket #1453. (CVS 2737)

FossilOrigin-Name: 6d780ca6cfbea10d29a4a1b5226efb269606e21a

19 years agoVersion 3.2.7 (CVS 2736)
drh [Sat, 24 Sep 2005 15:25:01 +0000 (15:25 +0000)] 
Version 3.2.7 (CVS 2736)

FossilOrigin-Name: bd141a7c12c779d15d81acc8f919c37b9a4aa40b