Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
57 check-ins using file test/pager1.test version 07116f72
|
2012-12-14
| ||
| 15:36 | Fix the virtual table IN optimizer so that it work even if the virtual table implementation leaves the sqlite3_index_info.aConstraintUsage[].omit flag clear for an equality constraint that it intends to use. (check-in: d6e045f8 user: drh tags: vtab-IN-opt) | |
|
2012-11-09
| ||
| 18:32 | Take into account the cost of inner loops when selecting which table of a join to use for the next outer loop. (check-in: 3f87f459 user: drh tags: trunk) | |
| 18:22 | Disable the table selection rule that tried to prevent full table scans from migrating to the outer loop unless they were optimal. The new scaling of outer-loop costs by cost of inner loops obviates the need for that step. And, in fact, that step causes problems with the new inner-loop cost accounting. (Closed-Leaf check-in: 51bfd63b user: drh tags: inner-loop-cost) | |
| 17:59 | Try to take into account the cost of inner loops when selecting which table of a join to use for the outer loop. (check-in: 94255634 user: drh tags: inner-loop-cost) | |
|
2012-11-06
| ||
| 20:39 | Adjust the SQLITE_DBSTATUS_STMT_USED calculation to take the modified usage of sqlite3VdbeClearObject() into account. (check-in: 82eb7ead user: mistachkin tags: trunk) | |
| 18:41 | In test_quota.c, provide a work-around for the missing _chsize_s() function in mingw. (check-in: 6b4979e8 user: drh tags: trunk) | |
|
2012-11-05
| ||
| 13:51 | Add the INSTR() SQL function. (check-in: a4c181cb user: drh tags: trunk) | |
|
2012-11-02
| ||
| 23:42 | Merge the fix for ticket [bfbf38e5e9956ac6] into trunk. (check-in: 4f7dfc32 user: drh tags: trunk) | |
| 19:08 | Adding test cases for ticket [bfbf38e5e9956a] (Closed-Leaf check-in: 62ebfa74 user: drh tags: ticket-bfbf38e5e9) | |
| 18:48 | Proposed fix for ticket [bfbf38e5e9]. (check-in: 18ae030d user: drh tags: ticket-bfbf38e5e9) | |
| 18:24 | Fix an out-of-date comment. No changes to code. (check-in: 10cc12b1 user: drh tags: trunk) | |
|
2012-10-30
| ||
| 21:03 | Pull all the latest trunk enhancements into the sessions branch. (check-in: fce667f2 user: drh tags: sessions) | |
| 18:09 | Enable the use of coroutines as an alternative to manifesting views used in a FROM clause. (check-in: 9dca18f5 user: drh tags: trunk) | |
| 15:31 | Make sure that the optimizer never tries to create an automatic index on a coroutine subquery. (Closed-Leaf check-in: f83aa0de user: drh tags: subquery-as-coroutine) | |
| 14:44 | Fix a typo in the header comment for the OpenPseudo opcode. (check-in: 4f106123 user: drh tags: subquery-as-coroutine) | |
| 14:39 | Make it possible to disable the subquery-by-coroutine optimization using sqlite3_test_control(). Remove an always-false conditional. (check-in: 564631f3 user: drh tags: subquery-as-coroutine) | |
| 00:29 | Add an optimization that attempts to run a subquery as a coroutine rather than manifesting it into a temporary table. (check-in: 7af3acbb user: drh tags: subquery-as-coroutine) | |
|
2012-10-29
| ||
| 14:27 | Make the multiplexor and the IntArray extensions callable from C++. (check-in: cbd8fddf user: drh tags: trunk) | |
|
2012-10-28
| ||
| 19:35 | Merge VSIX tooling and packaging enhancements to trunk. (check-in: 99f27d64 user: mistachkin tags: trunk) | |
|
2012-10-26
| ||
| 19:22 | Fix a 32-bit integer overflow problem that could cause an error in a CREATE INDEX statement that writes more than 16GB of data. (check-in: e24ba5be user: dan tags: trunk) | |
| 18:40 | Make sure the automatic index optimization is checked even if the covering index scan optimization was previously selected. (check-in: ac1d5d8a user: drh tags: trunk) | |
| 13:46 | Add QNX-specific performance tweaks to the unix VFS. (Cherry-pick merge of [b02849e7bde458].) (check-in: 63a7dd75 user: drh tags: trunk) | |
| 00:55 | Make sure all virtual table cursors have been closed on a prepared statement prior to unlinking the perpared statement from its database connection. The test case for this is in TH3, in the main39.test module. (check-in: 6d42d806 user: drh tags: trunk) | |
| 00:11 | Make sure all virtual table cursors have been closed on a prepared statement prior to unlinking the perpared statement from its database connection. (Closed-Leaf check-in: f7c5abe8 user: drh tags: deferred-close-order) | |
|
2012-10-25
| ||
| 23:47 | Further work on getting ssdsim to run. This is an incremental checkin to save my place while jumping off to work on other things. (Leaf check-in: ae2f1627 user: drh tags: ssdsim) | |
| 19:25 | Fix a bug in fts3 causing it to return SQLITE_NOMEM when NEAR, OR and some auxiliary functions were used together. Also a segfault in vtab.c that could follow an OOM condition. (check-in: 33f4f981 user: dan tags: trunk) | |
| 15:43 | Fix typo in usage text for the command-line shell. Also, in the same usage text, make the file name argument to -init uppercase for consistency. (check-in: a6d906cf user: mistachkin tags: trunk) | |
| 15:32 | Merge the command-line shell enhancements from trunk. Other edits toward trying to get ssdsim to run. (check-in: 848f87e2 user: drh tags: ssdsim) | |
| 15:23 | Improvements to the command-line argument parsing in the command-line shell. Command-line options can now occur either before or after the database name and first command and are still accepted and processed. Command-line options are processed even if no database name is given (and :memory: is assumed). (check-in: 317c80cb user: drh tags: trunk) | |
| 03:07 | Implementation of the INSTR() SQL function, as found in SQL Server, MySQL, and Oracle. (Closed-Leaf check-in: 49ccae96 user: drh tags: instr) | |
| 01:50 | Initial check-in of a test VFS designed to simulate a NAND-flash SSD for the purpose of measuring and subsequently minimizing write amplification caused by SQLite. The code in this check-in compiles but does not run. (check-in: 9e6efcf0 user: drh tags: ssdsim) | |
|
2012-10-24
| ||
| 00:47 | Translate the Debug/Release project configurations to the Debug/Retail VSIX package configurations. (Closed-Leaf check-in: 5023a7ad user: mistachkin tags: vsixFlavor) | |
|
2012-10-20
| ||
| 09:35 | Modify clean target to handle all VSIX package flavors. (check-in: 023217ea user: mistachkin tags: vsixFlavor) | |
| 08:40 | Modify VSIX build tools in support of an additional package flavor. (check-in: 702ebc64 user: mistachkin tags: vsixFlavor) | |
|
2012-10-19
| ||
| 02:10 | Make sure substructure elements have proper alignment in the ICU tokenizers of FTS2 and FTS3. (check-in: aaa2d9b0 user: drh tags: trunk) | |
| 00:23 | Add detailed comments to the build tools used to generate the VSIX package. Also, allow the build configurations and native library directories to be overridden for the multi-platform build tool for MSVC. (check-in: 0482c73b user: mistachkin tags: trunk) | |
|
2012-10-18
| ||
| 20:49 | Put auxiliary libraries after libsqlite3.a in the testfixture target of the "main.mk" makefile. (check-in: 8fc8548f user: drh tags: trunk) | |
| 15:01 | Merge Watcom compiler warning fixes into trunk. (check-in: 5be96788 user: drh tags: trunk) | |
| 10:35 | More warning fixes. (Closed-Leaf check-in: 51a6a797 user: mistachkin tags: warnings) | |
| 09:39 | Fix harmless compiler warnings. (check-in: 018e09c7 user: mistachkin tags: warnings) | |
|
2012-10-17
| ||
| 20:28 | Add a comment to fts3_snippet.c. (check-in: b5f5ba31 user: dan tags: trunk) | |
| 20:15 | Initialize variables used as outputs of custom tokenizer method calls in fts4. (check-in: 514505a8 user: dan tags: trunk) | |
| 16:20 | Add a test for the problem fixed by [bf44d73d3e]. (check-in: db9b1fa5 user: dan tags: trunk) | |
| 15:28 | Change the way the tcl crash-test code works to avoid triggering an assert() in os_unix.c. (check-in: b8b7b8f9 user: dan tags: trunk) | |
| 13:15 | Remove an incorrect "#ifndef SQLITE_OMIT_AUTOVACUUM" from pager. (check-in: bf44d73d user: drh tags: trunk) | |
|
2012-10-16
| ||
| 23:17 | Enable optimization of IN operators on constraints to virtual tables. (check-in: aa650746 user: drh tags: vtab-IN-opt) | |
| 23:08 | Merge updates from trunk. (check-in: f021559d user: mistachkin tags: configReadOnly) | |
| 21:08 | An optimization that converts "a IN (b)" into "a==b". Seems to work, but needs additional test cases. (Leaf check-in: 8b4c3c5e user: drh tags: degenerate_IN) | |
|
2012-10-15
| ||
| 20:28 | Correct comments and enhance readability of the mkvsix tool. (check-in: 2c3af657 user: mistachkin tags: trunk) | |
| 18:02 | Hold the mutex on the shared-cache for the duration of a VACUUM operation. (check-in: 629a42d4 user: dan tags: trunk) | |
| 16:24 | Dequote column names generated by the query flattener. (check-in: 5526e0aa user: drh tags: trunk) | |
| 14:25 | Merge all the latest core changes into the sessions branch. (check-in: 76767d65 user: drh tags: sessions) | |
| 11:28 | Fix a failing assert() in wal.c. (check-in: 8745530b user: dan tags: trunk) | |
|
2012-10-13
| ||
| 23:16 | Ensure that when the source of a backup is a database that is zero bytes in size, the final destination database consists of at least one page. Truncating it to zero bytes is equivalent to zeroing the schema cookie and change counter, which can cause problems for existing clients. (check-in: ca86138b user: drh tags: trunk) | |
| 20:55 | Mark an always-true conditional as such. (Closed-Leaf check-in: ae025cae user: drh tags: zero-byte-backup-fix) | |
| 20:20 | Modify backup4 test name prefix to make the resulting test names unique. (check-in: 637fb1c1 user: mistachkin tags: zero-byte-backup-fix) | |
| 19:58 | Ensure that when the source of a backup is a database that is zero bytes in size, the final destination database consists of at least one page. Truncating it to zero bytes is equivalent to zeroing the schema cookie and change counter, which can cause problems for existing clients. (check-in: af5c9ee4 user: dan tags: zero-byte-backup-fix) | |