f44ed02790
Add test cases for ticket #3378 and #3381 . Add a temporary hack to get those
...
to problems fixed. The hack causes failures in alias.test, but those are much
less serious than the aforementioned tickets. This is a stop-gap until we can
figure out a proper fix. (CVS 5711)
FossilOrigin-Name: a67da9dd2ff6acc163de4ce2b836b03e3f159a88
2008-09-16 18:02:47 +00:00
181ddaa184
Use (file nativename (pwd)) instead of just (pwd) to find the name of the current directory to pass to "PRAGMA temp_store_directory" in pragma.test. This helps the test pass on non-unix systems. (CVS 5709)
...
FossilOrigin-Name: 50feaa3707f4f61202bc855802ab2e405365d801
2008-09-16 15:50:11 +00:00
ec8d24279b
Add test script selectC.test which demonstrates ticket #3381 . (CVS 5708)
...
FossilOrigin-Name: 3847faff55d4bd7574785c3b18d5c95e687c7598
2008-09-16 15:09:53 +00:00
fab1127bd1
If the xAccess() call used by "PRAGMA temp_store_directory = /new/path/" to determine if the supplied directory is writable returns an error, assume the directory is not writable. (CVS 5707)
...
FossilOrigin-Name: e8418588f2c23487cefda702849d4546202fd8ec
2008-09-16 14:38:02 +00:00
5a70d286f5
Add test case for ticket #3376 . (CVS 5705)
...
FossilOrigin-Name: c64260579d353df3eae8c355b082b8206bc6185b
2008-09-16 11:58:20 +00:00
b5774cfa8f
Adjust the page recycling algorithm so that the number of pages allocated
...
to each connection does not exceed its cache_size limit. (CVS 5701)
FossilOrigin-Name: 3bc221b940565133ae8d95f59b3b120e57df0124
2008-09-15 15:36:57 +00:00
4ff6202642
Fix the async.test test script so that it invokes (finish_test) even if the asynchronous backend is not included in the build (and no tests are run). (CVS 5700)
...
FossilOrigin-Name: 5c954b40ecb71203b1013c23cdac54ff83484b0a
2008-09-15 14:47:21 +00:00
78a906552d
Fix the shared_err.test script so that it works if the device supports SQLITE_IOCAP_SAFEAPPEND. (CVS 5699)
...
FossilOrigin-Name: 38e5ea070a38fe1656e0f5c3024f28ce67eae725
2008-09-15 14:42:38 +00:00
f018cc2ef0
Fix issues with bizarrely quoted column names. Tickets #3370 , #3371 ,
...
and #3372 . (CVS 5696)
FossilOrigin-Name: ced6bbd228b4a324ddb9c5ff15fd027811c8806a
2008-09-13 01:20:14 +00:00
8578611b95
Fix the NEAR connector in FTS3 so that it can take ranges in excess of 9.
...
The maximum range is now 32767. (CVS 5695)
FossilOrigin-Name: 8e9b9553115c42dae38cad0612d98d9a0c453a5c
2008-09-12 18:25:30 +00:00
755339ec0f
Add a case to permutations.test to run tests with the IOCAP_SAFEAPPEND property set. (CVS 5693)
...
FossilOrigin-Name: 80bdaafa77ec5c967f633eaaf5ee6f493a6e5a56
2008-09-12 10:22:40 +00:00
540cf6a192
Add a couple of (fconfigure) commands to configure the incremental blob channels used by test file incrblob.test. This is required so that the tests work on windows and other platforms that have a default -translation mode other than 'lf'. (CVS 5692)
...
FossilOrigin-Name: 753caa20ca50bc42d747d934ccc61438790e7f32
2008-09-11 11:27:59 +00:00
67fd7a9a98
Fix some trivial cases where database corruption was causing an error code other than SQLITE_CORRUPT to be returned. (CVS 5690)
...
FossilOrigin-Name: 89fda074f6b4959c32f1083badba3c73cffb4995
2008-09-10 17:53:35 +00:00
9f580ad886
Fix for handling database files corrupted in such a was as to make a b-tree page a direct or indirect descendant of itself. (CVS 5689)
...
FossilOrigin-Name: 93545861a70c190d67b0d1effdd8fe038d28811c
2008-09-10 14:45:57 +00:00
38816ecf99
Avoid deleting a file while it is still open in corrupt2.test. Not all platforms support this. (CVS 5687)
...
FossilOrigin-Name: 099adfd31167a78d803e2992e5f50cf4e292dd43
2008-09-10 11:28:37 +00:00
f8b10a855e
Fix some test script details so that the test suite runs with an SQLITE_DEFAULT_AUTOVACUUM=2 build. (CVS 5686)
...
FossilOrigin-Name: 300a64b725a111ee66e38de099314f03b064c6eb
2008-09-10 10:57:27 +00:00
f2fb044bca
Add fuzz3.test. For testing the library's response to corrupted database files. (CVS 5685)
...
FossilOrigin-Name: 7fd4dd95791974b0ef6cf30a186b32df25ee2211
2008-09-09 18:28:06 +00:00
e3602be8fd
Calling sqlite3_create_function with nArg==(-1) does not override prior
...
calls on the same function name with nArg>=0. Ticket #3345 . Add the
new -argcount option to the "function" method in the TCL interface. (CVS 5684)
FossilOrigin-Name: 5aa5b8044a14f59559c1839dc0799b0d2f990809
2008-09-09 12:31:33 +00:00
ff9b2e75b4
If the 'rootpage' column of the sqlite_master table contains a NULL value, return SQLITE_CORRUPT to the caller. (CVS 5681)
...
FossilOrigin-Name: a7b7b126e9e9b0cd2d68643d8dff321cf41ce2ee
2008-09-08 09:06:18 +00:00
fdd8e5bab8
Deallocate a temp register allocated by codeEqualityTerm() in where.c. If it is not deallocated, its value may be reused by the column-cache mechanism. However, by the time it is used, the value may have been clobbered by a sub-routine that also uses the same temp register. Fix for #3357 . (CVS 5679)
...
FossilOrigin-Name: 7c0f638ef3d7ff9156f07d6fb01448453ffcf5ac
2008-09-06 14:19:11 +00:00
f7cbfae96a
Change pcache.test so that it works if sqlite is configured to create auto-vacuum databases by default. (CVS 5678)
...
FossilOrigin-Name: 55e677569ec131c388841f6f453291f737738076
2008-09-05 05:29:08 +00:00
518002e4ba
Fix a problem in btree.c preventing an OOM error from being propagated up to the caller. (CVS 5677)
...
FossilOrigin-Name: 0b8ee83f2ebadab099ccd6490f6995949dafdd6f
2008-09-05 05:02:46 +00:00
cc91e7f83e
Make the default threading mode multithread (-nomutex) in the TCL interface. (CVS 5670)
...
FossilOrigin-Name: d9e826942673ad048d611c014bfbee39ab5535c8
2008-09-03 01:08:00 +00:00
039963ad33
Add support for SQLITE_OPEN_FULLMUTEX. (CVS 5669)
...
FossilOrigin-Name: f2f361a5e2fb81fb0f99e83ecf8bae9a750723b1
2008-09-03 00:43:15 +00:00
78f82d1e6c
Continuing work on adding full support for the SQLITE_OMIT_WSD
...
compile-time option. (CVS 5658)
FossilOrigin-Name: ef26ea5c46d3915d206f8ff7f82a24f4c8955f1f
2008-09-02 00:52:52 +00:00
588a9a1a1c
Defer deleting Table objects associated with flattened subqueries until
...
all code has been generated, in case some expression node still references
the Table object. Ticket #3346 . (CVS 5650)
FossilOrigin-Name: d04d70336727a0db959c672e6c22cdaa0505dce5
2008-09-01 15:52:10 +00:00
5393b651c6
Run permutation subtests in sorted order. (CVS 5646)
...
FossilOrigin-Name: 4cd1bdf3ce8077e10dcd8ae4fe2df0dd9bb0f56b
2008-08-30 16:07:03 +00:00
c1def3e0af
Add some code to permutations.test to make sure no test file modifies the shared-cache setting. (CVS 5645)
...
FossilOrigin-Name: 8565b7c66525dc7808a2a266deb1a0d995c99917
2008-08-30 13:25:10 +00:00
3dbb0572d7
Make sure thread003.test waits for all spawned threads to finish before continuing. (CVS 5644)
...
FossilOrigin-Name: 87c7e82f54cd446721d553d5c48ca2571b063669
2008-08-30 09:10:16 +00:00
7a1d17f1d7
Modify tclsqlite.test so that it works reliably with tcl 8.5.4. (CVS 5640)
...
FossilOrigin-Name: 790d329f5d18d361a5d6d34f46c269f8b4057cd9
2008-08-29 15:54:56 +00:00
34c61e68ad
In permutations.test, disable tests that depend on soft-heap-limit functionality when running the memsubsys2 variant. It disables the soft-heap-limit. (CVS 5639)
...
FossilOrigin-Name: 047c7bdb9f37462c462071334f1cb9d3400917db
2008-08-29 12:00:20 +00:00
062d4cb0ae
If a page is made eligible for recycling when more than the configured maximum number of pages are allocated, free it immediately instead of adding it to the LRU list. (CVS 5638)
...
FossilOrigin-Name: 4b12922dcb4547bf3a7276d0542b2e1d12ad338d
2008-08-29 09:10:02 +00:00
8b213899e8
Avoid reevaluating WHERE and ORDER BY expressions that alias terms in the
...
result set. Ticket #3343 . Note that aliased GROUP BY expressions are still
evaluated twice. (CVS 5637)
FossilOrigin-Name: ab0292caa5887cc1bdc0e8c9d3f3502b83975440
2008-08-29 02:14:02 +00:00
3fb120cb9d
Fix ioerr5.test so that it works with the new pcache module. (CVS 5636)
...
FossilOrigin-Name: 83e6a75e7d70b4b01f0892924d7a8a49d5ef6bf2
2008-08-28 18:35:34 +00:00
570f5c7d70
Partial fix for a bug in recovery from xStress failures in pcache. (CVS 5635)
...
FossilOrigin-Name: 44193b92770062271711570d8532fa5af5f5da54
2008-08-28 17:46:18 +00:00
81fa193a66
Avoid using (clock seconds) in thread003.test. It is not available if testfixture is linked to tcl 8.5. (CVS 5634)
...
FossilOrigin-Name: b606263d0868aed267bcec623b9fe4d142099145
2008-08-28 13:55:10 +00:00
f599a1994c
Enable the disabled asserts added by (5629). Add extra tests to thread003.test. And the required modifications to pcache.c. (CVS 5631)
...
FossilOrigin-Name: 473c09fac22ed2f56ea86150a60b9f0f2263c889
2008-08-28 10:21:16 +00:00
51d2d03636
Fix a threads/mutex problem in pcache.c. (CVS 5630)
...
FossilOrigin-Name: 1928f15b78eee0fbf0a8ecdbbdd38dbbde2942b8
2008-08-28 08:31:48 +00:00
59633aeec2
If any error occurs during sqlite3_open(), move the database handle into "sick" state. When in the sick state the user can use sqlite3_errcode() and sqlite3_errmsg(), but not much else. (CVS 5628)
...
FossilOrigin-Name: ce9c74eaab459ddde213c828e821940f5d6cb354
2008-08-27 19:01:57 +00:00
255538e947
Add the trans2.test script designed to stress statement rollback and
...
no-write optimizations on large transactions with a small cache. (CVS 5627)
FossilOrigin-Name: 39c34e2238c27b2a2f4f0b896126ccbd299114c5
2008-08-27 18:56:36 +00:00
468c82bc50
Modifications to malloc5.test to account for the fact that sqlite3_release_memory() no longer reclaims dirty pages. (CVS 5625)
...
FossilOrigin-Name: b01c65b065c62e3dd71e88866a953668b5e2f25f
2008-08-27 16:38:56 +00:00
8af6906348
Clear the $result variable prior to using it in corrupt2.test. (CVS 5624)
...
FossilOrigin-Name: 12f2d24f88e55d170dd7750e7904ff14e84e820e
2008-08-27 16:14:20 +00:00
426c854102
Fix an issue with the permutation test script. (CVS 5619)
...
FossilOrigin-Name: 2e12aa3e078c0da9e418ff1f25a08f05cd03c07d
2008-08-26 23:08:04 +00:00
7426f864ae
All the page_size pragma to change the page size on a new :memory: database,
...
but not a vacuumed :memory: database. Ticket #3335 (CVS 5617)
FossilOrigin-Name: 226a9056783247679fcf442e10807a1f2707f463
2008-08-26 21:07:26 +00:00
d491e1bfd1
Simplify the pcache module by only recycling clean pages from 'other' caches. This commit causes errors in test files ioerr5.test and malloc5.test because they test recycling dirty pages from other caches. (CVS 5615)
...
FossilOrigin-Name: 9e511e161bcb077450d31fca5dd20c2557f103b3
2008-08-26 18:05:48 +00:00
229cf702f0
Do not flatten subqueries where the subquery has a LIMIT and the outer
...
query has a WHERE clause. Ticket #3334 . (CVS 5613)
FossilOrigin-Name: 4995a1d1c9530be9ce647d338169620cd95a72eb
2008-08-26 12:56:14 +00:00
df81a25abe
Fix obscure permutation test problems. (CVS 5611)
...
FossilOrigin-Name: aa92a1bec3d6bbcc59680ba13fed51ada9249d4c
2008-08-25 19:09:01 +00:00
0a846f96ef
Fix bug in the premutation testing that was causing many permutations from
...
begin skipped. There are now 16 errors reported by the permutation test. (CVS 5610)
FossilOrigin-Name: 4ad096bda1fc5c7b66f71ff5b32a4085c9a40574
2008-08-25 17:23:29 +00:00
f436620e3f
Additional coverage testing in the new name resolver module. (CVS 5608)
...
FossilOrigin-Name: 0d61960afd35721d6d07acd75288c20d2cd6fda1
2008-08-25 12:14:08 +00:00
8c20014a0a
If the sector size is greater than the database page size, SQLite journals all pages that lie within a sector before writing to any of them. This change ensure that a journal sync does not occur halfway through journalling the set of pages that belong to a single sector. (CVS 5605)
...
FossilOrigin-Name: 16f612d61e00938f29ecae4ebfe598be7a8709a8
2008-08-25 07:12:28 +00:00
