c66c0e14a6
Fix the allocator in mem5.c so that it can be enabled at run time using the sqlite3_config() function. (CVS 5304)
...
FossilOrigin-Name: 30ff6bb0b2d1068d28e86ac90bb9f454e4537a2d
2008-06-25 14:26:07 +00:00
32155ef0ff
Fix up some details to do with the mem3.c (memsys3) allocator. If the library is compiled with SQLITE_ENABLE_MEMSYS3, the memsys3 allocator can be selected at runtime. (CVS 5303)
...
FossilOrigin-Name: 9c6c8e01b31abfe2bc8e650bbfdb504021dc7e59
2008-06-25 10:34:34 +00:00
29b13cc9d9
Fixed typo to close #1731 . (CVS 5302)
...
FossilOrigin-Name: 9902be8d66453d3f4cfdc7f81a4ebe9bc6729204
2008-06-25 08:02:44 +00:00
ff354e91ba
If a unique index covers any prefix of the ORDER BY clause then let it
...
satisfy the ORDER BY clause. (CVS 5301)
FossilOrigin-Name: e53403b6d742be83c5b130ed6cef4035d081d613
2008-06-25 02:47:57 +00:00
fae37af17f
Add new test script for compound select statements. (CVS 5300)
...
FossilOrigin-Name: a193b1612e7ccd1c8f6136ece8d4768fccfe43fe
2008-06-25 02:22:32 +00:00
57e5ea9327
Modify the memory allocation system in mem3.c so to fit in with the new sqlite3_mem_methods scheme. At this point it only "mostly" works. (CVS 5297)
...
FossilOrigin-Name: 3febef548fb1c314336fe4bc359d72a4fe84e84e
2008-06-24 19:02:55 +00:00
6fb6444c3e
Add a few extra tests to select9.test. (CVS 5296)
...
FossilOrigin-Name: 37b084fd7d7ad7f13fc9454fc25ca5aed48d4a31
2008-06-24 15:39:43 +00:00
f6e369a119
Fix a problem in sqlite3ExprIsInteger() causing failures on select1-4.9.2.
...
Other bug fixes in compound-merge. The compound-merge is still disabled
in this check-in using "#if 0" due to additional bugs. (CVS 5295)
FossilOrigin-Name: 95037e6dbf4ed0ffd38790f3270dcaa4c1ae64ed
2008-06-24 12:46:30 +00:00
398cf3d707
Remove a surplus "breakpoint" from select4.test. (CVS 5294)
...
FossilOrigin-Name: 3117238ce9cbfc36e2de929592decef86220e2a2
2008-06-24 12:28:03 +00:00
9afe68477d
Add start of new test file "select9.test". To test LIMIT, OFFSET and ORDER BY on compound SELECT statements. (CVS 5293)
...
FossilOrigin-Name: 3a13e943d8fb4060fc1f0f827a156a730ee64be0
2008-06-24 11:21:20 +00:00
92b01d53c2
The compound-select merge optimization is mostly working with this check-in.
...
But there are still a few problems and so the optimization is disabled by
and "#if 0". This check-in is to synchronize with the other changes happening
in parallel. (CVS 5291)
FossilOrigin-Name: e2ba324cbcac0ba35bbde50048677e085abb092b
2008-06-24 00:32:35 +00:00
f7b9d66fd4
Fix a bug in handling queries on the sqlite_master table with an empty (0 bytes in size) database file. (CVS 5286)
...
FossilOrigin-Name: f8238770bf41e17014c6de05363b759304fc80de
2008-06-23 18:49:43 +00:00
52fd7beaba
Additional tests added to capi3.test. (CVS 5285)
...
FossilOrigin-Name: 1fdab2c65b966f74bdf130c640ae56a0e811fb71
2008-06-23 17:56:47 +00:00
8cf6c554c0
Fix a bug causing the pager-cache size to be reset to its default value whenever the database schema was reloaded. (CVS 5283)
...
FossilOrigin-Name: 6dbe67da5cb0141e011b4fdcc3964a20f68be843
2008-06-23 16:53:46 +00:00
b13dee9900
Run (a subset of) the rtree tests from quick.test. (CVS 5282)
...
FossilOrigin-Name: e872c78c72eb5976e72123485692a76409bd857f
2008-06-23 15:55:52 +00:00
171bfed311
Fix a bug whereby opening a connection to an existing shared-cache caused the cache-size (the value configured by "PRAGMA cache_size") to revert to its default value. (CVS 5274)
...
FossilOrigin-Name: 0492aa8ed3c35dd2cdfc69c9cb87e43ef0460826
2008-06-23 09:50:50 +00:00
94527a6d49
Prevent veryquick.test and all.test from running permutations.test directly. (CVS 5267)
...
FossilOrigin-Name: ae9e4c0e4d5639ff11f3fa23775a1118b39688c8
2008-06-21 19:20:13 +00:00
2dd6d809b6
Fix a bug in permutations.test causing the utf-16 tests to fail. (CVS 5266)
...
FossilOrigin-Name: 710621f373398748f31942f2ac9d1c857492538a
2008-06-21 19:10:27 +00:00
1077e3f7e0
Add test file permutations.test, which runs various other test files with sqlite configured in various ways. This adds a few new tests and replaces test files autovacuum_crash.test, autovacuum_ioerr.test, exclusive3.test, jrnlmode2.test, jrnlmode3.test, jrnlmode4.test, mutex2 and onefile.test. (CVS 5265)
...
FossilOrigin-Name: 0e9df3507bd30d320b7ccfeaf3e06e10938022e1
2008-06-21 18:07:37 +00:00
959e3a9b80
Remove mutex2.test. It will be replaced later today by permutations.test. (CVS 5261)
...
FossilOrigin-Name: 98a6a0a30f16cbc60c655663b5895429a34da0ba
2008-06-21 12:15:04 +00:00
4b9507a0f1
Fix a problem in the test suite that could cause a crash if using a pre-allocated block of memory for pages (the problem was that sqlite3_shutdown() was being called while there were still open database connections). (CVS 5259)
...
FossilOrigin-Name: 3d413e9b466a871650597407016131df4d07b3d2
2008-06-21 08:12:15 +00:00
9324c8f280
Add a test to check that opening a second connection to a shared cache does not reset the cache size to its default value. (CVS 5256)
...
FossilOrigin-Name: 3546e245aaf5d75b9f52ffb3268da9bc26946396
2008-06-20 17:51:16 +00:00
af83758645
Patch to memsubsys1.test in order to avoid a segfault in tableapi.test. (CVS 5252)
...
FossilOrigin-Name: 62411a6e605ec50d8d61233d753cd2ad65c2218d
2008-06-20 00:03:21 +00:00
3780b5de7e
Unset global TCL variables in the func.test script prior to use to avoid
...
conflicts from other scripts. (CVS 5251)
FossilOrigin-Name: 9b04e10f6c00c36652444206d1d8868a560eb56e
2008-06-19 18:39:11 +00:00
d09414cdd6
Move the malloc() failure simulation out of malloc.c and into a separate sqlite3_mem_methods interface. Still some related changes to come. (CVS 5250)
...
FossilOrigin-Name: d22cd2a59f472f4eaf80aa9f55fbff2514ca428d
2008-06-19 18:17:49 +00:00
55b0cf00ad
Documentation and test-script updates. (CVS 5249)
...
FossilOrigin-Name: 68d4f7954108f5bf586c4706c8664d8333fb2230
2008-06-19 17:54:33 +00:00
d72a841467
Additional test cases for loadable extensions. (CVS 5247)
...
FossilOrigin-Name: 9d73a68c305db673d393db118b6a41241683a670
2008-06-19 15:44:00 +00:00
bb5a9c3eea
Add the sqlite3_next_stmt() interface, including test cases. (CVS 5243)
...
FossilOrigin-Name: 565a530896b40790287eeaad709edd51980fbddf
2008-06-19 02:52:25 +00:00
f714199054
Add some test logic to the new memory allocation subsystem. (Lots more needed.)
...
The test suite is currently indicating memory leaks, though it is unclear if
this is a true code problem or just an instrumentation problem. (CVS 5240)
FossilOrigin-Name: cb1f11cd9764cf0275e88e1f6342e366e5536bfd
2008-06-19 00:16:08 +00:00
01bf29966d
Fix a test case in mutex1.test that was failing when sqlite was compiled with SQLITE_THREADSAFE=0. (CVS 5235)
...
FossilOrigin-Name: d1a87c3bcc9a32918f1cf743f85cd1a71557220e
2008-06-18 17:59:03 +00:00
59f8c08ecc
Implement the 'CONFIG_SINGLETHREAD' and 'CONFIG_MULTITHREAD' configuration modes. (CVS 5234)
...
FossilOrigin-Name: 5059644c4bc5f6679afd939e0bc26080f42a9918
2008-06-18 17:09:10 +00:00
a2baf3a2e5
Make sure aggregate functions can take any number of arguments up to the
...
limit imposed by SQLITE_LIMIT_FUNCTION_ARGS. Ticket #3179 . Modify
the group_concat() function to take an unlimited number of arguments in
order to facilitate testing this behavior. (CVS 5233)
FossilOrigin-Name: 70c6739f4e84b3433e14960346b54d0e9e0bb9c6
2008-06-18 15:34:09 +00:00
1a9ed0b27a
Add some test infrastructure and cases for the new mutex api. (CVS 5230)
...
FossilOrigin-Name: 262baee9952b28afe5dc77eb7365ebb11a480906
2008-06-18 09:45:56 +00:00
dfdf9844aa
Fix a recently introduced resource leak in test file incrblob2.test (forgot to close a blob handle). (CVS 5223)
...
FossilOrigin-Name: 88e1c6092e48c860950d3437f264785243bb67ed
2008-06-16 14:36:01 +00:00
99e925da51
Fix a problem with the incremental blob API. sqlite3_blob_open() was always reading the data for the leftmost column of the row that the opened blob was stored in. If this column happened to contain a (the) large blob, sqlite would make a large memory allocation to read the data into. Which defeats the purpose of using incremental blobs. (CVS 5222)
...
FossilOrigin-Name: 1b9478da2f421c1270e76297324fff8037d2f231
2008-06-16 14:19:57 +00:00
fce96308b1
Add a test to verify that IN(...) WHERE clause terms are not handled by virtual table implemetations. (CVS 5221)
...
FossilOrigin-Name: 85483c8fb3b45281ce07e84349841fc80e560b1f
2008-06-16 06:31:34 +00:00
40257ffd0a
Progress toward implementation of sqlite3_config() and a rework of the
...
mutex and memory allocation subsystems. This is an incremental check-in. (CVS 5218)
FossilOrigin-Name: a03c5af115889f477e17187a198a7d2d40bc76bf
2008-06-13 18:24:27 +00:00
655194d6ae
Enhance zeroblob tests to use the sqlite3_memory_highwater in order to
...
double-check that no large allocations are occurring. (CVS 5217)
FossilOrigin-Name: e93079be83a9df7328d9b910fcbdb762be7ec815
2008-06-12 18:17:40 +00:00
c91d86c95a
Fix a typo in the date/time function tests. Add additional cases to
...
the zeroblob tests to make sure sqlite3_bind_zeroblob() does not use
excess memory. (CVS 5216)
FossilOrigin-Name: c1006fb1c817bc0b7fada873edb772abbf972012
2008-06-12 18:05:40 +00:00
85f477a141
Convert the date/time functions to work with milliseconds since the
...
julian epoch internally (instead of days since the epoch) in order to avoid
problems with floating-point roundoff error. The interface is unchanged. (CVS 5215)
FossilOrigin-Name: ed35f8a98323dadb64b423615287fb24ea262ffb
2008-06-12 16:35:38 +00:00
5e982b1c38
Add another test to incrblob2.test. This test failed to reveal any new bugs. (CVS 5214)
...
FossilOrigin-Name: 20d8ea45afcddf22632c3de984147826d0616d3f
2008-06-12 14:42:06 +00:00
f1aaaa4092
Added additional testcases for julianday calculations with midnight boundary for UTC time. (CVS 5209)
...
FossilOrigin-Name: edd2cb00ae606858d8ae138c69eee7821b8cd6ea
2008-06-12 05:16:14 +00:00
9e855dac4f
Adjust the error-message text in corrupt7.test. (CVS 5205)
...
FossilOrigin-Name: 4a77ff5b588f4c83959591c208a8b20224b75a66
2008-06-11 18:56:42 +00:00
f3840b0645
Add a test case for the database corruption in the form of cell offsets
...
out of range in an otherwise valid btree page. (CVS 5202)
FossilOrigin-Name: c569a6cf664e9a8095f616327719392fb8186d37
2008-06-11 18:01:21 +00:00
3588ceb868
Invalidate sqlite3_blob* handles whenever an SQL statement is used to delete or modify the rows containing the open blob. Previously, modifying the table containing the open blob in any way invalidated the handle. This was too restrictive. (CVS 5199)
...
FossilOrigin-Name: e339c91f8718482ce74fc53781091db95e69d4c3
2008-06-10 17:30:26 +00:00
55edca5c17
Add test file incrblob2.test to test opening two blob handles on a single database blob. (CVS 5196)
...
FossilOrigin-Name: c1d877feb530b5cdaad55da3dbbb7c2596a10c49
2008-06-09 15:51:26 +00:00
ad0132dff1
Change the signature of sqlite3PagerPagecount() so that it can return an error code. (CVS 5195)
...
FossilOrigin-Name: e9f01c01866d302d81bf9ebc484ea6351cbc0f60
2008-06-07 08:58:22 +00:00
8162054b44
Do not call xSync() from zeroJournalHdr() if the Pager.noSync flag is set (i.e. for temp files). (CVS 5194)
...
FossilOrigin-Name: 9f5cbe29226151113e4565fcf8170317afe1b8c6
2008-06-07 05:19:37 +00:00
17b90b5316
Remove the xGetTempname() method from the vfs structure. Temp files are now opened by passing a NULL pointer as the filename to xOpen(). (CVS 5190)
...
FossilOrigin-Name: 5173b3e816c7eb711cd21a9068bbafb9ebb7cff1
2008-06-06 11:11:25 +00:00
861f74563d
Modify the signatures of the sqlite3_vfs.xAccess and sqlite3_vfs.xCheckReservedLock functions. (CVS 5188)
...
FossilOrigin-Name: 4226ac54beea1b58de8ab7b9d768d999f50438a6
2008-06-05 11:39:11 +00:00