drh [Sat, 10 Mar 2007 13:47:01 +0000 (13:47 +0000)]
Updates to the copyright.html page to address concerns some users have
SQLite have about copyright issues. A links to the wikipedia article
on public domain and a public domain icon. (CVS 3679)
drh [Sun, 4 Mar 2007 13:15:27 +0000 (13:15 +0000)]
Changes to the btree and pager that reduce the amount of I/O when dealing
with the freelist. (1) Avoid journaling pages of a table that is being
deleted. (2) Do not read the original content of pages being pulled off
of the freelist. (CVS 3671)
drh [Wed, 28 Feb 2007 04:47:26 +0000 (04:47 +0000)]
Add the undocumented and experimental I/O tracing interface. This
interface is likely to change and may be completely abandoned in the
near future. (CVS 3665)
drh [Sat, 24 Feb 2007 11:52:52 +0000 (11:52 +0000)]
Make sure that integer values are converted to real when pulled from
a REAL table column by GROUP BY. Ticket #2251. Also make sure default
values are correctly expanded. There may be other places in the code
where this issue comes up - we need to look further. (CVS 3659)
drh [Fri, 23 Feb 2007 23:13:33 +0000 (23:13 +0000)]
Disable the OR optimization if it would conflict with column
affinity coercions. Ticket #2249. Additional cleanup and testing
of the OR optimization. (CVS 3658)
drh [Fri, 23 Feb 2007 03:00:44 +0000 (03:00 +0000)]
Clarify the documentation on how comparisons occur in an IN operator.
Fix the comparison operators when both sides of an IN operator are
expressions (ticket #2248).
Changes to main.mk for adding FTS2 into the standard build also
got mixed in with this check-in by mistake. (CVS 3656)
drh [Wed, 14 Feb 2007 12:32:13 +0000 (12:32 +0000)]
In the corrupt2.test script,
change uses of (open ... a) to (open ... RDWR) to work around
inconsistencies in behavior across various platforms. (CVS 3645)
drh [Tue, 13 Feb 2007 12:49:24 +0000 (12:49 +0000)]
Expand the cursor index in SrcList_item to 32-bits to accomodate really
huge VDBE programs resulting from deeply nested triggers. This is an
interim fix until we rework triggers to use subroutines. (CVS 3640)
drh [Wed, 7 Feb 2007 13:09:45 +0000 (13:09 +0000)]
Explicit collations always override implicit collations. This is
backwards compatible since SQLite has not previously supported
explicit collations. Need to add tests of this new behavior. (CVS 3633)
drh [Wed, 7 Feb 2007 01:06:52 +0000 (01:06 +0000)]
Change the coding of PRAGMA count_changes so that it uses memory cells
of the VM rather than the stack, to avoid problems with leftovers on the
stack interfering with other operations. Ticket #2217. (CVS 3632)
shess [Wed, 7 Feb 2007 01:01:17 +0000 (01:01 +0000)]
http://www.sqlite.org/cvstrac/tktview?tn=2219
When creating fts tables in an attached database, the backing tables
are created in database 'main'. This change propagates the
appropriate database name to the routines which build sql statements.
Note that I propagate the database name and table name separately. I
briefly considered just making the table name be "db.table", but it
didn't fit so well in the model used to store the table name and other
information, and having the db name passed separately seemed a bit
more transparent. (CVS 3631)
drh [Tue, 6 Feb 2007 13:26:32 +0000 (13:26 +0000)]
When optimizing out an ORDER BY clause due to uniqueness constraints, make
sure unused terms to the right in the ORDER BY clause to not reference other
tables in a join. Ticket #2211. Additional test cases needed before
closing this ticket. (CVS 3629)
drh [Fri, 2 Feb 2007 12:44:37 +0000 (12:44 +0000)]
Minor tweaks to collating sequences. We'll hold of making major changes
until 3.4.0, since we'll likely end up with some minor technical
imcompatibilities. (CVS 3626)
drh [Thu, 1 Feb 2007 23:02:45 +0000 (23:02 +0000)]
First cut at adding the COLLATE operator. Regression tests pass (or at least
the quick set does) and a few new tests have been added. But many more
tests are needed. Rules for combining collations need to be worked out. (CVS 3624)
drh [Sat, 27 Jan 2007 02:38:29 +0000 (02:38 +0000)]
Parser changes to allow parenthesized numerical arguments to pragmas,
in support of the integrity_check enhancement of check-in (3609)
and ticket #2176. (CVS 3610)
drh [Sat, 27 Jan 2007 02:24:54 +0000 (02:24 +0000)]
Limit the number of errors returned by PRAGMA integrity_check to 100 by
default. Specify an alternative limit using an argument to the pragma.
Ticket #2176. (CVS 3609)
drh [Fri, 26 Jan 2007 19:23:33 +0000 (19:23 +0000)]
Add code to select.c for printing the contents of parse-tree structures.
The code is normally omitted. You must compile with -DSQLITE_TEST
or -DSQLITE_DEBUG to enable it. (CVS 3606)
shess [Fri, 19 Jan 2007 22:59:56 +0000 (22:59 +0000)]
http://www.sqlite.org/cvstrac/tktview?tn=2166,35
Calling UPDATE against an fts table in a UTF-16 database inserts
corrupted data into the database. The UTF-8 data is being inserted
directly. This appears to happen because sqlite3_ value_text()
destructively coerces a value to UTF-8, and it's never converted back
when updating the table. This works around the problem by rearranging
things so that the update happens before the coercion. (CVS 3596)
drh [Fri, 19 Jan 2007 01:06:01 +0000 (01:06 +0000)]
Make sure the IS NULL optimization introduced by check-in (3494) correctly
handles a LEFT JOIN where the a term from the right table of the join uses
an IS NULL constraint. Ticket #2177. This check-in also adds the new test
cases that were suppose to have been added with (3494) but which were
mistakenly omitted. (CVS 3595)
drh [Tue, 16 Jan 2007 18:19:12 +0000 (18:19 +0000)]
Additional memory initialization in lemon - bug reported from wireshark.
Ticket #2172. Note this problem only comes up with certain grammars,
and does not impact SQLite. On the other hand, it might cause SQLite
to run slower. So we might want to revisit this change at some point. (CVS 3594)
drh [Tue, 16 Jan 2007 03:09:02 +0000 (03:09 +0000)]
Make sure the parser generated by lemon always calls destructors on
unused symbols, even if there is no action following the rule.
Ticket #2171. (CVS 3593)
drh [Fri, 12 Jan 2007 23:09:23 +0000 (23:09 +0000)]
Fix a bug in lemon. The code in which the error appears might well be
unreachable. The changes does not effect the code that is generated for
the SQLite parser. Ticket #2164. (CVS 3591)