SQLite

Timeline
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

100 check-ins occurring around a35e83eac7.

2011-05-01
22:57
Backport check-ins [0900e35348f4b9bf3] and [4fead8e714c7e50] to the 3.7.2 branch. These check-ins provide hints to the btree layer for when it is possible to use a hash table rather than a btree to implement an index. The SQLite BTree layer does not use these hints, but alternative btree layers might. (check-in: 7155e6f3 user: drh tags: branch-3.7.2)
2011-04-28
18:46
Have r-tree virtual tables support on-conflict clauses. (check-in: 822ab52f user: dan tags: vtab-conflict)
2011-04-27
19:54
In windows, ignore ERROR_NOT_LOCKED when calling the read-lock removal routine. (check-in: f55156c5 user: drh tags: trunk)
18:08
Change the name of an internal function to avoid conflicts with the math library. (check-in: 1bd1484c user: drh tags: trunk)
16:05
Expose the UTF8 to MBCS conversion routine in os_win.c to external applications. (check-in: 7b479b9b user: drh tags: trunk)
16:02
Add documentation for the newly introduced sqlite3_vtab_config() and on_conflict() API functions. Test that encountering an SQLITE_MISMATCH in fts3 does not corrupt the full text index. (check-in: abdd70ae user: dan tags: vtab-conflict)
12:08
Fix problems related to savepoint rollback and fts3. (check-in: ff69f823 user: dan tags: vtab-conflict)
01:00
Fix a comment typo. (check-in: 19c6625a user: drh tags: trunk)
2011-04-26
19:21
Extra tests for fts3. And fixes for conflict-handling related problems in fts3. (check-in: fb4a3558 user: dan tags: vtab-conflict)
2011-04-25
18:49
Add support for on conflict clauses to fts3/fts4. (check-in: 6d2633a6 user: dan tags: vtab-conflict)
18:20
Test case for the ".log" command to the command-line shell. (check-in: 7d0ff26a user: drh tags: trunk)
18:03
Add the (deliberately undocumented) sqlite_log() SQL function as a built-in. (check-in: f7806e03 user: drh tags: trunk)
18:01
Invoke the unix open() system call through a wrapper to avoid problems resulting from differing declarations to that function in various systems. (check-in: 4c7ff4dd user: drh tags: trunk)
2011-04-24
22:56
Disable the transfer optimization if the destination table contains any foreign key constraint and foreign key constraints are enabled. Ticket [6284df89debdf]. (check-in: ddeea5ab user: drh tags: trunk)
2011-04-23
19:06
Test that it is now possible to use different VFSs for two databases attached to a single handle. (check-in: 2af51f85 user: dan tags: uri)
15:54
Have the ATTACH command do URI interpretation in the same way as sqlite3_open() and sqlite3_open_v2() do. (check-in: 68240e75 user: dan tags: uri)
10:12
Fix parsing of %00 in uri handling code. (check-in: 44f0874a user: dan tags: uri)
2011-04-22
22:55
Add the "getlock" utility for determining if a database file (on unix) is currently locked. (check-in: 0ab24b13 user: drh tags: trunk)
19:37
Add the start of the "uri-filenames" feature. (check-in: b8a8132e user: dan tags: uri)
2011-04-20
13:35
Update a comment in e_createtable.test. (check-in: d8b149f5 user: dan tags: trunk)
2011-04-19
06:43
Avoid passing NULL to the xOpen method of an FTS3/4 tokenizer. (check-in: 0dd09fc0 user: dan tags: trunk)
2011-04-18
17:30
Merge trunk changes into sessions branch. (check-in: b91b4c31 user: dan tags: sessions)
15:47
Fix further missing comments and other minor issues in the session module code. (check-in: 99f0f350 user: dan tags: sessions)
12:05
Fix some missing comments and other issues with session module code. (check-in: 20d7c280 user: dan tags: sessions)
07:36
Further coverage tests for the session module. (check-in: 69a01c70 user: dan tags: sessions)
2011-04-17
17:25
Version 3.7.6.2 (check-in: 154ddbc1 user: drh tags: release, version-3.7.6.2, branch-3.7.6)
17:17
Bump the version number to 3.7.6.2 (check-in: c429edf3 user: drh tags: branch-3.7.6)
17:14
Change the prototype for the open() system call to agree with Posix. Though a faulty function prototype in a pointer cast is a seemingly innocuous error, the correct prototype is necessary for pthreads to work correctly on NetBSD. (check-in: 986f2f25 user: drh tags: branch-3.7.6)
17:09
Change the prototype for the open() system call to agree with Posix. Though a faulty function prototype in a pointer cast is a seemingly innocuous error, the correct prototype is necessary for pthreads to work correctly on NetBSD. (check-in: 3e135748 user: drh tags: trunk)
00:55
Adjust some test cases in triggerC.test to handle non-default SQLITE_MAX_TRIGGER_DEPTH settings. (check-in: 9d6c6129 user: shaneh tags: trunk)
2011-04-16
19:23
Improve test coverage of session module. (check-in: f46d4b64 user: dan tags: sessions)
2011-04-15
21:37
Adjust test case in quota.test to handle Windows dir seperators. (check-in: 75ed1bce user: shaneh tags: trunk)
20:18
Updates to test code in os_win to bring winSync inline with unixSync (test code only). Updated a few test scripts to account for dirsync counting issues on Windows. (check-in: 8f99c5bf user: shaneh tags: trunk)
19:30
Remove stray semi-colon that MSVC complained about. (check-in: 7a085271 user: shaneh tags: trunk)
19:18
Improve coverage of session module. (check-in: 3dfd1d63 user: dan tags: sessions)
16:39
Changes to memory allocator usage tracking to delay the onset of integer overflow. (check-in: 4e33a0ea user: drh tags: trunk)
16:03
Add tests and fixes for OOM handling in sqlite3changeset_concat(). (check-in: df0b2d21 user: dan tags: sessions)
15:18
Backport check-in [9f9f32882501ac9] to provide EXPLAIN QUERY PLAN output for the count(*) optimization. Also backport check-in [a8761a9128de945aa] to prevent unordered indices from being used on a full table scan. The first backport was necessary in order to test the second. (check-in: 8d924e16 user: drh tags: branch-3.7.2)
15:04
Have sqlite3changeset_concat() return SQLITE_SCHEMA if an attempt is made to concatenate changesets based on incompatible database schemas. (check-in: 343b6451 user: dan tags: sessions)
14:46
Do not do full table scans of unordered indices. (check-in: a8761a91 user: drh tags: trunk)
14:33
Fix #ifs involving SQLITE_ENABLE_LOCKING_STYLE so that they check the value of that macro and not whether it is defined. (check-in: 8775f159 user: drh tags: trunk)
13:29
Add retry logic to GetFileAttributesEx() on windows. (Closed-Leaf check-in: 1cca9a49 user: drh tags: experimental)
12:36
Make sure the unix backend returns SQLITE_FULL if write() fails with an ENOSPC error code. (check-in: 721e3c16 user: drh tags: trunk)
12:04
Add documentation for sqlite3changeset_concat() to sqlite3session.h. (check-in: ada9efa5 user: dan tags: sessions)
2011-04-14
18:01
Add further tests for the sqlite3changeset_concat() function. Also fixes. (check-in: 1fc3f15d user: dan tags: sessions)
11:16
Start adding the sqlite3changeset_concat() function to the session module. (check-in: 8927b226 user: dan tags: sessions)
2011-04-13
23:42
Remove extra CR and NL characters from FormatMessage() generated error messages in the windows VFS. (check-in: 8332949c user: drh tags: trunk)
20:26
Add new extended error codes for I/O errors on seek and shared-memory map. Add sqlite3_log() calls in the windows backend to record details of errors. (check-in: fe603217 user: drh tags: trunk)
16:52
Fix a usage comment typo in the showdb utility. (check-in: 8744ced4 user: drh tags: trunk)
15:42
Update the apple-osx branch to version 3.7.6.1. (check-in: 289194d6 user: drh tags: apple-osx)
14:40
Version 3.7.6.1 (check-in: a35e83ea user: drh tags: trunk, release, version-3.7.6.1)
14:02
Bump the version number to 3.7.6.1 in preparation for a bug-fix release. (check-in: 5f0c394a user: drh tags: trunk)
13:42
Make sure the array of overloadable system calls is always correctly sized, regardless of the compile-time configuration. Ticket [bb3a86e890c8e96ab]. (check-in: c6e727ab user: drh tags: trunk)
2011-04-12
01:58
Version 3.7.6. (check-in: f9d43fa3 user: drh tags: trunk, release, version-3.7.6)
2011-04-11
18:35
Do not override the fchmod system call in unix unless the SQLITE_ENABLE_LOCKING_STYLE compile-time option is engaged. (check-in: 51029d84 user: drh tags: trunk)
15:36
Updates to the OS/2 patches. This change also move the location of a global variable declaration in shell.c which might effect other build targets. (check-in: 73906b67 user: drh tags: trunk)
15:35
Fix a signed integer overflow problem in the testcase() macro. (check-in: f18f5f58 user: drh tags: trunk)
13:57
Apply OS2 WAL patch. Changes to os_os2.c only. (check-in: eac17106 user: dan tags: trunk)
05:38
Change exists.test to run all tests with and without "PRAGMA journal_mode=WAL". (check-in: c4e624db user: dan tags: trunk)
2011-04-10
16:39
Add a simple test program to aid in verifying that journals are cross-platform. (check-in: a65a7a59 user: drh tags: trunk)
2011-04-09
19:17
Add test file unordered.test. (check-in: f346dae1 user: dan tags: trunk)
18:13
Pull all the latest trunk changes into the apple-osx branch. (check-in: 4eaef4ad user: drh tags: apple-osx)
18:07
Merge the latest trunk changes into the sessions branch. (check-in: 83705e90 user: drh tags: sessions)
17:53
Remove an always-true conditional. Replace it with an assert(). (check-in: 1c2f0f84 user: drh tags: trunk)
17:32
Add VerifyCookie instructions to "DROP XXX IF EXISTS" statements if the specified database object does not exist when the statement is prepared. (check-in: a46f3290 user: dan tags: trunk)
15:39
Add an OP_VerifyCookie instruction to "CREATE XXX IF NOT EXISTS" commands. This way, if the specified database object existed when the statement was compiled but removed from the database before sqlite3_step() was called, the statement still works as expected (and creates the object). (check-in: b9dbd993 user: dan tags: trunk)
03:30
Back port the unordered-index-hack to the 3.7.2 branch. (check-in: 80353020 user: drh tags: branch-3.7.2)
03:20
If the keyword "unordered" appears at the end of the SQLITE_STAT1.STAT column for an index, then use that index for equality lookups only, never for range queries or sorting. This feature is currently undocumented and my change or be removed in a future release. (check-in: 8a42e236 user: drh tags: trunk)
03:04
Back out the SQLITE_OMIT_UNIQUE_ENFORCEMENT compile-option. It is an unneeded complication. (check-in: 927e955b user: drh tags: trunk)
02:34
When ATTACH-ing a new database to an existing database with a codec, do not enable the codec in the attached database if it is not enabled in the existing database and it is not requested by the USING clause. (check-in: 4caa5fc8 user: drh tags: trunk)
02:09
Do not do a backup if the number of reserved bytes in the source and destination do not match. Try to make the match, but if unable fail. (check-in: 0ca8a233 user: drh tags: trunk)
2011-04-08
23:36
Backport test cases from trunk that seek to prove that the IS NOT NULL query optimization is working. (check-in: 9eff4702 user: drh tags: branch-3.7.2)
23:05
Make sure the query planner is able to correctly analyze NULL value samples in the sqlite_stat2 table. This is a backport of changes from check-in [f73a167b434f] (check-in: 1d637889 user: drh tags: branch-3.7.2)
23:04
Make sure the left-hand side of the IS NOT NULL operator is a simple column and not a general expression before applying the IS NOT NULL optimization. This is a backport of check-in [543f75a6abe3]. (check-in: e8177e01 user: drh tags: branch-3.7.2)
21:35
Always make sure the left-hand side of the IS NOT NULL operator is a simple column, not a general expression, before applying the IS NOT NULL query optimization. (check-in: 543f75a6 user: drh tags: trunk)
18:47
Add some rtree tests to the backcompat.test script. (check-in: 8ea3601c user: dan tags: trunk)
17:22
Fix incrvacuum2.test so that it works with the inmemory_journal permutation. (check-in: 7b8e1761 user: dan tags: trunk)
2011-04-07
19:56
Change two new internal functions in where.c from global to file scope. (check-in: 5bbfa17d user: drh tags: trunk)
15:24
Add test case to verify [d03d63d77e] works. (check-in: bf78acb9 user: dan tags: trunk)
14:47
When searching a list of freelist trunk pages looking for a specific page to allocate, avoid unnecessary journalling of the unchanged trunk pages towards the start of the list. (check-in: d03d63d7 user: drh tags: trunk)
14:05
Avoid running thread1.test or thread2.test if SQLITE_MUTEX_NOOP is defined. (check-in: 532ae32e user: dan tags: trunk)
10:09
Do not run multi-threaded Tcl tests if the library was built with SQLITE_MUTEX_NOOP defined. (check-in: e4e99606 user: dan tags: trunk)
05:17
Fix test script attach4.test so that it works with type 1 VFS implementations (no wal). And wal.test so that it work with a small default pager cache size. (check-in: 29c7b425 user: dan tags: trunk)
03:41
Fix a couple of MSVC compiler warnings; (check-in: 748c9109 user: shaneh tags: trunk)
01:54
Fix an issue with an analyze test. No code changes. (check-in: cddf79db user: shaneh tags: trunk)
01:14
Fix typos in documentation comments. No changes to code. (check-in: 9c64b5a9 user: drh tags: trunk)
2011-04-06
23:40
Add a missing "extern C" terminator to the end of sqlite3session.h. (check-in: 29090b69 user: drh tags: sessions)
23:39
Fix VC++ compiler warnings. (check-in: 7b7c8d36 user: drh tags: sessions)
22:33
Merge in the latest changes from the trunk. (check-in: 435b57dc user: drh tags: sessions)
22:05
Fix a performance regression: Keep two btree masks in each prepared statement; one for btrees used and another for btrees that require locks. Only try to lock the btrees identified by the second mask. (check-in: 614de91a user: drh tags: trunk)
19:15
Fix a benign inaccuracy in the os_unix.c SQLITE_FCNTL_SIZE_HINT code. (check-in: 61a6ccbe user: dan tags: trunk)
17:54
Changes to support building with various SQLITE_OMIT_XXX options defined. (check-in: 2039ed95 user: dan tags: trunk)
12:38
Update a comment in sqliteLimit.h. No changes to code or tests. (check-in: b7296fd3 user: dan tags: trunk)
12:37
Add configurations featuring the -ftrapv switch and large values for SQLITE_MAX_ATTACHED to releasetest.tcl. (check-in: 989588ab user: dan tags: trunk)
2011-04-05
22:13
Merge the latest trunk changes into the sessions branch. (check-in: 45f20261 user: drh tags: sessions)
22:10
Merge the latest trunk changes into the apple-osx branch. (check-in: c77a767c user: drh tags: apple-osx)
22:08
Suppress many harmless compiler warnings, mostly signed/unsigned comparisons within asserts or unused parameters in extensions. (check-in: 3eeb0ff7 user: drh tags: trunk)
19:27
Simplifications to the sqlite3BtreeEnterAll() and LeaveAll() routines. Just have them call BtreeEnter and BtreeLeave() repeatedly rather than trying to be clever. (check-in: 51039b35 user: drh tags: trunk)
19:26
Simplifications to the sqlite3ResetInternalSchema() logic to eliminate unreachable branches. (check-in: a4c3ac98 user: drh tags: trunk)
18:34
Remove dead code from the OP_JournalMode opcode in the VDBE. This code seems to have been useless since [f88c6367d2] on 2010-08-07. (check-in: a89f24e2 user: drh tags: trunk)