drh
5ffb3ac844
Fix a && where & was intended. This is a real problem, but it would be
...
very difficult to devise a test case where it might lead to an unexpected
result. Ticket #2306 . (CVS 3856)
FossilOrigin-Name: 7f9f0444ed1a85ed682b604fded535bff5be1535
2007-04-18 17:07:57 +00:00
danielk1977
7fa5dd1a8f
Better handle malloc() failures in the "echo" virtual table test module. (CVS 3855)
...
FossilOrigin-Name: 6881f9212fea0e0a98045b0acc60151eeaf5839e
2007-04-18 17:04:00 +00:00
drh
83968c44a5
The sqlite3_step() routine reports SQLITE_ERROR after a commit failure,
...
not SQLITE_DONE. This fix only effects the legacy sqlite3_prepare()
interface. It already worked correctly with sqlite3_prepare_v2(). (CVS 3854)
FossilOrigin-Name: 165dc72d7024258e225c8a7d60118071282f0f44
2007-04-18 16:45:24 +00:00
danielk1977
417d724069
Fix an assertion failure caused by (3851). (CVS 3852)
...
FossilOrigin-Name: 24683f1d29c5d312d6cabe2dde52d7c0424f629a
2007-04-18 14:47:23 +00:00
danielk1977
0125683288
Minor changes (mainly to assert() macros) to handle malloc failure in vtab operations. (CVS 3851)
...
FossilOrigin-Name: 175156d1fcaadab3b955597abb27f6b9043bbb5b
2007-04-18 14:24:32 +00:00
danielk1977
896e792463
Avoid reloading the db schema after a failed OP_VerifyCookie if the in-memory schema cookie already matches the database file. (CVS 3849)
...
FossilOrigin-Name: 61c1d06d10257575e1406303af331bcc4d00deb0
2007-04-17 08:32:33 +00:00
drh
5ea2df9107
Fix a memory leak introduced by (3842) associated with ticket #2296 . (CVS 3848)
...
FossilOrigin-Name: cdc7608b8d590b2ca19be37f94f2cd17423ba8ac
2007-04-16 17:07:55 +00:00
danielk1977
113e545f45
Add test cases to make sure virtual tables cannot be used in shared-cache mode. (CVS 3847)
...
FossilOrigin-Name: 66e468adfcf0132e558a666b847ce7c1e024d6fd
2007-04-16 15:49:41 +00:00
danielk1977
a04a34ff1a
Ensure sqlite3_finalize() can be called from within the xDisconnect() method of virtual tables. (CVS 3845)
...
FossilOrigin-Name: 8d6c3bfc4dfdd380a2915d778e256d3e49d22d72
2007-04-16 15:06:25 +00:00
drh
86a88114fa
Detect database file changes using a 128-bit segment of the file header
...
that includes the change counter. Ticket #2303 . (CVS 3844)
FossilOrigin-Name: e44995debf2456e55b502783849e93a045a527c8
2007-04-16 15:02:19 +00:00
drh
94ccde58d0
Match ORDER BY terms to columns using names in compound queries. Make sure
...
this works for subqueries, especially in the right-hand side of an IN
operator. Ticket #2296 . (CVS 3842)
FossilOrigin-Name: cfc6f933dc60ca88ae848f7f0c402e820437c2ff
2007-04-13 16:06:32 +00:00
drh
d215acf1f4
Fix a bug in autovacuum introduced by (3839). (CVS 3841)
...
FossilOrigin-Name: e39efa195a28f1cd7431b0811bd908dc7af3c8b1
2007-04-13 04:01:58 +00:00
drh
538f570cd1
Fix multiple performance regressions (ticket #2298 among them)
...
and add tests to make sure they do not come back. (CVS 3839)
FossilOrigin-Name: 32bb2d5859906b4fb0f6083eedd7f3a81b9cf5e2
2007-04-13 02:14:30 +00:00
drh
994c80af27
Changes toward fixes for tickets #2296 and #2291 . (CVS 3838)
...
FossilOrigin-Name: 0dd3e2e47b09156838edfa4dea0d82f9cf22d94d
2007-04-12 21:25:01 +00:00
drh
6c1426fd14
Get the column affinities right when processing an IN operator where
...
the right-hand side is a subquery with an ORDER BY clause. Ticket #2295 .
This bug has likely been present since version 3.0.0 and it has just now
been noticed, so it seems to be a obscure case. (CVS 3837)
FossilOrigin-Name: 4062ddf3c7f4fd150292304fa33ca76dc35571a1
2007-04-12 03:54:38 +00:00
drh
694b19d86e
Blind check-in of changes to fix #2294 - I have no ability to test.
...
Gentle wince users: please test this change and if it works leave a remark
on the #2294 ticket. Tnx. (CVS 3836)
FossilOrigin-Name: ca56c3e2250eda0b312ab6f801b0fd95fb136bfa
2007-04-11 17:54:03 +00:00
drh
f33c9fad35
Preliminary fix for ticket #2291 . This fixes the immediate problem. But
...
we really need to write more tests for the xfer optimization in order to
look for other related problems before closing this ticket. (CVS 3835)
FossilOrigin-Name: 34fec312fd1aeabb04e07d6aa061991775c7b8a1
2007-04-10 18:17:55 +00:00
drh
1eb2538a33
Be careful not to use the result of sqlite3_value_blob() after changing
...
the representation of an object. Ticket #2290 . (CVS 3834)
FossilOrigin-Name: e14374e4e6f14a90ecb53c2e7c86908a220c6d68
2007-04-10 13:51:17 +00:00
drh
431e853715
Fix stack buffer overrun problem in the test harness. (CVS 3832)
...
FossilOrigin-Name: cad9faf3ad99b68be4618dff4b3497b15b9e6d9d
2007-04-09 20:30:11 +00:00
drh
f53454438a
Fix an obscure pager refcnt leak that occurs following a transient I/O
...
error. (CVS 3829)
FossilOrigin-Name: ce6f56ece8eab743d20cd2c0a84b4a266c4da2ff
2007-04-09 12:45:02 +00:00
danielk1977
9038bb647f
Have the pager call xReiniter() instead of xDestructor() to restore btree level state after rolling back a page. (CVS 3828)
...
FossilOrigin-Name: 4e8941333ef053442877a2a696a2c68d403c7f4d
2007-04-09 11:20:54 +00:00
danielk1977
f35843b578
For filesystem databases, do not store a list of pages in the statement journal in main memory. (CVS 3825)
...
FossilOrigin-Name: 0af764a02695281b0a7d70ef4e7f8229fd3d6a30
2007-04-07 15:03:17 +00:00
drh
1e9daa6ab5
Changes to test scripts to support alternative configurations. (CVS 3824)
...
FossilOrigin-Name: 3471a2269fb6b3769b59b70992e6da3bdebea7df
2007-04-06 21:42:22 +00:00
drh
bb5f18d2ca
Additional coverage testing. (CVS 3823)
...
FossilOrigin-Name: 26b2e1aede3f776134b2d6e941d17a907843e650
2007-04-06 18:23:17 +00:00
drh
15926590ed
Binary file I/O infrastructure added and used to increase test coverage
...
for detection of corrupt database files. (CVS 3822)
FossilOrigin-Name: 479b3d965b19c3ec4cb72542718751debf8ff75c
2007-04-06 15:02:13 +00:00
drh
60218d2a0e
The FOR EACH STATEMENT clause in a trigger is now a syntax error. It used
...
to be silently ignored. STATEMENT is no longer a keyword. (CVS 3821)
FossilOrigin-Name: 8e2559b4da6329d7c21925d0850f7f91a3731975
2007-04-06 11:26:00 +00:00
drh
05f7c19a6e
Test coverage improvements. Over 90% of branches are now executed in
...
both directions. (CVS 3820)
FossilOrigin-Name: a776d93ccae3bfa6e992cdd1387571dd21561f98
2007-04-06 02:32:33 +00:00
drh
77a2a5e73c
Changes to increase test coverage. (CVS 3819)
...
FossilOrigin-Name: fd4da6b13499af2397d52cb0f25f8ff6f2192431
2007-04-06 01:04:39 +00:00
drh
8c4d3a6b42
Make sure the sqlite3BtreePrevious() routine terminates properly if the
...
table is deleted out from under it. Ticket #2286 . This bug was discovered
while trying to increase test coverage from 98.5% to 99% - once again
showing the value of full coverage testing. (CVS 3818)
FossilOrigin-Name: bebf8d2f886ed9fe1b96e4cb11ab3de2f2f7d2c8
2007-04-06 01:03:32 +00:00
drh
bd08af4871
Fix the amalgamation so that it works with -DSQLITE_ENABLE_REDEF_IO. Change
...
tclsqlite.c so that it can be appended to the amalgamation. Create a new
amalgamation of header files for use by projects that want to redefine their
own I/O interface using -DSQLITE_ENABLE_REDEF_IO. (CVS 3817)
FossilOrigin-Name: f2caff870c81c08ec85aae72986c231ee986b251
2007-04-05 21:58:33 +00:00
drh
c6ba55f4e0
New testfixture command: sqlite3_pager_refcounts. Returns a list of
...
integers which is the pager refcount for each pager in the database. (CVS 3815)
FossilOrigin-Name: 7338e68e0fd9263236f12f8911cb8293747dd1a4
2007-04-05 17:36:18 +00:00
danielk1977
e180dd9396
Always truncate the pager cache when truncating the database file. Also reorganize the code to check the change-counter after first obtaining a shared lock. (CVS 3814)
...
FossilOrigin-Name: 9dc4100eff71be579480ce7939c7da712d28f0ae
2007-04-05 17:15:52 +00:00
danielk1977
38ec0cb263
Use the MEMDB macro instead of OMIT_MEMORYDB in pager_recycle(). (CVS 3813)
...
FossilOrigin-Name: 97c5159816e211d9c71aa68db7c5e01df535d6a4
2007-04-05 14:29:42 +00:00
danielk1977
c551edc2c3
Avoid attempting to reclaim memory from in-memory databases in sqlite3_release_memory(). (CVS 3812)
...
FossilOrigin-Name: c20f7563c0ffa1df47df5464f1f1cc4703ffa9b4
2007-04-05 13:12:13 +00:00
danielk1977
5bb16fe41b
Add some assert() statements to pager.c. (CVS 3811)
...
FossilOrigin-Name: 973b2a5fb56a1ed1fd10d062edcb6e6dad13f001
2007-04-05 11:54:42 +00:00
drh
7c4ac0c555
Improvements to coverage testing. (CVS 3810)
...
FossilOrigin-Name: 38af156da83a8469080ddb75a9a286be33ff6bef
2007-04-05 11:25:58 +00:00
danielk1977
3997b9bb6b
Catch an IO error case introduced by (3808). (CVS 3809)
...
FossilOrigin-Name: 383a08e26083964e79bfe22156f5f554522fa1fb
2007-04-05 08:40:32 +00:00
danielk1977
2026cefaf8
Zero cached pages located beyond the end of the file before returning them. Ticket #2285 . (CVS 3808)
...
FossilOrigin-Name: 5180810eeaa3dfe3d934af0732a920ae117ec69f
2007-04-05 05:46:14 +00:00
drh
5f9c1a2cbd
Test coverage improvements. (CVS 3807)
...
FossilOrigin-Name: 25f49acc5662ed8dd321b83a60aeeab93a37e129
2007-04-04 01:27:44 +00:00
drh
bdcc276e94
Do not use the second parameter to gettimeofday() on unix. Pass it a NULL. (CVS 3804)
...
FossilOrigin-Name: 96b678818c9a536b77f10b25256facf4bff1ff65
2007-04-02 18:06:57 +00:00
drh
c94d9c776c
Fix a union initializer so that it works with the Borland compiler. (CVS 3803)
...
FossilOrigin-Name: a067f78bf6a45d68ee1337115704cda2041919f4
2007-04-02 17:54:56 +00:00
drh
ee2ce18189
If preprocessor macro OS_OTHER is defined, then ignore OS_UNIX, OS_WIN, and
...
OS_OS2. This makes it easier to add proprietary backends.. (CVS 3801)
FossilOrigin-Name: 4fdafd3f583b1ec4aa7fb6a9b5de2f52a375832b
2007-04-02 16:45:12 +00:00
drh
8fd5bd3608
Provide a compile-time option to enable exclusive access mode by default. (CVS 3800)
...
FossilOrigin-Name: 93a41510f02dc5649dbbc22c4e4fbee545bd76d8
2007-04-02 16:40:37 +00:00
danielk1977
cd1aa9000f
Fix for #2281 . This was a problem with the test-case only. (CVS 3795)
...
FossilOrigin-Name: c036db6251ca4671fc3388a4f37955c18adeca1d
2007-04-02 12:29:01 +00:00
drh
01fa4c349f
If an IO error is encountered on a commit, close the journal so that it
...
persists and can (hopefully) rollback the failed transaction later. (CVS 3792)
FossilOrigin-Name: 22e10cc24e4407feb276abfa8cc9964f20c6e54a
2007-04-02 11:22:22 +00:00
danielk1977
08d31a2a6d
Correctly handle the obscure case of a read-only hot-journal file. (CVS 3791)
...
FossilOrigin-Name: 4d8c6bf44ec00ec04e615983cb33425ca2c3998a
2007-04-02 11:08:58 +00:00
danielk1977
241687280b
Fix a resource leak introduced by the change-counter optimisation. Also add some test coverage. (CVS 3790)
...
FossilOrigin-Name: ba0538a4977aefd6645554f1989f0a98b540b9cd
2007-04-02 05:07:47 +00:00
drh
61fc595fdd
Fix some warnings about unused and uninitialized variables. (CVS 3788)
...
FossilOrigin-Name: 18aec1ddfb08b74f0ef9cf1215eac7af71449db3
2007-04-01 23:49:51 +00:00
drh
2c547df6cf
Make unix builds threadsafe by default. (CVS 3787)
...
FossilOrigin-Name: ddfc3b2df0b37be66fc55bb216cdcb6ba67aa7fd
2007-04-01 18:46:19 +00:00
drh
e1521f4c05
Remove unreachable code from util.c. (CVS 3784)
...
FossilOrigin-Name: 82b7a6f05c737f6ad4a21f354e55ec268fa1b032
2007-03-31 22:33:48 +00:00