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
12,338 Commits 1,785 Branches 392 Tags
rtree-queue
Commit Graph

4776 Commits

Author SHA1 Message Date
drh
c9cb207acf Add the new interfaces to rtree, though they do not yet work. Add the 
"show_speedtest1_rtree.tcl" script for showing the test data used for the
R-Tree tests of speedtest1.  Change speedtest1 to generate better R-Tree
test data.

FossilOrigin-Name: 0b70275972c7a6a533566c1e50bffbf3ac531e95
 2014-04-11 23:14:48 +00:00
drh
eb7c4f2aea Add the --verify option to speedtest1. Add verification test cases to 
the "rtree" testset and a case that uses a custom geometry callback.

FossilOrigin-Name: 9d485c4207a81f32334857d4a608c5c511dd2b83
 2014-04-11 17:41:08 +00:00
drh
dcc5c7b2fc Update comments in the R-Tree module in preparation for some big changes. 
Add an "rtree" performance test to speedtest1.

FossilOrigin-Name: 20a73ec0b2f56609a4504052e198e32803d30207
 2014-04-11 16:14:54 +00:00
drh
652cc4b6dc Merge all recent changes from trunk, 
including the fix for the OP_SCopy-vs-OP_Copy problem.

FossilOrigin-Name: 9515c8344a6743bbb0c6a6e49fb79fb3139090df
 2014-04-03 16:35:33 +00:00
drh
c438df1be0 Use OP_Copy instead of OP_SCopy when moving results out of a subquery, 
to prevent the subquery results from changing out from under the outer
query.  Fix for ticket [1e64dd782a126f48d78].

FossilOrigin-Name: d5513dfa23baa0b0a095aaf17d19aacd30dcef61
 2014-04-03 16:29:31 +00:00
drh
70c93204ea Disable the wal64k.test script for non-unix systems since it depends on 
unix-only features.

FossilOrigin-Name: 27deb6e49bcc76714dbdc61b34748603155ac770
 2014-03-28 14:41:35 +00:00
drh
a1f7c0a21c Enhance the sqlite3VdbeRecordCompare() routines so that if they encounter 
database corruption, they will set the UnpackedRecord.isCorrupt field and
return 0.  The sqlite3BtreeMovetoUnpacked() routine detects this and returns
SQLITE_CORRUPT, causing the corruption to be reported back to the top-level.

FossilOrigin-Name: 7fa85eaaaf6d211378620d728a759fdfe30a15b0
 2014-03-28 03:12:48 +00:00
drh
24ed9d0445 Merge in fixes (including the corrupt-database crash fix) and 
performance enhancements from trunk.

FossilOrigin-Name: fc8ca1a87e7127bd28f32fd809aec3e24355fbfa
 2014-03-26 19:43:30 +00:00
dan
68916c9fd3 Add an extra test case for the potential buffer overread patched by [28ddecff04]. 
FossilOrigin-Name: f585f5d7a0f9bf8c590388654a3638231eba8892
 2014-03-26 15:14:59 +00:00
drh
d9c131c366 Add a test case to verify that the previous change avoids excess buffer 
overread in sqlite3VdbeRecordCompare().

FossilOrigin-Name: 2b28e8d582cf10936fa1faca04a16ca2eeead66f
 2014-03-26 15:05:56 +00:00
drh
182ea4e324 Earlier detection of corruption in sqlite3VdbeRecordCompare() in order to 
avoid a potential buffer overread.

FossilOrigin-Name: 28ddecff044dbc2dff50a7d8406ab67dfe06587f
 2014-03-26 14:51:07 +00:00
drh
5e8980ddb1 Adjust the repeat counts on several tests in speedtest1 so that the relative 
time spent on the test is roughly the same regardless of --size.

FossilOrigin-Name: 7922809ee0d3978ce9221fbb7df63aa0684d0c4d
 2014-03-25 20:28:38 +00:00
drh
c872966ef4 Add another performance test case to speedtest1. This case is another 
ORDER BY test but this time without LIMIT.

FossilOrigin-Name: 9ab7ffd59209aef0ffbf384b3902a93fd3b86a6d
 2014-03-25 17:45:49 +00:00
drh
0c60c1fe66 Add an ORDER BY test case to speedtest1.c 
FossilOrigin-Name: 588122641e57e957813d329ea071e13ccbde5acd
 2014-03-25 14:54:36 +00:00
drh
3d1d90a13d Fix arithmetic operators so that they do not change the affinity of their 
input operands.  Ticket [a8a0d2996a].

FossilOrigin-Name: 221f8f944703108e47d789fa8ce6c00fe2abcbb6
 2014-03-24 15:00:15 +00:00
