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,676 Commits 1,785 Branches 392 Tags
threads
Commit Graph

9238 Commits

Author SHA1 Message Date
drh
c5f246eb37 Add #ifdefs for test coverage. Add a testcase(). 
FossilOrigin-Name: be2702ce35c713b33c9b7689643b45fb0de6af2a
 2014-05-01 20:24:21 +00:00
drh
57fe136b23 Take out the special handling of nolock=true in os_win.c and add it to 
pager.c, so that it works for all VFSes.  Add the pPager->noLock boolean
for clarity.

FossilOrigin-Name: 725c1c14be331bce9bf074960dbfa7b6d4c1ba87
 2014-05-01 01:49:22 +00:00
drh
48cdabcb1a Avoid unnecessary xUnlock operations on temp file. 
FossilOrigin-Name: 1829c38c3233c8cb194fae6d560d35a8916b1348
 2014-05-01 01:20:05 +00:00
drh
d1ae96d39e Add the immutable=TRUE query parameter and SQLITE_IOCAP_IMMUTABLE, either 
of which prevents locking of the database and omits tests for existance
of journal files.

FossilOrigin-Name: 71f152c85d79ebd9ca48bc9c4c71fc4debaf2437
 2014-05-01 01:13:08 +00:00
drh
fb4c9242a5 Merge in all recent changes and enhancements from trunk. 
FossilOrigin-Name: 84243f844417f888ab731841f7dbf95749f6e034
 2014-04-30 20:32:41 +00:00
dan
5da73e1a09 Fix a problem in calculating the costs of "OR" scans. 
FossilOrigin-Name: 9bbca48b42e4fe16f2188e18dc736da30a96435c
 2014-04-30 18:11:55 +00:00
dan
8164722c58 Add text to the header comment of whereLoopAddBtree() describing how the costs of various b-tree loops are estimated. 
FossilOrigin-Name: 05e6e16cb28c9ffb4596bd2ef81f687c5403ecbb
 2014-04-30 15:00:16 +00:00
dan
4a6b8a05cd Fix a couple of out-of-date comments in where.c. 
FossilOrigin-Name: eefeda32d54efbbdf7d20b719299eda48b891fae
 2014-04-30 14:47:01 +00:00
drh
224155dd1c Fix long-standing typos in comments. 
FossilOrigin-Name: b9f91317c34d07769a95dc2f905a6ccabceb64a3
 2014-04-30 13:19:09 +00:00
dan
264d2b97a9 Test that the default values used when sqlite_stat1 data is not available are calculated correctly. Fixes for the same. 
FossilOrigin-Name: e2d42f909de85a0586389f2dc0e654f7af2e351a
 2014-04-29 19:01:57 +00:00
dan
e4618fb30d Merge trunk changes into this branch. 
FossilOrigin-Name: d74299f037f3a6a4b3bce8b4d1c76c407c1f3b3e
 2014-04-29 16:46:24 +00:00
dan
09e1df6c00 Ignore likelihood() values on indexed IPK lookups. 
FossilOrigin-Name: 5bb7757a7b32a74482d3e93e9c9eea02273fe981
 2014-04-29 16:10:22 +00:00
dan
7de2a1faf6 Do not reduce the number of rows scanned at all for "IS NOT NULL" constraints. Fix a bug in calculating the number of rows visited by scans of partial indicies. 
FossilOrigin-Name: a8ae93f0cffa116df0ba34d46a53f49d42dace41
 2014-04-28 20:11:20 +00:00
dan
42685f211e The trunk assumes that an open range constraint on an indexed term (col>?) term matches 1/4 of the indexed rows, and that a closed constraint (col BETWEEN ? AND ?) matches 1/64. Change this branch to do the same. 
FossilOrigin-Name: 4047ac75e2a8f0b330255501c42e4f04e5ab500d
 2014-04-28 19:34:06 +00:00
drh
65e6b0dd12 Add the sqlite3_rtree_query_callback() API to the RTree virtual table. 
(Cherrypick from the sessions branch.)

FossilOrigin-Name: af2cbe64adab5f9e3b0f3da00d06428088589d7f
 2014-04-28 17:56:19 +00:00
dan
e3bfbb7284 Modify internal function whereLoopAdjustCost() so that it does not prefer a skip-scan over a regular index scan even if the regular scan uses a subset of the WHERE terms used by the skip-scan. 
FossilOrigin-Name: 88a5758dcce891eb7be15432ebdc9f80071d413b
 2014-04-28 09:35:31 +00:00
dan
440e6ff3b0 Fix an error in estimating of the number of rows visited by a range scan. 
FossilOrigin-Name: d491de62fce69d93e89f65f7713972f7c2c451f7
 2014-04-28 08:49:54 +00:00
