/ Timeline
Login

100 check-ins occurring around 1634fd223d.

2008-10-07
15:25
Remove the SQLITE_MUTEX_APPDEF compile-time option. The SQLITE_THREADSAFE=0 option always removes all mutex code. For application-defined mutexes only, use SQLITE_THREADSAFE=1 with SQLITE_MUTEX_NOOP=1. Ticket #3421. (CVS 5779) check-in: 02a12eb1 user: drh tags: trunk
15:00
Fix a recently introduced test script bug causing rollback.test to throw an exception when run using the "onefile" variation. (CVS 5778) check-in: 7d55ec37 user: danielk1977 tags: trunk
14:06
Have sqlite3_bind_value() call sqlite3ApiExit() before returning. Otherwise the db->mallocFailed flag may not be cleared. (CVS 5777) check-in: 6b7c8d56 user: danielk1977 tags: trunk
12:32
Do not use double unnecessarily in date+time functions. Ticket #3422. (CVS 5776) check-in: b0323132 user: drh tags: trunk
11:51
Fix a problem with hot-journal rollback. SQLITE_CANTOPEN was being returned if the hot-journal file contained a pointer to a master journal file that did not exist. (CVS 5775) check-in: 22d1feb9 user: danielk1977 tags: trunk
05:27
Initial support for LIMIT clause on DELETEs and UPDATEs. Changes likely with more testing. The code can be omitted with the define SQLITE_OMIT_UPDATE_DELETE_LIMIT. (CVS 5774) check-in: 9c8b132e user: shane tags: trunk
01:18
Removed redundant assert(). (CVS 5773) check-in: 486b1124 user: shane tags: trunk
2008-10-06
16:18
Allow INDEXED BY and NOT INDEXED to be used in UPDATE and DELETE statements. (CVS 5772) check-in: 83a7e446 user: danielk1977 tags: trunk
15:31
Add a test script to verify that ticket #3419 stays fixed. (CVS 5771) check-in: c3cf54a1 user: drh tags: trunk
15:18
Fix a typo in check-in (5769) (CVS 5770) check-in: 24891902 user: drh tags: trunk
13:54
Expression nodes of type TK_ROW mean the rowid of the first table in the source list. (CVS 5769) check-in: 2f7db6c9 user: drh tags: trunk
12:46
In sqlite3_bind() interfaces, avoid acquiring the mutex until after the statement handle has been validated. Ticket #3418. (CVS 5768) check-in: 693503e2 user: drh tags: trunk
11:29
Add a test to indexedby.test to check that automatic indexes (sqlite_autoindex_xxx) can be used with the INDEXED BY syntax. (CVS 5767) check-in: bb51c345 user: danielk1977 tags: trunk
05:32
Allow INDEXED BY and NOT INDEXED clauses in SELECT statements. (CVS 5766) check-in: 98ca5580 user: danielk1977 tags: trunk
2008-10-03
09:10
Modifications to bind.test to account for different values of SQLITE_MAX_VARIABLE_NUMBER. Ticket #3409. (CVS 5765) check-in: 1a91f3fd user: danielk1977 tags: trunk
08:44
Change one of the test cases in incrblob2.test to avoid allocating a 10MB block of heap memory. (CVS 5764) check-in: 83b7dd73 user: danielk1977 tags: trunk
2008-10-02
16:42
Change to reduce the number of OP_Null opcodes in "WHERE <rowid> IN (x,y,z)" queries. (CVS 5763) check-in: 33b59a3d user: danielk1977 tags: trunk
14:49
Fix for sqlite3_blob_write(): If either 3rd or 4th argument is less than zero, return SQLITE_ERROR. H17879. (CVS 5762) check-in: f6074c0b user: danielk1977 tags: trunk
14:33
Fix a typo that prevents the sqlite3_sql() interface from appearing in the official documentation. (CVS 5761) check-in: b46814b2 user: drh tags: trunk
13:50
Optimize queries that contain "WHERE rowid IN (x, y, z...)" by using an intkey btree to store the (x, y, z...) set instead of an index btree. (CVS 5760) check-in: 803a1736 user: danielk1977 tags: trunk
2008-10-01
13:55
Adjust the memory usage bounds on the memsubsys1.test script so that it works on amd64. (CVS 5759) check-in: aabde23f user: drh tags: trunk
08:43
Fix a bug in where.c where a non-temp register was being incorrectly deallocated. Ticket #3408. (CVS 5758) check-in: 59d2e89e user: danielk1977 tags: trunk
2008-09-30
17:18
Add some testcase() and assert() macros to btree.c to aid with testing recent changes. (CVS 5757) check-in: fb461b78 user: drh tags: trunk
16:48
Fix a comment in btree.c. No code changes. (CVS 5756) check-in: 0f3c5633 user: danielk1977 tags: trunk
14:06
Change leading tabs into spaces. (CVS 5755) check-in: 4e536463 user: drh tags: trunk
09:31
Fix a recently introduced problem with deleting entries from index tables. (CVS 5754) check-in: 83c064ca user: danielk1977 tags: trunk
04:20
Misc clean up. Wrapped a CE only variable in if-defs. Changed to only provide cache hint for CE builds (as this prevents CE from compressing the file.) Performance testing on XP and Vista showed caching hint had little effect when the DB size was much smaller than the O/S disk cache size, and provided only marginal benefit when the DB size was much larger than the cache. On Vista, overall system performance was hurt for very large DBs. Ticket #3387. (CVS 5753) check-in: 15dd0169 user: shane tags: trunk
00:31
A few minor changes to test scripts so that they work on linux-amd64. (CVS 5752) check-in: 78d075ff user: drh tags: trunk
2008-09-29
16:41
Remove the reparentPage() and reparentChildPages() functions from btree.c. All calls to these functions can now be replaced by a call to setChildPtrmaps(). (CVS 5751) check-in: 35e8e4dc user: danielk1977 tags: trunk
15:53
Remove the MemPage.idxShift variable. It is no longer required. (CVS 5750) check-in: 7354abd0 user: danielk1977 tags: trunk
14:27
Do not run vacuum.test as part of the "exclusive" permutation test. (CVS 5749) check-in: 2fb15ae9 user: danielk1977 tags: trunk
14:12
Update shared_err.test to work with (5668) (return SQLITE_CORRUPT if rollback fails). (CVS 5748) check-in: 292acaf7 user: danielk1977 tags: trunk
11:49
Instead of storing a pointer to the parent page in the MemPage structure, have each B-Tree cursor keep track of the ancestry of the current page. (CVS 5747) check-in: 40425e93 user: danielk1977 tags: trunk
00:11
fix #3077: use full version in pkg-config files (CVS 5746) check-in: efe095e0 user: vapier tags: trunk
2008-09-26
21:08
Add the "truncate" journal mode which commits transactions by truncating the rollback journal file to zero length and not calling fsync(). (CVS 5745) check-in: 7c561f2e user: drh tags: trunk
20:02
Make sure the queueMutex is held prior to writing the pQueueLast field of the write queue in the async demonstration code. Ticket #3405. (CVS 5744) check-in: 5622a1e2 user: drh tags: trunk
17:31
Performance enhancement: avoid calling reparentChildPages() from balance_nonroot(). (CVS 5743) check-in: 28fd0a50 user: danielk1977 tags: trunk
2008-09-24
14:03
On windows, avoid running those tests in exclusive.test that require the journal file to be externally accessed while SQLite is holding it open. This doesn't work on windows. (CVS 5742) check-in: 5debf12f user: danielk1977 tags: trunk
09:58
Add file fts3_icu.c to the amalgamation. Because of the way header files are included into sqlite3.c, fts3_icu.c has to appear after all the other fts3 and icu extension files. Ticket #3398. (CVS 5741) check-in: 0acca584 user: danielk1977 tags: trunk
09:12
Fix some function declarations (change "int foo()" to "int foo(void)"). Ticket #3399. (CVS 5740) check-in: 0fb98c35 user: danielk1977 tags: trunk
2008-09-23
17:39
Catch another case where SQLITE_IOERR could be returned instead of SQLITE_NOMEM following an out-of-memory error. (CVS 5739) check-in: 18d030da user: danielk1977 tags: trunk
16:41
Always transform error code SQLITE_IOERR_NOMEM to SQLITE_NOMEM before returning. This was already happening in most places. (CVS 5738) check-in: 046ef072 user: danielk1977 tags: trunk
10:23
Enable the LOCKING_STYLE extensions by default on a Mac. Leave them disabled on all other posix platforms. (CVS 5737) check-in: bae1d5b1 user: drh tags: trunk
10:16
Remove an unused variable from the test logic. (CVS 5736) check-in: 309ba380 user: drh tags: trunk
10:12
Fix the TCL installer so that it omits the release number. Ticket #3396. Use strcmp() instead of sqlite3StrICmp() in the "copy" method of the SQLite object in the TCL interface. (CVS 5735) check-in: a8860624 user: drh tags: trunk
09:58
Add no-op Unload entry points to the TCL interface. Ticket #3397. (CVS 5734) check-in: b31dd1e3 user: drh tags: trunk
09:36
Fix for ticket #3382 was mistakenly removed by (5712). Add an assert to prevent it from being removed again. (CVS 5733) check-in: 01d26b3d user: drh tags: trunk
2008-09-22
17:54
Get rid of all of the compiler magic associated with SQLITE_EXPERIMENTAL and SQLITE_DEPRECATED. It was causing more problems than it was solving. Ticket #3395 et al. (CVS 5732) check-in: bc040073 user: drh tags: trunk
17:22
Fix a memory leak that can follow a malloc failure in sqlite3_initialize. (CVS 5731) check-in: 118dc0ba user: danielk1977 tags: trunk
11:46
Add instrumentation to os_unix.c to test that a return value of SQLITE_FULL from an xSync() callback is handled correctly. (CVS 5730) check-in: 7bd2da93 user: danielk1977 tags: trunk
10:44
Version 3.6.3 (CVS 5729) check-in: 1634fd22 user: drh tags: trunk, release
06:13
Remove unused macro Release() from vdbe.c. (CVS 5728) check-in: 91567943 user: danielk1977 tags: trunk
2008-09-21
15:14
Give file scope to non-API routines in pcache. Ticket #3392. (CVS 5727) check-in: 6521f98a user: drh tags: trunk
2008-09-19
18:32
Speed up releaseMemArray() a bit by handling the most common types of memory cells inline. (CVS 5726) check-in: ce075085 user: danielk1977 tags: trunk
16:39
In function moveToRoot(), use the MemPage.pParent pointers to find the root page if they are valid. This is slightly faster than requesting a new reference to the root page from the pager layer. (CVS 5725) check-in: 0c8b74e6 user: danielk1977 tags: trunk
15:10
In sqlite3BtreeGetMeta(), if BtShared.pPage1 is available use it instead of requesting a new reference from the pager layer. (CVS 5724) check-in: 59be34cf user: danielk1977 tags: trunk
09:14
Remove an obsolete layer of redirection in pager.c. (CVS 5723) check-in: 75deaa44 user: danielk1977 tags: trunk
2008-09-18
18:18
Do not run the async tests if the async module is not installed. (CVS 5722) check-in: 4de71a4e user: drh tags: trunk
18:17
Fix a segfault introduced by (5720) that can follow an IO error. (CVS 5721) check-in: 05d34626 user: danielk1977 tags: trunk
17:34
Avoid parsing the structure of b-tree pages (in sqlite3BtreeInitPage) more than is necessary. (CVS 5720) check-in: 6b998f30 user: danielk1977 tags: trunk
13:49
Update the version number to 3.6.3. (CVS 5719) check-in: 419764b3 user: drh tags: trunk
11:30
Changes to test script nan.test to work on symbian. (CVS 5718) check-in: 0889b22a user: danielk1977 tags: trunk
11:18
Changes to test script io.test to work on symbian. (CVS 5717) check-in: 2b41c495 user: danielk1977 tags: trunk
01:08
Performance improvements in getAndInitPage(): omit the upper bound check on page number if the page is already in cache. (CVS 5716) check-in: badd0873 user: drh tags: trunk
2008-09-17
20:06
Speed improvements for in-memory databases by omitting flag clearing on pages where it is impossible for the flag to be set and by avoiding assert()s on non-debugging builds. Ticket #3384. (CVS 5715) check-in: a7fd9e62 user: drh tags: trunk
16:14
Changes to test scripts to support running on symbian. (CVS 5714) check-in: 6ef34e9d user: danielk1977 tags: trunk
11:02
Add a type identifier to argument sz to sqlite3PageMalloc() in pcache.c. Ticket #3383. (CVS 5713) check-in: 94fde77b user: danielk1977 tags: trunk
00:13
Fix for tickets #3378 and #3381 that preserves the aliasing optimization. And yet, this fix feels uncomfortable. Seeking an alternative... (CVS 5712) check-in: f8b759f1 user: drh tags: trunk
2008-09-16
18:02
Add test cases for ticket #3378 and #3381. Add a temporary hack to get those to problems fixed. The hack causes failures in alias.test, but those are much less serious than the aforementioned tickets. This is a stop-gap until we can figure out a proper fix. (CVS 5711) check-in: a67da9dd user: drh tags: trunk
15:55
Initialize variable pKeyDup in multiSelectOrderBy(). Technically it doesn't need to be initialized, but the reasoning required to come to that conclusion is too complicated for some automated systems. So it is initialized to keep some compilers happy. Ticket #3382. (CVS 5710) check-in: bd58be6e user: danielk1977 tags: trunk
15:50
Use (file nativename (pwd)) instead of just (pwd) to find the name of the current directory to pass to "PRAGMA temp_store_directory" in pragma.test. This helps the test pass on non-unix systems. (CVS 5709) check-in: 50feaa37 user: danielk1977 tags: trunk
15:09
Add test script selectC.test which demonstrates ticket #3381. (CVS 5708) check-in: 3847faff user: drh tags: trunk
14:38
If the xAccess() call used by "PRAGMA temp_store_directory = /new/path/" to determine if the supplied directory is writable returns an error, assume the directory is not writable. (CVS 5707) check-in: e8418588 user: danielk1977 tags: trunk
12:06
Modify the sqlite3VdbeMemCompare() routine so that it does not modify any Mem.z values. Ticket #3376. (CVS 5706) check-in: 2d450551 user: danielk1977 tags: trunk
11:58
Add test case for ticket #3376. (CVS 5705) check-in: c6426057 user: drh tags: trunk
09:09
Set the type of the "comment" field to SQLITE_TEXT when outputing the results of an EXPLAIN query. (CVS 5704) check-in: 5dff20f4 user: danielk1977 tags: trunk
05:12
Do not attempt to change the page size after a pager has entered the error state (Pager.errCode!=SQLITE_OK). This prevents an assertion failure in vacuum3.test. (CVS 5703) check-in: aa5c9455 user: danielk1977 tags: trunk
2008-09-15
15:49
Minor comment change to test_async.c. No code changes. (CVS 5702) check-in: b1341060 user: danielk1977 tags: trunk
15:36
Adjust the page recycling algorithm so that the number of pages allocated to each connection does not exceed its cache_size limit. (CVS 5701) check-in: 3bc221b9 user: drh tags: trunk
14:47
Fix the async.test test script so that it invokes (finish_test) even if the asynchronous backend is not included in the build (and no tests are run). (CVS 5700) check-in: 5c954b40 user: danielk1977 tags: trunk
14:42
Fix the shared_err.test script so that it works if the device supports SQLITE_IOCAP_SAFEAPPEND. (CVS 5699) check-in: 38e5ea07 user: danielk1977 tags: trunk
14:08
Modify test_async.c to avoid using internal SQLite APIs. There are still some comments that need updating. (CVS 5698) check-in: 1d4fcaaf user: danielk1977 tags: trunk
04:20
Check if error code ENOTSUP is supported before using it. Ticket #3375. (CVS 5697) check-in: c32cb106 user: danielk1977 tags: trunk
2008-09-13
01:20
Fix issues with bizarrely quoted column names. Tickets #3370, #3371, and #3372. (CVS 5696) check-in: ced6bbd2 user: drh tags: trunk
2008-09-12
18:25
Fix the NEAR connector in FTS3 so that it can take ranges in excess of 9. The maximum range is now 32767. (CVS 5695) check-in: 8e9b9553 user: drh tags: trunk
16:03
Declare the isInterrupted field of the sqlite3 structure to be volatile. Ticket #3369. (CVS 5694) check-in: 414da4eb user: drh tags: trunk
10:22
Add a case to permutations.test to run tests with the IOCAP_SAFEAPPEND property set. (CVS 5693) check-in: 80bdaafa user: danielk1977 tags: trunk
2008-09-11
11:28
Add a couple of (fconfigure) commands to configure the incremental blob channels used by test file incrblob.test. This is required so that the tests work on windows and other platforms that have a default -translation mode other than 'lf'. (CVS 5692) check-in: 753caa20 user: danielk1977 tags: trunk
10:29
Fix a couple of problems with variable initializations picked up by stricter compilers. (CVS 5691) check-in: f4293d14 user: danielk1977 tags: trunk
2008-09-10
17:53
Fix some trivial cases where database corruption was causing an error code other than SQLITE_CORRUPT to be returned. (CVS 5690) check-in: 89fda074 user: danielk1977 tags: trunk
14:45
Fix for handling database files corrupted in such a was as to make a b-tree page a direct or indirect descendant of itself. (CVS 5689) check-in: 93545861 user: danielk1977 tags: trunk
13:09
Documentation updates: Describe recursion capabilities for the various callbacks. (CVS 5688) check-in: edd80811 user: drh tags: trunk
11:28
Avoid deleting a file while it is still open in corrupt2.test. Not all platforms support this. (CVS 5687) check-in: 099adfd3 user: danielk1977 tags: trunk
10:57
Fix some test script details so that the test suite runs with an SQLITE_DEFAULT_AUTOVACUUM=2 build. (CVS 5686) check-in: 300a64b7 user: danielk1977 tags: trunk
2008-09-09
18:28
Add fuzz3.test. For testing the library's response to corrupted database files. (CVS 5685) check-in: 7fd4dd95 user: danielk1977 tags: trunk
12:31
Calling sqlite3_create_function with nArg==(-1) does not override prior calls on the same function name with nArg>=0. Ticket #3345. Add the new -argcount option to the "function" method in the TCL interface. (CVS 5684) check-in: 5aa5b804 user: drh tags: trunk
2008-09-08
15:35
Fix a C++ism in pager.c (variable useAtomicWrite not declard at the top of its scope). (CVS 5683) check-in: a6dee85b user: danielk1977 tags: trunk
11:07
Fix a bug in r-tree related to internal nodes with one or more dimensions of size zero. Ticket #3363. (CVS 5682) check-in: 8b600ed0 user: danielk1977 tags: trunk
09:06
If the 'rootpage' column of the sqlite_master table contains a NULL value, return SQLITE_CORRUPT to the caller. (CVS 5681) check-in: a7b7b126 user: danielk1977 tags: trunk
08:08
Add header file sqliteicu.h to the ICU extension. This is analogous to the rtree.h and fts3.h headers used by other extensions to declare their entry points. Fix for ticket #3361. (CVS 5680) check-in: 79364b96 user: danielk1977 tags: trunk