]>
git.ipfire.org Git - thirdparty/sqlite.git/log
drh [Mon, 20 Apr 2009 12:31:46 +0000 (12:31 +0000)]
Clarify the documentation to make it clear that sqlite3_interrupt() does not
effect new SQL statements that are started after the running statement
count reaches zero. Ticket #3815. (CVS 6524)
FossilOrigin-Name:
3182e8bf69eb4e5e4070930cb9c750942b1dc735
drh [Mon, 20 Apr 2009 12:07:37 +0000 (12:07 +0000)]
Do not use deprecated interfaces internally when compiling with
SQLITE_OMIT_DEPRECATED. Ticket #3813. (CVS 6523)
FossilOrigin-Name:
7f17956dfbf3090fd5832378e77bd83a525fed9d
drh [Mon, 20 Apr 2009 11:34:26 +0000 (11:34 +0000)]
Speed improvements by avoiding unnecessary calls to fstat() and ftruncate(). (CVS 6522)
FossilOrigin-Name:
5b7e3a411a6f2fe296675de9467783f6625cff3f
drh [Sun, 19 Apr 2009 20:51:06 +0000 (20:51 +0000)]
Update comments and remove unused code in btree.c. No functional changes. (CVS 6521)
FossilOrigin-Name:
bd860184909b7a9cc32c59770ebcee0efdc491f0
drh [Sun, 19 Apr 2009 12:23:58 +0000 (12:23 +0000)]
Make extra calls to sqlite3_shutdown() be harmless no-ops. (CVS 6520)
FossilOrigin-Name:
d80822953c2d2f2fd7f6acdd3caa403c0decacc4
drh [Fri, 17 Apr 2009 16:54:22 +0000 (16:54 +0000)]
Revise the implementation of sqlite3_initialize() slightly in order to make
it more easily testable. The functionality should be unchanged. (CVS 6519)
FossilOrigin-Name:
bb1a390a3d2f79b27e3ec2514ae00f5b22dbfb06
drh [Fri, 17 Apr 2009 15:18:47 +0000 (15:18 +0000)]
Get the behavior of SQLITE_HAVE_ISNAN right. It was reversed
in check-in (6517). Ticket #3809. (CVS 6518)
FossilOrigin-Name:
97c6ea2368556b2a9a914ba2322085e312598b15
drh [Fri, 17 Apr 2009 11:57:22 +0000 (11:57 +0000)]
Add the SQLITE_HAVE_ISNAN compile-time option which, if present, causes
SQLite to use the math library isnan() function rather than its own homebrew
implementation of isnan(). (CVS 6517)
FossilOrigin-Name:
54d23521c37938b9d98f41f5547975c469c0c8f0
drh [Fri, 17 Apr 2009 11:56:27 +0000 (11:56 +0000)]
Check-in (6514) did not completely remove the obsolete test, resulting in a
segfault. This check-in finishes the job. Ticket #3802. (CVS 6516)
FossilOrigin-Name:
c29b37ea36fe6a360807e66dffc467c66be00d38
drh [Thu, 16 Apr 2009 17:45:47 +0000 (17:45 +0000)]
Add NEVER and ALWAYS tags to conditionals in analyze.c that always false or
true. (CVS 6515)
FossilOrigin-Name:
fbbc80eaf3bb3726b053d1050104b4ec602eb0c1
drh [Thu, 16 Apr 2009 16:32:20 +0000 (16:32 +0000)]
Remove obsolete test from bindxfer.tcl. Ticket #3802. (CVS 6514)
FossilOrigin-Name:
b1b096171812f77082b0b63e7ab0908c82d1d8bb
drh [Thu, 16 Apr 2009 16:30:17 +0000 (16:30 +0000)]
Changes to alter.c to enable full branch coverage testing. (CVS 6513)
FossilOrigin-Name:
6a91ab08a55eacc77f69190e1126326f4da220af
drh [Thu, 16 Apr 2009 12:58:03 +0000 (12:58 +0000)]
Make sure the 'unixepoch' converter in the date and time functions rounds
to the nearest millisecond rather than truncating downward to the next
smaller millisecond. Ticket #3808. (CVS 6512)
FossilOrigin-Name:
e6e036b345b130c207716c4b81719b5b7c884a11
drh [Thu, 16 Apr 2009 00:24:23 +0000 (00:24 +0000)]
In a 3-fold compound SELECT make sure early code generation of the SELECTs
to the right do not dereference non-existant columns in SELECTs on the left. (CVS 6511)
FossilOrigin-Name:
414f340809c487901fa913026a342b19a2956c0a
drh [Wed, 15 Apr 2009 15:16:53 +0000 (15:16 +0000)]
Fix the group_concat() function so that it inserts the separator string
even if the initial content strings are empty. Ticket #3806. (CVS 6510)
FossilOrigin-Name:
b83fbf15a3920755ed77dc9c91b4f00a86ddb9ac
shane [Wed, 15 Apr 2009 14:36:25 +0000 (14:36 +0000)]
Fix access violation on WinCE platforms. Ticket #3804. (CVS 6509)
FossilOrigin-Name:
e203ad400dd61431b3e6b8219eb5357b6ca06561
drh [Wed, 15 Apr 2009 13:39:47 +0000 (13:39 +0000)]
Mark an branch in alter.c as always false. Only run the assert() on
the sqlite3_aggregate_count() function in func.c if the
SQLITE_OMIT_DEPRECATED compile-time option is off. (CVS 6508)
FossilOrigin-Name:
c0bba77ae619e709f3fb068526073a4a83cf33b6
drh [Wed, 15 Apr 2009 13:07:19 +0000 (13:07 +0000)]
Disable the temptrigger.test test script when shared cache is disabled.
Ticket #3801. (CVS 6507)
FossilOrigin-Name:
feedbce8f149820d082ecde4437109cc6b6ea0e3
aswift [Tue, 14 Apr 2009 18:44:38 +0000 (18:44 +0000)]
nMax can be zero and subtracting 1 from an unsigned zero produces undesirable results (CVS 6506)
FossilOrigin-Name:
a117d82dad82bc372bc1e3f1adb9540c1accf851
drh [Tue, 14 Apr 2009 12:58:20 +0000 (12:58 +0000)]
Change the sqlite3_bind_value() implementation to use a default branch on
the type switch so that there are no untested jumps in the switch. (CVS 6505)
FossilOrigin-Name:
d0a8bd6a53c5da0ac6b88818f82c7f7d330b527a
drh [Tue, 14 Apr 2009 12:43:33 +0000 (12:43 +0000)]
Reimplement the sqlite3_bind_value() interface so that it works when the
value being bound comes from a different database connection. (CVS 6504)
FossilOrigin-Name:
3db0c7980668cf38165add13f833863cd00a0cfe
drh [Mon, 13 Apr 2009 14:43:40 +0000 (14:43 +0000)]
Enhancements to virtual table documentation. Comment changes only. No changes to
code. (CVS 6503)
FossilOrigin-Name:
b0b2b2831cc84d57e90bf587ebed600fa72926e9
drh [Mon, 13 Apr 2009 09:29:04 +0000 (09:29 +0000)]
Version 3.6.13 (CVS 6502)
FossilOrigin-Name:
982cc7f4e7e2d8abfc2025dfbec7c1ce8f95383b
drh [Mon, 13 Apr 2009 09:09:24 +0000 (09:09 +0000)]
Rerun autoconf in preparation for 3.6.13. (CVS 6501)
FossilOrigin-Name:
f683e222112339d1f7980276e403efda76a18ebf
chw [Mon, 13 Apr 2009 08:14:03 +0000 (08:14 +0000)]
updated Makefile.vxwSH4 and renamed it to Makefile.vxworks,
should now be able to support SH4 and PPC targets. (CVS 6500)
FossilOrigin-Name:
e4a370c72dd3204be099a6706128507d5c06170c
drh [Sat, 11 Apr 2009 19:09:53 +0000 (19:09 +0000)]
Fix malloc5.test so it work on both 64-bit and 32-bit systems. The
::tcl_platform(wordSize) variable has to be used to adjust some memory
sizes. (CVS 6499)
FossilOrigin-Name:
ea20f78edb50778c40ed7f03f894ab898f58d67c
drh [Sat, 11 Apr 2009 16:27:49 +0000 (16:27 +0000)]
Fix an obscure problem with recovery from I/O errors while rolling back. (CVS 6498)
FossilOrigin-Name:
24ff486125b9ad62dd92314b62299093b55fe82b
drh [Sat, 11 Apr 2009 16:27:19 +0000 (16:27 +0000)]
Add a comments and an assert() to the virtual table implementation.
No functional changes. (CVS 6497)
FossilOrigin-Name:
ac5d0c0aa1de687bde972fbf0db8f04508825205
danielk1977 [Sat, 11 Apr 2009 16:06:15 +0000 (16:06 +0000)]
Fix a case where a corrupt database could cause an assert() to fail. (CVS 6496)
FossilOrigin-Name:
2c560e057e1da8a603efc36deea036f2392a4ab9
drh [Sat, 11 Apr 2009 14:46:43 +0000 (14:46 +0000)]
Allocate a little extra scratch space for the memsubsys1 tests. The
extra space is needed in some configurations. (CVS 6495)
FossilOrigin-Name:
5484419294356b704c2c9064f36ed254875ca8c0
drh [Sat, 11 Apr 2009 11:38:53 +0000 (11:38 +0000)]
Increase the hard upper bound on the number of pcache pages in test_pcache
when the test harness is compiled for in-memory temp tables. Some of the
test cases need to extra memory to avoid unplanned out of memory errors. (CVS 6494)
FossilOrigin-Name:
7f2d6a0bd510801e011eb075f494194d9ebf568b
danielk1977 [Sat, 11 Apr 2009 10:25:03 +0000 (10:25 +0000)]
Replace invocation of (really_finish_test) from async.test with (finish_test). Otherwise a tcl exception may be thrown when running permutations. (CVS 6493)
FossilOrigin-Name:
e6465e9da3d754833c21e0fb76c16a4efd047b91
danielk1977 [Sat, 11 Apr 2009 09:51:55 +0000 (09:51 +0000)]
In sqlite3PagerMovepage(), avoid holding a reference to page number X when calling sqlite3PcacheRekey() to move another page to page number X. (CVS 6492)
FossilOrigin-Name:
4447c94f45b8abd833eb82b67233029088fd1a54
drh [Fri, 10 Apr 2009 23:11:31 +0000 (23:11 +0000)]
Remove more unused branches from vdbeapi.c. (CVS 6491)
FossilOrigin-Name:
447e959594970a225a9b189e7e420ba9c3eedbdb
drh [Fri, 10 Apr 2009 20:55:13 +0000 (20:55 +0000)]
In the async test, make sure procedures do not get renamed over top of one
another. (CVS 6490)
FossilOrigin-Name:
b6430cc4297c426f89e68f180a2c50b9b1ecd8e3
drh [Fri, 10 Apr 2009 20:32:00 +0000 (20:32 +0000)]
Remove unused branches from the vdbeapi.c module. (CVS 6489)
FossilOrigin-Name:
7ae0fc7ea55dc5b5fbeef20f476a00f619bd3c5c
danielk1977 [Fri, 10 Apr 2009 18:41:01 +0000 (18:41 +0000)]
Increase the error tolerance when verifying the approximate size of a pseudo-random database in backup_ioerr.test. Otherwise the test could fail depending on the PRNG seed. (CVS 6488)
FossilOrigin-Name:
deda5ab35e7663ba5f30c08b16ef3393d7146816
danielk1977 [Fri, 10 Apr 2009 18:32:29 +0000 (18:32 +0000)]
Do not run io.test as part of the inmemory_journal permutation. io.test uses the tcl API to test for journal files in the file-system (which of course never exist when running with in-memory journals). (CVS 6487)
FossilOrigin-Name:
493f03bd73a15de994f69f23e9df8bb3ee4d20dc
drh [Fri, 10 Apr 2009 18:21:29 +0000 (18:21 +0000)]
Re-enable the alt_pcache tests in permutations.test so that they run
automatically during a full regression. Fix async.test so that it
works with the permutation.test pcacheNN test modules. (CVS 6486)
FossilOrigin-Name:
310192cc0fb56f8ffaa8e742f5600f16956212e7
shane [Fri, 10 Apr 2009 15:42:36 +0000 (15:42 +0000)]
Fix MSVC compiler warning in vdbeaux.c. (CVS 6485)
FossilOrigin-Name:
d619465e31c2366b389fea6ee2ce6b1806738a0f
drh [Fri, 10 Apr 2009 15:38:42 +0000 (15:38 +0000)]
Disable the select1-15 tests when locking_mode is EXCLUSIVE. Ticket #3771. (CVS 6484)
FossilOrigin-Name:
88cefbb4a12ab7037f025141ddbe041ea82a6c61
danielk1977 [Fri, 10 Apr 2009 15:02:43 +0000 (15:02 +0000)]
Changes to jrnlmode.test to account for in-memory temp databases. (CVS 6483)
FossilOrigin-Name:
c31d4359ae056dca9e9de61ef8ceb683b92850e7
drh [Fri, 10 Apr 2009 14:27:59 +0000 (14:27 +0000)]
Simplifications and additional comments on the sqlite3_get_table()
implementation. Changes to facilitate full branch test coverage. (CVS 6482)
FossilOrigin-Name:
57e3e6b3cb54e6626bee41a084c927ee264b6d03
danielk1977 [Fri, 10 Apr 2009 12:55:16 +0000 (12:55 +0000)]
Changes to ensure that when running in shared-cache mode with a non-threadsafe build, the correct busy-handler callback is always invoked. (CVS 6481)
FossilOrigin-Name:
683e4bd74783e6e3f6cf75f9582008c7b7e02a01
danielk1977 [Fri, 10 Apr 2009 09:47:06 +0000 (09:47 +0000)]
Always set BtShared.db when entering the BtShared mutex. Ticket #3793. (CVS 6480)
FossilOrigin-Name:
ed6620ba589ddbb6ca86f42a7652e3b019195647
drh [Fri, 10 Apr 2009 00:56:28 +0000 (00:56 +0000)]
Force 8-byte alignment of sqlite3_value objects in the
sqlite3VdbeUnpackRecord() primitive. Ticket #3777. (CVS 6479)
FossilOrigin-Name:
2cc68272b1f70701268075cfa82fa64bb2a8179d
drh [Thu, 9 Apr 2009 21:02:29 +0000 (21:02 +0000)]
Increase the version number to 3.6.13 in preparation for the next release. (CVS 6478)
FossilOrigin-Name:
9a09a47495d498a3372ead0eef5e3642a3ff30c2
chw [Thu, 9 Apr 2009 14:27:06 +0000 (14:27 +0000)]
Provide dummy DWORD arguments to output parameters of GetDiskFreeSpace(A|W),
NULL causes access violations on Windows NT 4.0 (CVS 6477)
FossilOrigin-Name:
5350a6586cd6504a0724631e4ef46245832435f9
drh [Thu, 9 Apr 2009 14:02:44 +0000 (14:02 +0000)]
Remove misuse detection from the deprecated sqlite3_transfer_bindings()
interface. The code was hard to test and was simply taking up space. (CVS 6476)
FossilOrigin-Name:
4cd829107cc9e94b092490aa821574492292b425
drh [Thu, 9 Apr 2009 01:23:49 +0000 (01:23 +0000)]
Enhance sqlite3_shutdown() so that it automatically invokes
sqlite3_reset_auto_extension(). This is a harmless no-op if applications
are already calling sqlite3_reset_auto_extension() prior to sqlite3_shutdown().
And it prevents possible memory corruption if they do not. So it works
either way. Most of the changes are to the test cases. (CVS 6475)
FossilOrigin-Name:
0c41f7cff4f6ffb9321f6f6b6ef3e431b750d41a
drh [Wed, 8 Apr 2009 23:05:28 +0000 (23:05 +0000)]
Simplify the implementation of the columnName() function in vdbeapi.c.
This is a code cleanup only - no behavior changes. (CVS 6474)
FossilOrigin-Name:
0628f5864f8cc035b41bbe644bd8ec8fb43c70ce
drh [Wed, 8 Apr 2009 23:04:14 +0000 (23:04 +0000)]
Add an assert() to the implementation of count(*) that checks the
correct operation of the sqlite3_aggregate_count() function. (CVS 6473)
FossilOrigin-Name:
f322be3833c4a938ee7d9e4bcfd5decaca57db0b
drh [Wed, 8 Apr 2009 16:10:04 +0000 (16:10 +0000)]
Reconfigure the default case for the printf switch in order to improve
branch coverage. (CVS 6472)
FossilOrigin-Name:
3cc79162dbdbce9d08bb28942128780277101e0d
drh [Wed, 8 Apr 2009 15:45:31 +0000 (15:45 +0000)]
Remove a pair unnecessary conditions from printf.c. The "db" parameter is
now required for sqlite3MPrintf(). (CVS 6471)
FossilOrigin-Name:
6fe8b5d70247d9c6b70dd482db3990986be97e69
drh [Wed, 8 Apr 2009 13:51:51 +0000 (13:51 +0000)]
Minor refactoring of the expression-compaction logic for clarity of
presentation. New comments added. The EXPRDUP_DISTINCTSPAN flag is
removed as obsolete. (CVS 6470)
FossilOrigin-Name:
44ded2ea67374f187a111df69c3f51f866735400
drh [Wed, 8 Apr 2009 12:21:30 +0000 (12:21 +0000)]
Do not attempt to walk a TokenOnly or SpanOnly expression tree node.
Ticket #3791. (CVS 6469)
FossilOrigin-Name:
8362d883248f00a8ec7294bf027fd19758aec5f2
drh [Wed, 8 Apr 2009 11:49:42 +0000 (11:49 +0000)]
Add a comment to printf.c - no changes to code. (CVS 6468)
FossilOrigin-Name:
ee5a4a0e595a7b916db7d55d30ddfda0a8d40d90
drh [Tue, 7 Apr 2009 22:06:57 +0000 (22:06 +0000)]
Fix the sqlite3_unlock_notify() interface so that when the callback is NULL
it simply cancels any outstanding callbacks. (CVS 6467)
FossilOrigin-Name:
9ccfcb760745df28b04e746355b1b6dec49a93de
drh [Tue, 7 Apr 2009 22:05:43 +0000 (22:05 +0000)]
Remove two unused tests from the integrity_check pragma logic. (CVS 6466)
FossilOrigin-Name:
22999d31418aa9ecb17ab5d135b206b967889614
danielk1977 [Tue, 7 Apr 2009 14:38:58 +0000 (14:38 +0000)]
Fix an incorrect assert in btree.c. (CVS 6465)
FossilOrigin-Name:
2c1f59834ab7a16066ee12cb8a8342d438c23ce9
danielk1977 [Tue, 7 Apr 2009 14:14:22 +0000 (14:14 +0000)]
Fix compilation and testing when SQLITE_OMIT_TRIGGER is defined. Ticket #3786. (CVS 6464)
FossilOrigin-Name:
277dace43d51fbc79c7a62fc841c150ecd8d0823
drh [Tue, 7 Apr 2009 13:48:11 +0000 (13:48 +0000)]
Only enable WHERE-tracing when both TEST and DEBUG are enabled. (CVS 6463)
FossilOrigin-Name:
55b93649258204797f56a58322cf31b564469633
danielk1977 [Tue, 7 Apr 2009 11:21:28 +0000 (11:21 +0000)]
Change "... myfunction() { ... }" to "... myfunction(void) { ... }" in a few pla
ces. Ticket #3783. (CVS 6462)
FossilOrigin-Name:
6f79e6ae0d30948db4ba26bb5b448c15c470464f
danielk1977 [Tue, 7 Apr 2009 09:16:56 +0000 (09:16 +0000)]
Have OP_IdxRowid handle the case where the index entry it is reading from is deleted. (CVS 6461)
FossilOrigin-Name:
cdad29b582ca832f6a717d8a6e3f3bca424e84a4
chw [Tue, 7 Apr 2009 05:35:03 +0000 (05:35 +0000)]
Compile fixes and improvements for vxwork: fixed deadlock in semClose,
detect if fcntl is usable, fall back to named semaphores if not. (CVS 6460)
FossilOrigin-Name:
efd0682b7e78acc4242cf257fc246350fc29b5c8
drh [Tue, 7 Apr 2009 00:49:16 +0000 (00:49 +0000)]
Remove an unused test for EXPLAIN-mode in the PRAGMA processing. (CVS 6459)
FossilOrigin-Name:
909683b3428784ce91d222ccf887033d86250bd5
drh [Tue, 7 Apr 2009 00:43:28 +0000 (00:43 +0000)]
Always enable WHERE-tracing on a test build.
Oops - accidentally included a debugging change to pragma.c in
this check-in. The real fix for the pragma problem is in the
following checking. (CVS 6458)
FossilOrigin-Name:
567cf90b038a37da93d02954ef8f9f435dcc9a38
drh [Tue, 7 Apr 2009 00:35:20 +0000 (00:35 +0000)]
It is OK for a unix file descriptor to be zero. It just can't be negative.
Adjust an assert accordingly. Ticket #3781. (CVS 6457)
FossilOrigin-Name:
47aa7eb0e047e30bbf09cb08c1e48c61f8d9861c
danielk1977 [Mon, 6 Apr 2009 17:50:03 +0000 (17:50 +0000)]
Test cases and minor code changes to increase coverage of btree.c. (CVS 6456)
FossilOrigin-Name:
def3a016914f683818b5f013ec4efecbb8fd4c0d
drh [Mon, 6 Apr 2009 15:55:03 +0000 (15:55 +0000)]
Updates and clarification to the documentation of the sqlite3_temp_directory
global variable. No changes to code. (CVS 6455)
FossilOrigin-Name:
aea99c572a69a00b709f0de816ea16488d899375
drh [Mon, 6 Apr 2009 14:16:43 +0000 (14:16 +0000)]
Allow "default" to be a keyword used by PRAGMA statements. (CVS 6454)
FossilOrigin-Name:
ed99d2d97f11784dda0f61f8e7d0eb5ca1bca371
drh [Mon, 6 Apr 2009 12:26:57 +0000 (12:26 +0000)]
Make sure the reverse_unordered_selects pragma works even on unindexed
tables that are queried without a WHERE clause (CVS 6453)
FossilOrigin-Name:
d8c6b28a734fccbbbd567d98ffa7e6557280f737
drh [Mon, 6 Apr 2009 11:11:42 +0000 (11:11 +0000)]
Check-in (6450) introduced the possibility of calling memset() with a
negative 3rd argument. This fixes that bug. Ticket #3777. (CVS 6452)
FossilOrigin-Name:
8ca612c42e0de3ef5b2f92d80a56db1bef34b1c6
drh [Sun, 5 Apr 2009 15:18:02 +0000 (15:18 +0000)]
Fix a segfault in Lemon that occurs if the input grammar does not define
a type for tokens. This does not effect SQLite since the SQLite grammar
does define a type for tokens. (CVS 6451)
FossilOrigin-Name:
4424aee958b2e764a61141b5c66c063e36ed5aae
drh [Sun, 5 Apr 2009 12:22:08 +0000 (12:22 +0000)]
Additional code to make sure and to assert that memory allocations have
8-byte alignment. Ticket #3777. (CVS 6450)
FossilOrigin-Name:
208382e032134d9c78fe1cfcb98ce9defb4e3e26
drh [Sat, 4 Apr 2009 16:02:32 +0000 (16:02 +0000)]
Allow the journal_size_limit to be larger than
2147483647 bytes. (CVS 6449)
FossilOrigin-Name:
81931259611ef10de731ea0e38cee92eb8629733
drh [Sat, 4 Apr 2009 15:53:47 +0000 (15:53 +0000)]
Allow the journal_mode for in-memory databases to be either OFF or MEMORY,
not just MEMORY. (CVS 6448)
FossilOrigin-Name:
11c77f4c2c2beee5267ea6e2f1a4bb845531b42c
drh [Sat, 4 Apr 2009 14:04:58 +0000 (14:04 +0000)]
Clarify the meanings of the SQLITE_SYNC_NORMAL and SQLITE_SYNC_FULL flags
passed into the xSync method of the VFS. Comment changes only - no changes
to code. (CVS 6447)
FossilOrigin-Name:
c47aeb37a1c054a8e0444b95e29cb332599af2d8
drh [Fri, 3 Apr 2009 12:12:58 +0000 (12:12 +0000)]
Remove a blank line in sqlite.h.in that was preventing the
SQLITE_LOCKED_SHAREDCACHE constant appears in the automatically-generated
documentation. Ticket #3775. (CVS 6446)
FossilOrigin-Name:
65f9d3b948cd6ed4728ab49833b9f2fca96563a2
drh [Fri, 3 Apr 2009 12:04:36 +0000 (12:04 +0000)]
Use integer rather than floating point compuations in converting from julian
day number to unix-time to avoid round-off errors on Borland compilers.
Ticket #3769. (CVS 6445)
FossilOrigin-Name:
c26f97bd857f3ddb15e63216cdd4a00e06d8eac8
drh [Fri, 3 Apr 2009 01:43:57 +0000 (01:43 +0000)]
Fix the PRAGMA parser so that it can accept negative numbers in parentheses,
like the syntax diagrams say it should be able to. (CVS 6444)
FossilOrigin-Name:
286e83178ddcd2efe2888697bcf8cc95ccdef880
drh [Thu, 2 Apr 2009 20:27:28 +0000 (20:27 +0000)]
Make sure count(*) works on the sqlite_master table of an empty database.
Ticket #3774. (CVS 6443)
FossilOrigin-Name:
e0c1a780f5a356c48b2a4cc66fab988fe441722f
drh [Thu, 2 Apr 2009 20:16:58 +0000 (20:16 +0000)]
Make sure the VACUUM statement locks down the page_size and auto_vacuum
modes after it runs. Otherwise, pragmas might change these settings on
a populated database, resulting in problems. (CVS 6442)
FossilOrigin-Name:
85e6a4740d6db731c8c35a331031c346e9189c27
drh [Thu, 2 Apr 2009 18:32:26 +0000 (18:32 +0000)]
Fix the sqlite3_prepare() family of interfaces so that they zero the *ppStmt
value even on an SQLITE_MISUSE return. Make it clear in the documentation
that the ppStmt parameter cannot be zero. (CVS 6441)
FossilOrigin-Name:
23bf9f266559603e37b2703715eaf8ef5af6bb17
danielk1977 [Thu, 2 Apr 2009 18:28:08 +0000 (18:28 +0000)]
Fix a problem causing the BtShared.isPending flag to be cleared to early. Also coverage improvements for btree.c. (CVS 6440)
FossilOrigin-Name:
8f1423445b29a5f52ed907de6db82128a96ebfe2
danielk1977 [Thu, 2 Apr 2009 17:23:32 +0000 (17:23 +0000)]
Ensure the required VerifyCookie/Transaction/TableLock opcodes are added for "x
IN (SELECT c FROM t)" expressions. Ticket #3771. (CVS 6439)
FossilOrigin-Name:
058a2f20930d7707c03c3c27db8e761d5657ee46
drh [Thu, 2 Apr 2009 17:22:41 +0000 (17:22 +0000)]
Fix a couple of harmless nuisance warnings. (CVS 6438)
FossilOrigin-Name:
53dac0a455b9a822f710c257711e8d319060cf84
drh [Thu, 2 Apr 2009 16:59:47 +0000 (16:59 +0000)]
Disable the query flattening optimization when the subquery is a compound
query with an ORDER BY clause. Ticket #3773 shows why that combination
does not work. (CVS 6437)
FossilOrigin-Name:
23f90d50737a36ebd17152dd4667948ce7049967
drh [Thu, 2 Apr 2009 14:05:21 +0000 (14:05 +0000)]
Change the way that the random() SQL function prevents the maximum
negative integer so that it is testable. (CVS 6436)
FossilOrigin-Name:
995f2b9b1031fadc85e179701536b9dd4153654b
drh [Thu, 2 Apr 2009 13:36:37 +0000 (13:36 +0000)]
Use ALWAYS and NEVER macros on unchangeable conditions within func.c. (CVS 6435)
FossilOrigin-Name:
eb65e64e7ed5edbe506365971d4d81ea037098d3
drh [Thu, 2 Apr 2009 10:16:17 +0000 (10:16 +0000)]
In the built-in SQL function implementations, improve some comments, fix
an off-by-one error in detecting over-size strings, and add testcase()
macros to verify that boundary values have been tested. (CVS 6434)
FossilOrigin-Name:
868a487f5fd7c795e04a08de36a85ba1e06bc8c6
drh [Thu, 2 Apr 2009 09:07:12 +0000 (09:07 +0000)]
Enforce the run-time sqlite3_limit() length limit on zeroblob(), not just
the compile-time SQLITE_MAX_LENGTH limit. (CVS 6433)
FossilOrigin-Name:
a04f9e7959325da18f66a1aa4ead1c50993807cb
drh [Wed, 1 Apr 2009 23:49:04 +0000 (23:49 +0000)]
Increase test coverage of bitvec.c slightly. Fix the line length on a
comment in bitvec.c. (CVS 6432)
FossilOrigin-Name:
ca3aa3ba7d751be1c2bcd100a203cd9c794a6cef
drh [Wed, 1 Apr 2009 23:09:43 +0000 (23:09 +0000)]
Mark untestable branches of memjournal.c as such. Reduce the size of a
single block allocation to a power of two. Reenable the inmemory_journal
permutation test. (CVS 6431)
FossilOrigin-Name:
05c182a5db9fa96f2d588dd884ce77916b0e60e4
drh [Wed, 1 Apr 2009 20:44:13 +0000 (20:44 +0000)]
Fix the strftime() function so that the %s format can handle dates outside
of the range of 1901 to 2038. Ticket #3769. (CVS 6430)
FossilOrigin-Name:
a95b843a9251ca9f9a23e8b67c2126f4c297a534
drh [Wed, 1 Apr 2009 19:35:55 +0000 (19:35 +0000)]
Change an unreachable error condition test to an assert() in rowset.c. (CVS 6429)
FossilOrigin-Name:
36115e4073528f03253dd94fadf3954522c0dfb9
danielk1977 [Wed, 1 Apr 2009 19:07:03 +0000 (19:07 +0000)]
Remove an unreachable branch from lockBtree(). Add comments. (CVS 6428)
FossilOrigin-Name:
859792958b4d4a3623d68526ff773f778bdf3f0d
drh [Wed, 1 Apr 2009 18:40:32 +0000 (18:40 +0000)]
Fix a bug in the sqlite3Utf16ByteLen() function so that it computes the
correct length even for strings that contain surrogate pairs.
Ticket #3766. (CVS 6427)
FossilOrigin-Name:
766bb7e59c28884e40ce13e3fc55c870d06d7e34
danielk1977 [Wed, 1 Apr 2009 18:25:54 +0000 (18:25 +0000)]
Test that two database connections that use different VFS implementations may not share a cache. (CVS 6426)
FossilOrigin-Name:
3a92c95644ead7c4728ffec1ec70676663518188
danielk1977 [Wed, 1 Apr 2009 18:03:00 +0000 (18:03 +0000)]
Remove the unused SQLITE_Vtab flag. (CVS 6425)
FossilOrigin-Name:
fdd78962fcb988edfb4147394045fc5d3944c620