SQLite

Timeline
Login

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

100 check-ins occurring around abdd70ae0424ccad.

2011-05-13
18:51
Make arrangements so that virtual table inserts into shadow tables do not modify the sqlite3_last_insert_rowid() return. Document that this is how sqlite3_last_insert_rowid() works. (check-in: e569f18b user: drh tags: trunk)
17:11
Rather than document goofy behavior, it seems better to make the behavior less goofy. (Was: Updates to the sqlite3_last_insert_rowid() documentation - to make it clear that the function does not work for virtual tables.) (Closed-Leaf check-in: f88dfac3 user: drh tags: mistake)
17:11
Also add fts3_term.c to main.mk. (check-in: 966f2d2c user: drh tags: trunk)
2011-05-12
21:01
Add fts3_term.c to amalg gen script and configure input files. (check-in: 6ee07732 user: shaneh tags: trunk)
15:32
Pull in the patches to support read-only WAL databases into a new branch off of the apple-osx branch. This also pulls in all the other pending 3.7.7 changes such as URI support. (check-in: 97b98010 user: drh tags: apple-wal-readonly)
2011-05-11
20:54
Improvements to documentation hyperlinks. Change the value of SQLITE_OPEN_URI to an unreserved value. (check-in: 851ab75d user: drh tags: trunk)
19:00
URI filename documentation updates. (check-in: 8885c867 user: drh tags: trunk)
17:36
Add missing comments associated with readonly shm changes. (check-in: 6a2ea52e user: dan tags: wal-readonly)
15:53
Merge latest trunk changes. Add a couple of readonly shm tests. (check-in: cde45a03 user: dan tags: wal-readonly)
14:57
Only open a read-only connection to shared-memory if the "readonly_shm=1" option is specified as part of the database file URI (and if a read-write connection fails). (check-in: 671ba5fc user: dan tags: wal-readonly)
2011-05-10
18:39
Have flags passed to sqlite3_open_v2() apply to the main and any attached databases. And change things so that any "mode=xxx" or "cache=xxx" options specified as part of a URI for the main database do not also apply to attached databases. (check-in: 3e490915 user: dan tags: trunk)
17:43
Update URI test cases to account for the new error message format. (check-in: 5bde5680 user: dan tags: trunk)
17:31
Add experimental support for read-only connections to WAL databases. (check-in: bb59f986 user: dan tags: wal-readonly)
14:52
Provide the ability to specify an alternative mutex subsystem at compile-time. - This check-in should have gone on the trunk, not on the 3.7.6 branch. (Closed-Leaf check-in: 489c453d user: drh tags: mistake)
10:17
Add new documentation keywords to the sqlite3_vfs description. (check-in: ad3389a9 user: drh tags: trunk)
2011-05-09
19:20
Return a suitable error message if the mode= argument to a URI specifies a higher mode than what is allowed by context. Other minor cleanups for the URI parsing logic. (check-in: d9bc1c7f user: drh tags: trunk)
2011-05-07
18:40
Set the sqlite3.mallocFailed flag if sqlite3ParseUri fails with SQLITE_NOMEM. (check-in: ca3797d4 user: drh tags: trunk)
18:18
Return SQLITE_MISUSE from the sqlite3_open_v2() function if the 3rd parameter is not a valid set of bit-values. (check-in: 3c926ce0 user: drh tags: trunk)
14:40
Fix minor compiler warnings. (check-in: 139eecbe user: drh tags: trunk)
2011-05-06
18:55
Merge the uri branch with the trunk. (check-in: 88df33c4 user: dan tags: trunk)
18:53
Remove some unnecessary modifications from the uri branch. Add a test to show that ATTACH only interprets its argument as a URI if the connection was opened with SQLITE_OPEN_URI (or URI interpretation is globally enabled). (Closed-Leaf check-in: aa90b943 user: dan tags: uri)
18:34
Update comments and documentation associated with new URI parsing code. Add test file e_uri.test, containing tests mapped to documentation regarding URI filenames. (check-in: 92751788 user: dan tags: uri)
13:58
Merge windows test case fixes. No changes to code. (check-in: 2e5c0ed7 user: dan tags: trunk)
00:19
Increase the iVersion for sqlite3_module needed for the xSavepoint, xRelease, and xRollbackTo methods from 1 to 2. This is so that it will conform to published documentation. (check-in: 0f4954e9 user: drh tags: trunk)
2011-05-05
23:07
Fix an incorrect assert() in sqlite3_value_config(). Updates to the sqlite3_value_config() documentation. (check-in: 22cbc01a user: drh tags: trunk)
19:44
Changes to various test scripts so that they pass on windows. (Closed-Leaf check-in: 1586244b user: dan tags: win32-test-fixes)
18:53
Have the xFullpath method in os_win.c discard the initial "/" if a filename begins with "/X:", where X is any alphabetic character. Also fix some test issues in uri.test. (check-in: fe57a8f6 user: dan tags: uri)
17:41
Fix sqlite3_vtab_on_conflict() to return the correct values for ABORT, FAIL, and IGNORE. (check-in: f0617d61 user: drh tags: trunk)
17:00
Fix a bug in memory usage tracking that was introduced by check-in [4e33a0eaf83922]. (check-in: 8ba456ae user: drh tags: trunk)
15:52
Merge the latest trunk changes into the apple-osx branch. (check-in: f9b149e5 user: drh tags: apple-osx)
15:46
Merge the latest trunk changes into the sessions branch. (check-in: 6883580e user: drh tags: sessions)
15:39
Bump the version number to 3.7.7 on account of the new sqlite3_vtab_config() and sqlite3_vtab_on_conflict() interfaces. Updates to the documentation on those interfaces. (check-in: 930be6a1 user: drh tags: trunk)
13:54
Change sqlite3_create_module() so that it avoids resetting the schema as long as preexisting modules are unchanged. (check-in: 8485855a user: drh tags: trunk)
13:53
Add a #include to test_demovfs.c in an effort to get it to compile on Solaris. (check-in: 8f06ea33 user: drh tags: trunk)
12:35
Fix a problem in the URI code preventing the amalgamation from building. Add comments describing SQLITE_CONFIG_URI and SQLITE_OPEN_URI to sqlite.h.in. (check-in: ea562d6d user: dan tags: uri)
2011-05-04
17:35
Merge latest trunk changes with uri branch. (check-in: af279f36 user: dan tags: uri)
17:23
Merge vtab-conflict branch with trunk. (check-in: 8f9666af user: dan tags: trunk)
16:30
Fix a couple of compiler warnings in the FTS code. (Closed-Leaf check-in: 1a113359 user: dan tags: vtab-conflict)
15:41
Fix a performance problem in queries that use "ORDER BY rowid DESC" and one or more FTS auxiliary functions. (check-in: 95e09b20 user: dan tags: vtab-conflict)
12:52
Optimize "ORDER BY rowid/docid DESC/ASC" clauses on FTS tables. (check-in: 13395121 user: dan tags: vtab-conflict)
2011-05-03
15:09
Remove some unused code related to URI parsing. (check-in: 008cd0ef user: dan tags: uri)
11:53
Allow only "localhost" and "" as authorities in URIs. Do not allow escapes (%HH) in the authority part of a URI. (check-in: b8a0f1b5 user: dan tags: uri)
10:22
Change the supported URI options to "mode" and "cache". (check-in: 0a694a0b user: dan tags: uri)
2011-05-02
17:41
Merge the latest trunk changes into uri branch. (check-in: 7fdd0786 user: dan tags: uri)
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)