7b4fc6a8cb
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)
FossilOrigin-Name: 912faf18d86416b1a36660851f8a4554e6746875
2007-02-06 13:26:32 +00:00
d7263927f7
Set the MEM_Term flag when an internal string has a nul-terminator appended to it. Fix for #2213 . (CVS 3627)
...
FossilOrigin-Name: fc969ad991e5114c3612f4796e342a6db2d79cd5
2007-02-05 14:21:47 +00:00
8b4c40d8ac
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)
FossilOrigin-Name: 85cca7cd252d46ba71d302a89bc67c56146ec552
2007-02-01 23:02:45 +00:00
137c728f5a
Replace the randomHex() function with separate functions
...
randomBlob() and hex(). (CVS 3620)
FossilOrigin-Name: f5ad74a9bc57e83c11beb3cf46bb6cd8c9de3f86
2007-01-29 17:58:28 +00:00
63cf66f02e
Add the randomhex() function as a built-in. (CVS 3619)
...
FossilOrigin-Name: a6001589ab1349f7a6b4af941e9e0fd73d13c1c0
2007-01-29 15:50:05 +00:00
e3d559ad37
Adjustments to the pragma test for OS-X. (CVS 3615)
...
FossilOrigin-Name: 4d0d2063df2191155b290dc426b502bc7e1959c7
2007-01-27 14:26:07 +00:00
05a6f4ac56
More adjustments to the pragma test for windows. (CVS 3614)
...
FossilOrigin-Name: 79a65436d1cd10ed6318edfaa7d76e2b99c7c879
2007-01-27 14:11:41 +00:00
90ddb12399
Adjustment to tests for PRAGMA integrity_check so that they run under windows. (CVS 3613)
...
FossilOrigin-Name: a79914ccbc9e33a1dbc9be3de805f99ab3b61c78
2007-01-27 14:04:13 +00:00
1dcdbc0639
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)
FossilOrigin-Name: d564a039f27be2bb2c3973e79dc99b25869139da
2007-01-27 02:24:54 +00:00
0ee5a1e763
Fix a (harmless) assertion fault on nested views where the inner views
...
are compound selects. Ticket #2192 . (CVS 3605)
FossilOrigin-Name: 942e7193bbf1ffe9a703891d175e016631e2ad5c
2007-01-26 19:04:00 +00:00
f2d315d0c2
Fix an additional problem with the IS NULL optimization on LEFT JOINs.
...
Ticket #2189 . See also ticket #2177 . (CVS 3602)
FossilOrigin-Name: 358dd82d3a921228155e2cf9e22aedd2b651ca9c
2007-01-25 16:56:06 +00:00
4e653855ab
Do not run the fts2i.test unless the FTS2 module is available. (CVS 3601)
...
FossilOrigin-Name: 310f68585188ae49b603af9bdef4ee7738ae37c0
2007-01-24 03:46:35 +00:00
e0201fc0e2
Do not run test fts1i.test if FTS1 is not installed. (CVS 3600)
...
FossilOrigin-Name: 810c0176f8413995a78963c453e4377f11b293b5
2007-01-24 03:43:20 +00:00
1941a3e8ac
Fix a pragma test so that it works in directories that have spaces in
...
their names. (CVS 3597)
FossilOrigin-Name: 071c957a5dcd236139113d7c0dc1d58b54180eb7
2007-01-22 13:02:24 +00:00
3ad202dd17
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)
FossilOrigin-Name: 4f2ab4b6320ffc621900049b41f50bc30d76d7f5
2007-01-19 22:59:56 +00:00
c49de5d98c
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)
FossilOrigin-Name: 335863e4d16113fb9ecebce35d2db043771d98b1
2007-01-19 01:06:01 +00:00
f6d8ab87c6
Fix a bug in sqlite3_prepare_v2() introduced by checkin (3578) and reported
...
on the mailing list. (CVS 3592)
FossilOrigin-Name: 87248470362f444f2339fee18d3624e8544f5256
2007-01-12 23:43:42 +00:00
297a66c257
Documentation and tests to show that the cause of a parsing error is
...
available on sqlite3_errmsg after sqlite3_step return SQLITE_SCHEMA. (CVS 3581)
FossilOrigin-Name: 31a661d424d0fe03eaf78f98031e360102dafeff
2007-01-09 15:06:41 +00:00
d47bcb9c73
Updates tests and documentation to justify the behavior observed in
...
ticket #2158 . No changes to code. (CVS 3580)
FossilOrigin-Name: e1f7cf065d2c4ca53e233a4506759a1899ad0560
2007-01-09 15:02:03 +00:00
3c23a88562
When an automatic re-prepare occurs, take care not to reset the internal
...
schema symbol table. Ticket #2156 . This change also includes some debugging
enhancements. (CVS 3578)
FossilOrigin-Name: 43fe7fc1c38f8d9b3c1346cb1d890c2e25cefe15
2007-01-09 14:01:13 +00:00
f1d89f0dd9
Additional tests of sqlite3_prepare_v2. (CVS 3577)
...
FossilOrigin-Name: b0650aa6cfcb4c59fd8556b8f5523573538bd7e5
2007-01-08 22:40:32 +00:00
c515525765
Fix a critical bug in sqlite3_prepare_v2 that can lead to segfaults when
...
the schema changes and the statement is recompiled automatically.
Ticket #2154 . (CVS 3576)
FossilOrigin-Name: 3401388dba6c150f788397a4dfbcdb01313247e2
2007-01-08 21:07:17 +00:00
622fa9a80e
Fix another round-off problem in strftime(). Ticket #2153 . (CVS 3574)
...
FossilOrigin-Name: d49ddc5ff05dd65e73edfa76db7e1af36967d81a
2007-01-08 16:19:07 +00:00
c2c9eef6b3
Fix a round-off error in the %W and %j conversions of the strftime() function.
...
Ticket #2150 . (CVS 3570)
FossilOrigin-Name: 52067937803e6b36afc8f11c5d24059414208b77
2007-01-08 13:07:30 +00:00
ba92a2ebad
Get threadtest2.c working again after being long neglected. (CVS 3562)
...
FossilOrigin-Name: 06216d0d3be38bfabda9f5f450a5eaccd20b52b9
2007-01-05 01:58:26 +00:00
92895268a4
Fix a test case that changed due to (3560). Ticket #2143 (CVS 3561)
...
FossilOrigin-Name: c28664d314b8caa2844072ee9e5a50901996dc1e
2007-01-05 00:14:27 +00:00
25403650c3
Fix the user_version and schema_version pragmas so that they set a result
...
column name. Ticket #2143 . (CVS 3560)
FossilOrigin-Name: f81c4227c26a4d43993904ab05c1eb9f988e3b66
2007-01-04 22:13:41 +00:00
e61c769620
Fix the trigger4 test so that it runs on windows. (CVS 3559)
...
FossilOrigin-Name: 5e4e65ea15c51e75e9f003fbfde3fe87e22b889b
2007-01-04 22:13:02 +00:00
15c9ffcd3f
Disable the alter2.test on utf16 since the results of that test only
...
work for utf8. (CVS 3555)
FossilOrigin-Name: 87f350f35be64cdaa128bde35fbe93251b107025
2007-01-04 16:37:03 +00:00
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
