/ Timeline
Login
SQLite training in Houston TX on 2019-11-05 (details)
Part of the 2019 Tcl Conference

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

100 ancestors of [a9c81815]

2014-05-09
23:31
Further MSVC makefile changes to support Windows Phone 8.1. check-in: a9c81815 user: mistachkin tags: vsixWinPhone81
20:54
Merge updates from trunk. check-in: f4fea7bb user: mistachkin tags: vsixWinPhone81
20:51
When cross-compiling with the MSVC makefile, make sure the correct library path is used. Also, keep track of the required compilation options separately. check-in: c3dce2e7 user: mistachkin tags: trunk
2014-05-07
21:16
Include sqlite3rtree.h in the tsrc/ pile of source files during target_source in the main.mk makefile. check-in: 116bed5a user: drh tags: trunk
20:33
Remove a superfluous variable initialization. check-in: 68766f83 user: drh tags: trunk
20:24
A better fix for the group_concat() problem. check-in: 1c086dee user: drh tags: trunk
19:59
Fix the way parenthesis in MATCH expressions are handled by FTS if the tokenizer considers them to be token characters. check-in: e21bf7a2 user: dan tags: trunk
18:23
Make sure the group_concat() function returns an empty string, not a NULL, if it has at least one input row. Fix for ticket [55746f9e65f8587]. check-in: d01cedaa user: drh tags: trunk
18:21
Ensure that the sqlite3StrAccumAppend() routine is never called with a NULL second argument. Doing so is harmless when N==0, but it causes an assert() to fail that was placed to quiet static analyzers. Closed-Leaf check-in: f03fbf37 user: drh tags: tkt-55746f9e
17:19
Make sure the group_concat() function returns an empty string, not a NULL, if it has at least one input row. Fix for ticket [55746f9e65f8587]. check-in: 0deac873 user: drh tags: tkt-55746f9e
15:46
Add the SQLITE_IOCAP_IMMUTABLE bit as a possible return value from the xDeviceCharacteristics method in the VFS. Add the "nolock" and "immutable" query parameters to URI filenames. check-in: 1a0d7d3d user: drh tags: trunk
15:32
Fix nolock and immutable so that they work even if READONLY is requested. Closed-Leaf check-in: e193aced user: drh tags: win32-none
15:09
Add test cases and documentation for the nolock and immutable query parameters. check-in: 19d56cba user: drh tags: win32-none
2014-05-06
21:37
Merge updates from trunk. check-in: 69698ae9 user: mistachkin tags: vsixWinPhone81
21:37
Update the template VSIX package file as well. check-in: 99d96765 user: mistachkin tags: trunk
21:30
Merge updates from trunk. check-in: 7579c44a user: mistachkin tags: vsixWinPhone81
21:26
Enhance the VSIX package creation tool to better support Visual Studio 2013. check-in: c1fb04f6 user: mistachkin tags: trunk
00:09
Refactor VSIX package creation tool to better support Visual Studio 2013. check-in: 8be166af user: mistachkin tags: vsixWinPhone81
2014-05-05
22:50
Merge updates from trunk. check-in: 668ed76a user: mistachkin tags: vsixWinPhone81
22:43
When building for Windows 8.0 using Visual Studio 2013, make sure the cross-compilation native library path is set correctly. check-in: c1ab9092 user: mistachkin tags: trunk
21:08
More modularization work on the MSVC batch build tool. check-in: 9a06773a user: mistachkin tags: trunk
20:35
Merge updates from trunk. check-in: eaa8fc81 user: mistachkin tags: vsixWinPhone81
20:32
Create new header file "os_setup.h" used to detect the operating system at compile-time, and "os_win.h" that contains windows-specific header in formation. check-in: bd92e0f8 user: drh tags: trunk
20:24
Work on cleaning up the MSVC batch build tool integration with Visual Studio 2013. check-in: b5a72dfd user: mistachkin tags: trunk
20:21
Attempt to fix the build on beagleboard. Closed-Leaf check-in: 3ac75725 user: drh tags: winHdr
18:24
Centralize and reform use of the Win32 related include files. check-in: 857f2baf user: mistachkin tags: winHdr
17:49
Merge updates from trunk. check-in: 6f07f20e user: mistachkin tags: vsixWinPhone81
17:45
Merge updates from trunk. check-in: a3cfd813 user: mistachkin tags: winHdr
17:43
Fix several header file comments. No changes to code. check-in: dd6eb5d1 user: mistachkin tags: winHdr
2014-05-02
22:39
Enhance the Win32 VFS I/O retry logic. check-in: 47605043 user: mistachkin tags: trunk
21:42
Merge updates from trunk. Closed-Leaf check-in: 598a3875 user: mistachkin tags: winIoRetry
21:38
Merge updates from trunk. check-in: c4d1d8a0 user: mistachkin tags: winHdr
14:54
Fix a broken test case in fuzz.test. check-in: faa46935 user: dan tags: trunk
00:09
Add a comment explaining why WhereLoop cost adjustments are omitted for skip-scan loops. check-in: 3bc43594 user: drh tags: trunk
2014-05-01
20:26
Fix an obscure problem to do with temp register allocation that could occur if more than one simple SELECT within a compound SELECT uses a partial sort. check-in: 427409ae user: dan tags: trunk
20:24
Add #ifdefs for test coverage. Add a testcase(). check-in: be2702ce user: drh tags: trunk
10:19
Update a test case in wal2.test that explicitly corrupts a checksum in the wal file to account for the fact that the first byte of said checksum may initially be 0xFF. check-in: 2b935bde user: dan tags: trunk
01:49
Take out the special handling of nolock=true in os_win.c and add it to pager.c, so that it works for all VFSes. Add the pPager->noLock boolean for clarity. check-in: 725c1c14 user: drh tags: win32-none
01:20
Avoid unnecessary xUnlock operations on temp file. check-in: 1829c38c user: drh tags: win32-none
01:13
Add the immutable=TRUE query parameter and SQLITE_IOCAP_IMMUTABLE, either of which prevents locking of the database and omits tests for existance of journal files. check-in: 71f152c8 user: drh tags: win32-none
2014-04-30
20:32
Merge in all recent changes and enhancements from trunk. check-in: 84243f84 user: drh tags: win32-none
18:11
Fix a problem in calculating the costs of "OR" scans. check-in: 9bbca48b user: dan tags: trunk
15:22
Modify the way the costs of various query plans are estimated. If the user supplies a likelihood() value (or equivalent) on an indexed WHERE constraint, use it to estimate the number of index rows visited. check-in: 90e36676 user: dan tags: trunk
15:00
Add text to the header comment of whereLoopAddBtree() describing how the costs of various b-tree loops are estimated. Closed-Leaf check-in: 05e6e16c user: dan tags: experimental-costs
14:53
Update a couple of test cases to account for the fact that this branch prefers an index scan and partial sort over a full-table scan and full external sort. check-in: 9b975bf3 user: dan tags: experimental-costs
14:47
Fix a couple of out-of-date comments in where.c. check-in: eefeda32 user: dan tags: experimental-costs
14:22
Improved rendering of LogEst values corresponding to real values near 0.0 in the tool/logest.c utility program. check-in: 32910c8c user: drh tags: experimental-costs
13:19
Fix long-standing typos in comments. check-in: b9f91317 user: drh tags: experimental-costs
2014-04-29
19:01
Test that the default values used when sqlite_stat1 data is not available are calculated correctly. Fixes for the same. check-in: e2d42f90 user: dan tags: experimental-costs
16:46
Merge trunk changes into this branch. check-in: d74299f0 user: dan tags: experimental-costs
16:10
Ignore likelihood() values on indexed IPK lookups. check-in: 5bb7757a user: dan tags: experimental-costs
12:01
Fix a test case so that it updates sqlite_stat1 consistently. check-in: 2dc5a0b5 user: dan tags: experimental-costs
2014-04-28
20:11
Do not reduce the number of rows scanned at all for "IS NOT NULL" constraints. Fix a bug in calculating the number of rows visited by scans of partial indicies. check-in: a8ae93f0 user: dan tags: experimental-costs
19:34
The trunk assumes that an open range constraint on an indexed term (col>?) term matches 1/4 of the indexed rows, and that a closed constraint (col BETWEEN ? AND ?) matches 1/64. Change this branch to do the same. check-in: 4047ac75 user: dan tags: experimental-costs
17:56
Add the sqlite3_rtree_query_callback() API to the RTree virtual table. (Cherrypick from the sessions branch.) check-in: af2cbe64 user: drh tags: trunk
15:11
Update unordered.test to take into account for the fact that SQLite now prefers a full-table scan over a non-covering index scan that visits a large percentage of the table rows. check-in: 20f468df user: dan tags: experimental-costs
12:08
Add an extra column to a table in analyze9.test to give the planner a little more reason to select an index. check-in: 1b95544f user: dan tags: experimental-costs
10:00
Update test script analyze3.test to account for the fact that SQLite now prefers a full-table scan over a non-covering index scan that visits a large percentage of the table rows. check-in: 35f46a55 user: dan tags: experimental-costs
09:35
Modify internal function whereLoopAdjustCost() so that it does not prefer a skip-scan over a regular index scan even if the regular scan uses a subset of the WHERE terms used by the skip-scan. check-in: 88a5758d user: dan tags: experimental-costs
08:49
Fix an error in estimating of the number of rows visited by a range scan. check-in: d491de62 user: dan tags: experimental-costs
2014-04-26
20:21
Fix an sqlite3_stmt_status() problem caused by recent changs on this branch. check-in: dee20409 user: dan tags: experimental-costs
19:23
Update requirements marks to fix typos in the requirements text. No changes to code. check-in: f5a26365 user: drh tags: trunk
17:52
Allow the xfer optimization to proceed if the DEFAULT on the very first column of the two tables is different. This is a refinement of the fix for ticket [f67b41381a]. check-in: 349f4834 user: drh tags: trunk
14:07
Avoid transfering records between tables unless the default values for all columns are the same. Fix for [f67b41381a]. check-in: f8c4c495 user: dan tags: trunk
2014-04-25
20:22
If the user provides likelihood() data for a WHERE clause term used as part of an index key, have the planner use it when calculating the expected number of rows visited by the loop. check-in: c51efaa5 user: dan tags: experimental-costs
17:37
Add test cases to ensure correct operation of joins with a virtual table that include DISTINCT and ORDER BY clauses. Verification for ticket [388d01d4bb8f9]. check-in: 5ada136f user: drh tags: trunk
15:01
Store values loaded from the stat1 table as logarithmic values in memory. check-in: 1bd74c49 user: dan tags: experimental-costs
14:42
Make sure ORDER BY clauses on joins that involve virtual tables and that have a DISTINCT clause work correctly. This is a candidate fix for ticket [388d01d4bb8f9]. Test cases for that ticket will be checked in separately. check-in: 17113812 user: drh tags: trunk
12:35
When VDBE_PROFILE is enabled, ignore negative opcode times, which sometimes occur, perhaps due to context swaps. check-in: 4e88042f user: drh tags: trunk
2014-04-24
20:04
Changes to the way the planner calculates the costs of various table and index scans. Some test cases still failing. check-in: c5a6ec0a user: dan tags: experimental-costs
2014-04-22
19:42
Change from using the win32-none VFS to just a query parameter. check-in: ffceacf6 user: drh tags: win32-none
19:34
Add some OSTRACE calls for consistency. check-in: be292d55 user: mistachkin tags: win32-none
19:30
Add the win32-none VFS which omits rollback-journal locking. check-in: 03e3c5a8 user: drh tags: win32-none
2014-04-21
18:00
Preliminary changes to support building VSIX packages for Windows 8.0 and Windows Phone 8.0 using Visual Studio 2013. check-in: 3bf97c81 user: mistachkin tags: vsixWinPhone81
13:36
Comment tweaks on the test case for the [b75a9ca6b0] bug fix. check-in: 65d2544a user: drh tags: trunk
13:21
Avoid discarding an ORDER BY clause in the case where an identical GROUP BY clauses uses an index to group, but not sort, the rows. Fix for [b75a9ca6b0]. check-in: de9a490f user: dan tags: trunk
2014-04-18
22:20
Clean up the proper-subset cost adjustment logic to make it more compact and easier to read and so that full branch test coverage is more easily obtained. check-in: 9a5d38c7 user: drh tags: trunk
00:49
Add the SQLITE_RUNTIME_BYTEORDER compile-time option to force SQLite to check the processor byte-order at run-time. Add additional compile-time byte order checks for ARM, PPC, and SPARC. check-in: 2c536387 user: drh tags: trunk
00:08
Preliminary changes to support building VSIX packages for Windows Phone 8.1. check-in: a1b2f28b user: mistachkin tags: vsixWinPhone81
00:06
Add the SQLITE_TESTCTRL_BYTEORDER test control to interrogate SQLite's notion of the processor byte order and whether the byte order is known at compile-time or determined at run-time. check-in: 9c696196 user: drh tags: trunk
2014-04-14
19:48
Make sure the undocumented sqlite_rename_parent() function does not crash even if it is invoked with NULL arguments. Ticket [264b970c4379fd4b94] check-in: c6fa8d0d user: drh tags: trunk
2014-04-13
19:28
Remove the unused second argument from sqlite3ExprCachePop(). Add an ALWAYS() on an always-true conditional in sqlite3VdbeResolveLabel(). check-in: ab23abf3 user: drh tags: trunk
19:15
Make sure column cache elements are cleared correctly when jumping over code for key generation in a partial index. Fix for ticket [2ea3e9fe6379fc3f6]. check-in: 3122b836 user: drh tags: trunk
2014-04-10
02:24
Modify the OR-clause handling so that it can safely deal with OR-clause with 17 or more terms. Fix for ticket [10fb063b1179be53ea0b53bb]. check-in: a67b5312 user: drh tags: trunk
2014-04-04
18:49
Performance improvements when reading large blobs, especially if SQLITE_DIRECT_OVERFLOW_READ is defined. check-in: 2312eb6a user: drh tags: trunk
18:20
Merge changes to the query planner that strive to ensure that any index usage that is a proper subset of some other index usage always has a slightly higher cost. check-in: 683dd379 user: drh tags: trunk
14:12
Ensure the "PRAGMA journal_mode=WAL" works coming from any other journal_mode with ATTACH-ed databases. check-in: e54330b4 user: drh tags: trunk
2014-04-03
16:29
Use OP_Copy instead of OP_SCopy when moving results out of a subquery, to prevent the subquery results from changing out from under the outer query. Fix for ticket [98825a79ce1456]. Problem introduced by check-in [1e64dd782a126f48d78]. check-in: d5513dfa user: drh tags: trunk
14:31
Fix a typo in the "Synopsis:" comment for the OP_VFilter opcode. check-in: 48ecdd4a user: drh tags: trunk
00:32
In the command-line shell, run set writable_schema before running the ".clone" command. check-in: 9d2ae634 user: drh tags: trunk
2014-04-01
01:24
Remove an unnecessary conditional, replacing it with an assert(). Improvements to comments. Closed-Leaf check-in: 834bf1c3 user: drh tags: overflow-pgno-cache
2014-03-31
23:57
Fix a compiler warning when SQLITE_DIRECT_OVERFLOW_READ is defined. Minor performance enhancement and size reduction. check-in: 96385dc4 user: drh tags: overflow-pgno-cache
22:03
Merge in the latest changes and fixes from trunk. check-in: f6211540 user: drh tags: overflow-pgno-cache
20:05
Remove an unnecessary conditional. Closed-Leaf check-in: 7473c4df user: drh tags: query-plan-experiments
19:49
Also make sure an index that is a proper subset of some other index has a higher cost than that other index. Add test cases. check-in: b7830d23 user: drh tags: query-plan-experiments
18:24
Make sure that an index that covers a proper superset of the WHERE clause terms of some other index has a lower cost than the other index. check-in: ea8b0910 user: drh tags: query-plan-experiments
13:42
Avoid a (harmless) buffer overread that is possible on an OOM when MEMSYS5 is engaged. check-in: b3296267 user: drh tags: trunk
2014-03-29
21:16
Experiments in picking better query plans, especially when the usage of one index is a subset of another. check-in: 8f869ca7 user: drh tags: query-plan-experiments
2014-03-28
14:41
Disable the wal64k.test script for non-unix systems since it depends on unix-only features. check-in: 27deb6e4 user: drh tags: trunk
12:56
Fix a harmless compiler warning. check-in: a4e47150 user: drh tags: trunk
03:12
Enhance the sqlite3VdbeRecordCompare() routines so that if they encounter database corruption, they will set the UnpackedRecord.isCorrupt field and return 0. The sqlite3BtreeMovetoUnpacked() routine detects this and returns SQLITE_CORRUPT, causing the corruption to be reported back to the top-level. check-in: 7fa85eaa user: drh tags: trunk