Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
100 events occurring around dd473cae5b6ea02b.
2013-02-13
| ||
01:00 | Allow an index to be used for sorting even if prior terms of the index are constrained by IN operators. (check-in: 2cef8b68f0 user: drh tags: trunk) | |
2013-02-12
| ||
22:20 | • Edit [09dfc0c915ec2f0c|09dfc0c915]: Mark "Closed". (artifact: e990b82e6c user: drh) | |
22:20 | Improve memory allocation error handling on WinCE. (check-in: cdbca259da user: drh tags: trunk) | |
22:15 | • Edit [3f67437536591a1b|3f67437536]: Mark "Closed". (artifact: 2a6a12ef37 user: drh) | |
22:09 | A bug report coming from from Firefox (https://bugzilla.mozilla.org/show_bug.cgi?id=840377) describes an infinite recursion. We are unable to reproduce the problem. Nevertheless, this check-in should prevent the problem from ever occurring again. (check-in: b7222a2bd0 user: drh tags: trunk) | |
09:46 | Improve memory allocation error handling on WinCE. (Closed-Leaf check-in: 09dfc0c915 user: mistachkin tags: wince) | |
2013-02-11
| ||
13:47 | Add extended error codes for all SQLITE_CONSTRAINT errors. (check-in: 939d828274 user: drh tags: trunk) | |
01:37 | • Ticket [25e09aa2ab] Lint mode status still Open with 6 other changes (artifact: fadb9ad0f7 user: anonymous) | |
2013-02-09
| ||
15:37 | Rename SQLITE_CONSTRAINT_RAISE to SQLITE_CONSTRAINT_TRIGGER. Put the extended constraint error codes in alphabetical order. Add many test cases for the extended constraint error codes. (Closed-Leaf check-in: 3f67437536 user: drh tags: constraint-error-codes) | |
13:58 | Add extended error codes for constraint errors. (check-in: 5461104668 user: drh tags: constraint-error-codes) | |
2013-02-08
| ||
23:18 | Fix a potential NULL-pointer dereference following an OOM error in the query planner logic for virtual tables with OR-connected terms. (Closed-Leaf check-in: 71b6c26053 user: drh tags: IN-with-ORDERBY) | |
20:39 | Make sure the virtual tables that take advantage of IN operators sort the RHS of the IN operator in the correct order according to the ORDER BY clause. (check-in: b016b7546d user: drh tags: IN-with-ORDERBY) | |
18:48 | Loop through the elements on the RHS of an IN operator in reverse order when the ORDER BY clauses specifies DESC. (check-in: f78395c889 user: drh tags: IN-with-ORDERBY) | |
16:04 | Allow the "a=?1 OR a=?2" to "a IN (?1,?2)" transformation to work on virtual tables again. This was formerly restricted because virtual tables could not optimize IN terms. (See check-in [fad88e71cf195e].) But IN terms are now used by virtual tables (as of check-in [3d65c70343]) so the restriction can now be removed. (check-in: a917c1f092 user: drh tags: IN-with-ORDERBY) | |
2013-02-07
| ||
21:15 | Allow an index to be used for sorting even if prior terms of the index are constrained by IN operators. (check-in: 98bf668ab1 user: drh tags: IN-with-ORDERBY) | |
09:33 | Fix harmless compiler warnings. (check-in: 4a7b4ee011 user: drh tags: trunk) | |
05:12 | Add the ability to skip defining the localtime() function when being compiled for WinCE. (check-in: e1640876df user: mistachkin tags: trunk) | |
2013-01-30
| ||
01:46 | Remove some debugging logic accidently left in the limit.test module. (check-in: 7d346250e8 user: drh tags: trunk) | |
2013-01-29
| ||
23:55 | • Fixed ticket [db4d96798d]: LIMIT does not work with nested views containing UNION ALL plus 3 other changes (artifact: fb99c7de2d user: drh) | |
23:55 | Fix LIMIT and OFFSET so that they work and do not leak memory even on complex queries involving deeply nested views of UNION ALL compounds. Ticket [db4d96798da8]. Secondary to ticket [d58ccbb3f1b7]. (check-in: 497ee36cb8 user: drh tags: trunk) | |
23:32 | • Ticket [db4d96798d] LIMIT does not work with nested views containing UNION ALL status still Open with 6 other changes (artifact: 85bbb79f0d user: drh) | |
19:14 | New debugging pragmas: PRAGMA vdbe_debug=ON is short-hand for the sql_trace, vdbe_listing, and vdbe_trace pragmas. PRAGMA vdbe_debug enables tracing of sqlite3VdbeAddOp() calls. None of this is active unless compiled with SQLITE_DEBUG. (check-in: ae565ff3e0 user: drh tags: trunk) | |
2013-01-28
| ||
22:52 | Fix an issue with the SQLITE_TESTCTRL_EXPLAIN_STMT and compound queries with multiple terms. (check-in: a6499c2521 user: drh tags: trunk) | |
19:34 | • New ticket [db4d96798d] LIMIT does not work with nested views containing UNION ALL. (artifact: 8c39a3c9ee user: drh) | |
19:00 | • Fixed ticket [d58ccbb3f1]: Segmentation fault on a valid query with "union" plus 6 other changes (artifact: df11176738 user: drh) | |
19:00 | Issue an error message and quit (rather than overflowing a reference counter) if the number of references to a table exceeds the maximum due to nested UNION views. Fix for ticket [d58ccbb3f1]. (check-in: c2462a95ed user: drh tags: trunk) | |
18:18 | Cause the command-line shell to issue an error message if you give something that does not look like a boolean value to a dot-command that wants a boolean argument. (check-in: b4d94947fc user: drh tags: trunk) | |
10:28 | • New ticket [d58ccbb3f1] Segmentation fault on a valid query with "union". (artifact: ff39df430c user: anonymous) | |
2013-01-26
| ||
19:31 | Add a single test case to fts4unicode.test to verify that title-case maps to lower case. (check-in: 955a9459da user: drh tags: trunk) | |
19:26 | Add a single test case to fts4unicode.test to verify that title-case maps to lower case. (Leaf check-in: 46f7c9301e user: drh tags: branch-3.7.15) | |
2013-01-25
| ||
19:11 | Fix the test_spellfix.c extension so that it can be made loadable at run-time. Add spellfix to the shell when building using the build-shell.sh script. (check-in: 7813b17d8b user: drh tags: trunk) | |
18:33 | Enhance the command-line shell so that adding a non-zero numeric argument to the ".exit" command causes an immediate exit without cleaning up. This can be used (for example) to cause journal files to be left behind. (check-in: 8ba951d1b7 user: drh tags: trunk) | |
15:59 | Add btree-page decoding logic to showwal.c. Commands of the form: "showwal $FILE 123bmc" show the content of the btree page in frame 123. "b" means decode the btree. "c" means show cell content. "m" means give a map of the btree page. (check-in: 93b159da5d user: drh tags: trunk) | |
15:31 | Further improvements to showwal.c: Reset the checksum after each frame so that only individual checksum failures are shown. And only show failures, not correct checksums. (check-in: 4e2bf57549 user: drh tags: trunk) | |
15:09 | Enhance the "showwal" utility program to show checksum failures on frames. (check-in: a7f6d19816 user: drh tags: trunk) | |
02:10 | Enhancements to the query planner to exploit transitive relationships in the WHERE clause, and other minor changes to bring the sessions branch into alignment with the trunk. (check-in: 82d3d1ae82 user: drh tags: sessions) | |
2013-01-23
| ||
18:53 | Improved parsing of the arguments to the ".backup" command in the command-line shell. (check-in: f1127e87b9 user: drh tags: trunk) | |
18:44 | Fix a double-free() call that can occur when SQLITE_ENABLE_TREE_EXPLAIN is defined. (check-in: 5bfb5967d7 user: drh tags: trunk) | |
2013-01-20
| ||
00:18 | Fix a typo in a comment in the test_regexp.c test file. (check-in: 68346af70b user: drh tags: trunk) | |
2013-01-18
| ||
03:35 | The \xXX escape in the test_regexp.c must be followed by exactly two hex digits. (check-in: 82957495aa user: drh tags: trunk) | |
2013-01-17
| ||
22:08 | • Edit [593d67c8b0908daf|593d67c8b0]: Mark "Closed". (artifact: 0526569e6a user: drh) | |
17:20 | Enhance the query planner to exploit transitivity of join constraints. (check-in: 38852f158a user: drh tags: trunk) | |
17:05 | • Edit [652233d646236d3f|652233d646]: Mark "Closed". (artifact: ae22eb46a7 user: drh) | |
17:05 | • Edit [dd473cae5b6ea02b|dd473cae5b]: Mark "Closed". (artifact: fab4f78685 user: drh) | |
17:05 | Improved error messages on the RTREE virtual table. Make the "fs" virtual table used for testing available on windows. (check-in: c0b90d75a8 user: drh tags: trunk) | |
16:43 | Add the ability to disable transitive constraints using the sqlite3_test_control(SQLITE_TESTCTRL_OPTIMIZATIONS) interface. (Closed-Leaf check-in: 593d67c8b0 user: drh tags: transitive-constraints) | |
16:18 | Avoid unnecessary collating sequence and affinity restrictions on the use of transitivity. Add test cases to show that the restrictions are not needed. (check-in: 56549f4566 user: drh tags: transitive-constraints) | |
15:05 | Make more aggressive use of transitivity in optimizing queries. Add a test case. (check-in: d96762841a user: drh tags: transitive-constraints) | |
03:18 | Enhance RTree virtual table creation error messages that involve the getNodeSize() function. (Closed-Leaf check-in: 652233d646 user: mistachkin tags: rtreeErrMsg) | |
03:18 | Make the 'fs' virtual table module portable to Windows. (Closed-Leaf check-in: dd473cae5b user: mistachkin tags: fsVfsWin) | |
00:08 | Improved comments explaining the operation of the findTerm() utility routine in where.c. Increase the maximum number of levels of transitivity from 4 to 11. (check-in: fe152f8b04 user: drh tags: transitive-constraints) | |
2013-01-16
| ||
20:33 | Fix the activate_extensions pragma so that it is a no-op when the required argument is omitted. (check-in: 6195ebd833 user: drh tags: trunk) | |
17:08 | Enhance the query planner to exploit transitivity of join constraints in a multi-way join. (check-in: 13171eb5dc user: drh tags: transitive-constraints) | |
00:46 | Improvements to query planning for joins: Avoid unnecessary calls to "optimal scan" checks in cases where table reordering is not possible. Make sure optimal scan checks are carried out for CROSS JOINs and LEFT JOINs. (check-in: d5ebb78778 user: drh tags: trunk) | |
2013-01-15
| ||
18:49 | Fix a missing word in a comment. Enhance the "wheretrace" debugging output to show the estimated cost of each table option while planning the join order. (check-in: ac4e119a87 user: drh tags: trunk) | |
16:15 | Clarification to a comment in where.c. No code changes. (check-in: 04507c1763 user: drh tags: trunk) | |
15:28 | • Closed ticket [7c6a01c6c5]: Multi-column index is not used with IN operator plus 6 other changes (artifact: cf1aa36725 user: dan) ... 1 similar event omitted. | |
2013-01-11
| ||
09:58 | Add another test for the fts4 content= option. (check-in: 7e6007a000 user: dan tags: trunk) | |
2013-01-09
| ||
15:44 | Check in an extra test for the fts4 "content=" option. No code changes. (check-in: 0d0e5ab8f1 user: dan tags: trunk) | |
14:49 | Merge latest trunk changes into the sessions branch, especially the ORDER BY bug fix of 3.7.15.2. (check-in: 34af6fac67 user: drh tags: sessions) | |
14:43 | • Fixed ticket [c997b11c4d]: ORDER BY clause ignored in 3-way join query plus 3 other changes (artifact: 6645b72352 user: drh) | |
14:42 | • Edit [3d0609c958040d04|3d0609c958]: Edit check-in comment. (artifact: b78af229e4 user: drh) | |
14:42 | • Edit [5774f2175ce621df|5774f2175c]: Edit check-in comment. (artifact: bbafb26d35 user: drh) | |
14:41 | • Edit [598f5f7596b0557b|598f5f7596]: Edit check-in comment. (artifact: 2659e49c24 user: drh) | |
13:25 | • Edit [c0e09560d26f0a64|c0e09560d2]: Change background color to "#d0c0ff". Edit check-in comment. Add tag "version-3.7.15.2". (artifact: 69d144701b user: drh) | |
11:53 | Version 3.7.15.2 (check-in: c0e09560d2 user: drh tags: version-3.7.15.2, branch-3.7.15) | |
11:44 | Fix an over-aggressive optimization of ORDER BY on a three-way join where the second table is UNIQUE and the ORDER BY occurs on the third table. Ticket [c997b11c4d53a2ee]. (check-in: 3d0609c958 user: drh tags: branch-3.7.15) | |
11:31 | Fix an over-aggressive optimization of ORDER BY on a three-way join where the second table is UNIQUE and the ORDER BY occurs on the third table. Ticket [c997b11c4d53a2]. (check-in: 5774f2175c user: drh tags: trunk) | |
11:27 | Fix the date on the new orderby3.test test case. (check-in: 7249bfc2ca user: drh tags: trunk) | |
11:25 | Add a test case that demonstrates ticket [c997b11c4d53a2ee9983]. (check-in: 598f5f7596 user: drh tags: trunk) | |
09:39 | • Ticket [c997b11c4d] ORDER BY clause ignored in 3-way join query status still Open with 3 other changes (artifact: 45820a5886 user: dan) ... 1 similar event omitted. | |
2013-01-08
| ||
17:24 | Merge updates from trunk. (Closed-Leaf check-in: f29680c468 user: mistachkin tags: configReadOnly) | |
12:49 | • Edit [0a1207c895d9f775|0a1207c895]: Move to branch mistake. Mark "Closed". Edit check-in comment. (artifact: 85513c1466 user: drh) | |
12:48 | Do not raise an error if an unknown SQL function is found in a CHECK constraint while parsing the schema of an existing database. (check-in: cda790280a user: drh tags: trunk) | |
2013-01-07
| ||
17:31 | Merge updates from trunk. (check-in: bf90f1fbf8 user: mistachkin tags: configReadOnly) | |
13:26 | Do not raise an error if an unknown SQL function is found in a CHECK constraint while parsing the schema of an existing database. This version causes a run-time error when processing STAT3 tables. (Closed-Leaf check-in: 0a1207c895 user: dan tags: mistake) | |
2013-01-05
| ||
17:17 | More bug fixes to the test_regexp.c module. Bring test_regexp.c into alignment with the regexp.c file in the Fossil sources. (check-in: 7695b88fe0 user: drh tags: trunk) | |
2013-01-04
| ||
22:26 | Remove superfluous text from a comment. (check-in: e9ac533960 user: mistachkin tags: trunk) | |
20:45 | Do not use umask() since it change the umask for the entire process, not just the thread using SQLite. Make whatever permission changes are needed using fchmod() after the file is created, instead. (check-in: 6c4c2b7dba user: drh tags: trunk) | |
19:22 | Fix an out-of-order local variable declaration in test_regexp.c. (check-in: 8285b15a05 user: drh tags: trunk) | |
14:06 | Fix the zInit[] optimization of test_regexp.c when the initial string contains 3-byte UTF8 characters. (check-in: 357231ec97 user: drh tags: trunk) | |
2013-01-03
| ||
22:22 | Merge recent trunk changes into the sessions branch. (check-in: 7e068e39b3 user: drh tags: sessions) | |
19:34 | Bring back test_regexp changes that were made when porting to Fossil. Also fix some bugs that were introduced by the Fossil port. (check-in: 45c158b1a0 user: drh tags: trunk) | |
18:07 | • Edit [20730bad7082b559|20730bad70]: Mark "Closed". (artifact: 371aec3f47 user: drh) | |
18:07 | Improvements to column name resolution in queries with parenthesized FROM clauses. Also includes a fix for ticket [beba9cae6345a3]. (check-in: 99127a669c user: drh tags: trunk) | |
17:34 | Further corner-case fixes to the name resolution logic. (Closed-Leaf check-in: 20730bad70 user: drh tags: name-resolution-fix) | |
16:54 | Remove an incorrect assert() statement (ticket [beba9cae6345a]). Fix other minor problems in the name resolution logic. (check-in: afe96a118c user: drh tags: name-resolution-fix) | |
15:27 | • New ticket [beba9cae63] Assertion fault on a valid query. (artifact: abccd059f8 user: drh) | |
00:45 | Now supports result sets of the form "TABLE.*" with nested FROM clauses. (check-in: 4cf5ed7ea1 user: drh tags: name-resolution-fix) | |
2013-01-02
| ||
21:16 | • Ticket [5ac9b497de] Some issues with aliases, fully qualified identifiers, and * status still Open with 3 other changes (artifact: 59d155c926 user: anonymous) | |
14:57 | When resolving result-set name collisions, make them x:1, x:2, x:3, etc. instead of x:1, x:1:1, x:1;1;1. (check-in: ef01e30456 user: drh tags: name-resolution-fix) | |
12:50 | • Ticket [5ac9b497de] Some issues with aliases, fully qualified identifiers, and * status still Open with 7 other changes (artifact: a2adb458a0 user: drh) | |
12:49 | • Add attachment bugselect_test.sqlite to ticket [5ac9b497de] (artifact: 0a4eca845a user: nobody) | |
12:48 | • Delete attachment "bugselect_test.sqlite" from ticket [5ac9b497de] (artifact: e72a5c8bd5 user: nobody) | |
12:47 | • Ticket [5ac9b497de] Some issues with aliases, fully qualified identifiers, and * status still Open with 6 other changes (artifact: 98d95015ce user: anonymous) | |
12:29 | Merge all the latest trunk changes into the name-resolution enhancement branch. (check-in: a5f4d2b641 user: drh tags: name-resolution-fix) | |
04:46 | • Ticket [6c266900a2] shell: The column mode (and width option) does not manage correctly UTF-8 status still Open with 5 other changes (artifact: 0d16918047 user: anonymous) | |
04:43 | • Add attachment bug536662_test.result to ticket [6c266900a2] (artifact: 325f5c5653 user: nobody) | |