database/sqlite
1
0
Fork 0
mirror of https://github.com/sqlite/sqlite.git synced 2026-10-25 09:59:22 +03:00
Code Activity
13,071 Commits 1,785 Branches 392 Tags
threadtest3
Commit Graph

4939 Commits

Author SHA1 Message Date
drh
85fabf1444 This is a cherry-pick of version [b5df5ac052]. 
FossilOrigin-Name: d4b2d5d066891e06f2bf4337902b44b000fa9fd2
 2014-11-11 22:55:26 +00:00
mistachkin
bfa395d085 Remove some calls to the 'breakpoint' test command. 
FossilOrigin-Name: 1412fcc480799ecbd68d44dd18d5bad40e20ccf1
 2014-11-11 19:07:56 +00:00
dan
2d8e3caa2e Add tests for sqlite3_blob_bytes(). 
FossilOrigin-Name: a066a3832a7c6de65c3016e77e49ac00e09db749
 2014-11-11 16:11:04 +00:00
drh
949d43a5fd Permit read operations to continue after a ROLLBACK as long as the schema 
does not change.

FossilOrigin-Name: b5df5ac0529f7b0d1e880a7f4a307e7d77b7fa6c
 2014-11-11 14:59:31 +00:00
dan
43f4066e10 Add new test file e_blobclose.test, containing tests for sqlite3_blob_close(). 
FossilOrigin-Name: 5a1eac2419b1462e6f21595a3fff26d9cc49d203
 2014-11-11 12:20:35 +00:00
drh
47b7fc7843 Experimental changes that permit read operations to continue after a 
ROLLBACK, as long as the schema is unchanged.

FossilOrigin-Name: fa6e6a9ae276cad60e9a4abc1bc23cf2809ea786
 2014-11-11 01:33:57 +00:00
drh
de58f4fe7f New test cases for deleting content out from under a SELECT statement. 
FossilOrigin-Name: 8289c3e9b47f7c2a606a88839f6bf615f8904ac2
 2014-11-10 19:16:59 +00:00
dan
923c4b35be Add test file e_blobwrite.test, containing tests for the sqlite3_blob_write() interface. 
FossilOrigin-Name: 1df77e5f1bd82de4dc92fe28359c3e56ab3f9ed4
 2014-11-10 17:53:03 +00:00
drh
1728bcb07f Add the eval() SQL function extension in ext/misc/eval.c. 
FossilOrigin-Name: 27cf665b957f2c0ced403e3032099e80c295598f
 2014-11-10 16:49:56 +00:00
dan
b391b94431 Add new test file e_blobopen.test, containing tests for sqlite3_blob_open(). 
FossilOrigin-Name: ecbccd0e594d22b3ae7fabc8037951dc49570bc3
 2014-11-07 14:41:11 +00:00
drh
518140ed04 Change the SQLITE_SCANSTAT_EST parameter so that it returns a double for 
the estimated number of output rows per loop, rather than a 64-bit integer.
Revise the output format for the ".scanstats on" in the shell to make use
of this new capability.

FossilOrigin-Name: f9684000665ae7ef6f89c3773612b8286b8f545a
 2014-11-06 03:55:10 +00:00
drh
e1db0db899 Fixes to the Windows VFS to allow memory mapped files to work without WAL support. 
FossilOrigin-Name: 272fddc14cc322655eeba670bc0f9fc30e5a804c
 2014-11-05 21:34:56 +00:00
drh
6d3f91d040 Change the query planner to do a better job of estimating the number rows 
selected by a BETWEEN operator using STAT4 when both upper and lower bounds
are contained within the same sample.

FossilOrigin-Name: 2d36be5d9a1cdd4fd2d54fc4eeece32a81cbacc1
 2014-11-05 19:26:12 +00:00
drh
6b5631e02f Make sure that NULL results from OP_Column are fully and completely NULL 
and do not have the MEM_Ephem bit set.  Fix for ticket [094d39a4c95ee4].

FossilOrigin-Name: 42705fd7d892c4fdfb95fbbb468c99569beece25
 2014-11-05 15:57:39 +00:00
dan
937994aa65 Add a test case to check that the previous commit is effective. 
FossilOrigin-Name: 948d6e5d07bc14b6de32ec2144c716a5532f894c
 2014-11-05 14:19:05 +00:00
mistachkin
fdece7bad1 Skip tests that require WAL mode when it is not enabled. 
FossilOrigin-Name: 6fc4ead26d19b9348bbda34c3053ae1e066abc32
 2014-11-04 19:52:15 +00:00
dan
e2f771b047 Add further tests. Fixes so that compilation without ENABLE_STMT_SCANSTATUS works. 
FossilOrigin-Name: a2303c719222f1effb51acc6b37930561148c00c
 2014-11-03 15:33:17 +00:00
