Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
50 check-ins occurring around 5e3b9ecc7b2b2e50.
2014-02-05
| ||
19:10 | Separate out the code generators for the RHS of an IN operator and for SELECT/EXISTS expressions. (check-in: 61c34ba71b user: drh tags: subquery-codegen-refactor) | |
18:15 | Use a new opcode, OP_OpenHash, to indicate that ephemeral tables can be unordered, rather than using the BTREE_UNORDERED bit in the P5 field. (check-in: 2997e18157 user: drh tags: subquery-codegen-refactor) | |
17:08 | Make the root page of an ephemeral index be page 1 instead of page 2. (check-in: a332908b70 user: drh tags: subquery-codegen-refactor) | |
11:05 | In the Win32 VFS, the winSysInfo variable should be static. (check-in: 4a4dd371a7 user: mistachkin tags: trunk) | |
2014-02-04
| ||
23:45 | Do not mark the ephemeral tables used to hold the RHS of IN clauses as unordered because the NGQP will use those ephemeral tables to help order the output. This is not an issue for standard SQLite since ephemeral tables there are always ordered, regardless of the hint. It only affects systems that substitute an alternative storage engine. (check-in: f2504089df user: drh tags: trunk) | |
20:46 | Remove the SF_Materialize flag from the SELECT object as it does not accomplish anything useful. (check-in: 65d5dcddbd user: drh tags: trunk) | |
15:55 | Rearrange fields in the Parse object for a tighter packing, resulting in an 8% size reduction on x64. (check-in: 3e1a3f68d7 user: drh tags: trunk) | |
2014-02-03
| ||
17:04 | Performance optimizations in sqlite3PcacheFetch(). (check-in: b60cc11ef7 user: drh tags: trunk) | |
14:04 | Provide hints to the btree layer Next and Previous primitives to let them know if they can be no-ops if the underlying index is unique. (check-in: 6c643e45c2 user: drh tags: trunk) | |
13:58 | Sync with version 3.8.3. (check-in: a704b65b94 user: drh tags: sessions) | |
13:52 | Version 3.8.3 (check-in: e816dd9246 user: drh tags: trunk, release, version-3.8.3) | |
13:49 | Minor change to TEA extension docs in an attempt to make links work correctly. (check-in: af3c775e5d user: drh tags: trunk) | |
2014-01-31
| ||
11:50 | Update the "sqlite3.1" unix manpage document. (check-in: 21ce9e3a53 user: drh tags: trunk) | |
06:35 | Minor change to TEA extension docs in an attempt to make links work correctly. (Closed-Leaf check-in: 492585c820 user: mistachkin tags: teaDoc) | |
2014-01-30
| ||
17:47 | Update evidence marks on SELECT tests. Comment changes only. No changes to code or tests. (check-in: 1973d80e47 user: drh tags: trunk) | |
15:03 | Fix requirements marks only. No changes to code or tests. (check-in: 4a34378b9b user: drh tags: trunk) | |
14:10 | Update a requirement mark and add some additional test cases to cover the requirement associated with ORDER BY and LIMIT on compound SELECT statements. (check-in: 8560091e85 user: drh tags: trunk) | |
12:45 | Enhance the MSVC makefile for better debugging symbol support. (check-in: c9bef0f29a user: mistachkin tags: trunk) | |
12:16 | Do not run test script mmapfault.test as part of the "inmemory_journal" permutation test. (check-in: b222b61a98 user: dan tags: trunk) | |
11:12 | Enhance the MSVC makefile for better debugging symbol support. (Closed-Leaf check-in: c723ec2784 user: mistachkin tags: msvcDebug) | |
2014-01-29
| ||
14:21 | Merge latest fixes from the trunk. (check-in: 6b6dcd4cc7 user: dan tags: sessions) | |
01:46 | Make sure that sqlite3SelectDup() initializes the nSelectRow of the duplicate Select object. (check-in: 5bb29b8210 user: drh tags: trunk) | |
2014-01-28
| ||
20:36 | Fix harmless compiler warnings in the showdb utility program. (check-in: 27c27daa33 user: drh tags: trunk) | |
18:53 | Fix a potential over-size and hence undefined shift operation. (check-in: 6379b07295 user: drh tags: trunk) | |
18:06 | Bring in the latest updates from trunk. (check-in: 7b5f377386 user: drh tags: sessions) | |
17:49 | Minor bugfix in main.c so that the library builds with SQLITE_OMIT_WSD defined. (check-in: 5e3b9ecc7b user: dan tags: trunk) | |
00:49 | Provide hints to the btree layer Next and Previous primitives to let them know if they can be no-ops if the underlying index is unique. (Leaf check-in: a2c347faf9 user: drh tags: branch-3.8.2) | |
2014-01-27
| ||
16:35 | Fix a couple of problems with new test scripts causing the permutations test to fail. (check-in: 48d736c0ee user: dan tags: trunk) | |
15:02 | Update some requirements marks to conform with improvements in the documentation. (check-in: be1acb610f user: drh tags: trunk) | |
14:19 | Fix a problem in pagerfault.test causing an assert() to fail. (check-in: ba8d2d507f user: dan tags: trunk) | |
13:58 | Fix (harmless) duplicate variable declaration. (check-in: 94ed9bc420 user: drh tags: trunk) | |
08:48 | Fix some problems in test scripts. No code changes. (check-in: 08acfc6587 user: dan tags: trunk) | |
2014-01-25
| ||
12:16 | Fix a problem causing SQLITE_OMIT_COMPOUND_SELECT builds to fail. (check-in: b30db0ac30 user: dan tags: trunk) | |
2014-01-24
| ||
22:58 | Fixes for various clang warnings. (check-in: 87bf60637e user: drh tags: trunk) | |
20:37 | Select collation sequences for ORDER BY expressions attached to recursive CTEs in the same way as they are selected for other compound SELECT statements. (check-in: 9554519c12 user: dan tags: trunk) | |
17:03 | Fix harmless compiler warnings in the Tcl interface. (check-in: 35bc81f5ad user: mistachkin tags: trunk) | |
16:57 | Add test cases for LIMIT and ORDER BY on recursive CTEs. (check-in: 67d6c42d44 user: dan tags: trunk) | |
16:36 | Use an unsigned integer to accumulate the string hash. Avoids compiler warnings. (check-in: b1824344ea user: drh tags: trunk) | |
15:42 | Add a few more CTE test cases to closure.test. (check-in: 1b6405d978 user: drh tags: trunk) | |
14:37 | Add test cases that compare the performance of the transitive_closure virtual table again common table expressions for walking a tree. (check-in: 9a23f020e8 user: drh tags: trunk) | |
14:05 | Bring in all the latest trunk changes, including the Common Table Expressions implementation. (check-in: 9b43e55919 user: drh tags: sessions) | |
11:16 | Add test cases showing the use of ORDER BY on a recursive query to control depth-first versus breath-first search of a tree. (check-in: 83b0b29165 user: drh tags: trunk) | |
2014-01-23
| ||
14:44 | Modifications to test files to omit any tests that intentionally access out-of-bounds locations in clang -fsanitize=address builds. (check-in: f4a701d55f user: dan tags: trunk) | |
2014-01-22
| ||
19:23 | Avoid an extra seek when inserting records into the epheremal index used to ensure that rows returned by UNION recursive queries are unique. (check-in: 72c4b3f07a user: dan tags: trunk) | |
18:31 | Fix harmless compiler warnings. (check-in: dea2ca6a15 user: drh tags: trunk) | |
18:16 | Change the WITH RECURSIVE implementation to use a queue instead of a pair of tables. Add support for ORDER BY, LIMIT, and OFFSET on recursive queries. (check-in: b6cea42006 user: drh tags: trunk) | |
18:07 | Add support for LIMIT and OFFSET in a recursive query. (Closed-Leaf check-in: 1945484e6b user: drh tags: cte-via-queue) | |
17:43 | Update the spellfix virtual table to optimize queries of the form "SELECT ... FROM tbl WHERE rowid=?". (check-in: a0ba55ff05 user: dan tags: trunk) | |
17:28 | Get ORDER BY working for recursive queries. (check-in: 37b343b018 user: drh tags: cte-via-queue) | |
13:35 | Add new SelectDest codes, SRT_Queue and SRT_DistQueue in anticipation of adding ORDER BY support on recursive queries. Factor out the recursive query code generator into a separate procedure. (check-in: 3eb5f9f8d6 user: drh tags: cte-via-queue) | |