Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
100 events occurring around 9b67c633d932f3e5.
|
2013-01-03
| ||
| 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) | |
| 16:54 | Remove an incorrect assert() statement (ticket [beba9cae6345a]). Fix other minor problems in the name resolution logic. (check-in: afe96a11 user: drh tags: name-resolution-fix) | |
| 15:27 | • New ticket [beba9cae] Assertion fault on a valid query. (artifact: abccd059 user: drh) | |
| 00:45 | Now supports result sets of the form "TABLE.*" with nested FROM clauses. (check-in: 4cf5ed7e user: drh tags: name-resolution-fix) | |
|
2013-01-02
| ||
| 21:16 | • Ticket [5ac9b497] Some issues with aliases, fully qualified identifiers, and * status still Open with 3 other changes (artifact: 59d155c9 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: ef01e304 user: drh tags: name-resolution-fix) | |
| 12:50 | • Ticket [5ac9b497] Some issues with aliases, fully qualified identifiers, and * status still Open with 7 other changes (artifact: a2adb458 user: drh) | |
| 12:49 | • Add attachment bugselect_test.sqlite to ticket [5ac9b497] (artifact: 0a4eca84 user: nobody) | |
| 12:48 | • Delete attachment "bugselect_test.sqlite" from ticket [5ac9b497] (artifact: e72a5c8b user: nobody) | |
| 12:47 | • Ticket [5ac9b497] Some issues with aliases, fully qualified identifiers, and * status still Open with 6 other changes (artifact: 98d95015 user: anonymous) | |
| 12:29 | Merge all the latest trunk changes into the name-resolution enhancement branch. (check-in: a5f4d2b6 user: drh tags: name-resolution-fix) | |
| 04:46 | • Ticket [6c266900] shell: The column mode (and width option) does not manage correctly UTF-8 status still Open with 5 other changes (artifact: 0d169180 user: anonymous) | |
| 04:43 | • Add attachment bug536662_test.result to ticket [6c266900] (artifact: 325f5c56 user: nobody) | |
| 04:43 | • Add attachment bug536662_test.sqlite to ticket [6c266900] (artifact: e20361ae user: nobody) | |
| 04:42 | • Add attachment bugselect_test.sqlite to ticket [5ac9b497] (artifact: 1830de9a user: nobody) | |
| 04:34 | • New ticket [5ac9b497] Some issues with aliases, fully qualified identifiers, and *. (artifact: a0203678 user: anonymous) | |
| 00:08 | • New ticket [6c266900] shell: The column mode (and width option) does not manage correctly UTF-8. (artifact: 3d7fc0e8 user: anonymous) | |
|
2013-01-01
| ||
| 14:01 | Reduce the size of the Index object (by 8 bytes on x64). (check-in: 5a2ac944 user: drh tags: trunk) | |
| 13:55 | Enhance the table_info pragma so that the pk column shows the order of the columns in a multi-column primary key. (check-in: 3076a890 user: drh tags: trunk) | |
|
2012-12-31
| ||
| 20:16 | More test cases for the REGEXP operator. Fix minor bugs uncovered by these test cases. (check-in: a611c750 user: drh tags: trunk) | |
| 19:18 | Add the test_regexp.c module containing a cross-platform implementation of the REGEXP operator. (check-in: 46c8c01b user: drh tags: trunk) | |
| 17:21 | • Ticket [030632f5] make sqlite2 detect sqlite3 status still Open with 7 other changes (artifact: f996ecde user: anonymous) ... 1 similar event omitted. | |
|
2012-12-23
| ||
| 22:00 | • Add attachment control_c.patch to ticket [1c67bd6c] (artifact: 3334cf61 user: anonymous) | |
|
2012-12-21
| ||
| 16:16 | • Closed ticket [0cfd98ee]: Potential corruption of backup db when backing up a db last written by sqlite<3.7.0 plus 5 other changes (artifact: 82635d7d user: dan) | |
| 16:15 | Ensure the database size field in the db header of a backup database is set correctly. Fix for [0cfd98ee201]. (check-in: ff6857b6 user: dan tags: trunk) | |
| 16:01 | • New ticket [0cfd98ee] Potential corruption of backup db when backing up a db last written by sqlite<3.7.0. (artifact: d23e9114 user: dan) | |
|
2012-12-20
| ||
| 02:38 | • Edit [b5a8f3160b5dc139|b5a8f316]: Mark "Closed". (artifact: a54566a7 user: drh) | |
| 01:15 | Add PRAGMA foreign_key_check. Name the child and parent tables as part of a "foreign key mismatch" error. (check-in: e408dc90 user: drh tags: trunk) | |
| 00:32 | Remove an unreachable branch operation from the foreign_key_check pragma. (Closed-Leaf check-in: b5a8f316 user: drh tags: foreign-key-check) | |
|
2012-12-19
| ||
| 20:39 | Version 3.7.15.1 (check-in: 6b85b767 user: drh tags: release, version-3.7.15.1, branch-3.7.15) | |
| 17:10 | Backport to the 3.7.15 branch the fix to the segfault problem of ticket [a7b7803e8d1e869] which involved the use of "AS" named result columns as logical terms of the WHERE clause. Also, change the version number to 3.7.15.1. (check-in: bae528f4 user: drh tags: branch-3.7.15) | |
| 16:58 | • Edit [0ae142178d5ff874|0ae14217]: Mark "Closed". (artifact: ce1c4fea user: drh) | |
| 16:58 | • Fixed ticket [a7b7803e]: crash when filtering twice by same predicate using aliases plus 3 other changes (artifact: 94765940 user: drh) | |
| 16:58 | Fix the segfault problem of ticket [a7b7803e8d1e869] which involved the use of "AS" named result columns as logical terms of the WHERE clause. (check-in: b3c9e8f8 user: drh tags: trunk) | |
| 16:32 | A couple more test cases. (Closed-Leaf check-in: 0ae14217 user: drh tags: tkt-a7b7803e) | |
| 16:25 | Additional test cases involving the use of a result column specified by its "AS" name as a logical term of the WHERE clause. Ticket [a7b7803e8d1e8699cd]. (check-in: d7cc364e user: drh tags: tkt-a7b7803e) | |
| 15:53 | Proposed fix for ticket [a7b7803e8d1e8699cd8a]. (check-in: 3d0e00c7 user: drh tags: tkt-a7b7803e) | |
| 15:17 | • Fixed ticket [71e333e7]: COLLATE operator inside CHECK constraint fails in shared-cache mode plus 5 other changes (artifact: 5335c947 user: drh) | |
| 15:16 | • Ticket [a7b7803e] crash when filtering twice by same predicate using aliases status still Open with 4 other changes (artifact: 2cbd563d user: drh) ... 2 similar events omitted. | |
| 13:41 | Add commentary to the ExprList object to explain how zSpan is overloaded. Add test cases for the new name resolution functionality. (check-in: 3e7d84db user: drh tags: name-resolution-fix) | |
| 12:46 | • Closed ticket [dec444cd]: rowid not usable in complex queries plus 6 other changes (artifact: 13db8a68 user: drh) | |
| 02:36 | Better resolution of table and column names in joins where some of the terms of the FROM clause are parenthesized. (check-in: 7344e791 user: drh tags: name-resolution-fix) | |
|
2012-12-18
| ||
| 20:41 | • New ticket [dec444cd] rowid not usable in complex queries. (artifact: ae927fc3 user: anonymous) | |
| 19:36 | Optimize the degenerate case of a FROM clause table name enclosed all by itself inside parentheses. Generate code as if the parentheses did not exist, rather than the old behavior of manifesting the parenthesized table into a transient table. Also, tag every FROM-clause SELECT subquery that is generated by a parenthesized FROM-clause expression using the SF_NestedFrom flag. The new SF_NestedFrom flag is not yet used for anything. (check-in: 7fecced4 user: drh tags: trunk) | |
| 16:07 | Resolve names in FROM-clause subqueries prior to resolving names in the result set expressions of a SELECT statement. (check-in: 9b67c633 user: drh tags: trunk) | |
| 14:04 | • Closed ticket [df678d73]: Cache corruption following IO error on systems supporting atomic-write plus 4 other changes (artifact: 500e2da7 user: dan) | |
| 13:12 | Remove old commented-out code from parse.y. Fix some over-length source lines in parse.y. No logical changes. (check-in: 7e30c021 user: drh tags: trunk) | |
| 11:59 | On atomic-write capable systems, if copying the contents of an in-memory journal to disk fails, close the (on disk) journal file before returning the error to the caller. This causes the subsequent rollback operation to use the in-memory journal. Fix for [df678d738adb]. (check-in: 8183d8d7 user: dan tags: trunk) | |
| 11:57 | • New ticket [df678d73] Cache corruption following IO error on systems supporting atomic-write. (artifact: b8af6f09 user: dan) | |
|
2012-12-17
| ||
| 22:32 | Added test cases for PRAGMA foreign_key_check. Fixed a bug that appears when the column order of the child and parent differ. (check-in: 25411f83 user: drh tags: foreign-key-check) | |
| 20:57 | Add to the foreign_key_check pragma an extra output column "parent" that contains the name of the parent table for the constraint that failed. (check-in: 97f7f737 user: drh tags: foreign-key-check) | |
| 20:40 | Enhance the error message for "foreign key mismatch" to include the names of the child and parent tables. Begin adding test cases for PRAGMA foreign_key_check. Make sure PRAGMA foreign_key_check gets all necessary table locks. (check-in: 0f996352 user: drh tags: foreign-key-check) | |
| 18:43 | "PRAGMA foreign_key_check" with no argument checks the foreign keys on all tables. (check-in: 57d47423 user: drh tags: foreign-key-check) | |
| 18:05 | Fix an issue with child keys that are not INTEGER PRIMARY KEY referencing INTEGER PRIMARY KEY in the parent. (check-in: 603b695b user: drh tags: foreign-key-check) | |
| 16:46 | Prototype for PRAGMA that checks all foreign key constraints on a table. (check-in: 01c980e9 user: drh tags: foreign-key-check) | |
|
2012-12-15
| ||
| 14:33 | • Ticket [5eaa61ea] sigbus on disk ful in WAL mode status still Open with 5 other changes (artifact: e816a1c2 user: drh) ... 1 similar event omitted. | |
|
2012-12-14
| ||
| 17:55 | • Edit [d2fb7619b063b329|d2fb7619]: Mark "Closed". (artifact: ca223b0e user: drh) | |
| 17:54 | Optimize IN operators in the WHERE clause of queries using virtual tables. (check-in: 3d65c703 user: drh tags: trunk) | |
| 17:48 | Remove an unreachable branch. Improvements to comments. (Closed-Leaf check-in: d2fb7619 user: drh tags: vtab-IN-opt) | |
| 15:54 | Merge in all the trunk changes that have occurred since this branch was opened. (check-in: 6d507e4d user: drh tags: vtab-IN-opt) | |
| 15:36 | Fix the virtual table IN optimizer so that it work even if the virtual table implementation leaves the sqlite3_index_info.aConstraintUsage[].omit flag clear for an equality constraint that it intends to use. (check-in: d6e045f8 user: drh tags: vtab-IN-opt) | |
|
2012-12-13
| ||
| 18:57 | Generalize the min/max optimization so that if an appropriate index exists, the index it can be used by any aggregate query that contains only a single max() or min() and does not contain a GROUP BY clause. (check-in: 52e75594 user: drh tags: trunk) | |
| 18:51 | Increase the version number to 3.7.16 in advance of adding new features for the next release. (check-in: 8bcf5f51 user: drh tags: trunk) | |
| 16:37 | Attempt to further generalize the min/max optimization so that, if an appropriate index exists, it can be used by any aggregate query that contains only a single aggregate of the form max(colname) or min(colname) and does not contain a GROUP BY clause. (Closed-Leaf check-in: 7280e14c user: dan tags: minmax-opt) | |
|
2012-12-12
| ||
| 14:30 | Allow the error message from "PRAGMA integrity_check" to be longer than 20,000 bytes. (check-in: 120c82d5 user: drh tags: trunk) | |
| 13:36 | Version 3.7.15 (check-in: cd0b37c5 user: dan tags: trunk, release, version-3.7.15) | |
|
2012-12-11
| ||
| 19:40 | Update requirements marks and test cases for multi-VALUE INSERT and to fix typos in requirements text. (check-in: 81d9ee0f user: drh tags: trunk) | |
| 19:10 | Fix a typo in a comment that is used to generate documentation. No changes to code. (check-in: e38adb60 user: drh tags: trunk) | |
| 18:36 | • Edit [cdbfa664839a4095|cdbfa664]: Mark "Closed". (artifact: 34d82def user: drh) | |
| 18:36 | • Edit [0c31a46801746191|0c31a468]: Mark "Closed". (artifact: 0d591ba3 user: drh) | |
|
2012-12-10
| ||
| 22:19 | When an arithmetic operation with two integer operands must give a floating-point answer due to overflow, make sure the answer is not rounded back to integer by affinity. (check-in: bd7aeeb6 user: drh tags: trunk) | |
| 10:22 | Modify releasetest.tcl so that it runs the "checksymbols" test on a build without SQLITE_DEBUG defined. If SQLITE_DEBUG is defined, the sqlite3WhereTrace variable causes the test to fail. (check-in: 75e545a9 user: dan tags: trunk) | |
| 09:08 | Remove a reference to JumpOnce from a comment in vdbe.c. No code changes. (check-in: ee662c03 user: dan tags: trunk) | |
|
2012-12-08
| ||
| 23:37 | Pull the latest trunk changes into the sessions branch, and in particular the collating-sequence refactorization. (check-in: 4f6d69ae user: drh tags: sessions) | |
| 22:14 | Factor some work out of the index loop of the bestBtreeIndex() routine for a small performance increase. (check-in: 92c9ab56 user: drh tags: trunk) | |
| 21:51 | Refactor collating-sequence handling as a fix for ticket [71e333e7d2e642]. The Expr.pColl field is removed from the Expr object. The COLLATE operator now becomes a separate instance of Expr in the expression tree. The code generator looks up the correct collating function as needed, rather than referring to Expr.pColl. (check-in: 8542e618 user: drh tags: trunk) | |
| 21:36 | Adjustments to the collating-sequence refactoring to facilitate full-coverage testing and to fix some minor issues found by TH3. (Closed-Leaf check-in: cdbfa664 user: drh tags: ticket-71e333e7) | |
| 14:16 | Make sure WHERE clause constraints A=B and B=A work the same even with COLLATE clauses. (check-in: b3f53668 user: drh tags: ticket-71e333e7) | |
| 13:26 | Fix the header comment on the OP_Compare operator. (check-in: 2722f407 user: drh tags: ticket-71e333e7) | |
| 06:46 | Merge updates from trunk. (check-in: e65db42c user: mistachkin tags: configReadOnly) | |
| 04:10 | Duplicating check constraint expressions prior to code generation is no longer required, and so it is removed. (check-in: 1a9db8dc user: drh tags: ticket-71e333e7) | |
| 03:34 | Veryquick passes all tests now. (check-in: 7b96115e user: drh tags: ticket-71e333e7) | |
| 00:52 | Recognize TK_COLLATE operators that have been transformed into TK_REGISTER. Skip both TK_COLLATE and TK_AS operators when looking for the top of an expression. (check-in: f66c1db2 user: drh tags: ticket-71e333e7) | |
|
2012-12-07
| ||
| 23:23 | Improved error messages when column integers in an ORDER BY clause are out of range. (check-in: bd960d93 user: drh tags: ticket-71e333e7) | |
| 23:10 | For an ORDER BY on a compound SELECT, take the collating sequence from the left-most term of the compound. (check-in: 8e724b38 user: drh tags: ticket-71e333e7) | |
| 22:54 | Do not report missing collating functions while parsing the schema. Also remove a stray comment. (check-in: e313edca user: drh tags: ticket-71e333e7) | |
| 22:18 | Fix a long-standing issue with the distinct-as-aggregate optimization that only expressed when the new collating-sequence logic is turned on. (check-in: 0aaf52a3 user: drh tags: ticket-71e333e7) | |
| 21:02 | Fix the processing of ORDER BY clauses with COLLATE terms on compound queries. 52 veryquick test failures remain. (check-in: 49654453 user: drh tags: ticket-71e333e7) | |
| 20:31 | Many more tests are passing. Only about 100 failures remain in veryquick. (check-in: f9fa7581 user: drh tags: ticket-71e333e7) | |
| 19:41 | • Closed ticket [d6b36be3]: Sub-select in LIMIT clause may access db without locks. plus 1 other change (artifact: c347a2a0 user: dan) | |
| 19:28 | Ensure the VerifyCookie sub-routine has been run before the database is accessed in an obscure case. Fix for ticket [d6b36be38]. (check-in: 2d5f37c9 user: dan tags: trunk) | |
| 19:02 | • Ticket [d6b36be3] Sub-select in LIMIT clause may access db without locks. status still Open with 1 other change (artifact: af09caff user: dan) ... 2 similar events omitted. | |