dan
037b5324bd Remove unused variable from struct WhereInfo. Add some explanatory comments to new code. 
FossilOrigin-Name: f5313e0c680d9baebefb1cf50ddadedd4418a334
 2014-11-03 11:25:32 +00:00
dan
6f9702ed4d If SQLITE_ENABLE_STMT_SCANSTATUS is defined, record the number of times each VDBE opcode is executed. Derive the values returned by sqlite3_stmt_scanstatus() from these records on demand. 
FossilOrigin-Name: 9ea37422a8cc2fce51bb10508e5e90f40fd4b511
 2014-11-01 20:38:06 +00:00
dan
89e71646df Minor fixes and documentation improvements for sqlite3_stmt_scanstatus(). 
FossilOrigin-Name: 8d8cc9608d30bb65fffcfe488e904411cbbc7f41
 2014-11-01 18:08:04 +00:00
dan
04489b6dce Add the experimental sqlite3_stmt_scanstatus() API. 
FossilOrigin-Name: 6a9bab34aeb6a01b612211a28c140de60a3e883c
 2014-10-31 20:11:32 +00:00
drh
af8f513f9d Fix the %c format character in sqlite3VXPrintf() so that it correctly 
handles precisions larger than 70.

FossilOrigin-Name: 08a27440f19b7fc884464832e6105af1bf008172
 2014-10-29 18:20:18 +00:00
drh
a26b9a7727 Fix problems with running UPDATE and DELETE against a VIEW and referencing 
the rowid in the WHERE clause.  This is a cherrypick of [95f8ebdbf87326f2]
and [8523670d50004f3].

FossilOrigin-Name: cc33e846c8509419f0a1fbfb286807b4c137788d
 2014-10-29 01:26:25 +00:00
drh
739383d25d In the OP_Column opcode, when extracting a field that is past the end of 
a short record (because the row was originally inserted prior to ALTER TABLE
ADD COLUMN) then make sure the output register is fully NULL and does not
contain leftover flags (such as MEM_Ephem) from its previous use.
Fix for ticket [43107840f1c02].  This is a cherrypick of
check-in [24780f8ddc1683fc].

FossilOrigin-Name: 304ea6ba6f4cf40a76d32d37af73a253f493ba47
 2014-10-29 01:13:58 +00:00
drh
22e8d833f0 In the OP_Column opcode, when extracting a field that is past the end of 
a short record (because the row was originally inserted prior to ALTER TABLE
ADD COLUMN) then make sure the output register is fully NULL and does not
contain leftover flags (such as MEM_Ephem) from its previous use.
Fix for ticket [43107840f1c02].

FossilOrigin-Name: 24780f8ddc1683fc62180e6961dc6bfe1168f4df
 2014-10-29 00:58:38 +00:00
dan
aa55563d7e Add new test file e_totalchanges.test, containing tests of the sqlite3_total_changes() interface. 
FossilOrigin-Name: f84af4adcc34d7a4c72027bf5b038a1a45a4c307
 2014-10-28 20:49:59 +00:00
dan
c3da667b25 Modify the documentation for sqlite3_changes() to make it more testable. Add tests and minor fixes for the same. 
FossilOrigin-Name: 41cdd0c422d61533a94870cb5ad094682956d472
 2014-10-28 18:24:16 +00:00
dan
dd8c460081 Fix a crash that could occur if the WHERE clause of an UPDATE statement on a view that does not feature a column named "rowid" contains a term such as "rowid=?". 
FossilOrigin-Name: 8523670d50004f3112b7871f11c8b8b02aab96ab
 2014-10-28 16:50:10 +00:00
dan
f77b610e44 Add test file e_wal.test. 
FossilOrigin-Name: fc6920b5483eeeb06a474ff399a21afa51dc4859
 2014-10-27 11:25:28 +00:00
drh
059b2d50e1 Enhance the automatic index logic so that it creates a partial index when 
doing so gives the same answer for less work.

FossilOrigin-Name: d95d0313c447f5baeabdb17284d8606331ab7d49
 2014-10-24 19:28:09 +00:00
drh
c8bbce1e6a If a skip-scan is a proper subset of some other scan, then adjust the 
cost of the skip-scan upward so that it is more costly than the other scan.
Such a cost imbalance can arise under STAT4 because of difficulties in getting
an accurate estimate for skip-scans.

FossilOrigin-Name: f4b22a2620a5dc48949048c2ecbd226755d4b2c3
 2014-10-21 01:05:09 +00:00
mistachkin
92c2e0da8f Changes to work around Win32 and MSVCRT APIs that are not present on Windows CE 200x. 
FossilOrigin-Name: 1418c006e377d7915a50577d4ccb21125b750bae
 2014-10-16 18:34:50 +00:00
dan
5d510d4c41 Update releasetest.tcl so that x86-64 runs a superset of the x86 tests. 
FossilOrigin-Name: 3c1e70f4d55bc009ed9ed4cf6d756d7061985851
 2014-10-15 15:28:27 +00:00
