c2ee76cb1c
Fix a memory leak introduced by the latest changes to pager.c. (CVS 3554)
...
FossilOrigin-Name: 8cad5d671be9be3f7dd7dab99ad65c0fa21931ad
2007-01-04 14:58:14 +00:00
5de872d520
Reactivate disabled "alter2" tests. (CVS 3553)
...
FossilOrigin-Name: 093467a099bb205897a58c1eeb734e1d13fba405
2007-01-04 14:36:01 +00:00
89c69d00bd
Fix for ticket #2141 . (CVS 3552)
...
FossilOrigin-Name: 70f5f3b85f30bbec0ddc59ba364e1229c09ed636
2007-01-04 01:20:28 +00:00
dddb2f23e2
Clean up memory leaks and uninitialized variables detected by valgrind.
...
Identify all tests where we deliberately derefence freed memory by adding
a "-misuse" tag. (CVS 3550)
FossilOrigin-Name: 70a862702d6dfcfe73bdeef8f0502c6c50e32a3a
2007-01-03 23:37:28 +00:00
588f5bc31b
Update the vtab_err test to check for -DSQLITE_MEMDEBUG=1 and skip the tests
...
if missing. Pager is more careful to clear its file size cache. Remove
an assert() in VDBE that might fail on a corrupt database file. (CVS 3547)
FossilOrigin-Name: bf1afd016ad71dac90e58540122108f92e77ce3d
2007-01-02 18:41:54 +00:00
cc19254de9
The query optimizer does a better job of optimizing out ORDER BY clauses
...
that contain the rowid or which use indices that contain the rowid.
Ticket #2116 . (CVS 3536)
FossilOrigin-Name: f245f5c2c2d337fe6458824beb7f9e721837765f
2006-12-20 03:24:19 +00:00
61dfc31d80
Query optimizer enhancement: In "FROM a,b,c left join d" allow the C table
...
to be reordered with A and B. This used to be the case but the capability
was removed by (3203) and (3052) in response to ticket #1652 . This change
restores the capability. (CVS 3529)
FossilOrigin-Name: 7393c81b8cb9d4344ae744de9eabcb3af64f1db8
2006-12-16 16:25:15 +00:00
736c7d4b2c
Change the table_info pragma so that it returns NULL for the default
...
value if there is no default value. Ticket #2078 . (CVS 3527)
FossilOrigin-Name: 5f21c3a5f02b4f2c4550f5904e9d0e1e2eafb0f3
2006-11-30 13:06:37 +00:00
741f70633d
Improvements to the new performance tests. (CVS 3526)
...
FossilOrigin-Name: 27f56c20514030e009fc3aa7e060d2e6276ddb83
2006-11-30 13:06:00 +00:00
d53f898f51
Test that terms longer than interior nodes work correctly. A bug
...
prior to fts2.c r1.10 meant that such large terms caused an eventual
stack overflow. (CVS 3523)
FossilOrigin-Name: 66581162daa188d23078c9d21fd5b2563d4d238a
2006-11-29 21:03:00 +00:00
abcddedb37
Added the speed1.test script (CVS 3522)
...
FossilOrigin-Name: 30355dfbd920f3b6a78110aaf370371f620324b7
2006-11-29 20:52:59 +00:00
3590f15775
Improvements to the speed tests recently added to the test suite. (CVS 3519)
...
FossilOrigin-Name: 272c1a6e61d053121b5412564948dad4366b5727
2006-11-23 21:09:10 +00:00
b62c335ed6
Add performance tests to the test suite. (CVS 3516)
...
FossilOrigin-Name: 270c745dffad7aa24f8707720b3d68ad7a6b2749
2006-11-23 09:39:16 +00:00
b900aaf34a
First cut at adding the sqlite3_prepare_v2() API. Test cases added, but
...
more testing would be useful. Still need to update the documentation. (CVS 3506)
FossilOrigin-Name: f1efae9224170c9155afcf17ab3ee769a557b874
2006-11-09 00:24:53 +00:00
382765866b
Fix a bug in the optimizer that was causing it to miss an OR optimization
...
opportunity. (CVS 3502)
FossilOrigin-Name: 9bf153b54c6e9ba16914dedd9e2949f32d7550ea
2006-11-06 15:10:05 +00:00
d5d63ca6a3
Test to force edge cases in query logic. Basically, exercise code to
...
handle lack of hits correctly. (CVS 3485)
FossilOrigin-Name: 2cb59033662f25677169e2e63b871fb0a4c10c21
2006-10-25 20:27:39 +00:00
8e734e3518
dup fts1 tests and edit for fts2. fts1porter.test omitted because it
...
depends on being able to poke through to %_term table. (CVS 3482)
FossilOrigin-Name: 2806c3415841b98d52163fa672a747d0a47ffd41
2006-10-19 23:36:25 +00:00
1c5f160762
Add tests for delete and update in fts1. (CVS 3481)
...
FossilOrigin-Name: b01c4371d861a087623a34c38cb8db74eca95348
2006-10-19 23:28:35 +00:00
28f4591466
Fix a problems that arise if malloc() fails while compiling SELECT
...
statements within a TRIGGER. (CVS 3478)
FossilOrigin-Name: ee4894b49995e4904db1991281563cfbb7b1c16d
2006-10-18 23:26:38 +00:00
f6bbe022c7
Make sure the names of all expressions in compound SELECT statements used
...
as subqueries are correctly resolved. Ticket #2018 . (CVS 3477)
FossilOrigin-Name: b886eaa334150262ce4d1a1d0470ca4cf623a396
2006-10-13 15:34:16 +00:00
53c36d5444
The snippet generator adds ellipsis between text from different columns. (CVS 3465)
...
FossilOrigin-Name: 6cf1fb9f801dc1b2865c0d1f9afb1b2076d4246e
2006-10-04 17:35:28 +00:00
d9910fe529
Tests cases automatically remove many of their temporary files. (CVS 3463)
...
FossilOrigin-Name: eef0ec0d7ae0743d29454567f539e46ad2d5008e
2006-10-04 11:55:49 +00:00
b1b6d4a929
Make DL_POSITION the default mode in FTS1. Remove the need to compile
...
with SQLITE_CORE when SQLITE_ENABLE_FTS1 is used. (CVS 3462)
FossilOrigin-Name: df1a4b4834fdc88056371bcc767c5dfde2eaab72
2006-10-03 19:37:37 +00:00
f02a759980
Another typo in the Porter stemmer check-in. (CVS 3455)
...
FossilOrigin-Name: 6696bda11ccad9663b15206592116d638aa3ff0a
2006-10-01 20:41:03 +00:00
b3be9815a1
Typo in previous check-in. (CVS 3454)
...
FossilOrigin-Name: a7350bf86c41c428adbfe42dc9cbb3ecf0045c25
2006-10-01 18:59:56 +00:00
8923c9d378
Remove one non-working test case fromthe Porter stemmer tests and add
...
an acknowledgement for the source of the test data (Martin Porter himself.) (CVS 3453)
FossilOrigin-Name: 1a2df2a61b3c84feae7587fa5b1eebf9c7e73daa
2006-10-01 18:58:31 +00:00
6da40bcd79
Add a Porter stemmer option to the FTS1 module. (CVS 3452)
...
FossilOrigin-Name: 936b06aaa8133e83104de87e03dc94e286a31f86
2006-10-01 18:41:19 +00:00
2564ef9781
Make sure memory does not leak when patching up column names so that
...
they are unique in a join or view. Tickets #1952 and #2002 . (CVS 3451)
FossilOrigin-Name: fcde639119c309c699ee9dd60ed60fd6e9c8c077
2006-09-29 14:01:04 +00:00
7cf43fa64e
Fix a bug in the handling of the OR operator in FTS1. Test cases added to
...
prevent a repeat. (CVS 3450)
FossilOrigin-Name: 8cdf1d6ae018dfc93f8f0962b2530e31aa0bebff
2006-09-28 19:43:31 +00:00
07aa67c14a
More snippet generator improvements and test cases. (CVS 3449)
...
FossilOrigin-Name: 0934d220b33c52024f42c89fa13326bd52333f39
2006-09-28 18:57:59 +00:00
1e7423e57f
Bug fix in the FTS1 snippet generator. Improvements in the way the snippet
...
generator handles whitespace. (CVS 3448)
FossilOrigin-Name: d3f4ae827582bd0aac54ae3211d272a1429b6523
2006-09-28 18:37:15 +00:00
361e2bdeb5
Avoid segfaults when inserted NULL values into FTS1. (CVS 3447)
...
FossilOrigin-Name: 165645d30115f3171fc45489823f85639fe2bfcd
2006-09-28 11:41:41 +00:00
9df9492adc
Fix a roundoff error in the %f converter of strftime(). Ticket #1991 . (CVS 3442)
...
FossilOrigin-Name: 51b9c755ea01528e32690aabe91236ed917369f1
2006-09-25 18:03:28 +00:00
ece3c728d0
Be sure to ignore PRAGMA encoding pragmas if the encoding has already been
...
set for a database. Ticket #1987 . This patch also includes some cleanup
of the schema parser and initialization logic. (CVS 3436)
FossilOrigin-Name: dc797bf4fa96deabd9ceb6cc062b98d2ac49a574
2006-09-23 20:36:01 +00:00
8b62817797
Implementation of the snippet() function for FTS1. Includes a few
...
simple test cases but more testing is needed. (CVS 3431)
FossilOrigin-Name: c7ee60d00976efab25a830e7416538010c734129
2006-09-21 02:03:08 +00:00
b08249ced3
Modify FTS1 so that the "magic" column has the same name as the virtual
...
table. Offsets are retrieved using a special "offsets" function whose
first argument is the magic column. Snippets will ultimately be retrieved
in the same way. (CVS 3427)
FossilOrigin-Name: 5e35dc1ffadfe7fa47673d052501ee79903eead9
2006-09-18 02:12:47 +00:00
b7481e70c5
Add the sqlite3_overload_function() API - part of the virtual table
...
interface. (CVS 3426)
FossilOrigin-Name: aa7728f9f5b80dbb1b3db124f84b9166bf72bdd3
2006-09-16 21:45:14 +00:00
e49f982792
Bug fix and better testing of the extended result codes. (CVS 3423)
...
FossilOrigin-Name: 78ae74db1cbf605cd421e7ea321e879d3638968e
2006-09-15 12:29:16 +00:00
4ac285a1c2
Add support for extended result codes - additional result information
...
carried in the higher bits of the integer return codes. This must be
enabled using the sqlite3_extended_result_code() API. Only a few extra
result codes are currently defined. (CVS 3422)
FossilOrigin-Name: ba579ddc4361fc6e8ea66f9385770d70dfe94751
2006-09-15 07:28:50 +00:00
8abc58e33b
New FTS1 test data based on enron emails. (CVS 3421)
...
FossilOrigin-Name: 01651a32c6e67c4ac2cd23f1da7f3cc3adad1b33
2006-09-14 21:08:54 +00:00
a3baa963bc
Implementation of "column:" modifiers in FTS1 queries. (CVS 3411)
...
FossilOrigin-Name: 820634f71e3a3499994f82b56b784d22a7e3cdcf
2006-09-13 16:02:43 +00:00
cbaac514bc
Module spec parser enhancements for FTS1. Now able to cope with column
...
names in the spec that are SQL keywords or have special characters, etc.
Also added support for additional control lines. Column names can be
followed by a type specifier (which is ignored.) (CVS 3410)
FossilOrigin-Name: adb780e0dc8bc7dcd1102efbfa4bc17eefdf968e
2006-09-13 15:20:13 +00:00
a6be0dc938
Fix the FTS1 test cases and add new tests. Comments added to the FTS1 code. (CVS 3409)
...
FossilOrigin-Name: 528036c828c93c78ca879bf89a52131b72e24067
2006-09-13 12:36:08 +00:00
fdd48a76a6
Add support for IF EXISTS on CREATE/DROP TRIGGER/VIEW. Ticket #1899 . (CVS 3406)
...
FossilOrigin-Name: e4fe736cfbbdc081581911a01690576034877b72
2006-09-11 23:45:48 +00:00
a2a9d18869
Add some simple test cases for the OR and NOT logic of the fts1 module.
...
Fix lots of bugs discovered while developing these test cases. (CVS 3400)
FossilOrigin-Name: 70bcff024b44d1b40afac6eba959fa89fb993147
2006-09-10 03:34:06 +00:00
f11c34df74
Bug fix in date/time computations. Ticket #1964 .
...
Some unrelated comment typos are also fixed and got accidently
checked in at the same time. (CVS 3396)
FossilOrigin-Name: c81eaa0dc9a327d222e066076c4a2da5e69d8c21
2006-09-08 12:27:36 +00:00
b2b4996280
Fix a bug in the new misc6.test script. Fix error messages when not
...
compiled with memory debugging enabled. Ticket #1957 . (CVS 3392)
FossilOrigin-Name: 9fb92024bf5058bdc32066a0d07b93da575779fa
2006-09-04 18:54:14 +00:00
f0313813ec
Make sure strings returned by sqlite3_value_text() and sqlite3_value_text16()
...
are always '\000'-terminated. (CVS 3391)
FossilOrigin-Name: 2c63588b45f4e1ab9b9f1b72c901f3800433424a
2006-09-04 15:53:53 +00:00
f80ad49f72
Fix bugs in test scripts so that fulltest will pass. (CVS 3390)
...
FossilOrigin-Name: 367bd8376f323beb3148eab86ada1a3cb379ba3b
2006-09-02 22:14:59 +00:00
80788d8b65
Test for busted TCL builds that do not support 64-bit integers and print
...
a warning message to users that test failures may be a result of the bad
TCL build and not some problem with SQLite. Ticket #1953 . (CVS 3386)
FossilOrigin-Name: ca864ee913ea5ae88761e617bcac300ffa339369
2006-09-02 14:50:23 +00:00
