/ Timeline
Login

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

50 check-ins occurring around a65a62893ca8319e.

2017-01-11
16:52
Attempt to detect physical sector sizes on Windows 8 and higher. check-in: 381fd34b97 user: mistachkin tags: winSectorSize
15:42
Fix a problem preventing UPDATE statements that use a range-scan on the PK index of a WITHOUT ROWID table from using a one-pass strategy. check-in: cab86c9094 user: dan tags: onepass-update
14:21
In the STAT4 computations, ensure that the aAvgEq values do not go negative. check-in: 4f83f6806a user: drh tags: branch-3.8.9
14:15
In the STAT4 computations, ensure that the aAvgEq values do not go negative. check-in: f58f75b5a0 user: drh tags: trunk
2017-01-10
20:04
Changes to allow some multi-row UPDATE statements to avoid the two-pass approach. check-in: 46db23ccd1 user: dan tags: onepass-update
17:37
Add a test case for ticket [25e335f802dd]. check-in: e500c15a9f user: dan tags: trunk
17:33
Throw an error if the ON clause of a LEFT JOIN references tables to the right of the ON clause. Fix for ticket [25e335f802dd]. check-in: c92ecff2ec user: drh tags: trunk
16:09
Avoid unnecessary calls to the xRoundup() method of the memory allocator when the soft heap limit is not set. check-in: 4209b89eab user: drh tags: trunk
15:08
Fix a potential assertion fault discovered by OSS-Fuzz. check-in: 71c03b59b6 user: drh tags: trunk
2017-01-09
20:57
Merge latest changes from trunk, and also move the perf-counter into the inner loop of sqlite3BtreeMovetoUnpacked(). Leaf check-in: ff9eab9587 user: drh tags: vdbe-aux-perf
19:55
Remove a redundant assignment statement. check-in: a5fa09657b user: drh tags: trunk
19:27
Performance optimization and size reduction in the OP_Variable opcode. check-in: 237aa97452 user: drh tags: trunk
18:22
Fix typo in a comment. No changes to code. check-in: d38fd22935 user: mistachkin tags: trunk
18:20
Try to move OP_Concat operations outside the inner loop. This turns out to make things very slightly slower, at least in speedtest1.c. Closed-Leaf check-in: 8a90f69139 user: drh tags: failed-optimization
15:44
Modify the OP_RowData opcode so that when P3!=0 it is allowed to hold an ephemeral copy of the content. This avoids unnecessary memcpy() operations in the xfer-optimization and VACUUM. check-in: 6e106acd74 user: drh tags: trunk
13:43
Add the SQLITE_UINT64_TYPE compile-time option. check-in: a5fe03bc41 user: drh tags: trunk
07:00
Merge the "changebatch" functionality into this branch. check-in: 50fb1eb368 user: dan tags: begin-concurrent
06:53
Disable the optimization from [8cb8516d] (omit TableLock instructions for non-sharable databases) on this branch. This branch uses the TableLock instructions to ensure that the db schema is not written from within a BEGIN CONCURRENT transaction. check-in: c8ca3e0a8d user: dan tags: begin-concurrent
06:33
Upgrade this branch to 3.16 plus the various fixes that appeared after its release. check-in: d0e212d08f user: dan tags: begin-concurrent
2017-01-07
14:47
Improvements to the iIdxNoSeek optimization of sqlite3GenerateRowDelete() so that it is automatically disabled for BEFORE triggers but works in all other cases. check-in: 3178ec4c27 user: drh tags: trunk
14:26
Critical fix to the previous check-in so that it works when there are BEFORE triggers that move the cursor before the OP_Delete has a chance to be applied. check-in: db2c0960ff user: drh tags: trunk
03:26
Avoid an unnecessary btree seek while deleting an index entry due to a conflict on a REPLACE operation. check-in: f0495c5133 user: drh tags: trunk
00:56
Avoid duplicate b-tree searches in the duplicate row detector used to implement DISTINCT. check-in: d577dda0a7 user: drh tags: trunk
00:42
This hack illustrates how to use the VDBE_PROFILE mechanism to show which bytecode operators are using resources other than time. In this case, the number of loops through the binary search code in sqlite3BtreeMovetoUnpacked() is measured, for the purpose of helping to identify unnecessary btree searches. check-in: 746b183683 user: drh tags: vdbe-aux-perf
2017-01-06
17:01
Merge the changes for version 3.16.2. check-in: c59c888023 user: drh tags: apple-osx
16:32
Version 3.16.2 Leaf check-in: a65a62893c user: drh tags: release, version-3.16.2, branch-3.16
13:53
Clarify the documentation on sqlite3_column_count(). check-in: 01b4cb2676 user: dan tags: branch-3.16
13:52
Ensure that "PRAGMA case_sensitive_like" and "PRAGMA shrink_memory" set the number of output columns to 0 (as they are statements that return no data). check-in: 4a97ba4ee0 user: dan tags: branch-3.16
13:49
Ensure that "PRAGMA case_sensitive_like" and "PRAGMA shrink_memory" set the number of output columns to 0 (as they are statements that return no data). check-in: 6696cd1878 user: dan tags: trunk
11:56
Improve handling of corrupt databases in fts5. check-in: b07269413d user: dan tags: branch-3.16
11:55
Improve handling of corrupt data in fts5. check-in: 609ac1c73f user: dan tags: trunk
01:09
Clarify the documentation on sqlite3_column_count(). check-in: 9ea0baddd8 user: drh tags: trunk
00:02
Remove several non-portable tests for the deprecated temp_store_directory PRAGMA. check-in: 28d8778914 user: mistachkin tags: trunk
2017-01-05
20:01
Ensure that sqlite3_column_count() returns 0 for the "set" mode of "get/set" PRAGMA statements that do not return a value in that case (e.g. page_size, cache_size, auto_vacuum). check-in: e745da6b14 user: dan tags: branch-3.16
20:00
Ensure that sqlite3_column_count() returns 0 for the "set" mode of "get/set" PRAGMA statements that do not return a value in that case (e.g. page_size, cache_size, auto_vacuum). check-in: 2f57939a55 user: dan tags: trunk
19:32
Ensure that sqlite3_column_count() returns 0 for the "set" mode of "get/set" PRAGMA statements that do not return a value in that case (e.g. page_size, cache_size, auto_vacuum). Closed-Leaf check-in: 5c05d8ec5e user: dan tags: pragma-columncount-fix
17:27
Version 3.16.2 second release candidate check-in: 285c5a54dd user: drh tags: branch-3.16
17:25
Fix handling the case where a sub-query in a FROM clause is itself a UNION ALL, and one side of that UNION ALL is a query on a view that includes an ORDER BY. Fix for ticket [190c2507]. check-in: ec1e85a657 user: dan tags: branch-3.16
17:23
Fix handling the case where a sub-query in a FROM clause is itself a UNION ALL, and one side of that UNION ALL is a query on a view that includes an ORDER BY. Fix for ticket [190c2507]. check-in: 590ca83b8e user: dan tags: trunk
15:50
Version 3.16.2 release candidate check-in: 9d8ffe13bd user: drh tags: branch-3.16
14:05
Increase the version number to 3.16.2 check-in: 9592cbcf35 user: drh tags: branch-3.16
13:56
Fix problems in trigger and foreign key handling when doing REPLACE on a WITHOUT ROWID table that has no secondary indexes. Fix for ticket [30027b613b4]. check-in: 8a788594e2 user: drh tags: branch-3.16
13:52
Ensure that the sqlite3_value_text() interface returns a buffer that is long enough to hold the complete string plus the zero terminator even when the input is a zeroblob. Fix for a problem detected by OSS-Fuzz. check-in: ca185808ad user: drh tags: branch-3.16
13:50
Fix problems in trigger and foreign key handling when doing REPLACE on a WITHOUT ROWID table that has no secondary indexes. Fix for ticket [30027b613b4]. check-in: 571f166ea8 user: drh tags: trunk
07:58
Ensure that the sqlite3_value_text() interface returns a buffer that is long enough to hold the complete string plus the zero terminator even when the input is a zeroblob. Fix for a problem detected by OSS-Fuzz. check-in: 2dc7eeb5b4 user: drh tags: trunk
06:57
Fix some problems with foreign key processing within REPLACE ops on WITHOUT ROWID tables with no triggers or auxiliary indexes. Closed-Leaf check-in: c1220b1af6 user: dan tags: replace-fix
2017-01-04
22:02
Improved the comment on the block of code the provides the performance optimization originally added by check-in [925840cfdb]. The original check-in omitted condition 4, which was the cause of bug [30027b613b]. check-in: c6506b82aa user: drh tags: replace-fix
20:13
Possible fix for [30027b61]. There may still be problems surrounding foreign key processing. check-in: 71ccb1f4c4 user: dan tags: replace-fix
14:53
Adjust filename creation in test_sqllog.c so that it uses leading zeros on counters, so that files appear in order when sorted lexicographically. check-in: 8d67097359 user: drh tags: trunk
13:09
Performance enhancements in the printf implementation. check-in: 82e4001b8c user: drh tags: trunk