Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
100 events occurring around faedaeace9c7ed9a.
2013-05-10
| ||
20:26 | Now generating OR-clause plans. (check-in: e17003fc user: drh tags: nextgen-query-plan-exp) | |
15:16 | Update the NGQP so that it can produce plans that include automatic indices. (check-in: 586b55d8 user: drh tags: nextgen-query-plan-exp) | |
03:30 | Factor out common operations into whereLoopAddAll(). Add stubs for missing features. (check-in: 0278e420 user: drh tags: nextgen-query-plan-exp) | |
02:11 | Merge in the latest trunk changes. (check-in: 5ed31c82 user: drh tags: nextgen-query-plan-exp) | |
02:00 | Free up bits of wsFlags for reuse. Install the ORDER BY optimization infrastructure for the NGQP. (check-in: 82d50e19 user: drh tags: nextgen-query-plan-exp) | |
2013-05-09
| ||
23:40 | Merge trunk changes into the sessions branch. (check-in: 512f8a1e user: drh tags: sessions) | |
18:12 | Add assert()s to the implementation of xRead() in the built-in VFSes to verify that the offset parameter is always non-negative. (check-in: cf5c3642 user: drh tags: trunk) | |
14:20 | • Fixed ticket [f2369304]: Incorrect results when OR is used in the ON clause of a LEFT JOIN plus 5 other changes (artifact: 4712b561 user: drh) | |
14:20 | Do not move WHERE clause terms inside OR expressions that are contained within an ON clause of a LEFT JOIN. Fix for ticket [f2369304e47167e3e]. (check-in: 1128575d user: drh tags: trunk) | |
13:38 | • New ticket [f2369304] Incorrect results when OR is used in the ON clause of a LEFT JOIN. (artifact: 979fa9ab user: drh) | |
00:40 | Refine and reform all Windows OSTRACE macro usage. Replace all usage of sqlite3TestErrorName() with sqlite3ErrName() and add missing return codes. (check-in: 610425f1 user: mistachkin tags: trunk) | |
2013-05-08
| ||
20:05 | Fix memory leaks in the NGQP logic for virtual tables. (check-in: 3c2e83a4 user: drh tags: nextgen-query-plan-exp) | |
18:50 | Merge all recent trunk changes into the sessions branch. (check-in: ae6c4a09 user: drh tags: sessions) | |
17:06 | Fix a couple of harmless compiler warnings in the fts3_tokenize virtual table. (check-in: 1fa8c457 user: drh tags: trunk) | |
16:58 | • Fixed ticket [6709574d]: COLLATE clause in ORDER BY causes incorrect EXCEPT plus 5 other changes (artifact: 63278902 user: drh) | |
16:57 | Make sure the ORDER BY collating sequences are compatible with the comparison collations before using the merge algorithm for compound SELECT statements. Fix for ticket [6709574d2a8d8]. (check-in: ce853a75 user: drh tags: trunk) | |
14:35 | • Edit [bd9327a9684b9997|bd9327a9]: Edit check-in comment. (artifact: 4e9edb0e user: drh) | |
14:20 | Fix the wholenumber virtual table so that it returns higher costs for unconstrained usage. Cherrypick from [ceff8955020cd13]. (check-in: 7227b615 user: drh tags: trunk) | |
14:14 | NGQP working with virtual tables, though many legacy tests fail and there are yet some memory leaks. (check-in: bd9327a9 user: drh tags: nextgen-query-plan-exp) | |
14:13 | Fix the wholenumber virtual table so that it returns higher costs for unconstrained usage. (check-in: ceff8955 user: drh tags: nextgen-query-plan-exp) | |
04:22 | More bug fixes to the WhereLoop generator and the solver in NGQP. Now finds the best plan for TPC-H Q8. This seems to prove the concept, but there is still much work to be done. (check-in: 8e5aad37 user: drh tags: nextgen-query-plan-exp) | |
03:22 | Bug fixes in the solver. (check-in: b36034bb user: drh tags: nextgen-query-plan-exp) | |
03:05 | Add the NGQP solver. (check-in: 5d37587c user: drh tags: nextgen-query-plan-exp) | |
2013-05-07
| ||
23:06 | Continued progress on generating good WhereLoop objects for the new query planner. (check-in: 15cc8a16 user: drh tags: nextgen-query-plan-exp) | |
19:44 | Inserting a few WhereLoop objects without leaking memory. Costs are not correct. Inequality and IN constraints are not implemented. (check-in: e8881a8b user: drh tags: nextgen-query-plan-exp) | |
17:49 | Make sure the ORDER BY collating sequences are compatible with the comparison collations before using the merge algorithm for compound SELECT statements. Candidate fix for ticket [6709574d2a8d8]. (Closed-Leaf check-in: fc3630cd user: drh tags: tkt-6709574) | |
12:16 | Modify the fts3tokenize table implementation so that it does not use the SQL function fts3_tokenizer. The user may have installed an authorizer callback that prohibits this. (check-in: 0ba67b64 user: dan tags: trunk) | |
2013-05-06
| ||
21:06 | • Add attachment sk2.sql to ticket [4eb3a0bd] (artifact: 6398d0f5 user: drh) | |
21:05 | • New ticket [4eb3a0bd] Performance regression in Skrooge. (artifact: 2fcf41f2 user: drh) | |
21:01 | In the command-line shell, output the elements of the schema in the order that they appear in the sqlite_master table. This is necessary in some cases to make the schema parsable. (check-in: e5b3cd74 user: drh tags: trunk) | |
20:29 | • Fixed ticket [2f96536e]: .tables output is not redirected into .output file plus 5 other changes (artifact: d54d7c3d user: drh) | |
20:28 | In the command-line shell, make sure the output of dot-commands goes to the same redirected output stream as the result of queries. Ticket [2f96536e7ff7dba] (check-in: b72d3659 user: drh tags: trunk) | |
18:49 | • Fixed ticket [5eaa61ea]: sigbus on disk ful in WAL mode plus 3 other changes (artifact: 77a9876b user: drh) | |
15:21 | • New ticket [6709574d] COLLATE clause in ORDER BY causes incorrect EXCEPT. (artifact: 5bbf9ac1 user: drh) | |
14:57 | Add an assert() to fts3_expr.c in order to silence a clang warning. (check-in: d8dc2c5f user: drh tags: trunk) | |
13:45 | • Ticket [0eb70d77] Invalid pointer passed to the authorizer callback status still Fixed with 3 other changes (artifact: ee1c6f48 user: drh) ... 1 similar event omitted. | |
13:22 | Make sure the authorizer callback gets a valid pointer to "ROWID" for the column-name parameter when doing an UPDATE that changes the rowid. Fix for ticket [0eb70d77cb05bb2272]. (check-in: 26a59bb8 user: drh tags: trunk) | |
13:03 | • New ticket [0eb70d77] Invalid pointer passed to the authorizer callback. (artifact: 6ec5e901 user: drh) | |
2013-05-04
| ||
20:25 | In where.c, make findTerm() a wrapper around methods to a new WhereScan object which is capable of finding all suitable matching terms, not just the first. This check-in includes some prototype functions for building WhereLoop objects. (check-in: dd92b8fa user: drh tags: nextgen-query-plan-exp) | |
2013-05-03
| ||
20:08 | Add magic numbers for Bentley Systems application files. (check-in: 9314b080 user: drh tags: trunk) | |
18:29 | Merge all recent trunk changes into the sessions branch. (check-in: 3879ab1b user: drh tags: sessions) | |
15:23 | Allocate meta(8) in the header as the "application ID" and add the "PRAGMA application_id" command to query and set it. (check-in: b2efe4f2 user: drh tags: trunk) | |
2013-05-02
| ||
17:37 | Minor fixes for compilation with SQLITE_OMIT_WAL defined. (check-in: b81e87e7 user: dan tags: trunk) | |
14:36 | • New ticket [2f96536e] .tables output is not redirected into .output file. (artifact: 23dd941d user: anonymous) | |
00:15 | Begin inserting some experimental code for the next generation query planner. (check-in: ccaf4c3f user: drh tags: nextgen-query-plan-exp) | |
2013-05-01
| ||
20:40 | Fix comments in the magic number file. (Closed-Leaf check-in: 5a500848 user: drh tags: application-id) | |
20:36 | Preserve the application-ID across VACUUM. Updates to the magic number file. (check-in: 4a190bea user: drh tags: application-id) | |
19:49 | Allocate 4 bytes of unused header space for an "Application ID". Add the "PRAGMA application_id" command to set and query this identifier. Add the "magic.txt" file to show how the posix file command might use this application id. (check-in: 28c9e7fd user: drh tags: application-id) | |
17:58 | Do not use a transitive constraint to an IN operator where the RHS is a constant if there exists a direct == operator to another table in an outer loop. (check-in: faedaeac user: drh tags: trunk) | |
17:22 | Avoid redundant constraint checking due to transitive constraints. (check-in: 329478cb user: drh tags: trunk) | |
2013-04-30
| ||
14:26 | • Fixed ticket [19b44e35]: sqlite3_bind_text inconsistent with NULL pointers, zero length etc plus 4 other changes (artifact: f0937c04 user: drh) | |
14:25 | Update the documentation to explain that when the 3rd parameter to sqlite3_bind_text() and friends is NULL the result is to bind a NULL SQL value. Ticket [19b44e35753ba] (check-in: bd92de0e user: drh tags: trunk) | |
14:07 | • Fixed ticket [28c6e830]: Segfault while parsing/compiling an SQL statement plus 5 other changes (artifact: 6702b47b user: drh) | |
14:06 | Make sure extra parentheses around subqueries in the FROM clause are harmless. Ticket [28c6e830f239ea5]. (check-in: 1c795692 user: drh tags: trunk) | |
13:26 | • New ticket [28c6e830] Segfault while parsing/compiling an SQL statement. (artifact: a81f8ab6 user: drh) | |
07:58 | Add the #ifdefs for sqlite3ErrName() to sqliteInt.h as well. (Closed-Leaf check-in: 400fc4c3 user: mistachkin tags: winOsTrace) | |
07:54 | Define the sqlite3ErrName() function only when necessary. More robust handling of unknown return codes. (check-in: e47cd314 user: mistachkin tags: winOsTrace) | |
2013-04-29
| ||
18:07 | Improve the error message issued when an FTS query exceeds the maximum allowable tree depth. (check-in: f480b1fe user: dan tags: trunk) | |
17:12 | Fix an off-by-one in the code for limiting the depth of FTS expression trees. (check-in: 72ac7318 user: dan tags: trunk) | |
09:20 | Merge mmap test fix from trunk. (check-in: 95811877 user: mistachkin tags: winOsTrace) | |
09:17 | Fix mmap1.test so that it passes on windows as well as unix. (check-in: 52417eac user: dan tags: trunk) | |
08:58 | Adjust a WAL test result due to changes in the corresponding return code name. (check-in: 9272009f user: mistachkin tags: winOsTrace) | |
08:56 | Merge updates from trunk. (check-in: 3a245a83 user: mistachkin tags: winOsTrace) | |
07:01 | Update 'fuzzerfault' test for its new module loading command. Fix several test names in 'io.test' and make sure the database gets closed between tests. (check-in: e81e9ca1 user: mistachkin tags: trunk) | |
03:09 | More refinements to Windows OSTRACE usage. Replace all usage of sqlite3TestErrorName() with sqlite3ErrName() and add missing return codes. (check-in: 05ba5e23 user: mistachkin tags: winOsTrace) | |
2013-04-28
| ||
01:44 | Initial work on reforming usage of OSTRACE by the Windows VFS. (check-in: b347b5d1 user: mistachkin tags: winOsTrace) | |
2013-04-27
| ||
18:06 | Remove spellfix virtual table documentation from the source tree. Reference the separate documentation on the website instead. (check-in: adcf7890 user: drh tags: trunk) | |
12:13 | Untested fix for building on VxWorks. (check-in: f14d55cf user: drh tags: trunk) | |
2013-04-26
| ||
19:33 | Fix a formatting typo in a comment. No changes to code. (check-in: 7a97226f user: drh tags: trunk) | |
18:36 | Avoid unnecessarily reseting the pager cache after committing a transaction that takes advantage of the SQLITE_IOCAP_ATOMIC related optimization. (check-in: c47144e9 user: dan tags: trunk) | |
17:00 | Avoid using posix_fallocate() in WAL mode, as it is not supported by all file-systems. (check-in: 1bbb4be1 user: dan tags: trunk) | |
16:09 | Avoid using posix_fallocate() in WAL mode, as it is not supported by all file-systems. (Closed-Leaf check-in: 9c7523da user: dan tags: avoid-fallocate) | |
15:55 | Update documentation with new hyperlinks. No changes to code. (check-in: 640eb54a user: drh tags: trunk) | |
14:13 | Rebalance FTS expressions after parsing to limit recursion during evaluation. Avoid recursion when deleting FTS expression trees. Enforce a limit (currently 12) on the depth of an expression tree. (check-in: 49d23ef6 user: dan tags: trunk) | |
14:04 | Merge another trunk change. (Closed-Leaf check-in: 2648966f user: dan tags: fts3-expr-rebalance) | |
14:02 | • Edit [bbe607c7d17c50b6|bbe607c7]: Edit check-in comment. (artifact: 541fa0a1 user: drh) | |
13:14 | Fix harmless compiler warnings in the FTS expression parser. (check-in: 3c78af8c user: drh tags: fts3-expr-rebalance) | |
12:08 | Reduce the default SQLITE_MAX_MMAP_SIZE slightly so that it fits in a signed 32-bit integer. (check-in: 460752b8 user: drh tags: trunk) | |
06:58 | Merge latest trunk changes. (check-in: 4d08e74d user: dan tags: fts3-expr-rebalance) | |
2013-04-25
| ||
20:38 | • Edit [2b3fed09eb89f1e9|2b3fed09]: Edit check-in comment. (artifact: e6a1cc6b user: drh) | |
20:34 | Rebalance FTS expressions after parsing to limit recursion during evaluation. Avoid recursion when deleting FTS expression trees. Enforce a limit on the depth of an expression tree. (check-in: f968d43f user: dan tags: fts3-expr-rebalance) | |
19:31 | Added the nextchar.c extension. Minor changes to the spellfix.c extension so that it can be appended to an amalgamation and compiled without duplicating symbols. (check-in: 56b9a417 user: drh tags: trunk) | |
17:27 | Fix the tool/build-shell.sh script to remove references to files that are now loadable extensions. (check-in: aabeea98 user: drh tags: trunk) | |
17:07 | Add wiki documentation files for the spellfix1 virtual table. (check-in: 381564e9 user: drh tags: trunk) | |
17:00 | • Edit [84018099c8715b98|84018099]: Mark "Closed". (artifact: 7b83f909 user: drh) | |
16:52 | Merge the std-ext branch into trunk. This merge adds several new extensions to the ext/misc folder, including transitive_closure, ieee754, and amatch, and it converts some older src/test_*.c file into extensions in the ext/misc folder. (check-in: bbe607c7 user: drh tags: trunk) | |
16:42 | Added the transitive_closure, ieee754, and amatch extensions. (Closed-Leaf check-in: 84018099 user: drh tags: std-ext) | |
14:59 | Move the test_spellfix.c module to ext/misc/spellfix.c. (check-in: de556add user: drh tags: std-ext) | |
14:36 | Fix the MSVC makefile so that it works with the ext/misc/*.c extensions. (check-in: 680822e8 user: drh tags: std-ext) | |
14:31 | Convert the fuzzer virtual table into a loadable extension and move it to the ext/misc/fuzzer.c file. (check-in: c8c69307 user: drh tags: std-ext) | |
11:58 | Make test_wholenumber.c into a loadable extension and move it to ext/misc/wholenumber.c. (check-in: efcc9dd0 user: drh tags: std-ext) | |
00:57 | Make sure the affinity and datatype of sub-subqueries are initialized prior to subqueries as the latter relies on the former. (check-in: 39b4e6ff user: drh tags: trunk) | |
2013-04-24
| ||
13:50 | Fix a simple comment typo. No changes to code. (check-in: f136bd95 user: drh tags: trunk) | |
2013-04-23
| ||
20:10 | Make "test_regexp.c" into a loadable extension and move it over to ext/misc/regexp.c. Add the "load_static_extension" command for testing purposes. (check-in: 860fc393 user: drh tags: std-ext) | |
2013-04-22
| ||
23:59 | Merge the latest trunk changes into the sessions branch. (check-in: 6994826c user: drh tags: sessions) | |
23:38 | Fix harmless compiler warnings. (check-in: 1a1cf5aa user: drh tags: trunk) | |
22:29 | • Fixed ticket [ba82a4a4]: Query optimizer removes ORDER BY when it is needed plus 3 other changes (artifact: c1b7e291 user: drh) | |
19:56 | Do not allow a virtual table to cancel the ORDER BY clause unless all outer loops are guaranteed to return no more than one row result. Candidate fix for ticket [ba82a4a41eac1]. (check-in: 49cfa14f user: drh tags: trunk) | |
18:26 | • Ticket [ba82a4a4] Query optimizer removes ORDER BY when it is needed status still Open with 6 other changes (artifact: 294e00a4 user: drh) | |