]>
git.ipfire.org Git - thirdparty/sqlite.git/log
drh [Tue, 4 Nov 2008 14:25:06 +0000 (14:25 +0000)]
Avoid a segfault when OOM on a simple EXPLAIN query. Ticket #3478. (CVS 5860)
FossilOrigin-Name:
acf26cc0f77b3a308d86f6dc02ecda66a4b12fd0
drh [Tue, 4 Nov 2008 13:46:27 +0000 (13:46 +0000)]
Add the sqlite3_db_mutex() interface. No test cases yet. (CVS 5859)
FossilOrigin-Name:
d95de32e8ded397adeef8f7a29b87bc85669ac95
drh [Mon, 3 Nov 2008 21:40:00 +0000 (21:40 +0000)]
Test cases to verify that COMMIT and ROLLBACK return SQLITE_BUSY when
there are active statements. (CVS 5858)
FossilOrigin-Name:
cedfa214e4e979ab04a30f558f767d46862151de
drh [Mon, 3 Nov 2008 20:55:06 +0000 (20:55 +0000)]
Change the name of the Cursor object to VdbeCursor. (CVS 5857)
FossilOrigin-Name:
fdb98fd8c1706085ebeef8e48ac6737839bed5e5
danielk1977 [Mon, 3 Nov 2008 09:39:45 +0000 (09:39 +0000)]
Modify an assert() statement to fix #3473. No other code changes. (CVS 5856)
FossilOrigin-Name:
aca6b260c0dd1a1515b70f3567a0653b6bcdeea2
danielk1977 [Mon, 3 Nov 2008 09:06:05 +0000 (09:06 +0000)]
Fix a bug reported on the mailing list triggered by the pattern "SELECT <col>, (SELECT ... FROM tbl WHERE rowid > <col>) FROM ...". (CVS 5855)
FossilOrigin-Name:
6c918c4eb9362ebfdbe0486515679102b2862970
shane [Fri, 31 Oct 2008 13:57:40 +0000 (13:57 +0000)]
Test that single byte corruptions in increasingly larger quantities are handled gracefully. (CVS 5854)
FossilOrigin-Name:
c73d915923e393f72e1c0897526a20527db2e03c
danielk1977 [Fri, 31 Oct 2008 10:53:22 +0000 (10:53 +0000)]
Change the way sqlite3VdbeSetColName() is called so as to remove a few lines of code. This also fixes #3470. (CVS 5853)
FossilOrigin-Name:
bfce91429b1dad6e0ca36929e41a7adfb30f8522
drh [Thu, 30 Oct 2008 22:13:23 +0000 (22:13 +0000)]
Fix a faulty assert() in the merge implementation of the UNION operator.
Ticket #3467. (CVS 5852)
FossilOrigin-Name:
cd1662e964d9c071a41038676c5a6ef2c990f1ac
danielk1977 [Thu, 30 Oct 2008 17:21:12 +0000 (17:21 +0000)]
Fix a crash that can follow a malloc failure in sqlite3ValueFromExpr(). Ticket #3468. (CVS 5851)
FossilOrigin-Name:
0996783b1b7e6dda166565071cbd19f23e7edbbc
drh [Thu, 30 Oct 2008 15:03:15 +0000 (15:03 +0000)]
Add the sqlite3_extended_errcode() interface. Change to return
SQLITE_BUSY instead of SQLITE_ERROR when a COMMIT is attempted and one
or more queries are still pending. (CVS 5850)
FossilOrigin-Name:
4c6a90a16627b1664bf7f15ab40b440b3bd60b48
danielk1977 [Wed, 29 Oct 2008 07:01:56 +0000 (07:01 +0000)]
If a hot-journal file is detected but the application does not have the required read/write permissions, return SQLITE_CANTOPEN. Prior to this change, SQLITE_BUSY was returned. Ticket #3457. (CVS 5849)
FossilOrigin-Name:
dc5308c7629abe6a3bad21489c8e97087c264e5a
drh [Tue, 28 Oct 2008 18:58:20 +0000 (18:58 +0000)]
Remove the vestigial mem4 and mem6 memory allocators. Add the
SQLITE_ZERO_MALLOC compile-time option and the mem0.c module to
handle memory allocation for that case. (CVS 5848)
FossilOrigin-Name:
4651f590f0b8bf13938b2b15d5082136e763af8d
drh [Tue, 28 Oct 2008 18:12:36 +0000 (18:12 +0000)]
Add data structure description comments to memjournal.c. (CVS 5847)
FossilOrigin-Name:
e9c2adbcbf5c28837b06e0fbba93f1764cc3607f
danielk1977 [Tue, 28 Oct 2008 17:52:39 +0000 (17:52 +0000)]
Avoid exposing internal interfaces sqlite_attach() and sqlite_detach() as SQL scalar functions. Ticket #3466. (CVS 5846)
FossilOrigin-Name:
679c0b35aaa1ea488a205cc03802e7078a2bcf29
danielk1977 [Mon, 27 Oct 2008 15:34:32 +0000 (15:34 +0000)]
If an SQLITE_DELETE authorization callback returns SQLITE_IGNORE, proceed with the delete operation but disable the truncate optimization. (CVS 5845)
FossilOrigin-Name:
65a2e131732399f0f14f982eb0689482fdb87b6c
danielk1977 [Mon, 27 Oct 2008 13:59:33 +0000 (13:59 +0000)]
Make sqlite3_count_changes() and total_changes() work with "DELETE FROM <table-name>". (CVS 5844)
FossilOrigin-Name:
e68e4282adb9003aa297d033aeb5d9cadee215cd
danielk1977 [Mon, 27 Oct 2008 08:24:38 +0000 (08:24 +0000)]
Remove some if() conditions that are always true from delete.c. (CVS 5843)
FossilOrigin-Name:
297ad90dd3a69002e6e4175e9e3938b3a627574d
danielk1977 [Sat, 25 Oct 2008 17:10:10 +0000 (17:10 +0000)]
Remove unused parameter from function rtreeInit() (part of the r-tree extension). (CVS 5842)
FossilOrigin-Name:
3224ea59812d0f3b5685bd92751054b81e3b681e
drh [Sat, 25 Oct 2008 15:03:20 +0000 (15:03 +0000)]
Disable the result-set alias cache when on conditional code branches.
Ticket #3461. The column cache and result set alias cache mechanisms are
prone to this kind of error and need to be refactored. This check-in should
be considered a temporary fix in advance of a more general redesign of the
whole mechanism. (CVS 5841)
FossilOrigin-Name:
1fa3bbd8220ce073e91935ea362b6f5d5d6d2859
danielk1977 [Sat, 25 Oct 2008 09:34:59 +0000 (09:34 +0000)]
Add file tkt3461.test with a few examples of bug #3461. Because these tests currently fail they are disabled for now. (CVS 5840)
FossilOrigin-Name:
f2cc159159278201809022706c28bc53b6c3c859
danielk1977 [Thu, 23 Oct 2008 05:45:07 +0000 (05:45 +0000)]
Fix a bug in pragma table_info. Column default values specified as negative numbers (col DEFAULT -1) were being reported as NULL by the pragma. (CVS 5839)
FossilOrigin-Name:
0e448bc6096c7ee3b21dbd22dc4ca9470ae7ba31
shane [Wed, 22 Oct 2008 18:27:31 +0000 (18:27 +0000)]
Updated configure/makefiles to handle SQLITE_ENABLE* compile options. Made sure makefile passes command line options (OPTS=-Dfoo) to the compiler. Add -DSQLITE_COVERAGE_TEST=1 if gcov being used. (CVS 5838)
FossilOrigin-Name:
acb106e51f8bb7449a0e214075c559cc66497277
shane [Wed, 22 Oct 2008 16:55:47 +0000 (16:55 +0000)]
Removed some more dead code and fixed some unresolved externals for WINCE. Ticket #3420. (CVS 5837)
FossilOrigin-Name:
5276e31d42070e7b94bd6050c4fa484dfbfe98ca
shane [Wed, 22 Oct 2008 16:26:47 +0000 (16:26 +0000)]
Make sure variable declarations occur first in code blocks. (CVS 5836)
FossilOrigin-Name:
b78f44c91fcf3920e69c11a6f72e8f032905a3c7
shane [Wed, 22 Oct 2008 16:04:42 +0000 (16:04 +0000)]
Test cases for ticket #3442. (CVS 5835)
FossilOrigin-Name:
a8bb5acf708c8f7e52d3f67b85094116386f10fa
danielk1977 [Wed, 22 Oct 2008 10:45:37 +0000 (10:45 +0000)]
Fix an assert() failure that can occur following a malloc() failure. Ticket #3455. (CVS 5834)
FossilOrigin-Name:
e0d3aa75b4fa0e706185a3058b5962916e30d066
danielk1977 [Tue, 21 Oct 2008 04:30:31 +0000 (04:30 +0000)]
Update the autoconf build system to include memjournal.c. (CVS 5833)
FossilOrigin-Name:
a3c810f0c80e3e9dfe60a0ffd8688d7c76a30d50
drh [Sun, 19 Oct 2008 21:03:27 +0000 (21:03 +0000)]
When a name in double quotes falls back to being a string literal,
make sure it has no affinity. Ticket #3442. (CVS 5832)
FossilOrigin-Name:
81cfee5c14f241f5ae7f607d73b0b5cb821cda24
danielk1977 [Fri, 17 Oct 2008 19:13:04 +0000 (19:13 +0000)]
Add the memjournal.c file that should have been with the previous checkin. (CVS 5831)
FossilOrigin-Name:
0509eff0e6b5cdeeb52c12c0574ea63e9715bcb5
danielk1977 [Fri, 17 Oct 2008 18:51:52 +0000 (18:51 +0000)]
Add "pragma journal_mode=memory". Change the way rollback works for in-memory databases so that it reuses the journal_mode=memory code. (CVS 5830)
FossilOrigin-Name:
39ebf01addf9d0867daafd06a38719e725128f9c
drh [Fri, 17 Oct 2008 15:10:37 +0000 (15:10 +0000)]
Fix a typo in documentation. Ticket #3447. (CVS 5829)
FossilOrigin-Name:
5ce2ddffea807d45318619cc9e259a99dfa14346
danielk1977 [Thu, 16 Oct 2008 13:27:40 +0000 (13:27 +0000)]
Fix an error in (5826). (CVS 5828)
FossilOrigin-Name:
8065a92f705dfa04863ba4a828f5bd2803901be8
drh [Wed, 15 Oct 2008 19:03:02 +0000 (19:03 +0000)]
Fix a naming problem when SQLITE_MUTEX_NOOP is used. (CVS 5827)
FossilOrigin-Name:
35ce71c6f19953a17aa37abe1c0c97685070e2f6
danielk1977 [Wed, 15 Oct 2008 16:02:48 +0000 (16:02 +0000)]
Do not open and sync the directory in unixDelete() if the SQLITE_DISABLE_DIRSYNC option is defined. (CVS 5826)
FossilOrigin-Name:
8ef141644edc5182785c6a554222c2ffbe92fef5
drh [Wed, 15 Oct 2008 11:59:23 +0000 (11:59 +0000)]
Version 3.6.4 (CVS 5825)
FossilOrigin-Name:
cd73cffab39d80393f26a20c90aa97cb73d595ea
danielk1977 [Wed, 15 Oct 2008 11:43:55 +0000 (11:43 +0000)]
After running speed1.test and speed1p.test, reset the size of the lookaside buffer. Otherwise, subsequent runs of malloc5.test may report an error. Changes to test code only. (CVS 5824)
FossilOrigin-Name:
9283478e69d84aa99b2d4636587c8c0b34e7c4da
danielk1977 [Tue, 14 Oct 2008 19:21:51 +0000 (19:21 +0000)]
Disable the page-cache at the end of pcache2.test. (CVS 5823)
FossilOrigin-Name:
3d2d05b6286e2a22a711e02f37748065b3b7f86e
drh [Tue, 14 Oct 2008 18:21:11 +0000 (18:21 +0000)]
Fix the amalgamation generator to recognize indented #include directives.
Ticket #3438. (CVS 5822)
FossilOrigin-Name:
494510d8f25c69f5a5f5937b92f505849def6745
drh [Tue, 14 Oct 2008 17:58:38 +0000 (17:58 +0000)]
Fix the xRandomness() method on the unix VFS to return the number of bytes
of randomness obtained. (CVS 5821)
FossilOrigin-Name:
b7687e2f2dfa5b0a01ba87ae0bf13684cda50499
drh [Tue, 14 Oct 2008 15:54:08 +0000 (15:54 +0000)]
Make sure malloc3.test runs even if a CREATE TABLE transaction commits
prior to the last OOM error. (CVS 5820)
FossilOrigin-Name:
603c40e5b47e4798136af5420a1fa1511791a934
danielk1977 [Tue, 14 Oct 2008 14:56:01 +0000 (14:56 +0000)]
Update main.mk so that a couple of fts3 files are compiled with SQLITE_TEST when building testfixture. (CVS 5819)
FossilOrigin-Name:
8eb315ee5c2a15919171b7d495ac4f1c851b2da9
danielk1977 [Tue, 14 Oct 2008 14:28:35 +0000 (14:28 +0000)]
Modifications to main.mk so that -DSQLITE_ENABLE_FTS3 works. (CVS 5818)
FossilOrigin-Name:
a06d226dee0df0df1aedb9c17353332c6a6e712f
pweilbacher [Mon, 13 Oct 2008 21:46:46 +0000 (21:46 +0000)]
fix a few return codes in the OS/2 VFS (CVS 5817)
FossilOrigin-Name:
4e978a40f7ee93b09093e82173edc74a992aadeb
drh [Mon, 13 Oct 2008 17:09:11 +0000 (17:09 +0000)]
Get the load extension tests working on amd64. Needed for test coverage. (CVS 5816)
FossilOrigin-Name:
119b69fba0c27c4c479749360176b6eb69d2e70f
drh [Mon, 13 Oct 2008 15:35:08 +0000 (15:35 +0000)]
Fix the SQLITE_OMIT_DATETIME_FUNCS compile-time option so that it builds
successfully. (CVS 5815)
FossilOrigin-Name:
c3f91645159511250c9f86c2a97d819f0253d182
drh [Mon, 13 Oct 2008 14:16:11 +0000 (14:16 +0000)]
In rollback.test, do not check for journal deletion if the journal mode
is not DELETE. Call show_memstats after each test module in all.test
and quick.test. (CVS 5814)
FossilOrigin-Name:
df2c28dc7310510bada292a2e8c1be073803858c
danielk1977 [Mon, 13 Oct 2008 10:56:48 +0000 (10:56 +0000)]
Use one less temporary table in genfkey.c. The retired table was being used to workaround the bug fixed by (5812). (CVS 5813)
FossilOrigin-Name:
73efca985a05930df761b42886a3ba1c5199f32a
danielk1977 [Mon, 13 Oct 2008 10:37:49 +0000 (10:37 +0000)]
If sqlite3_column_value() is called to obtain a value with the MEM_Static flag set, clear it and set the MEM_Ephem flag before returning. Otherwise, if the value is passed to sqlite3_bind_value() or sqlite3_result_value(), sqlite may attempt to use the buffer after the statement has been finalized. This is not always valid, as MEM_Static only guarantees that a MEM.z buffer will be valid for the lifetime of the owner statement, not that it is actually a static buffer. (CVS 5812)
FossilOrigin-Name:
b055bfc4e5268d8a66d6a4f5e8aec1285fe4b8e7
shane [Sun, 12 Oct 2008 02:27:38 +0000 (02:27 +0000)]
Check for failures in winTruncate. Ticket #3415. (CVS 5811)
FossilOrigin-Name:
500c50561fba88948aad21d1aef1e1e96ab8c3aa
shane [Sun, 12 Oct 2008 02:03:37 +0000 (02:03 +0000)]
Added -DSQLITE_ENABLE_RTREE=1 to the mkdll.sh script. Ticket #3427. (CVS 5810)
FossilOrigin-Name:
66f57ecb1626f3c5292070c1b9a9c1a9a9164d4f
shane [Sun, 12 Oct 2008 01:49:41 +0000 (01:49 +0000)]
Add gcov compile options to link line when GCOV option enabled. (CVS 5809)
FossilOrigin-Name:
3ddda111867f64d9dfd729c50c4d0555cac1499d
shane [Sun, 12 Oct 2008 00:27:53 +0000 (00:27 +0000)]
Added SQLITE_OMIT_DEPRECATED compile time option to leave out deprecated functions. Updated test scripts to skip tests of deprecated functions if they are compiled out. (CVS 5808)
FossilOrigin-Name:
ba3711acee6f4659bbf133a23d8f9f37e14d0f38
drh [Sat, 11 Oct 2008 18:11:21 +0000 (18:11 +0000)]
Add macros tests so that the compiler always recognizes that x86_64 is little endian. (CVS 5807)
FossilOrigin-Name:
b201e7093c7c47b23b0f17a0890a344f3792d6d3
danielk1977 [Sat, 11 Oct 2008 17:51:38 +0000 (17:51 +0000)]
When transfering an error message from a statement handle to the database handle so that it can be accessed by sqlite3_errmsg(), a malloc may fail. If this malloc fails, it is considered benign. (CVS 5806)
FossilOrigin-Name:
311003aff85e6b6c47e854d33f46eee31da6f30c
drh [Sat, 11 Oct 2008 17:42:28 +0000 (17:42 +0000)]
Conditionally omit prototypes in pcache.h when the corresponding routines
are not used. Ticket #3430. (CVS 5805)
FossilOrigin-Name:
977ae12c365846e1bc582fd17146151953b5ed68
drh [Sat, 11 Oct 2008 17:35:16 +0000 (17:35 +0000)]
Fix to sqlite3DbMallocRaw() when SQLITE_OMIT_LOOKASIDE is defined so that
once it fails it continues to fail. Add a comment explaining why this is
important. (CVS 5804)
FossilOrigin-Name:
63dd8be70d333c56171dfd254406abb1af685b0f
drh [Sat, 11 Oct 2008 17:06:04 +0000 (17:06 +0000)]
Fix a OOM segfault in the BETWEEN operator parsing - discovered while
using SQLITE_OMIT_LOOKASIDE. Add SQLITE_OMIT_LOOKASIDE to test_config.c and
bypass lookaside.test when defined. (CVS 5803)
FossilOrigin-Name:
2a21d52c651ba113c472b6686dcf8ba009924305
danielk1977 [Sat, 11 Oct 2008 17:04:04 +0000 (17:04 +0000)]
Add "nolookaside" case to permutations.test. (CVS 5802)
FossilOrigin-Name:
56fb7a22864774fcbd8cd00195359dc0f223ec8b
drh [Sat, 11 Oct 2008 16:47:35 +0000 (16:47 +0000)]
Fix a memory leak on ORDER BY of a compound select caused by the resolver
on a flattened query. Also fix a OOM segfault in WHERE clause processing. (CVS 5801)
FossilOrigin-Name:
d2c252d6bbde4ae14da6c9e6c2683d763d11c59f
drh [Sat, 11 Oct 2008 15:38:29 +0000 (15:38 +0000)]
Added an assert() to detect lookaside memory leaks. Also added the
SQLITE_OMIT_LOOKASIDE compile-time option which is useful in trying to
track down lookaside memory leaks. (CVS 5800)
FossilOrigin-Name:
0c4c66071a46cecc5f87afb8f8f01ae2c90ee9b3
drh [Sat, 11 Oct 2008 15:20:04 +0000 (15:20 +0000)]
Fix an assertion fault that occurs with SQLITE_THREADSAFE=0. (CVS 5799)
FossilOrigin-Name:
28bba42b338afd63e1dad9f431d631f6f3027275
drh [Fri, 10 Oct 2008 23:48:25 +0000 (23:48 +0000)]
Add the SQLITE_OMIT_TRUNCATE_OPTIMIZATION option. Other unrelated
documentation enhancements. (CVS 5798)
FossilOrigin-Name:
fab4940d54fd1e5459a3d0d9b64b491e6972fd8d
shane [Fri, 10 Oct 2008 18:25:45 +0000 (18:25 +0000)]
Further simplifications of the code for the LIMIT clause on an UPDATE or DELETE. Added a few test cases to wherelimit.test. (CVS 5797)
FossilOrigin-Name:
282c6a46b25f4e4278fd4c8b0b1cde1de28d8f51
danielk1977 [Fri, 10 Oct 2008 17:58:26 +0000 (17:58 +0000)]
Add the genfkey program to the tool/ directory. (CVS 5796)
FossilOrigin-Name:
84e73fe8a6f538c4b1bb4f641a661d6fafb60c76
danielk1977 [Fri, 10 Oct 2008 17:47:21 +0000 (17:47 +0000)]
Change 'pragma foreign_key_list' to return some extra information. (CVS 5795)
FossilOrigin-Name:
3bb33cf59da49f13201c0226e964cda067a4e780
drh [Fri, 10 Oct 2008 17:41:28 +0000 (17:41 +0000)]
Simplify the symbol hash table to use only a single key class. Other
changes to improve code coverage. (CVS 5794)
FossilOrigin-Name:
ff50a8a7e5a15fac192939ff3206fa18d1c5a6dd
drh [Fri, 10 Oct 2008 17:26:35 +0000 (17:26 +0000)]
Documentation updates. No changes to code. (CVS 5793)
FossilOrigin-Name:
07b5f70317a0b2d32df86a01bdeec79ead00f68c
drh [Fri, 10 Oct 2008 14:27:16 +0000 (14:27 +0000)]
Simplify the parser reduction code for the LIMIT clause on an UPDATE or
DELETE. (CVS 5792)
FossilOrigin-Name:
3de179630e812396ec29e77f7a06758472d0802f
shane [Fri, 10 Oct 2008 13:35:57 +0000 (13:35 +0000)]
Re-factored memory allocation failure handling in the sqlite3LimitWhere() function based on failures in the mallocJ.test script. (CVS 5791)
FossilOrigin-Name:
43507bbefbf79e8db8fe31319ad621d48247983f
shane [Fri, 10 Oct 2008 13:34:29 +0000 (13:34 +0000)]
Added mallocJ.test to test allocation failure handling of the new LIMIT/OFFSET support for UPDATE/DELETE. (CVS 5790)
FossilOrigin-Name:
5375b348b12a4ae149472c84d6f05a78a5542a21
shane [Fri, 10 Oct 2008 06:01:59 +0000 (06:01 +0000)]
Initial test cases for the new LIMIT/OFFSET support for DELETE/UPDATE. (CVS 5789)
FossilOrigin-Name:
d9f5e15ca00d4d54dc395926e4c9171f1d24982a
shane [Fri, 10 Oct 2008 04:34:16 +0000 (04:34 +0000)]
Updated LIMIT support for DELETE/UPDATE. Omit option changed to SQLITE_ENABLE_UPDATE_DELETE_LIMIT. (CVS 5788)
FossilOrigin-Name:
c10e8a3c7ab7f21c95f24d0aba590f5b18a4b028
danielk1977 [Thu, 9 Oct 2008 18:48:30 +0000 (18:48 +0000)]
Fix an assert() failure that can occur if the user attempts to set an into an integer primary key column to a text value in a table that has a BEFORE UPDATE trigger. (CVS 5787)
FossilOrigin-Name:
c2cf9d60d6626844193b008a37e4417aa0a0f323
drh [Thu, 9 Oct 2008 17:57:33 +0000 (17:57 +0000)]
New speed testing tools. (CVS 5786)
FossilOrigin-Name:
2d427746d53104ca032c404f7f65c51b41b7a20e
drh [Thu, 9 Oct 2008 15:56:45 +0000 (15:56 +0000)]
Add a test to verify the sqlite3_column_name() interface returns the
correct value when the query is of the form: "SELECT rowid,* FROM...".
Ticket #3429. (CVS 5785)
FossilOrigin-Name:
e90d5a5515f7096e247e6059cf77f8089ed90b2c
drh [Thu, 9 Oct 2008 15:56:06 +0000 (15:56 +0000)]
Update the version number to 3.6.4. (CVS 5784)
FossilOrigin-Name:
4b973ac98d027cc1097fa9845eb4a8489b633ea4
drh [Thu, 9 Oct 2008 14:45:25 +0000 (14:45 +0000)]
Minor cleanup of the new "status" command on the TCL bindings. (CVS 5783)
FossilOrigin-Name:
ec01bd72ee875df179c680c1a40304d2f807fe38
danielk1977 [Wed, 8 Oct 2008 17:58:48 +0000 (17:58 +0000)]
After an OP_NullRow is executed on a cursor, cause any subsequent OP_Next or OP_Prev to behave as if there were no more rows to traverse. Ticket #3424. (CVS 5782)
FossilOrigin-Name:
af679f6170b346fe61df7dae963b2a2853e62a62
drh [Tue, 7 Oct 2008 23:46:38 +0000 (23:46 +0000)]
Add the experimental sqlite3_stmt_status() interface. (CVS 5781)
FossilOrigin-Name:
de473efb35ffdf9a8222a70a84dfd7d3198c87c1
drh [Tue, 7 Oct 2008 19:53:14 +0000 (19:53 +0000)]
Raise the hard upper bound on SQLITE_MAX_FUNCTION_ARG to 1000 from 100.
The default upper bound is still 100, but it can now be raised as high
as 1000 at compile-time. (CVS 5780)
FossilOrigin-Name:
79df72ee836db91647913055ba6cf55558679b01
drh [Tue, 7 Oct 2008 15:25:48 +0000 (15:25 +0000)]
Remove the SQLITE_MUTEX_APPDEF compile-time option. The SQLITE_THREADSAFE=0
option always removes all mutex code. For application-defined mutexes only,
use SQLITE_THREADSAFE=1 with SQLITE_MUTEX_NOOP=1. Ticket #3421. (CVS 5779)
FossilOrigin-Name:
02a12eb1cfe9307c66556105a1a99d657cc01ab5
danielk1977 [Tue, 7 Oct 2008 15:00:08 +0000 (15:00 +0000)]
Fix a recently introduced test script bug causing rollback.test to throw an exception when run using the "onefile" variation. (CVS 5778)
FossilOrigin-Name:
7d55ec374d62c6d3d588949b96e194920083fe4e
danielk1977 [Tue, 7 Oct 2008 14:06:11 +0000 (14:06 +0000)]
Have sqlite3_bind_value() call sqlite3ApiExit() before returning. Otherwise the db->mallocFailed flag may not be cleared. (CVS 5777)
FossilOrigin-Name:
6b7c8d56403f6b9b88b8494c86f3d62e487cb2ac
drh [Tue, 7 Oct 2008 12:32:13 +0000 (12:32 +0000)]
Do not use double unnecessarily in date+time functions. Ticket #3422. (CVS 5776)
FossilOrigin-Name:
b03231323a7f06c736c38ae3c5535d2fd025583f
danielk1977 [Tue, 7 Oct 2008 11:51:20 +0000 (11:51 +0000)]
Fix a problem with hot-journal rollback. SQLITE_CANTOPEN was being returned if the hot-journal file contained a pointer to a master journal file that did not exist. (CVS 5775)
FossilOrigin-Name:
22d1feb9b20b8fd9c86066b94e4220cf8929b043
shane [Tue, 7 Oct 2008 05:27:11 +0000 (05:27 +0000)]
Initial support for LIMIT clause on DELETEs and UPDATEs. Changes likely with more testing. The code can be omitted with the define SQLITE_OMIT_UPDATE_DELETE_LIMIT. (CVS 5774)
FossilOrigin-Name:
9c8b132e34bc6024bc9898182f8f93127ca52ac9
shane [Tue, 7 Oct 2008 01:18:59 +0000 (01:18 +0000)]
Removed redundant assert(). (CVS 5773)
FossilOrigin-Name:
486b1124f76bcf0505b6be908f2a3e988ad6e05d
danielk1977 [Mon, 6 Oct 2008 16:18:39 +0000 (16:18 +0000)]
Allow INDEXED BY and NOT INDEXED to be used in UPDATE and DELETE statements. (CVS 5772)
FossilOrigin-Name:
83a7e446b2d4846a6f92bd831a2adaa265f5a786
drh [Mon, 6 Oct 2008 15:31:13 +0000 (15:31 +0000)]
Add a test script to verify that ticket #3419 stays fixed. (CVS 5771)
FossilOrigin-Name:
c3cf54a1b6bbaaeab4cab701c6cbbed02695facc
drh [Mon, 6 Oct 2008 15:18:02 +0000 (15:18 +0000)]
Fix a typo in check-in (5769) (CVS 5770)
FossilOrigin-Name:
24891902fa625445aa47ae930f0cb340cc73d25d
drh [Mon, 6 Oct 2008 13:54:35 +0000 (13:54 +0000)]
Expression nodes of type TK_ROW mean the rowid of the first table in the
source list. (CVS 5769)
FossilOrigin-Name:
2f7db6c98f17e0b7110258093c283091a91d4e4f
drh [Mon, 6 Oct 2008 12:46:43 +0000 (12:46 +0000)]
In sqlite3_bind() interfaces, avoid acquiring the mutex until after the
statement handle has been validated. Ticket #3418. (CVS 5768)
FossilOrigin-Name:
693503e241001271512f4ce3e8cc932ba6a3106c
danielk1977 [Mon, 6 Oct 2008 11:29:49 +0000 (11:29 +0000)]
Add a test to indexedby.test to check that automatic indexes (sqlite_autoindex_xxx) can be used with the INDEXED BY syntax. (CVS 5767)
FossilOrigin-Name:
bb51c34506b3353506b6f3566fbe2a10d02e8ebc
danielk1977 [Mon, 6 Oct 2008 05:32:18 +0000 (05:32 +0000)]
Allow INDEXED BY and NOT INDEXED clauses in SELECT statements. (CVS 5766)
FossilOrigin-Name:
98ca5580f5acd2e7b3ce512520ec0527f221505e
danielk1977 [Fri, 3 Oct 2008 09:10:45 +0000 (09:10 +0000)]
Modifications to bind.test to account for different values of SQLITE_MAX_VARIABLE_NUMBER. Ticket #3409. (CVS 5765)
FossilOrigin-Name:
1a91f3fd58608e258b60305d1d18c3d07d2e9c46
danielk1977 [Fri, 3 Oct 2008 08:44:54 +0000 (08:44 +0000)]
Change one of the test cases in incrblob2.test to avoid allocating a 10MB block of heap memory. (CVS 5764)
FossilOrigin-Name:
83b7dd737a16555b9eb4ad9faacac3d705b0a90e
danielk1977 [Thu, 2 Oct 2008 16:42:06 +0000 (16:42 +0000)]
Change to reduce the number of OP_Null opcodes in "WHERE <rowid> IN (x,y,z)" queries. (CVS 5763)
FossilOrigin-Name:
33b59a3db0b1797663ae840ceaca1b23a9a9e3b0
danielk1977 [Thu, 2 Oct 2008 14:49:01 +0000 (14:49 +0000)]
Fix for sqlite3_blob_write(): If either 3rd or 4th argument is less than zero, return SQLITE_ERROR. H17879. (CVS 5762)
FossilOrigin-Name:
f6074c0b9b5ba51d131509dba2aec80d0fcf3b7e
drh [Thu, 2 Oct 2008 14:33:56 +0000 (14:33 +0000)]
Fix a typo that prevents the sqlite3_sql() interface from appearing
in the official documentation. (CVS 5761)
FossilOrigin-Name:
b46814b202f4cc355b925551c90ea811f3f9e44a