Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
100 events occurring around 3d0e00c731c39af9.
|
2013-01-08
| ||
| 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) | |
| 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) | |