dan
f41652419e Fix a problem causing lock5.test to fail in mmap-mode. 
FossilOrigin-Name: b3e7b446bdb47cf9d7fe43dc37e3b4f8010ee09e
 2014-10-15 14:45:34 +00:00
drh
8683e08676 Require the SQLITE_ENABLE_RTREE compile-time option in speedtest1.c in order 
to enable the R-Tree tests.

FossilOrigin-Name: 5d29a033b0f17b0fd74656b28a8367a9a9067f81
 2014-10-11 10:52:54 +00:00
dan
b6453201d2 Account for the ASC/DESC properties of ORDER BY expressions when using the same index for GROUP BY and ORDER BY. Candidate fix for [ba7cbfaedc]. 
FossilOrigin-Name: 2a9573962b837973c4959465d8a5f2641d109a5a
 2014-10-10 20:52:53 +00:00
dan
5bd8af7c6b Fix a failing test case in index5.test. Also tweak the way cache memory is divided between read-only and dirty pages when using SQLITE_CONFIG_PAGECACHE to reduce IO in some cases. 
FossilOrigin-Name: 8541dfb3bbdf63dc9ab304d8a0ab8b290cdc9d96
 2014-10-10 19:10:59 +00:00
drh
e35626fabd When using the -config option to releasetest.tcl, default the testing type 
to "fulltest" if it is not specified on the command line.

FossilOrigin-Name: cf291cbe9f49396f03cfca39c2e892f27f750107
 2014-10-10 17:47:00 +00:00
drh
2eeb7ae437 Provide the new "-config CONFIG" option to the test/releasetest.tcl script, 
which allows one to run a single test configuration selected by name.

FossilOrigin-Name: d479e32be205f6cd0474f002282eae6eec613f36
 2014-10-10 17:44:03 +00:00
dan
6e1a037357 Allow FTS tokenizers to choose whether or not to consider the "*" character part of tokens or not. This restores the pre-[e21bf7a2ad] behaviour. Also fix a problem causing FTS to interpret tokens beginning with "*" characters as EOF. 
FossilOrigin-Name: 49dfee7cd1c9ab2901b8a871a6cd00b2ead76801
 2014-10-09 15:08:17 +00:00
drh
622d4f8bb1 Add a test case for the memory leak fixed by the previous check-in. 
FossilOrigin-Name: bae36d544676c90e337381a83f4513b4d925ab05
 2014-10-09 14:10:38 +00:00
drh
3705ef6a73 Fix up test cases to account for the new SQLITE_LIMIT_WORKER_THREADS limit. 
FossilOrigin-Name: 6483d426c4c5c772cd49412ea37e0fa7a0378904
 2014-10-08 15:53:21 +00:00
dan
923c0b53be Remove some temporary code in mallocA.test that was accidentally checked in. 
FossilOrigin-Name: dedd15f7cd13868f3be37646dd30ab7ceac5dea7
 2014-10-08 11:11:24 +00:00
drh
69afd9980e Fix the STAT4 range scan estimates for DESC indexes. 
FossilOrigin-Name: e3fe84005259ef9a6027d25793514cebb2d4e7e0
 2014-10-08 02:53:25 +00:00
drh
89a5833cb9 Fix the corruptI.test script so that it works with 
SQLITE_ENABLE_OVERSIZE_CELL_CHECK and with SQLITE_DEFAULT_AUTOVACUUM=1.

FossilOrigin-Name: e405b9e4a9ef322d84b20e902234b4f6aa196b1b
 2014-10-07 20:09:27 +00:00
dan
61a157254f Improve the accuracy of the estimates used when searching an index for values not present in any stat4 samples. 
FossilOrigin-Name: 3aff9a9cac7aa994dfdaa0ab5c23ae73a1e820f0
 2014-10-06 14:37:48 +00:00
drh
00729cba46 Updates to documentation and requirements marks. No code changes. 
FossilOrigin-Name: 0f8102d71a0ee828629f037775ad86fe2a544120
 2014-10-04 11:59:33 +00:00
dan
4ee3eb0ad4 Add a test to show that the change on this branch is effective. 
FossilOrigin-Name: fc619be057975b8be6d0958024c5d436edbdf084
 2014-10-04 10:22:01 +00:00
drh
8da47419dd Update to requirements marks related to changes in the memory allocation 
interface and enhancement of the documentation regarding DEFAULT clauses
in CREATE TABLE.

FossilOrigin-Name: 440705b98a3429b830ea85e71cc1e414bc6d8058
 2014-10-03 14:54:47 +00:00
drh
2a3d1d17fd Avoid a NULL pointer deference when processing the IS operator if the 
right-hand side is an illegal "#ID" style variable.
Fix for ticket [8c32a33a53092c85a15b]

FossilOrigin-Name: ffe7573636c8057614b02f0a85559e1857fd04e4
 2014-10-02 21:52:35 +00:00