dan
2dd3cdcfab Fix an sqlite3_stmt_status() problem caused by recent changs on this branch. 
FossilOrigin-Name: dee204092421a239f9f60ab83c3a5b3e24d1baea
 2014-04-26 20:21:14 +00:00
drh
453e0261df Allow the xfer optimization to proceed if the DEFAULT on the very first 
column of the two tables is different.  This is a refinement of the
fix for ticket [f67b41381a].

FossilOrigin-Name: 349f483499dd685a8da94923b6bd810a52e5e236
 2014-04-26 17:52:08 +00:00
dan
9940e2aa45 Avoid transfering records between tables unless the default values for all columns are the same. Fix for [f67b41381a]. 
FossilOrigin-Name: f8c4c495e6de1f124d205383d4bafa46accbff5c
 2014-04-26 14:07:57 +00:00
dan
8ad1d8ba38 If the user provides likelihood() data for a WHERE clause term used as part of an index key, have the planner use it when calculating the expected number of rows visited by the loop. 
FossilOrigin-Name: c51efaa5d29ee0a91b9e6a83a8dd82530670811a
 2014-04-25 20:22:45 +00:00
dan
cfc9df76e1 Store values loaded from the stat1 table as logarithmic values in memory. 
FossilOrigin-Name: 1bd74c49ddab6f53bb6eaa57907eff44c2580dd6
 2014-04-25 15:01:01 +00:00
drh
9dfaf621d1 Make sure ORDER BY clauses on joins that involve virtual tables and that 
have a DISTINCT clause work correctly.  This is a candidate fix for
ticket [388d01d4bb8f9].  Test cases for that ticket will be checked in
separately.

FossilOrigin-Name: 171138122690faafde0dcab0201b90bdf02d3637
 2014-04-25 14:42:17 +00:00
drh
a01c7c70fd When VDBE_PROFILE is enabled, ignore negative opcode times, which sometimes 
occur, perhaps due to context swaps.

FossilOrigin-Name: 4e88042f9d3e678914da96c0eb276f3d8fca5a94
 2014-04-25 12:35:31 +00:00
dan
aa9933c115 Changes to the way the planner calculates the costs of various table and index scans. Some test cases still failing. 
FossilOrigin-Name: c5a6ec0a880652dc8f4593d9f7acd58ddc3dc5f3
 2014-04-24 20:04:49 +00:00
drh
f690c14280 Improved header comment on the vdbesort.c module. No changes to code. 
FossilOrigin-Name: bf09ce24d054bc68c226064f5f28d97e0e648a13
 2014-04-24 16:25:25 +00:00
drh
0ff435a782 Reopen the orderby-planning branch and merge in the latest trunk enhancements 
and fixes.

FossilOrigin-Name: 6077ddcd93318e24b9756adaaf293ba9fb3cedf7
 2014-04-24 15:06:25 +00:00
drh
3de4df27dd Improvements to comments. Store some extra information in SqliteThread that 
is useful for debugging.

FossilOrigin-Name: 9fb5e212089d85cdd3b4787dd69c72e6d84560b6
 2014-04-24 12:28:28 +00:00
drh
9e0ed8d4ec Merge all recent trunk changes into the threads branch. 
FossilOrigin-Name: e2c9f71a451e44040624b9f255b4510743513019
 2014-04-23 12:57:55 +00:00
drh
f34a9fef4c Change from using the win32-none VFS to just a query parameter. 
FossilOrigin-Name: ffceacf61905dc3553978ba5f68e133947eca2fa
 2014-04-22 19:42:22 +00:00
mistachkin
9df245b073 Add some OSTRACE calls for consistency. 
FossilOrigin-Name: be292d559748a24ff012266a1f58ce6c027e0411
 2014-04-22 19:34:16 +00:00
drh
0bf8277196 Add the win32-none VFS which omits rollback-journal locking. 
FossilOrigin-Name: 03e3c5a8b17a219a49bfbe79b7debd27ace8ad85
 2014-04-22 19:30:00 +00:00
dan
374cd78c1d Avoid discarding an ORDER BY clause in the case where an identical GROUP BY clauses uses an index to group, but not sort, the rows. Fix for [b75a9ca6b0]. 
FossilOrigin-Name: de9a490f594183f337a2ec9e0f87792eac83548b
 2014-04-21 13:21:56 +00:00
drh
b355c2cc12 Clean up the proper-subset cost adjustment logic to make it more compact 
and easier to read and so that full branch test coverage is more easily
obtained.

FossilOrigin-Name: 9a5d38c79d2482a23bcfbc3ff35ca4fa269c768d
 2014-04-18 22:20:31 +00:00
