SQLite

Timeline
Login

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

100 events occurring around 1da87fcdacfa7d27.

2011-10-13
13:52 Closed ticket [4776dee0]: Documentation and code about registering functions plus 1 other change (artifact: ca1846da user: drh)
13:35 Closed ticket [ac55d88a]: H10336 is no longer applicable plus 2 other changes (artifact: ed1c3715 user: drh)
13:34 Fixed ticket [24666532]: Various dump issues plus 1 other change (artifact: 3fcbbe87 user: drh)
13:34
Do the ".dump" command inside of a transaction to prevent other processes from modifying the database while the dump is underway. Ticket [2466653295e65] (check-in: 1c00d545 user: drh tags: trunk)
13:25 Fixed ticket [517e206a]: Fix sqlite3_analyzer plus 2 other changes (artifact: de2e5dae user: drh)
13:24 Closed ticket [54831703]: H35230 & H35240 refer incorrectly to H35230 - should be H35220 plus 2 other changes (artifact: c5cb2722 user: drh)
13:23 Closed ticket [cbd054fa]: "out of memory" in ANALYZE with SQLITE_ENABLE_STAT2 (artifact: c7d03710 user: drh)
13:22 Fixed ticket [9d68c883]: Database corruption following OOM fault plus 2 other changes (artifact: a5cd168d user: drh)
13:21 Fixed ticket [26ff0c82]: Incorrect result when using unnamed "?" bindings plus 2 other changes (artifact: f9fda6f1 user: drh)
13:20 Ticket [c25aab7e] The ".import" command does not parse CSV correctly. status still Open with 2 other changes (artifact: 8a44239e user: drh)
13:19 Fixed ticket [fc62af45]: Executing "PRAGMA journal_mode" may delete journal file while it is in use. plus 1 other change (artifact: fe5973ee user: drh)
13:18 Ticket [f817a457] CantOpen doesn't include name of file that can't be opened status still Open with 3 other changes (artifact: 6864a995 user: drh)
13:16 Fixed ticket [54844eea]: Incorrect caching of sub-query results in the FROM clause of a scalar sub-query. plus 1 other change (artifact: 3894b502 user: drh)
13:15 Fixed ticket [e59bdf61]: Possible database corruption following EINTR on unix plus 2 other changes (artifact: 5384614f user: drh)
13:13 Fixed ticket [af95b8c6]: Vacuuming a WAL database resets the file header read and write versions to 1. plus 2 other changes (artifact: d2b24c04 user: drh)
01:01
Fix a harmless compiler warning introduced into os_unix.c by one of the recent changes. (check-in: 4bf4d5eb user: drh tags: trunk)
00:42 Fixed ticket [ee19e690]: If shell is interrupted while dumping it still produces commit (and invalid dump) plus 2 other changes (artifact: 607efff6 user: drh)
00:41
If errors are encountered while processing the ".dump" command in the command-line shell, print error messages as comments in the output and ROLLBACK at the end rather than committing. Ticket [ee19e690ec9a5a2] (check-in: 8a8dcd6b user: drh tags: trunk)
00:11 Fixed ticket [7d32c69b]: sqlite3LoadExtension truncates file names plus 2 other changes (artifact: d69605cf user: drh)
00:11
Be sure to allocate plenty of space for error messages coming out of sqlite3_load_extension(), so that filenames and procedure names are not truncated. Ticket [7d32c69b50f89d] (check-in: af8bcdd9 user: drh tags: trunk)
2011-10-12
23:50 Fixed ticket [20f9d4fb]: sqlite3_overload_function ignores errors plus 2 other changes (artifact: 16e6acf2 user: drh)
23:49
The sqlite3_overload_function() interface returns an error if it is unable to create the overload function. Ticket [20f9d4fbbff3a3] (check-in: d5b6b374 user: drh tags: trunk)
23:14 Fixed ticket [0b803bff]: Return (error code) of xCurrentTime is always ignored plus 2 other changes (artifact: 4120d6b5 user: drh)
23:13
The date/time functions return NULL if the xCurrentTime or xCurrentTimeInt64 VFS methods fail. Ticket [0b803bff856c644c] (check-in: c96651dd user: drh tags: trunk)
19:04
Suppress a compiler warning that occurs with SQLITE_OMIT_VIRTUALTABLE. (check-in: 6bedb49d user: drh tags: trunk)
18:52
Clean up obsolete comments in printf.c. (check-in: 97ef4f50 user: drh tags: trunk)
17:00
Clarify a comment and fix a code formatting issue in btree.c. (check-in: 4f1a558d user: drh tags: trunk)
2011-10-11
20:41
Put in code to defend against signed/unsigned character problems in the command-line shell. (check-in: b94a80a8 user: drh tags: trunk)
20:14
Add a couple of asserts trying to make the operation of sqlite3SelectNew() clearer. (check-in: b21b1c7b user: drh tags: trunk)
18:38
Simplify the readonly_shm implementation so that it conforms to the implementation on trunk. Update the test cases to agree with the new behavior. (check-in: 9efb74ce user: drh tags: apple-osx)
18:18
Change the behavior of the readonly_shm=1 query parameter so that it never attempts to open the -shm file read/write. (check-in: f1364004 user: drh tags: trunk)
17:54
Remove all precision and width limits from formatting fields in the sqlite3_mprintf() family of functions. Malloc for space as necessary. The prevents a stack overflow on very large numbers using %f. (check-in: 1f843fb3 user: drh tags: trunk)
15:03
Fix a locking error introduced when porting the new Apple locking code. (check-in: cce1f521 user: drh tags: apple-osx)
14:19
Merge the latest trunk changes into the apple-osx branch. (check-in: 7e2c4898 user: drh tags: apple-osx)
12:58
Merge all the latest trunk changes into the sessions branch - especially the SQLITE_ENABLE_STAT3 enhancements. (check-in: 403431ca user: drh tags: sessions)
12:39
Fix requirements marks associate with STAT3. (check-in: 9325c1a8 user: drh tags: trunk)
00:09
Patches to the apple-osx-377 branch so that it will compile and run on non-Mac unix platforms. (Leaf check-in: b431a634 user: drh tags: apple-osx-377)
2011-10-10
23:53
Forward port the Apple-specific changes from [db5b7b778c] in the apple-osx-377 branch. Fix this up so that it will compile and run on Linux. (check-in: 6cb43f6c user: drh tags: apple-osx)
22:11
Merging in cherry picked diffs for persist wal, alloc padding, wal-safe vacuum and sqlite3_file_control based lockstate checking (check-in: db5b7b77 user: adam tags: apple-osx-377)
18:59 Edit [aef7945c423a8338|aef7945c]: Edit check-in comment. Cancel background color. (artifact: fe0f9bb6 user: drh)
18:59
Cherrypick the sqlite_data_count() changes from [d4f95b3b6e] and [9913996e7b] into the apple-osx branch for version 3.7.7. (check-in: aef7945c user: drh tags: apple-osx-377)
16:06
Enhance sqlite3_analyzer so that it is able to deal with multiplexed databases that have 8+3 filenames. (check-in: e5169f9a user: drh tags: trunk)
12:04
Fix a typo in a comment for PRAGMA journal_mode. Also amplify that same comment. (check-in: c8ff2a48 user: drh tags: trunk)
2011-10-08
21:39
All the soft_heap_limit to be exceeded by 10% in test cases. (check-in: 4be9dccc user: drh tags: trunk)
14:57
Add the SQLITE_DIRECT_OVERFLOW_READ compile time option. (check-in: 2ab14a84 user: dan tags: trunk)
2011-10-07
23:52
Change the ANALYZE command so that it no longer tried to delete unused sqlite_stat2 and sqlite_stat3 tables. Change the DROP TABLE command so that it is able to drop those tables. (check-in: 589f3f56 user: drh tags: trunk)
18:24
Make sure sqlite3_data_count() behaves as documented, even for EXPLAIN QUERY PLAN queries. (check-in: d4f95b3b user: drh tags: trunk)
17:56 Edit [5c132592820e9dc2|5c132592]: Mark "Closed". (artifact: f78ac0f5 user: drh)
17:52
Improved handling of OR terms in the WHERE clause with multi-column indexes. (check-in: b23ae131 user: drh tags: trunk)
17:45
Add testcase() macros to ensure good test coverage. (Closed-Leaf check-in: 5c132592 user: drh tags: or-opt)
16:57
Add the SQLITE_FCNTL_OVERWRITE file-control. Used by SQLite to indicate to the OS layer that the current transaction will overwrite the entire file. (check-in: 1da87fcd user: dan tags: trunk)
16:08
More test cases for the OR optimization. (check-in: 4997d8b8 user: drh tags: or-opt)
14:40
Prevent infinite recursion of in the query planner for some pathological test cases by disabling OR-clause processing upon first recursion. (check-in: 9fca05ea user: drh tags: or-opt)
13:33
Begin an effort to enhance the query planner to do a better job with OR terms in the WHERE clause. This change allows ANDs outside of the OR to be factored into the OR terms if that is helpful in finding better indices. (check-in: 876bd21a user: drh tags: or-opt)
12:59
Enhance the sqlite3_data_count() routine so that it can be used to determine if SQLITE_DONE has been seen on the prepared statement. (check-in: 9913996e user: drh tags: trunk)
2011-10-05
19:46
Add the --pageinfo and --stats options to the sqlite3_analyzer utility. (check-in: baa80c7b user: drh tags: trunk)
18:18
Update the sqlite3_analyzer utility program to provide more details about the compression performance of ZIPVFS database files. (check-in: fa5ed532 user: drh tags: trunk)
17:36
Fix test code related to reporting the size of overflow pages in zipvfs databases. (check-in: ad7c9eed user: dan tags: trunk)
15:26
When finding the appropriate file permissions for journal files with SQLITE_ENABLE_8_3_NAMES, ignore "-" characters in the name of the containing directory. (check-in: 328cc186 user: drh tags: trunk)
15:11
Change FTS4 so that if both the content=xxx option and column names are specified, the virtual table assumes that the named columns correspond to columns of table xxx. (check-in: 289ee431 user: dan tags: fts4-content)
06:07
Fix a problem with IO error handling in the rebuild-index code. (check-in: c6ba81fc user: dan tags: fts4-content)
2011-10-04
19:41
Improve test coverage of fts3.c. (check-in: 0f439944 user: dan tags: fts4-content)
16:37
Add tests to check that modifying the schema of an FTS content table does not cause a crash in the FTS module. Also disable the deferred token optimization for content=xxx FTS tables. (check-in: be86c706 user: dan tags: fts4-content)
11:22
Add experimental 'content' option to FTS4. (check-in: 1d27ea74 user: dan tags: fts4-content)
2011-10-03
17:58 Edit [eaf447ea87b0ff29|eaf447ea]: Mark "Closed". Edit check-in comment. (artifact: 44c3c5a9 user: drh)
17:57 Edit [a7e18468825622e5|a7e18468]: Mark "Closed". (artifact: ada7ff27 user: drh)
17:57 Edit [4a153f010037db83|4a153f01]: Mark "Closed". Edit check-in comment. (artifact: 29c0b3bb user: drh)
15:30
Merge the STAT3 changes into trunk. (check-in: 774d0842 user: drh tags: trunk)
2011-10-02
05:23
Update MSVC makefile to allow targets to be built with support for ICU. (check-in: eb5da5e1 user: mistachkin tags: trunk)
2011-09-30
12:19 Closed ticket [c48d99d6]: Crash in "INSERT INTO ... SELECT" when "PRAGMA count_changes=1" is configured plus 2 other changes (artifact: 9fbd73a1 user: dan) ... 2 similar events omitted.
12:01
Disable the xfer optimization if "PRAGMA count_changes=1" is configured. Ticket [c48d99d690]. (check-in: 9ddfe1e4 user: dan tags: trunk)
11:42 New ticket [c48d99d6] Crash in "INSERT INTO ... SELECT" when "PRAGMA count_changes=1" is configured. (artifact: 64346b71 user: dan)
2011-09-28
01:11 Fixed ticket [d1d84037]: import doesn't work on attached databases due to unnecessary quoting plus 2 other changes (artifact: 31182e44 user: drh)
01:10
In the shell, allow arbitrary table names on the ".import" command. Ticket [d1d84037b90a449]. (check-in: f4dd32d3 user: drh tags: trunk)
00:50
Enhance the stat VFS to report out the total size of all pages used by a table, even if the ZIPVFS compression backend is in play. Update the sqlite3_analyzer logic to use these new outputs. (check-in: 19b8eaaf user: drh tags: trunk)
2011-09-27
21:44 Ticket [d1d84037] import doesn't work on attached databases due to unnecessary quoting status still Open with 3 other changes (artifact: e5821bc9 user: rogerb) ... 1 similar event omitted.
13:40
Changes to sqlite3_analyzer to try to avoid integer overflow problems when linking against older versions of TCL. (check-in: 8c846311 user: drh tags: trunk)
2011-09-26
23:07 New ticket [57c971fc] Some user defined string functions do not operate correctly on strings with embedded nuls. (artifact: e916c2f4 user: rogerb)
19:32
Changes to the analyzer script to make it work with zipvfs databases. (check-in: d82cffab user: dan tags: trunk)
2011-09-25
17:49
If an open as read/write fails, do not try to reopen as read-only if in exclusive access mode. (check-in: 263c5fb2 user: drh tags: trunk)
17:47
If an open as read/write fails, do not try to reopen as read-only if in exclusive access mode. (Closed-Leaf check-in: 4a153f01 user: drh tags: stat3-trunk)
2011-09-24
09:54
Fix misc3.test so that it works with OMIT_MERGE_SORT builds. (check-in: 87946c62 user: dan tags: trunk)
05:55
Fix some test files so that they work with SQLITE_OMIT_WAL builds. (check-in: a38668dc user: dan tags: trunk)
2011-09-23
18:58
Add SQLITE_DBSTATUS_CACHE_HIT and _MISS to the ".stat" command in the shell. (check-in: d279e1a3 user: drh tags: trunk)
16:34
Add the -DBUILD_sqlite option to the compiler when building testfixture.exe using the configure script. (check-in: 15a13b6c user: drh tags: trunk)
14:40
Merge the latest trunk changes into the stat3-trunk branch. (check-in: 0beb88a9 user: drh tags: stat3-trunk)
13:59
Testability enhancements. (check-in: be44928c user: drh tags: stat3-trunk)
13:25
Fix typos in the format description comment of analyze.c. (check-in: 74e27fad user: drh tags: stat3-trunk)
2011-09-22
20:52
Remove the restriction on the number of entries per index in sqlite_stat3. (check-in: 374343c8 user: drh tags: stat3-trunk)
18:46
Fix an issue in ANALYZE when STAT3 is disabled but both sqlite_stat2 and sqlite_stat3 tables exist. Also add testability tweaks to the STAT3 code. (check-in: 3ca7e449 user: drh tags: stat3-trunk)
15:31
Remove a redundant (and undefined) "forcedelete" command from corruptE.test. (check-in: 6d8d4e16 user: dan tags: trunk)
15:05 Edit [646db971885bb7b6|646db971]: Mark "Closed". (artifact: d5423142 user: drh)
14:56
Remove the SQLITE_PAGECACHE_BLOCKALLOC compilation option. (check-in: 4eb46898 user: dan tags: trunk)
14:41
Add the SQLITE_DB_STATUS_CACHE_HIT and MISS options. For querying the number of cache hits and misses on a per-connection basis. (check-in: 5100b6e9 user: dan tags: trunk)
14:18 Edit [646db971885bb7b6|646db971]: Move to branch mistake. Change background color to "#e0e0e0". (artifact: e13d2642 user: dan)
14:17 Edit [646db971885bb7b6|646db971]: Cancel tag "trunk". (artifact: 1f7ba885 user: dan)
03:13 Edit [892723575c033ed3|89272357]: Mark "Closed". (artifact: 1647fb22 user: drh)