SQLite
Timeline
Not logged in

2 descendants and 50 ancestors of [0a1207c8]

2013-01-08
17:24
[f29680c4] Closed-Leaf: Merge updates from trunk. (user: mistachkin, tags: configReadOnly)
2013-01-07
17:31
[bf90f1fb] Merge updates from trunk. (user: mistachkin, tags: configReadOnly)
13:26
[0a1207c8] Closed-Leaf: 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. (user: dan, tags: mistake)
2013-01-05
17:17
[7695b88f] More bug fixes to the test_regexp.c module. Bring test_regexp.c into alignment with the regexp.c file in the Fossil sources. (user: drh, tags: trunk)
2013-01-04
22:26
[e9ac5339] Remove superfluous text from a comment. (user: mistachkin, tags: trunk)
20:45
[6c4c2b7d] 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. (user: drh, tags: trunk)
19:22
[8285b15a] Fix an out-of-order local variable declaration in test_regexp.c. (user: drh, tags: trunk)
14:06
[357231ec] Fix the zInit[] optimization of test_regexp.c when the initial string contains 3-byte UTF8 characters. (user: drh, tags: trunk)
2013-01-03
19:34
[45c158b1] Bring back test_regexp changes that were made when porting to Fossil. Also fix some bugs that were introduced by the Fossil port. (user: drh, tags: trunk)
18:07
[99127a66] Improvements to column name resolution in queries with parenthesized FROM clauses. Also includes a fix for ticket [beba9cae6345a3]. (user: drh, tags: trunk)
17:34
[20730bad] Closed-Leaf: Further corner-case fixes to the name resolution logic. (user: drh, tags: name-resolution-fix)
16:54
[afe96a11] Remove an incorrect assert() statement (ticket [beba9cae6345a]). Fix other minor problems in the name resolution logic. (user: drh, tags: name-resolution-fix)
00:45
[4cf5ed7e] Now supports result sets of the form "TABLE.*" with nested FROM clauses. (user: drh, tags: name-resolution-fix)
2013-01-02
14:57
[ef01e304] 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. (user: drh, tags: name-resolution-fix)
12:29
[a5f4d2b6] Merge all the latest trunk changes into the name-resolution enhancement branch. (user: drh, tags: name-resolution-fix)
2013-01-01
14:01
[5a2ac944] Reduce the size of the Index object (by 8 bytes on x64). (user: drh, tags: trunk)
13:55
[3076a890] Enhance the table_info pragma so that the pk column shows the order of the columns in a multi-column primary key. (user: drh, tags: trunk)
2012-12-31
20:16
[a611c750] More test cases for the REGEXP operator. Fix minor bugs uncovered by these test cases. (user: drh, tags: trunk)
19:18
[46c8c01b] Add the test_regexp.c module containing a cross-platform implementation of the REGEXP operator. (user: drh, tags: trunk)
2012-12-21
16:15
[ff6857b6] Ensure the database size field in the db header of a backup database is set correctly. Fix for [0cfd98ee201]. (user: dan, tags: trunk)
2012-12-20
01:15
[e408dc90] Add PRAGMA foreign_key_check. Name the child and parent tables as part of a "foreign key mismatch" error. (user: drh, tags: trunk)
00:32
[b5a8f316] Closed-Leaf: Remove an unreachable branch operation from the foreign_key_check pragma. (user: drh, tags: foreign-key-check)
2012-12-19
16:58
[b3c9e8f8] Fix the segfault problem of ticket [a7b7803e8d1e869] which involved the use of "AS" named result columns as logical terms of the WHERE clause. (user: drh, tags: trunk)
16:32
[0ae14217] Closed-Leaf: A couple more test cases. (user: drh, tags: tkt-a7b7803e)
16:25
[d7cc364e] 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]. (user: drh, tags: tkt-a7b7803e)
15:53
[3d0e00c7] Proposed fix for ticket [a7b7803e8d1e8699cd8a]. (user: drh, tags: tkt-a7b7803e)
13:41
[3e7d84db] Add commentary to the ExprList object to explain how zSpan is overloaded. Add test cases for the new name resolution functionality. (user: drh, tags: name-resolution-fix)
02:36
[7344e791] Better resolution of table and column names in joins where some of the terms of the FROM clause are parenthesized. (user: drh, tags: name-resolution-fix)
2012-12-18
19:36
[7fecced4] 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. (user: drh, tags: trunk)
16:07
[9b67c633] Resolve names in FROM-clause subqueries prior to resolving names in the result set expressions of a SELECT statement. (user: drh, tags: trunk)
13:12
[7e30c021] Remove old commented-out code from parse.y. Fix some over-length source lines in parse.y. No logical changes. (user: drh, tags: trunk)
11:59
[8183d8d7] 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]. (user: dan, tags: trunk)
2012-12-17
22:32
[25411f83] Added test cases for PRAGMA foreign_key_check. Fixed a bug that appears when the column order of the child and parent differ. (user: drh, tags: foreign-key-check)
20:57
[97f7f737] 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. (user: drh, tags: foreign-key-check)
20:40
[0f996352] 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. (user: drh, tags: foreign-key-check)
18:43
[57d47423] "PRAGMA foreign_key_check" with no argument checks the foreign keys on all tables. (user: drh, tags: foreign-key-check)
18:05
[603b695b] Fix an issue with child keys that are not INTEGER PRIMARY KEY referencing INTEGER PRIMARY KEY in the parent. (user: drh, tags: foreign-key-check)
16:46
[01c980e9] Prototype for PRAGMA that checks all foreign key constraints on a table. (user: drh, tags: foreign-key-check)
2012-12-14
17:54
[3d65c703] Optimize IN operators in the WHERE clause of queries using virtual tables. (user: drh, tags: trunk)
17:48
[d2fb7619] Closed-Leaf: Remove an unreachable branch. Improvements to comments. (user: drh, tags: vtab-IN-opt)
15:54
[6d507e4d] Merge in all the trunk changes that have occurred since this branch was opened. (user: drh, tags: vtab-IN-opt)
15:36
[d6e045f8] 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. (user: drh, tags: vtab-IN-opt)
2012-12-13
18:57
[52e75594] 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. (user: drh, tags: trunk)
18:51
[8bcf5f51] Increase the version number to 3.7.16 in advance of adding new features for the next release. (user: drh, tags: trunk)
16:37
[7280e14c] Closed-Leaf: 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. (user: dan, tags: minmax-opt)
2012-12-12
14:30
[120c82d5] Allow the error message from "PRAGMA integrity_check" to be longer than 20,000 bytes. (user: drh, tags: trunk)
13:36
[cd0b37c5] Version 3.7.15 (user: dan, tags: trunk, release, version-3.7.15)
2012-12-11
19:40
[81d9ee0f] Update requirements marks and test cases for multi-VALUE INSERT and to fix typos in requirements text. (user: drh, tags: trunk)
19:10
[e38adb60] Fix a typo in a comment that is used to generate documentation. No changes to code. (user: drh, tags: trunk)
2012-12-10
22:19
[bd7aeeb6] 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. (user: drh, tags: trunk)
10:22
[75e545a9] 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. (user: dan, tags: trunk)
09:08
[ee662c03] Remove a reference to JumpOnce from a comment in vdbe.c. No code changes. (user: dan, tags: trunk)
2012-12-08
22:14
[92c9ab56] Factor some work out of the index loop of the bestBtreeIndex() routine for a small performance increase. (user: drh, tags: trunk)