dan
4979088506 Avoid attempting to mmap memory from an offset that is not a multiple of the system page size on systems with page sizes larger than 32KB. 
FossilOrigin-Name: db7d62c8d58eb1e8654a762c9b199ae4e2759038
 2014-03-24 11:23:17 +00:00
drh
9a4444778f Add the ability to use indices for the first few terms of an ORDER BY clause, 
then sort in batches to handle the later terms.

FossilOrigin-Name: fa06a6fed9f48322d9b89721799ba12c46efa898
 2014-03-21 20:58:42 +00:00
dan
9afccba269 Avoid leaking memory in an obscure case where the flattener adds an ORDER BY clause to the recursive part of a recursive query. 
FossilOrigin-Name: 1f413aca00015100224273480e1ce39a76bf93ab
 2014-03-21 19:27:54 +00:00
drh
cc08fa48b8 Merge the OFFSET-on-query-without-FROM fix from trunk. 
FossilOrigin-Name: 71e9ae72c272dc86720b2bfe719f57de437c400b
 2014-03-21 18:45:19 +00:00
drh
a22a75e5ca Fix the OFFSET clause so that it works correctly on queries that lack 
a FROM clause.  Ticket [07d6a0453d4ed8].

FossilOrigin-Name: 179ef81648b0ad557df78b7712f216b876b6fb65
 2014-03-21 18:16:23 +00:00
drh
e99b9cdc70 New test case for block-sorting. 
FossilOrigin-Name: e70cfa28aa393661ccc742ecd5e672d807bdd0a9
 2014-03-21 15:24:07 +00:00
drh
f9f1bdb0c8 Merge trunk fixes for "x IN (?)" handling. 
FossilOrigin-Name: eca35871c34374ca9189c7c9b6d490ac3c30357f
 2014-03-20 20:56:49 +00:00
drh
fbb24d1092 The "x IN (?)" optimization in check-ins [2ff3b25f40] and [e68b427afb] is 
incorrect, as demonstrated by the in4-5.1 test case in this check-in.
The "COLLATE binary" that was being added to the RHS of IN was overriding
the implicit collating sequence of the LHS.  This change defines the EP_Generic
expression node property that blocks all affinity or collating sequence
information in the expression subtree and adds that property to the expression
taken from RHS of the IN operator.

FossilOrigin-Name: 2ea4a9f75f46eaa928ba17e9e91bc0432750d46d
 2014-03-20 17:03:30 +00:00
drh
0a8d14261c Previous check-in is not quite correct. "x IN (?)" is not exactly the same 
as "x==?" do to collation and affinity issues.  The correct converstion should
be to "x==(+? COLLATE binary)".  The current check-in fixes this problem and
provides test cases.  Ticket [e39d032577df69]

FossilOrigin-Name: 2ff3b25f40fd117c8a2da1d1a3625f6b167b7b16
 2014-03-20 14:56:47 +00:00
drh
2b59b3a4c8 Convert expressions of the form "X IN (?)" with exactly one value on the 
RHS of the IN into equality tests:  "X=?".  Add test cases to verify that
statements work correctly on this corner case.
Fix for ticket [e39d032577df6942].

FossilOrigin-Name: e68b427afbc82e201c64474117851aa4c9eb0c92
 2014-03-20 13:26:47 +00:00
dan
bc76063cd2 Add a test to ensure os_unix.c works with 64KiB OS pages. 
FossilOrigin-Name: e3d2be3ba47cdaafd26347620ae3bc2813203f16
 2014-03-20 09:42:09 +00:00
drh
6284db908a Fix query planner weights associated with choosing block-sorting. Fix 
block sorting of tables with collating functions.  Fix various test cases.
All "veryquick" tests are now passing, though more tests need to be added.

FossilOrigin-Name: 01afbf97c0ff29667806e9a7c4d74ca717819de5
 2014-03-19 23:24:49 +00:00
dan
d88e521f59 Fix an obscure bug causing sqlite3_close() to fail if there are virtual tables on the disconnect list when it is called. 
FossilOrigin-Name: 6504aa47a8ebb13827be017c4cb4b2dc3c4c55f4
 2014-03-12 19:38:38 +00:00
dan
82d25da5b0 Changes to FTS to ensure that it does not access the database from within the xConnect method. 
FossilOrigin-Name: c67a52c356416cc200f51f9168d942e78db11d34
 2014-03-12 19:20:36 +00:00
drh
181aed3c25 Version 3.8.4 for sessions (plus two minor fixes). 
FossilOrigin-Name: 917c410808756e1697bd628f4c9c57dd13d08ce7
 2014-03-11 01:48:06 +00:00
drh
89212fb9f9 Adjustments to the cost computation for the skip-scan query plan, to take 
into account the fact that a seek has to occur on each skip.

FossilOrigin-Name: 0769eebd028ce31375cf93509a1d3687f7b117eb
 2014-03-10 20:12:31 +00:00
