dan
6950c616ff
Apply OS2 WAL patch. Changes to os_os2.c only.
...
FossilOrigin-Name: eac17106808fa54551a18ff9b44f8370cb5d7160
2011-04-11 13:57:26 +00:00
drh
806ebcb449
Remove an always-true conditional. Replace it with an assert().
...
FossilOrigin-Name: 1c2f0f8477bcf251fe874a2cfae4d7a403cb88ff
2011-04-09 17:53:30 +00:00
dan
579667537a
Add VerifyCookie instructions to "DROP XXX IF EXISTS" statements if the specified database object does not exist when the statement is prepared.
...
FossilOrigin-Name: a46f32900a013aa6bb2dad2a9ed3ce00ab2493fd
2011-04-09 17:32:58 +00:00
dan
7687c83d4c
Add an OP_VerifyCookie instruction to "CREATE XXX IF NOT EXISTS" commands. This way, if the specified database object existed when the statement was compiled but removed from the database before sqlite3_step() was called, the statement still works as expected (and creates the object).
...
FossilOrigin-Name: b9dbd9936191666c3fc9889e938344a82cc03aeb
2011-04-09 15:39:02 +00:00
drh
c2822b76b4
If the keyword "unordered" appears at the end of the SQLITE_STAT1.STAT
...
column for an index, then use that index for equality lookups only, never
for range queries or sorting. This feature is currently undocumented and
my change or be removed in a future release.
FossilOrigin-Name: 8a42e236701c8afd9ada7d4568712a21690ea087
2011-04-09 03:20:59 +00:00
drh
2184fc75a2
Back out the SQLITE_OMIT_UNIQUE_ENFORCEMENT compile-option. It is an unneeded
...
complication.
FossilOrigin-Name: 927e955b93e869727c55b784401de3ea07bee257
2011-04-09 03:04:13 +00:00
drh
9f6106f5ee
When ATTACH-ing a new database to an existing database with a codec, do
...
not enable the codec in the attached database if it is not enabled in the
existing database and it is not requested by the USING clause.
FossilOrigin-Name: 4caa5fc86e7fe404cd188713277f2801cd02dbc9
2011-04-09 02:34:33 +00:00
drh
2b89fbcb1e
Do not do a backup if the number of reserved bytes in the source and
...
destination do not match. Try to make the match, but if unable fail.
FossilOrigin-Name: 0ca8a2332b28d88585dc890e5162b095e783fc20
2011-04-09 02:09:44 +00:00
drh
ea6dc4458b
Always make sure the left-hand side of the IS NOT NULL operator is a
...
smiple column, not a general expression, before applying the IS NOT NULL
query optimization.
FossilOrigin-Name: 543f75a6abe3aa4f49df43e71a462702d40b3251
2011-04-08 21:35:26 +00:00
drh
041e09f189
Change two new internal functions in where.c from global to file scope.
...
FossilOrigin-Name: 5bbfa17d4d6db18f8077f758d70c1bc253b58e2e
2011-04-07 19:56:21 +00:00
drh
93b4fc78cf
When searching a list of freelist trunk pages looking for a specific page
...
to allocate, avoid unnecessary journalling of the unchanged trunk pages towards
the start of the list.
FossilOrigin-Name: d03d63d77ed144ac2c02a0245c4b4b070b79c88e
2011-04-07 14:47:01 +00:00
dan
7329ed9b38
Do not run multi-threaded Tcl tests if the library was built with SQLITE_MUTEX_NOOP defined.
...
FossilOrigin-Name: e4e99606fdf1f1cecf914dc865b066bf07793d1f
2011-04-07 10:09:00 +00:00
shaneh
cef8368093
Fix a couple of MSVC compiler warnings;
...
FossilOrigin-Name: 748c9109c973e1d3e914adbe533f12af7783bfe4
2011-04-07 03:41:01 +00:00
drh
8b2b2e67fe
Fix typos in documentation comments. No changes to code.
...
FossilOrigin-Name: 9c64b5a99c5251818000e7d655f3a870589b631e
2011-04-07 01:14:12 +00:00
drh
dc5b047ec3
Fix a performance regression: Keep two btree masks in each prepared
...
statement; one for btrees used and another for btrees that require locks.
Only try to lock the btrees identified by the second mask.
FossilOrigin-Name: 614de91a504d2231009a9de1305e31fce1b1c5a6
2011-04-06 22:05:53 +00:00
dan
dc5df0f824
Fix a benign inaccuracy in the os_unix.c SQLITE_FCNTL_SIZE_HINT code.
...
FossilOrigin-Name: 61a6ccbe3c9c3ad5f35fb325e3c327cb19409925
2011-04-06 19:15:45 +00:00
dan
bb2b441867
Changes to support building with various SQLITE_OMIT_XXX options defined.
...
FossilOrigin-Name: 2039ed952a02bdcd4fc6d2e20572c4632084dcdb
2011-04-06 17:54:31 +00:00
dan
6d59c2c1c2
Update a comment in sqliteLimit.h. No changes to code or tests.
...
FossilOrigin-Name: b7296fd380319bcae26b1ac13f23e57a4852881b
2011-04-06 12:38:10 +00:00
drh
fcd71b6010
Suppress many harmless compiler warnings, mostly signed/unsigned comparisons
...
within asserts or unused parameters in extensions.
FossilOrigin-Name: 3eeb0ff78d04891b5fd1a3d99a9fb8cfbed77a81
2011-04-05 22:08:24 +00:00
drh
1a86f50d85
Simplifications to the sqlite3BtreeEnterAll() and LeaveAll() routines.
...
Just have them call BtreeEnter and BtreeLeave() repeatedly rather than
trying to be clever.
FossilOrigin-Name: 51039b3578f948c23a810d176e81fa51a278fb28
2011-04-05 19:27:41 +00:00
drh
d3ef5ae05f
Simplifications to the sqlite3ResetInternalSchema() logic to eliminate
...
unreachable branches.
FossilOrigin-Name: a4c3ac989d4e93f0279172901b9ece822d137700
2011-04-05 19:26:30 +00:00
drh
8d4991e7ba
Remove dead code from the OP_JournalMode opcode in the VDBE.
...
This code seems to have been useless since [f88c6367d2] on [20010-08-07].
FossilOrigin-Name: a89f24e2c9591d09cbe329895ceec87885059184
2011-04-05 18:34:10 +00:00
drh
e54e051800
Remove the mutex counter and the logic that attempts to verify that btree
...
mutexes are held continuously. We are not making that assumption at this
time.
FossilOrigin-Name: 242ce7cff416a87d57d4eb624cb79fa4e2215559
2011-04-05 17:31:56 +00:00
dan
ce8e5ffe1c
When committing a WAL transaction, do not write any pages to the WAL file with page numbers greater than the size of the database image in pages.
...
FossilOrigin-Name: 311d0b613d9cfa2dbcbb9ef2450041b1fd48770a
2011-04-05 16:09:08 +00:00
drh
0d8bba982d
Fix a documentation typo.
...
FossilOrigin-Name: d25c17ef6e2b916923489dccaaa018a2d6525401
2011-04-05 14:22:48 +00:00
drh
959b6a95ee
Merge the scheme-parse-refactor changes into trunk: (1) added
...
sqlite3SchemaMutexHeld() asserts, (2) Use -1 instead of 0 to mean
"all" in sqlite3ResetInternalSchema(), and other cosmetic changes.
FossilOrigin-Name: 5db4511d8a77b74be3503a7c34257ef6b07541f5
2011-04-05 13:12:28 +00:00
drh
8d129422ed
Fix the P4_TRANSIENT constant so that it works correct - so that it really
...
makes a copy of the string for the P4 argument. Use P4_TRANSIENT wherever
appropriate. Change P4_STATICs of schema names to P4_TRANSIENT.
FossilOrigin-Name: bf664b206bf6f5c1941da1986dfe2c0d1831d5e4
2011-04-05 12:25:19 +00:00
drh
0bfc2d1cc8
Improved comment on the sqlite3SrcListLookup function.
...
FossilOrigin-Name: bcbc9ff568d1eb9f925574ebd22e5fdfa06daf6e
2011-04-05 11:26:54 +00:00
drh
03faf63b57
Add a comment to the VACUUM implementation explaining when all schemas are
...
reset and not just the "main" schema.
FossilOrigin-Name: 2aff1b0ca87a99b8ec80e696b9e8a48bb43db2c2
2011-04-04 23:08:14 +00:00
shaneh
3a2d29f8f4
Changes for consistent use of SQLITE_OS_UNIX and removal of legacy OS_UNIX from testfixture source;
...
FossilOrigin-Name: 78b6eee200cab363be520d771375e44898f80e01
2011-04-04 21:48:01 +00:00
drh
cdf011dcc4
Additional schema mutex checks for sqlite3RootPageMoved().
...
Reduce the scope of sqlite3ResetInternalSchema() in a few places.
FossilOrigin-Name: 39c00907833413c0d97d3e06fdda967b825d23ea
2011-04-04 21:25:28 +00:00
drh
9bbc2e283e
Minor comment typo corrections. Simplify an assert. No functional changes.
...
FossilOrigin-Name: 82c2316240345167a571507d9392dfb6445ef523
2011-04-04 20:40:22 +00:00
drh
2120608e0f
Add a description of access rules for the Schema object and lots of asserts
...
to verify that the access rules are followed.
FossilOrigin-Name: ae8374af057b6e6546e9265148cfffe32fcb0849
2011-04-04 18:22:02 +00:00
dan
f32021de6f
Merge test_syscall.c fix from the trunk.
...
FossilOrigin-Name: 1e1a23cc56563d512b28288256c34f05ea15b4aa
2011-04-04 14:05:39 +00:00
dan
68db57b691
Have test_syscall.c include "sqliteInt.h". Otherwise the SQLITE_OS_UNIX symbol may not be defined correctly.
...
FossilOrigin-Name: fda8fadd837e399d3fab7a9e6894617a5788d679
2011-04-04 14:03:58 +00:00
drh
b6ee66072e
Rename sqlite3SchemaFree() to sqlite3SchemaClear() to more accurately reflect
...
its function.
FossilOrigin-Name: 71d7440023f67760d0bff4bd7459fe88bd226f30
2011-04-04 13:40:53 +00:00
drh
e038f852c8
Merge in the latest changes from trunk.
...
FossilOrigin-Name: 47b79c40cf07048f682c44bfef533d4764b20c4d
2011-04-04 13:07:02 +00:00
drh
7b94e7f838
Move the expired-statement test for OP_Function until after all memory has
...
been freed. The test is still commented out, however.
FossilOrigin-Name: 425e3edb146c497817855dd741878709a25c8b98
2011-04-04 12:29:20 +00:00
drh
dfdc48e157
Suppress unused parameter warnings in sqlite3VdbeEnter() and related routines.
...
FossilOrigin-Name: f8e98ab3062a6e56924a86e8f3204c30d0f3d906
2011-04-04 03:27:16 +00:00
drh
bdaec52c62
Remove the BtreeMutexArray object - use the Vdbe.btreeMask field to accomplish
...
the same result. Add a generation counter to btree mutexes in order to assert
that mutexes are never temporarily dropped over a range of instructions in order
to do deadlock avoidance in some subroutine. Lock all btrees in any Vdbe
program that uses OP_ParseSchema.
FossilOrigin-Name: d81708f7d1eee399bfe76f6b8dac950a85dc2582
2011-04-04 00:14:43 +00:00
drh
dddd779b2b
Make sure that the constant 1 is cast to yDbType before shifting to create
...
an attached database mask. This check-in is a follow-up and fix to the
[7aaf8772274422] change that increases the maximum number of attached databases
from 30 to 62.
FossilOrigin-Name: e2a09ea73c76a0bec1e09d1fc11092517e3ebdf9
2011-04-03 18:19:25 +00:00
drh
4fa7d7c0df
Fix typos in comments. No changes to code.
...
FossilOrigin-Name: 28c5f12e98655d5c6167b13e8a15085eca43dd5b
2011-04-03 02:41:00 +00:00
drh
069d32592d
Merge in the latest changes from trunk.
...
FossilOrigin-Name: 0d99229a7a58da07748072326f6261c533c1958f
2011-04-02 20:08:10 +00:00
drh
6412358526
Change the name of the "tAttachMask" datatype to "yDbMask".
...
FossilOrigin-Name: 3d6f2e82358c0d8c0ca04e0da20b84fc65c3f7fa
2011-04-02 20:01:02 +00:00
dan
51438a7936
Avoid returning SQLITE_NOTFOUND when the unix xSetSystemCall interface is invoked with NULL passed as the second argument, even if all the default system calls are already installed.
...
FossilOrigin-Name: 3b91eaaa0b3c25022332ba3d1a5651848fc5d84c
2011-04-02 17:00:47 +00:00
drh
ff2e14b93f
When resetting any non-TEMP schema, also reset the TEMP schema since it might
...
be holding references to the non-TEMP schema that just got reset.
FossilOrigin-Name: 211d5dde1f9c15048c65d1d700141aa7b2491011
2011-04-02 16:50:25 +00:00
drh
c7792fa052
Begin a series of changes designed to reduce the scope and frequency of
...
invalidating schemas. Design goals are that the internal schema should
never be deleted out from under a prepared statement that is running and
that all prepared statements should be expired if the schema is invalidated.
At the same time, minimize the number of schema invalidations. This change
merely revises the sqlite3ResetInternalSchema() function to use -1 as the
wildcard for "all" rather than 0, so that we can reset the main schema
independently of all the others.
FossilOrigin-Name: 6a8ad6e31e0d2b8a5ace38faf0efd805155ee5f3
2011-04-02 16:28:52 +00:00
dan
6c15487b7e
Fix a race condition in OP_ParseSchema.
...
FossilOrigin-Name: 71a799b02a3b3cf2e12758dea29fd2465bbec3e1
2011-04-02 09:44:43 +00:00
drh
70586beb3d
Add the "wholenumber" virtual table module to the test suite - useful in
...
populating tables with many rows of content prior to a test.
FossilOrigin-Name: 975dff155bd9db42f2b6855b24c861852bb7a201
2011-04-01 23:49:44 +00:00
drh
f5a8a917ee
Merge the word-fuzzer branch into trunk.
...
FossilOrigin-Name: f77609d44194ee8871b3fb281ea6b90a9182f69f
2011-04-01 20:47:27 +00:00