Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
100 events occurring around 5bfb5967d70433bf.
|
2013-02-19
| ||
| 18:45 | Enhance the pgidx of the showdb utility so that it provides better information even if the sqlite_master table is corrupt. (check-in: d14263a7 user: drh tags: trunk) | |
| 18:34 | Do not rollback the schema if a parsing error occurs while parsing the schema and writable_schema is set. (check-in: 680d3ab5 user: drh tags: trunk) | |
| 18:34 | Truncate over-length source lines in sqliteInt.h to 80 characters or less. (check-in: d71abab0 user: drh tags: trunk) | |
| 11:51 | Add the edit_cost_table= command to the spellfix1 virtual table, permitting the edit distance cost table to be changed at runtime. (check-in: 89d63682 user: drh tags: trunk) | |
|
2013-02-17
| ||
| 01:36 | • Edit [6f3081a8e52beca1|6f3081a8]: Move to branch shunning-error. (artifact: b23c705e user: drh) | |
|
2013-02-16
| ||
| 02:41 | Fix an unsafe VM register deallocation. (check-in: cfba2c8d user: drh tags: trunk) | |
|
2013-02-15
| ||
| 04:21 | Check for a NULL handle prior to manually calling winClose. (check-in: 843e1c54 user: mistachkin tags: trunk) | |
|
2013-02-14
| ||
| 16:16 | Verify that the schema has not changed before running PRAGMA table_info, index_list, index_info, and foreign_key_list. (check-in: 82952d08 user: drh tags: trunk) | |
|
2013-02-13
| ||
| 22:54 | On WinCE, fill in the winFile structure after winceCreateLock has succeeded. (check-in: ec13544c user: mistachkin tags: trunk) | |
| 14:04 | Add recent API additions to the extension mechanism. (check-in: 7e10a62d user: drh tags: trunk) | |
| 13:42 | Enhancements to the query planner to make use of indices for ORDER BY even when IN constraints are in the WHERE clause. Add extended error codes for all SQLITE_CONSTRAINT errors. (check-in: 7e14dc73 user: drh tags: sessions) | |
| 01:00 | • Edit [71b6c26053fdf2a5|71b6c260]: Mark "Closed". (artifact: 52e27ce4 user: drh) | |
| 01:00 | Allow an index to be used for sorting even if prior terms of the index are constrained by IN operators. (check-in: 2cef8b68 user: drh tags: trunk) | |
|
2013-02-12
| ||
| 22:20 | • Edit [09dfc0c915ec2f0c|09dfc0c9]: Mark "Closed". (artifact: e990b82e user: drh) | |
| 22:20 | Improve memory allocation error handling on WinCE. (check-in: cdbca259 user: drh tags: trunk) | |
| 22:15 | • Edit [3f67437536591a1b|3f674375]: Mark "Closed". (artifact: 2a6a12ef 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: b7222a2b user: drh tags: trunk) | |
| 09:46 | Improve memory allocation error handling on WinCE. (Closed-Leaf check-in: 09dfc0c9 user: mistachkin tags: wince) | |
|
2013-02-11
| ||
| 13:47 | Add extended error codes for all SQLITE_CONSTRAINT errors. (check-in: 939d8282 user: drh tags: trunk) | |
| 01:37 | • Ticket [25e09aa2] Lint mode status still Open with 6 other changes (artifact: fadb9ad0 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: 3f674375 user: drh tags: constraint-error-codes) | |
| 13:58 | Add extended error codes for constraint errors. (check-in: 54611046 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: 71b6c260 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: b016b754 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: f78395c8 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: a917c1f0 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: 98bf668a user: drh tags: IN-with-ORDERBY) | |
| 09:33 | Fix harmless compiler warnings. (check-in: 4a7b4ee0 user: drh tags: trunk) | |
| 05:12 | Add the ability to skip defining the localtime() function when being compiled for WinCE. (check-in: e1640876 user: mistachkin tags: trunk) | |
|
2013-01-30
| ||
| 01:46 | Remove some debugging logic accidently left in the limit.test module. (check-in: 7d346250 user: drh tags: trunk) | |
|
2013-01-29
| ||
| 23:55 | • Fixed ticket [db4d9679]: LIMIT does not work with nested views containing UNION ALL plus 3 other changes (artifact: fb99c7de 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: 497ee36c user: drh tags: trunk) | |
| 23:32 | • Ticket [db4d9679] LIMIT does not work with nested views containing UNION ALL status still Open with 6 other changes (artifact: 85bbb79f 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: ae565ff3 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: a6499c25 user: drh tags: trunk) | |
| 19:34 | • New ticket [db4d9679] LIMIT does not work with nested views containing UNION ALL. (artifact: 8c39a3c9 user: drh) | |
| 19:00 | • Fixed ticket [d58ccbb3]: Segmentation fault on a valid query with "union" plus 6 other changes (artifact: df111767 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: c2462a95 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: b4d94947 user: drh tags: trunk) | |
| 10:28 | • New ticket [d58ccbb3] Segmentation fault on a valid query with "union". (artifact: ff39df43 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: 955a9459 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: 46f7c930 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: 7813b17d 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: 8ba951d1 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: 93b159da 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: 4e2bf575 user: drh tags: trunk) | |
| 15:09 | Enhance the "showwal" utility program to show checksum failures on frames. (check-in: a7f6d198 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: 82d3d1ae 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: f1127e87 user: drh tags: trunk) | |
| 18:44 | Fix a double-free() call that can occur when SQLITE_ENABLE_TREE_EXPLAIN is defined. (check-in: 5bfb5967 user: drh tags: trunk) | |
|
2013-01-20
| ||
| 00:18 | Fix a typo in a comment in the test_regexp.c test file. (check-in: 68346af7 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: 82957495 user: drh tags: trunk) | |
|
2013-01-17
| ||
| 22:08 | • Edit [593d67c8b0908daf|593d67c8]: Mark "Closed". (artifact: 0526569e user: drh) | |
| 17:20 | Enhance the query planner to exploit transitivity of join constraints. (check-in: 38852f15 user: drh tags: trunk) | |
| 17:05 | • Edit [652233d646236d3f|652233d6]: Mark "Closed". (artifact: ae22eb46 user: drh) | |
| 17:05 | • Edit [dd473cae5b6ea02b|dd473cae]: Mark "Closed". (artifact: fab4f786 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: c0b90d75 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: 593d67c8 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: 56549f45 user: drh tags: transitive-constraints) | |
| 15:05 | Make more aggressive use of transitivity in optimizing queries. Add a test case. (check-in: d9676284 user: drh tags: transitive-constraints) | |
| 03:18 | Enhance RTree virtual table creation error messages that involve the getNodeSize() function. (Closed-Leaf check-in: 652233d6 user: mistachkin tags: rtreeErrMsg) | |
| 03:18 | Make the 'fs' virtual table module portable to Windows. (Closed-Leaf check-in: dd473cae 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: fe152f8b 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: 6195ebd8 user: drh tags: trunk) | |
| 17:08 | Enhance the query planner to exploit transitivity of join constraints in a multi-way join. (check-in: 13171eb5 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: d5ebb787 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: ac4e119a user: drh tags: trunk) | |
| 16:15 | Clarification to a comment in where.c. No code changes. (check-in: 04507c17 user: drh tags: trunk) | |
| 15:28 | • Closed ticket [7c6a01c6]: Multi-column index is not used with IN operator plus 6 other changes (artifact: cf1aa367 user: dan) ... 1 similar event omitted. | |
|
2013-01-11
| ||
| 09:58 | Add another test for the fts4 content= option. (check-in: 7e6007a0 user: dan tags: trunk) | |
|
2013-01-09
| ||
| 15:44 | Check in an extra test for the fts4 "content=" option. No code changes. (check-in: 0d0e5ab8 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: 34af6fac user: drh tags: sessions) | |
| 14:43 | • Fixed ticket [c997b11c]: ORDER BY clause ignored in 3-way join query plus 3 other changes (artifact: 6645b723 user: drh) | |
| 14:42 | • Edit [3d0609c958040d04|3d0609c9]: Edit check-in comment. (artifact: b78af229 user: drh) | |
| 14:42 | • Edit [5774f2175ce621df|5774f217]: Edit check-in comment. (artifact: bbafb26d user: drh) | |
| 14:41 | • Edit [598f5f7596b0557b|598f5f75]: Edit check-in comment. (artifact: 2659e49c user: drh) | |
| 13:25 | • Edit [c0e09560d26f0a64|c0e09560]: Change background color to "#d0c0ff". Edit check-in comment. Add tag "version-3.7.15.2". (artifact: 69d14470 user: drh) | |
| 11:53 | Version 3.7.15.2 (check-in: c0e09560 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: 3d0609c9 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: 5774f217 user: drh tags: trunk) | |
| 11:27 | Fix the date on the new orderby3.test test case. (check-in: 7249bfc2 user: drh tags: trunk) | |
| 11:25 | Add a test case that demonstrates ticket [c997b11c4d53a2ee9983]. (check-in: 598f5f75 user: drh tags: trunk) | |
| 09:39 | • Ticket [c997b11c] ORDER BY clause ignored in 3-way join query status still Open with 3 other changes (artifact: 45820a58 user: dan) ... 1 similar event omitted. | |
|
2013-01-08
| ||
| 17:24 | Merge updates from trunk. (Closed-Leaf check-in: f29680c4 user: mistachkin tags: configReadOnly) | |
| 12:49 | • Edit [0a1207c895d9f775|0a1207c8]: Move to branch mistake. Mark "Closed". Edit check-in comment. (artifact: 85513c14 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: cda79028 user: drh tags: trunk) | |
|
2013-01-07
| ||
| 17:31 | Merge updates from trunk. (check-in: bf90f1fb 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: 0a1207c8 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: 7695b88f user: drh tags: trunk) | |
|
2013-01-04
| ||
| 22:26 | Remove superfluous text from a comment. (check-in: e9ac5339 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: 6c4c2b7d user: drh tags: trunk) | |
| 19:22 | Fix an out-of-order local variable declaration in test_regexp.c. (check-in: 8285b15a 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: 357231ec user: drh tags: trunk) | |
|
2013-01-03
| ||
| 22:22 | Merge recent trunk changes into the sessions branch. (check-in: 7e068e39 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: 45c158b1 user: drh tags: trunk) | |
| 18:07 | • Edit [20730bad7082b559|20730bad]: Mark "Closed". (artifact: 371aec3f user: drh) | |
| 18:07 | Improvements to column name resolution in queries with parenthesized FROM clauses. Also includes a fix for ticket [beba9cae6345a3]. (check-in: 99127a66 user: drh tags: trunk) | |
| 17:34 | Further corner-case fixes to the name resolution logic. (Closed-Leaf check-in: 20730bad user: drh tags: name-resolution-fix) | |