dan
b72cad14d0 Fix a bug causing "SELECT char()" to return SQLITE_NOMEM. 
FossilOrigin-Name: ba39df9d4f7ffc6475ae0dc794f7d3f58c486de8
 2014-03-08 19:07:03 +00:00
drh
4e2f459987 Merge the fix for the journal_mode=PERSIST error recovery delay bug. 
FossilOrigin-Name: bb6a75f4bbcaaabc3ad47992c7c87868c70e8daf
 2014-03-07 14:36:50 +00:00
mistachkin
8879481868 Avoid calling sqlite3OsDelete() on a file that is open, since this causes Windows to run *very* slowly. Comes up on error recovery in journal_mode=PERSIST. 
FossilOrigin-Name: fdc651e2ec7a0babee669e24fd56632e7cd5f0e9
 2014-03-07 02:29:56 +00:00
dan
f0ec2a5ea7 Do not run corruptH.test in mmap mode. 
FossilOrigin-Name: c0d54b4e41cba84dc5934e0fcd03fe422fe5c92b
 2014-03-06 18:16:45 +00:00
drh
3bde1354ff Merge compiler-warning fixes from trunk. 
FossilOrigin-Name: a1f2b0428518ec18af74a0e01deb4e40cd95a78f
 2014-03-05 23:12:55 +00:00
dan
a6eaa635cc Avoid running a couple of test cases that use realloc() extensively if SQLITE_MEMDEBUG is defined. 
FossilOrigin-Name: e406d4bb786a34cdd5dd23ed39f35dfce3e1cabd
 2014-03-05 19:13:32 +00:00
dan
13ef14afc1 Add tests to join.test to verify that it is not possible to use more than 64 tables in a join. 
FossilOrigin-Name: ef1a998625e1fc051732228844388d6c59665382
 2014-03-05 16:15:07 +00:00
dan
1496566560 Add a test case for the problem fixed by [1d134ba2ed]. 
FossilOrigin-Name: d4fbc05df9501a09623d420fcd5b2bce3a57201b
 2014-03-05 15:04:36 +00:00
drh
0503cf491f Merge in various obscure bug fixes and the removal of Mem.memType from trunk. 
FossilOrigin-Name: 0828975d580d309a1c66da4b6caeb65b21a01199
 2014-03-05 14:49:51 +00:00
dan
d520041bc0 Do not run corruptI.test with the mmap permutation. 
FossilOrigin-Name: 378b290da85cadc1acba081322d1f0e8d7694e17
 2014-03-05 11:22:33 +00:00
drh
19c6d96aec Avoid indexing off the front end of an array when creating a view with 
two or more blank column names in the SELECT statement that defines the view.

FossilOrigin-Name: 554501f158534f9c27fd51900589c2ab7cf300d8
 2014-03-04 21:19:51 +00:00
dan
052c6784ee Fix a problem with "DEFAULT (-(-9223372036854775808))" clauses in ALTER TABLE ... ADD COLUMN commands. 
FossilOrigin-Name: e072cb3ee2a03d786c08230cecc6e970de2cec5b
 2014-03-04 21:00:20 +00:00
drh
7826a9b83f Merge the performance enhancements of trunk (and some obscure bug fixes) 
into the sessions branch.

FossilOrigin-Name: 7f51ad97f0b24c57453d58faf25eee68861faa23
 2014-03-04 14:34:14 +00:00
mistachkin
b64fa0adf7 Fix comment in test. 
FossilOrigin-Name: 1e57f67b20a1c01ede36d684be628e9270bf109a
 2014-03-04 12:07:24 +00:00
mistachkin
ad4b262545 Fix minor typos in the new test file. 
FossilOrigin-Name: 3cbb9b1b4f8c5c2735799e84dc80614586222cd2
 2014-03-04 11:54:35 +00:00
dan
5810d0315b Add tests to verify the fix for bug [4ef7e3cfca]. 
FossilOrigin-Name: 62410bb8a7b33efcd13bce8fd75b83523922adb8
 2014-03-04 11:35:20 +00:00
dan
9b8afef260 Avoid a buffer overread in vdbeCompareRecordInt() that might occur if the database is corrupt. 
FossilOrigin-Name: 7c0b4381f0e6f33cb13299a915851d9431bf3850
 2014-03-03 20:48:50 +00:00
dan
80b2f97234 Merge latest trunk changes. 
FossilOrigin-Name: 1d60356462f111ed147aa865dd17a13511db6ab7
 2014-03-03 17:48:03 +00:00
drh
6295524e3d Change an OP_SCopy into an OP_Copy in a case where the destination might be 
used after the source has changed.

FossilOrigin-Name: c0fa0c0e2de50d7eda19ab8862496b18eff93538
 2014-03-03 17:36:39 +00:00