Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
100 events occurring around c57deced09c67085.
2014-02-03
| ||
17:04 | Performance optimizations in sqlite3PcacheFetch(). (check-in: b60cc11e 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: 6c643e45 user: drh tags: trunk) | |
13:58 | Sync with version 3.8.3. (check-in: a704b65b user: drh tags: sessions) | |
13:52 | Version 3.8.3 (check-in: e816dd92 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: af3c775e user: drh tags: trunk) | |
2014-01-31
| ||
11:50 | Update the "sqlite3.1" unix manpage document. (check-in: 21ce9e3a user: drh tags: trunk) | |
06:35 | Minor change to TEA extension docs in an attempt to make links work correctly. (Closed-Leaf check-in: 492585c8 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: 1973d80e user: drh tags: trunk) | |
15:03 | Fix requirements marks only. No changes to code or tests. (check-in: 4a34378b 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: 8560091e user: drh tags: trunk) | |
12:46 | • Edit [c723ec2784d6b60c|c723ec27]: Mark "Closed". (artifact: ef77cfa7 user: mistachkin) | |
12:45 | Enhance the MSVC makefile for better debugging symbol support. (check-in: c9bef0f2 user: mistachkin tags: trunk) | |
12:16 | Do not run test script mmapfault.test as part of the "inmemory_journal" permutation test. (check-in: b222b61a user: dan tags: trunk) | |
11:12 | Enhance the MSVC makefile for better debugging symbol support. (Closed-Leaf check-in: c723ec27 user: mistachkin tags: msvcDebug) | |
2014-01-29
| ||
14:21 | Merge latest fixes from the trunk. (check-in: 6b6dcd4c user: dan tags: sessions) | |
01:46 | Make sure that sqlite3SelectDup() initializes the nSelectRow of the duplicate Select object. (check-in: 5bb29b82 user: drh tags: trunk) | |
2014-01-28
| ||
20:36 | Fix harmless compiler warnings in the showdb utility program. (check-in: 27c27daa user: drh tags: trunk) | |
18:53 | Fix a potential over-size and hence undefined shift operation. (check-in: 6379b072 user: drh tags: trunk) | |
18:06 | Bring in the latest updates from trunk. (check-in: 7b5f3773 user: drh tags: sessions) | |
17:49 | Minor bugfix in main.c so that the library builds with SQLITE_OMIT_WSD defined. (check-in: 5e3b9ecc 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: a2c347fa 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: 48d736c0 user: dan tags: trunk) | |
15:02 | Update some requirements marks to conform with improvements in the documentation. (check-in: be1acb61 user: drh tags: trunk) | |
14:19 | Fix a problem in pagerfault.test causing an assert() to fail. (check-in: ba8d2d50 user: dan tags: trunk) | |
13:58 | Fix (harmless) duplicate variable declaration. (check-in: 94ed9bc4 user: drh tags: trunk) | |
08:48 | Fix some problems in test scripts. No code changes. (check-in: 08acfc65 user: dan tags: trunk) | |
2014-01-25
| ||
12:16 | Fix a problem causing SQLITE_OMIT_COMPOUND_SELECT builds to fail. (check-in: b30db0ac user: dan tags: trunk) | |
2014-01-24
| ||
22:58 | Fixes for various clang warnings. (check-in: 87bf6063 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: 9554519c user: dan tags: trunk) | |
17:03 | Fix harmless compiler warnings in the Tcl interface. (check-in: 35bc81f5 user: mistachkin tags: trunk) | |
16:57 | Add test cases for LIMIT and ORDER BY on recursive CTEs. (check-in: 67d6c42d user: dan tags: trunk) | |
16:36 | Use an unsigned integer to accumulate the string hash. Avoids compiler warnings. (check-in: b1824344 user: drh tags: trunk) | |
15:42 | Add a few more CTE test cases to closure.test. (check-in: 1b6405d9 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: 9a23f020 user: drh tags: trunk) | |
14:05 | Bring in all the latest trunk changes, including the Common Table Expressions implementation. (check-in: 9b43e559 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: 83b0b291 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: f4a701d5 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: 72c4b3f0 user: dan tags: trunk) | |
18:31 | Fix harmless compiler warnings. (check-in: dea2ca6a 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: b6cea420 user: drh tags: trunk) | |
18:10 | • Edit [c57deced09c67085|c57deced]: Mark "Closed". (artifact: 99c2885e user: drh) | |
18:07 | Add support for LIMIT and OFFSET in a recursive query. (Closed-Leaf check-in: 1945484e 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: a0ba55ff user: dan tags: trunk) | |
17:28 | Get ORDER BY working for recursive queries. (check-in: 37b343b0 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: 3eb5f9f8 user: drh tags: cte-via-queue) | |
10:22 | Fix a typo in a comment. No changes to code or tests. (check-in: cceacc0e user: dan tags: cte-via-queue) | |
00:23 | Remove an unnecessary parameter from selectInnerLoop(). Clean up comments. (check-in: 5e6c4a55 user: drh tags: cte-via-queue) | |
2014-01-21
| ||
22:25 | Change the recursive common table expression algorithm to use a queue instead of a pair of tables. Runs about 25% faster on the sudoku solver query. The OP_SwapCursors opcode is no longer required. The current implementation uses just a fifo, but the plan is to change it into a queue that will support ORDER BY and LIMIT in a recursive query. (check-in: b2671e11 user: drh tags: cte-via-queue) | |
15:04 | Remove the undocumented requirement for applications that use an SQLITE_ENABLE_SQLLOG build to define a sqlite3_init_sqllog() function. (check-in: 5e43bf01 user: dan tags: trunk) | |
14:56 | • Edit [cc1cb3217800ff66|cc1cb321]: Move to branch level-pseudocolumn. (artifact: 896de8fc user: drh) | |
01:13 | Fix a couple comment typos and one overly long line. No functional changes. (Closed-Leaf check-in: c57deced user: mistachkin tags: level-pseudocolumn) | |
00:19 | Add support for the LEVEL pseudo-column in the recursive part of a common table expression. LEVEL has the value of 1 on the first iteration and successively larger integer values of subsequent iterations. It cannot have a table qualifier. Actual columns named "level" can still be accessed by including the table name qualifier. (check-in: cc1cb321 user: drh tags: level-pseudocolumn) | |
2014-01-20
| ||
21:14 | • Edit [7d9e22187daaa316|7d9e2218]: Edit check-in comment. (artifact: df9a6acd user: drh) | |
19:56 | • Closed ticket [1a1a194d]: Assertion fault on query of virtual table with cross-column constraints plus 3 other changes (artifact: fcc16e77 user: dan) ... 1 similar event omitted. | |
19:55 | In where.c, do not allocate space in sqlite3_index_info structures for the internal WHERE clause "terms" generated to record column equivalencies. Fix for ticket [1a1a194d1e5f8]. (check-in: 7d9e2218 user: dan tags: trunk) | |
19:15 | • New ticket [1a1a194d] Assertion fault on query of virtual table with cross-column constraints. (artifact: ce84c752 user: drh) | |
18:25 | Handle a few obscure problems that could manifest if a database corrupted in a certain way was written by a connection in the middle of a SELECT statement on the same db. (check-in: eba8a564 user: dan tags: trunk) | |
14:58 | Remove an unused #define and add an assert(), both associated with WITH logic. (check-in: a06235e0 user: drh tags: trunk) | |
14:17 | Do not run the tests in with2.test with SQLITE_OMIT_CTE builds. (check-in: 8a973912 user: dan tags: trunk) | |
2014-01-18
| ||
18:33 | Add a sudoku solver to the recursive query tests in with1.test. (check-in: 679eff87 user: drh tags: trunk) | |
15:59 | Add extra test cases. No changes to code. (check-in: d38d485e user: dan tags: trunk) | |
15:22 | Add asserts() for a couple of unreachable conditions. Add the Mandelbrot Set query as a test case. (check-in: 2ad4583c user: drh tags: trunk) | |
08:27 | Avoid spurious "no such table" errors in statements of the form "INSERT INTO tbl WITH xxx AS (...) SELECT * FROM xxx". (check-in: cccff8a0 user: dan tags: trunk) | |
2014-01-17
| ||
20:36 | Add extra tests to with2.test. (check-in: eecc325a user: dan tags: trunk) | |
18:34 | Minor simplification of error message text for a couple of errors associated with WITH clause processing. (check-in: 2031004d user: drh tags: trunk) | |
17:40 | Resolve table names within CTEs in the context in which the CTE is declared, not the context in which it is used. (check-in: a7323838 user: dan tags: trunk) | |
16:19 | Add tests that verify that keywords WITH, WITHOUT, and RECURSIVE can still be used as table and column names. (check-in: 9ca18a01 user: drh tags: trunk) | |
16:04 | • Edit [6a549187ed8b5ed5|6a549187]: Mark "Closed". (artifact: 245e6420 user: drh) | |
15:27 | Fix a compiler warning in selectPopWith(). (check-in: c8eb1163 user: drh tags: trunk) | |
15:15 | Add support for common table expressions (WITH clauses). (check-in: 0171e3bb user: dan tags: trunk) | |
14:59 | Fix some problems to do with WITH clauses and name resolution. (Closed-Leaf check-in: 6a549187 user: dan tags: common-table-expr) | |
11:48 | Remove some code from resolve.c that was only required for recursive cte references in sub-queries. Also a stray "finish_test" command in pagerfault.test. (check-in: f68c6c4d user: dan tags: common-table-expr) | |
2014-01-16
| ||
22:40 | Add the ability for the authorizer callback to disallow recursive queries. (check-in: 9efc120a user: drh tags: common-table-expr) | |
21:59 | Tweaks to error message text. (check-in: 090a77d9 user: drh tags: common-table-expr) | |
21:02 | Improve the error messages used to report illegal recursive cte references. (check-in: 54eee9fe user: dan tags: common-table-expr) | |
18:34 | Allow only a single recursive reference in a recursive CTE. Also require that this reference is not part of a sub-query. (check-in: a296b733 user: dan tags: common-table-expr) | |
15:31 | Always use available indices to optimize LIKE operators even if the pattern of the LIKE operator has a COLLATE modifier. This fixes an ineffiency that was introduced into 3.7.15 by check-in [8542e6180d4] on 2012-12-08. (check-in: 16bd5478 user: drh tags: trunk) | |
10:58 | Disable the flattening optimization if the parent query is the recursive part of a recursive CTE and the sub-query is a compound query. (check-in: 6bfa387e user: dan tags: common-table-expr) | |
04:37 | Merge trunk changes. Fix a possible NULL-pointer deference in WITH clause name resolution. (check-in: 7f953b56 user: drh tags: common-table-expr) | |
2014-01-15
| ||
20:10 | Remove an ALWAYS() that is no longer always true. (check-in: c95823cd user: drh tags: common-table-expr) | |
19:42 | Fixes so that SQLITE_OMIT_CTE builds work. (check-in: 3908e2ea user: dan tags: common-table-expr) | |
18:35 | Further comments on WITH-clause processing routines in select.c. (check-in: c948384d user: drh tags: common-table-expr) | |
18:23 | Add a header comment to the searchWith() routine. (check-in: d9ae0f5d user: drh tags: common-table-expr) | |
18:21 | Disable automatic indices on recursive CTE references. (check-in: 28aa6db8 user: dan tags: common-table-expr) | |
18:12 | When resolving names, consider a reference to a recursive CTE column as equivalent to a reference to the outermost name-context. This ensures that correlated sub-queries are correctly identified as such. (check-in: 61be2da0 user: dan tags: common-table-expr) | |
15:27 | Return an error if a CTE specifies a different number of columns than its SELECT statement returns. (check-in: 9a514b50 user: dan tags: common-table-expr) | |
14:40 | Don't try to verify the schema of transient table (such as generated inside a WITH clause) when generating code for "IN table" operators. (check-in: 860aa936 user: drh tags: common-table-expr) | |
14:17 | Disable the flattening optimization if the sub-query is a recursive CTE. (check-in: 9472f6d8 user: dan tags: common-table-expr) | |
02:40 | Use the user-supplied table name in WITH RECURSIVE tables as the internal name of the table and the name of the table in VDBE comments. (check-in: a2933023 user: drh tags: common-table-expr) | |
00:24 | Merge recent fixes from trunk. Cherrypick of [c43b59dac1], [a221aa82bb], [e1eba1fb09], and [1e131094b5]. (check-in: c697d2f8 user: mistachkin tags: branch-3.8.2) | |
2014-01-14
| ||
20:14 | Add code to handle recursive CTEs. (check-in: a5c2a54a user: dan tags: common-table-expr) | |
10:17 | Fix harmless compiler warning in LEMON. (check-in: f61a7058 user: mistachkin tags: trunk) | |
10:17 | For the Win32 VFS, defining winShmMutexHeld should be controlled by NDEBUG, not SQLITE_DEBUG. (check-in: 1e131094 user: mistachkin tags: trunk) | |
2014-01-13
| ||
20:38 | In the command-line shell, defend against a NULL-pointer dereference in the case where sqlite3_column_name() returns NULL (as might happen following an OOM error). (check-in: ac15455a user: drh tags: trunk) | |
20:32 | For statements of just an unadorned VALUES clause, assign column names as "columnN" for increasing whole numbers N. (check-in: 260587d2 user: drh tags: trunk) | |
16:36 | Fix some memory leaks and crashes that could follow an OOM condition during WITH clause parsing. (check-in: 8839850c user: dan tags: common-table-expr) | |
15:12 | Add code to handle non-recursive CTEs in the same way as SQL views. (check-in: a26f399b user: dan tags: common-table-expr) | |
2014-01-11
| ||
19:19 | Update the parser so that sub-queries and CTEs may have WITH clauses. (check-in: 704d3931 user: dan tags: common-table-expr) | |
13:22 | Parse common table expressions. But do not do anything with them (yet). (check-in: da98b720 user: drh tags: common-table-expr) | |