SQLite
Timeline
Not logged in

100 check-ins occurring around c0e09560d2.

2013-02-13
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
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
Improve memory allocation error handling on WinCE. check-in: cdbca259 user: drh tags: trunk
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
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
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
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: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
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
17:20
Enhance the query planner to exploit transitivity of join constraints. check-in: 38852f15 user: drh tags: trunk
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
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
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
2013-01-08
17:24
Merge updates from trunk. Closed-Leaf check-in: f29680c4 user: mistachkin tags: configReadOnly
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
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
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
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:29
Merge all the latest trunk changes into the name-resolution enhancement branch. check-in: a5f4d2b6 user: drh tags: name-resolution-fix
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
2012-12-21
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
2012-12-20
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
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
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
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
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
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
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-14
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