drh
958d261bb8 Fix harmless compiler warnings. 
FossilOrigin-Name: f8f72ecb9052a4cace1db75879fb8b5131ea4f50
 2014-04-18 13:40:07 +00:00
drh
e9af1894e3 Merge recent trunk changes into the threads branch. 
FossilOrigin-Name: 8729aa3e3ed1da2e15408ef8705cbe185cd2a5ac
 2014-04-18 12:38:54 +00:00
drh
71794dbaeb Add the SQLITE_RUNTIME_BYTEORDER compile-time option to force SQLite to check 
the processor byte-order at run-time.  Add additional compile-time byte order
checks for ARM, PPC, and SPARC.

FossilOrigin-Name: 2c5363873a6f990a0abaacac6303acd46b48befc
 2014-04-18 00:49:29 +00:00
drh
2cf4acbd9f Add the SQLITE_TESTCTRL_BYTEORDER test control to interrogate SQLite's notion 
of the processor byte order and whether the byte order is known at compile-time
or determined at run-time.

FossilOrigin-Name: 9c6961967ae00e563ebe2859eaf2639a79f2cb01
 2014-04-18 00:06:02 +00:00
dan
a9f43d735b Fix build problems in vdbesort.c. Add further comments and changes to make things easier to understand. 
FossilOrigin-Name: 12b190db1d20c34390c768614b40ff58a9d3b74c
 2014-04-17 08:57:17 +00:00
dan
31a0bfde9b Clarify the purpose of the nField argument passed to sqlite3VdbeSorterInit(). 
FossilOrigin-Name: c0c8cff17b7311bbc4fd081313a5552f927c3833
 2014-04-16 19:04:23 +00:00
dan
db30fc4ff2 Change the name of vdbeIncrInit2 to vdbePmaReaderIncrInit. Add a header comment to the same function. 
FossilOrigin-Name: 6622d87675c1d7992b1e6d52ae7da1007a1568a4
 2014-04-16 17:41:22 +00:00
dan
7f0a24b7bf Rework the way trees of MergeEngine objects are built in vdbesort.c to make it easier to follow. Fix memory leaks that could follow an OOM or IO error. Add various comments to explain functions in vdbesort.c. 
FossilOrigin-Name: 69026ec7dc3bd3e33bbe17c221a53cf1dd0f8945
 2014-04-16 16:43:05 +00:00
dan
22ace89179 Fix some problems to do with OOM conditions in vdbesort.c. Some problems remain. 
FossilOrigin-Name: 2f94f9ce9bf11f1599bbc640b3fc8c15da588416
 2014-04-15 20:52:27 +00:00
dan
1a088a8ef5 Fix further code and documentation issues in vdbesort.c. 
FossilOrigin-Name: d03f5b8622d304f029f73c7cd0bee3182a81d081
 2014-04-15 19:52:34 +00:00
drh
65b9ac5224 Make sure the undocumented sqlite_rename_parent() function does not 
crash even if it is invoked with NULL arguments.
Ticket [264b970c4379fd4b94]

FossilOrigin-Name: c6fa8d0d82805be230f672eabccdfa5680d4ddfd
 2014-04-14 19:48:25 +00:00
dan
f77ceba594 Improve performance in single-threaded mode by having the final merge pass keys directly to the VDBE, instead of going via a final PMA. 
FossilOrigin-Name: 02610cd9b77caa2c181210056088beb3ad6ce30f
 2014-04-14 18:41:21 +00:00
dan
92a20dde1f Minor fixes so that builds with SQLITE_MAX_WORKER_THREADS=0 work. 
FossilOrigin-Name: e400bbbf26cdfe88f6cb231e96cdcddb9a6bcc0f
 2014-04-14 08:45:32 +00:00
dan
be3018c18f Improve use of multiple threads in sqlite3VdbeSorterRewind(). 
FossilOrigin-Name: e1bdc4b810907cc0e55e0c923c8ebc777068cfe0
 2014-04-14 07:30:39 +00:00
drh
d249090450 Remove the unused second argument from sqlite3ExprCachePop(). Add an 
ALWAYS() on an always-true conditional in sqlite3VdbeResolveLabel().

FossilOrigin-Name: ab23abf392175d3e256ff619b13abbbe732a49ed
 2014-04-13 19:28:15 +00:00
drh
87744513e7 Make sure column cache elements are cleared correctly when jumping over 
code for key generation in a partial index. 
Fix for ticket [2ea3e9fe6379fc3f6].

FossilOrigin-Name: 3122b8364082be783821da01d4af2af6a9586327
 2014-04-13 19:15:49 +00:00