Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
100 events occurring around e890bcde34370079.
|
2012-12-17
| ||
| 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. | |
| 18:38 | Some errors in veryquick resolved. Many more to go. (check-in: 972443b4 user: drh tags: ticket-71e333e7) | |
| 16:03 | • Edit [7fafab12e4c0c832|7fafab12]: Edit check-in comment. (artifact: ac6ff8f2 user: drh) | |
| 14:02 | Veryquick now runs to completion without segfaulting or asserting. But there are still lots of errors. (check-in: 7fafab12 user: drh tags: ticket-71e333e7) | |
| 10:55 | Do not run test file malloc3.test as part of the inmemory_journal permutation. Explanation is in a comment at the top of malloc3.test. (check-in: df1827b1 user: dan tags: trunk) | |
| 09:08 | Spelling and header fixes for the async extension. (check-in: 930ba852 user: mistachkin tags: trunk) | |
| 04:46 | Backport VSIX tooling and packaging fixes and enhancements. (check-in: e890bcde user: mistachkin tags: branch-3.7.14) | |
|
2012-12-06
| ||
| 23:16 | In the async VFS, treat the new error code SQLITE_IOERR_DELETE_NOENT as success for xDelete. (check-in: c507ca4a user: mistachkin tags: trunk) | |
| 21:16 | Remove the Expr.pColl field and compute the collating sequence as it is needed. This fixes the test script "shared9.test", though there is still a memory leak. And there are other problems. Consider this a work-in-progress. (check-in: fd011cb2 user: drh tags: ticket-71e333e7) | |
| 20:27 | Cherrypick [79ef8e3c77] (Apply the same restrictions on constant refactoring to statements within a trigger program as top-level statements). (Leaf check-in: 34aafb74 user: dan tags: branch-3.7.9) | |
| 20:19 | Cherrypick [557c69055a3] and [0064bab7714] (OP_Once-related fixes for triggers). (check-in: 0d7b5d45 user: dan tags: branch-3.7.9) | |
| 19:42 | • Closed ticket [ae3c5670]: Bug caused by factoring of constants in trigger programs plus 1 other change (artifact: 55927093 user: dan) ... 1 similar event omitted. | |
| 19:41 | Merge the constant-refactoring-in-triggers branch with the trunk. (check-in: 79ef8e3c user: dan tags: trunk) | |
| 19:37 | Apply the same restrictions on constant refactoring to statements within a trigger program as top-level statements. Candidate fix for [ae3c5670b6]. (Closed-Leaf check-in: 0c31a468 user: dan tags: constant-refactoring-in-triggers) | |
| 19:01 | Add the SQLITE_FCNTL_TEMPFILENAME file control that asks the underlying VFS to return a new temporary filename. Per request from NSS team at Mozilla. (check-in: 1a63b1d5 user: drh tags: trunk) | |
| 18:48 | • New ticket [ae3c5670] Bug caused by factoring of constants in trigger programs. (artifact: 61605c7d user: dan) | |
| 15:15 | Add a test case that demonstrates ticket [71e333e7d2e642]. (check-in: cc6e0785 user: drh tags: ticket-71e333e7) | |
| 15:05 | • New ticket [71e333e7] COLLATE operator inside CHECK constraint fails in shared-cache mode. (artifact: 7f899f32 user: drh) | |
| 04:33 | For the sqlite3-all.c target, use backslashes when calling the splitter script via the MSVC makefile. (check-in: d507648d user: mistachkin tags: trunk) | |
| 04:19 | Bring the ancient malloc3.test file closer into relevance with the latest core code. (check-in: 9793a21c user: mistachkin tags: trunk) | |
| 02:57 | • Edit [51bfd63b7f9fe538|51bfd63b]: Mark "Closed". (artifact: 7890293b user: drh) | |
| 02:57 | • Edit [597333f1024092b9|597333f1]: Mark "Closed". (artifact: 567ddb44 user: drh) | |
| 02:57 | • Edit [692ad3c02b1af83f|692ad3c0]: Mark "Closed". (artifact: 93185c80 user: drh) | |
| 02:56 | • Edit [b3809c937b230b34|b3809c93]: Mark "Closed". (artifact: 92ed4505 user: drh) | |
| 02:56 | • Edit [e1feab9834fe829d|e1feab98]: Mark "Closed". (artifact: 04be96a2 user: drh) | |
| 02:56 | Stop using the TCL_LIBS configuration variable when linking with Tcl. Remove superfluous 'rm' command from the "clean" target. (check-in: 15512772 user: drh tags: trunk) | |
| 01:03 | Remove obsolete comments from the definition of the CollSeq object. (check-in: 7b695101 user: drh tags: trunk) | |
| 00:16 | Stop using the TCL_LIBS configuration variable when linking with Tcl. Remove superfluous 'rm' command. (Closed-Leaf check-in: e1feab98 user: mistachkin tags: noTclLibs) | |
|
2012-12-05
| ||
| 19:04 | Disable a couple of tests in where.test when running the "no_optimization" permutation. (check-in: 5e961e37 user: dan tags: trunk) | |
| 16:44 | Modify a query in test/thread001.test to ensure that results are returned in the order expected by the test. (check-in: 51cbddd5 user: dan tags: trunk) | |
| 14:37 | Fixes to a test case in shared_err.test. The fix is to prevent sqlite3_prepare() from being called when the test intends to test the response of sqlite3_step() to an OOM condition. (check-in: 40c14395 user: dan tags: trunk) | |
| 14:31 | Make sure memory is freed using a routine that is compatible with the routine used to allocate the memory. The SQLITE_MEMDEBUG compile-time option enforces this. (check-in: 9f6c6885 user: drh tags: trunk) | |
| 11:30 | Since errors are ignored anyway, use sqlite3OsFileControlHint() instead of OsFileControl() to invoke the SQLITE_FCNTL_BUSY_HANDLER file-control. (check-in: bdceca27 user: dan tags: trunk) | |
| 10:01 | If the atomic-write property is enabled, a transaction may be committed in journal_mode=DELETE mode without ever actually creating a journal file on disk. In this case, do not attempt to unlink() the journal file when committing the transaction. (check-in: 11aa47b0 user: dan tags: trunk) | |
| 09:12 | Update a couple of test scripts so that they work in auto-vacuum mode. (check-in: 04ab2dc6 user: dan tags: trunk) | |
|
2012-12-04
| ||
| 11:03 | Fix a harmless compiler warning. (check-in: 12693deb user: drh tags: trunk) | |
| 10:52 | • Edit [59c233942e583086|59c23394]: Mark "Closed". (artifact: f6150875 user: drh) | |
| 10:47 | • Edit [59c233942e583086|59c23394]: Move to branch mistake. (artifact: 8ca063c2 user: drh) | |
| 05:24 | Add a test to ensure that the fix in [b0c1ba655d] has worked. (check-in: 41806de5 user: dan tags: trunk) | |
| 05:23 | • Edit [59c233942e583086|59c23394]: Add tag "mistake". Cancel tag "trunk". (artifact: 022df688 user: dan) | |
| 05:21 | Add a test to ensure that the fix in [b0c1ba655d] has worked. (Closed-Leaf check-in: 59c23394 user: dan tags: mistake) | |
| 00:59 | Improvements to the 'tcl' shell output mode. Escape doublequotes, set separator to space when mode is set, and skip separator after final column. (check-in: 487ba753 user: drh tags: trunk) | |
| 00:58 | • Edit [41fd9dd29034b226|41fd9dd2]: Mark "Closed". (artifact: 7e1a4ee1 user: drh) | |
| 00:53 | Fix an uninitialized variable detected by valgrind. (check-in: ffd1e514 user: drh tags: trunk) | |
| 00:37 | Fix an out-of-order function declaration when compiled with MEMDEBUG. (check-in: 6d315578 user: mistachkin tags: trunk) | |
| 00:23 | Improvements to the 'tcl' shell output mode. Escape double quotes, set separator to space when mode is set, and skip separator after final column. (Closed-Leaf check-in: 41fd9dd2 user: mistachkin tags: tclMode) | |
|
2012-12-03
| ||
| 19:42 | Remove an unreachable condition. Replace it with an assert(). (check-in: 7d5fc1a3 user: drh tags: trunk) | |
| 17:04 | Make sure that the optimization that set the maximum column that will be used on a particular query does not mistakenly change an opcode other than OP_OpenRead or OP_OpenWrite. In particular, make sure it does not overwrite the P4 field of an OP_SorterOpen. (check-in: b0c1ba65 user: drh tags: trunk) | |
|
2012-12-02
| ||
| 18:09 | • Edit [2e5e65152758bc37|2e5e6515]: Edit check-in comment. (artifact: e3d13558 user: drh) | |
|
2012-12-01
| ||
| 20:21 | Do not exit the command-line shell if a ".read" command invokes a script that contains two errors. But reported on the mailing list. (check-in: 2e5e6515 user: drh tags: trunk) | |
|
2012-11-29
| ||
| 14:27 | • Closed ticket [f46ca03b]: The order of two operations in asyncLock() plus 6 other changes (artifact: d357b734 user: drh) | |
| 14:26 | Mark the "async" module as deprecated as its functionality has been superceded by WAL mode. This closes ticket [f46ca03b55ae0e] (check-in: 3d548db7 user: drh tags: trunk) | |
| 08:31 | • New ticket [f46ca03b] The order of two operations in asyncLock(). (artifact: e93ae3ff user: anonymous) | |
|
2012-11-27
| ||
| 21:56 | Update the sessions branch to include the SQLLOG enhancement, the SQLITE_IOERR_DELETE_NOENT fix, and a fix for the number-of-documents bug in FTS4. (check-in: ba8d08b6 user: drh tags: sessions) | |
| 21:22 | Add the SQLLOG capability to trunk. (check-in: f0843f88 user: drh tags: trunk) | |