SQLite
Timeline
Not logged in

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

50 most recent timeline items

2016-10-25
19:39
[f7f78147c5] Leaf: Simplifications to faststat1.c. Fix a bug in sqlite3MovetoProportional() for very large b-trees. (user: drh, tags: est_count_pragma)
19:21
[b051fd19bc] Further refinements to the faststat1.c utility. (user: drh, tags: est_count_pragma)
18:28
[65444f2e35] Enhance faststat1.c to deal better with WITHOUT ROWID tables. (user: drh, tags: est_count_pragma)
17:28
[c3570e462a] Merge recent trunk changes, and especially the PRAGMA index_info enhancement which is needed on this branch. (user: drh, tags: est_count_pragma)
15:39
[fe49fb0313] Leaf: Enhance the "PRAGMA index_info" and "PRAGMA index_xinfo" statements so that they work on WITHOUT ROWID tables and provide information about the underlying index btree that implements the WITHOUT ROWID table. (user: drh, tags: index-info-on-table)
15:06
[b115856408] Leaf: Add test case to demonstrate a "BEGIN EXCLUSIVE" command returning SQLITE_BUSY_SNAPSHOT. (user: dan, tags: trunk)
13:57
[7b83581a43] First attempt at a utility program to compute sqlite_stat1 without doing a full table scan. (user: drh, tags: est_count_pragma)
2016-10-24
01:01
[98795c2dd9] Performance optimization in moveToRoot(). Avoid repeated validity checking of the root page on each call. Once is enough. (user: drh, tags: trunk)
2016-10-22
01:22
[5f3e602831] In the sessions module, avoid recording a change if an UPDATE statement overwrites a column with REAL affinity containing an integer value with the same value. (user: drh, tags: trunk)
2016-10-21
21:21
[b861328ab9] Closed-Leaf: In the sessions module, avoid recording a change if an UPDATE statement overwrites a column with REAL affinity containing an integer value with the same value. (user: dan, tags: sessions-fix)
18:01
[04fe12b590] When reading from an index, the shared-cache lock must be on the corresponding table. (user: drh, tags: est_count_pragma)
17:45
[0c8a5b8844] Merge updates from trunk, and especially the ".mode quote" enhancement to the shell. (user: drh, tags: est_count_pragma)
17:39
[c4f5fa78cd] Add ".mode quote" to the command-line shell. (user: drh, tags: trunk)
17:25
[affc2ef5ee] Add the btree_sample(INDEX,LOCATION,LIMIT) pragma. (user: drh, tags: est_count_pragma)
15:36
[c39fd9b8f1] Fix problems in the est_count pragma for indexes and WITHOUT ROWID tables. (user: drh, tags: est_count_pragma)
10:49
[b54c15f117] Avoid using the "direct overflow read" optimization to read large blobs if the pager layer has a wal file open - even if the database header indicates that the db is not a wal database. (user: dan, tags: trunk)
10:09
[b7d9727bff] If SQLITE_DIRECT_OVERFLOW_READ is defined at compile time, add "DIRECT_OVERFLOW_READ" to the list of symbols returned by "PRAGMA compile_options". (user: dan, tags: trunk)
2016-10-20
22:02
[340822afbe] Experimental est_count pragma. (user: drh, tags: est_count_pragma)
18:20
[fd81d8a430] Leaf: Add the ability for the PRAGMA statement to accept multiple arguments. Currently all arguments other than the first are ignored. (user: drh, tags: multi-arg-pragma)
11:48
[fd9c6ff05f] Add test case to incrblob4.test. No changes to code. (user: dan, tags: trunk)
2016-10-18
16:36
[56474ebca3] Minor simplification of the comparison opcodes. (user: drh, tags: trunk)
15:29
[2aa7a03b86] Fix harmless uninitialized variable warnings in speedtest1.c. (user: drh, tags: trunk)
14:35
[6ca0e06b21] Add the --repeat option to speedtest1.c and speed-check.sh. (user: drh, tags: trunk)
2016-10-17
23:44
[29997f797f] Leaf: Fix SQLITE_DBCONFIG_REQUIRE_TXN so that it allows BEGIN IMMEDAITE and BEGIN EXCLUSIVE to run outside of a transaction. (user: drh, tags: require-write-txn)
19:00
[a3a96c4da3] Leaf: Escape non-ASCII character from an ICU extension comment. Cherrypick of [5ec02ecf3d20ce7e]. (user: mistachkin, tags: mutexDbg)
18:59
[2fb9a5dd40] Enhancments to Win32 mutex debugging. (user: mistachkin, tags: mutexDbg)
18:44
[5ec02ecf3d] Escape non-ASCII character from an ICU extension comment. (user: mistachkin, tags: trunk)
18:33
[3d89dc4544] Corrections to a couple recently added 'filectrl.test' results. (user: mistachkin, tags: trunk)
15:28
[c88d36e251] Changes to support interrupting a checkpoint using sqlite3_interrupt(). (user: dan, tags: trunk)
00:48
[cda998f080] Small size reduction and performance increase in the string duplicator. (user: drh, tags: trunk)
2016-10-15
18:37
[16d88a9077] Add documentation for the OP_SorterInsert opcode, formerly omitted by mistake. No changes to code. (user: drh, tags: trunk)
08:56
[2674d779f5] Add test case to hook.test. No changes to non-test code. (user: dan, tags: trunk)
2016-10-14
21:27
[16039be373] Add the SQLITE_FCNTL_WIN32_GET_HANDLE file control. (user: mistachkin, tags: trunk)
21:16
[aa6de9c40b] Bump the version number in anticipation of the next development cycle. (user: drh, tags: trunk)
10:20
[707875582f] Version 3.15.0 (user: drh, tags: trunk, release, version-3.15.0)
2016-10-13
12:56
[4d66ac98de] Take care to avoid integer overflow when doing the initial page cache allocation with an excessively large cache_size setting. (user: drh, tags: trunk)
2016-10-12
18:55
[443913d582] Avoid reading the -1-th element of an array in the query planner. Fix to a bug introduced by check-in [8e2b25f9b8a7] from earlier today. Curiously, the problem only appeared on 32-bit systems. (user: drh, tags: trunk)
18:26
[e87d02d289] Add to sqlite3_analyzer command-line options --version and --tclsh, and also the undocumented --debug option. (user: drh, tags: trunk)
15:35 • Fixed ticket [96c1454cbf]: Incorrect result with ORDER BY DESC and LIMIT (again) plus 5 other changes (user: drh)
15:15
[61f0526978] New testcase() macros to ensure coverage of the ORDER BY LIMIT optimization code in where.c. (user: drh, tags: trunk)
14:48
[8e2b25f9b8] Fix a problem affecting queries that match the pattern (... WHERE ipk IN (....) ORDER BY ? LIMIT ?). Fix for [96c1454c]. (user: dan, tags: trunk)
14:00 • New ticket [96c1454cbf] Incorrect result with ORDER BY DESC and LIMIT (again). (user: drh)
2016-10-10
14:48
[6624c4964b] Remove a stray line from session4.test causing a memory leak. No changes to SQLite code. (user: dan, tags: trunk)
14:38 • Closed ticket [4766f44486]: ORDER BY handling with indexes on expressions plus 6 other changes (user: dan)
14:34
[aebe429e52] When handling ORDER BY expressions, do not assume all values of an indexed expressions are distinct. Fix for [4766f444]. (user: dan, tags: trunk)
14:20 • New ticket [4766f44486] ORDER BY handling with indexes on expressions. (user: dan)
14:18 • Fixed ticket [4baa464912]: NULL handling for indexes on expressions plus 5 other changes (user: drh)
13:29
[71797ba431] Make sure indexes on expressions skip over initial NULL values in the index. Fix for ticket [4baa464912129477f3c9] (user: drh, tags: trunk)
13:05 • New ticket [4baa464912] NULL handling for indexes on expressions. (user: drh)
10:06
[788f86bebe] Fix a case in which the rtree module was ignoring an OOM while generating an error message. (user: dan, tags: trunk)