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,433 Commits 1,785 Branches 392 Tags
push-down-backport
Commit Graph

13433 Commits

This Branch
This Branch
All Branches
Author SHA1 Message Date
drh
eb4e3f8348 When checking for the WHERE-clause push-down optimization, verify that 
all terms of the compound inner SELECT are non-aggregate, not just the
last term.  Fix for ticket [f7f8c97e97597].

FossilOrigin-Name: adc082c1461e0237cd42653b529fbc136f5899baeff6ee32ee943d76184080c1
 2017-07-17 19:25:10 +00:00
drh
3aeec23c29 Do not apply the WHERE-clause pushdown optimization to terms that originate 
in the ON or USING clause of a LEFT JOIN.  Fix for ticket
[c2a19d81652f40568c].

FossilOrigin-Name: 52674f948c3e74e5cc32874d4885f2302ad1d5dd0bc45ff6bfda18cf4bea904a
 2017-07-17 19:14:11 +00:00
drh
9da8bf9ae7 For FROM-clause subqueries that cannot be flattened, try to push relevant 
WHERE clause terms of the outer query down into the subquery in order to help
the subquery run faster and/or use less memory.
Cherry-pick from [6df18e949d36].  Still need to backport bug fixes associated
with that check-in.

FossilOrigin-Name: 043d6ce8ad85f8044735747b8938ea5ce9a08e71b860c2b7179b824021bb7a62
 2017-07-17 19:07:14 +00:00
drh
3a907ce696 Fix the covering index OR optimization (check-in [fcbd6abd]) so that 
it works with SQLITE_MAX_ATTACHED>30.  Broken by a bad cherry-pick merge.

FossilOrigin-Name: d227de8ad9cf757f30f5415ca8fccff3b5959621d09244bd1f444d3282c5b2ef
 2017-07-08 01:01:08 +00:00
drh
b792d9ef4c Make use of covering indexes in the OR optimization. 
FossilOrigin-Name: fcbd6abdb1a4cf622ff7e85625b9c2a9bbae92410359872924b7fc1e35046a75
 2017-07-05 16:20:49 +00:00
drh
23a09adc0b Add the count-of-view optimization when compiled using 
SQLITE_COUNTOFVIEW_OPTIMIZATION.

FossilOrigin-Name: b7ae4b879fc086e9543493843377ae90ceff1fe49c97b4c23367012034c3c9d5
 2017-07-05 14:54:24 +00:00
drh
1adf686f0c Add the SQLITE_DEFAULT_ROWEST compile-time option for changing the estimated 
number of rows in tables that lack sqlite_stat1 entries.

FossilOrigin-Name: 802b82f342328762e3995825aed1b22e61361ef24b673cd5d66b55756ce2a461
 2017-06-06 18:22:05 +00:00
drh
607e10998d Fix a problem in STAT4 equality estimation for multi-column indexes 
introduced by check-in [3e0590dee0e68cc1599].

FossilOrigin-Name: 19dad0a720c41d1d111f42cb2cb1f291c559957e76e3f88dc6cfc065e4845e77
 2017-05-24 04:32:09 +00:00
drh
b3785b8322 When planning a query using sorting, resolve ties in the solver by selecting 
loop plans with the smaller unsorted cost.

FossilOrigin-Name: 962531e7c1f3ff604271ddf9f47b6234dfd47702ccf24849f55b80814e7be267
 2017-05-22 00:27:20 +00:00
drh
80354c6630 In the STAT4 computations, ensure that the aAvgEq values do not go negative. 
FossilOrigin-Name: 4f83f6806aa6816656668feb181369500cc2cf0f
 2017-01-11 14:21:20 +00:00
drh
66d89de8b4 When the [https://www.sqlite.org/queryplanner.html#partialsort|block sorting optimization] 
is used in a scalar subquery, be sure to exit the loop as soon as the first
valid output row is received.  Fix for ticket [cb3aa0641d9a4] backported
to the 3.8.9 branch.

FossilOrigin-Name: 8e4ba115ededca6da78f0679bc9eff08af9365a8
 2016-11-02 16:29:31 +00:00
drh
4427e597b2 Fix the ORDER BY LIMIT optimization backport so that it works when the 
ORDER BY uses the DESC direction.

FossilOrigin-Name: 0c3cafb7ebb887dbfa2652f8bf69b52ed265c344
 2016-09-23 18:06:22 +00:00
drh
b5c7f2f235 Backport the ORDER BY LIMIT optimization to version 3.8.9. 
FossilOrigin-Name: db3614825fa02ddacc76b85d76a37aad9d2a9dc8
 2016-09-14 01:43:24 +00:00
drh
5efbd06ab3 Version 3.8.9 
FossilOrigin-Name: 8a8ffc862e96f57aa698f93de10dee28e69f6e09
version-3.8.9 		2015-04-08 12:16:33 +00:00
drh
b6f47deb0c Avoid signed integer overflow when converting oversized in-line integer 
widths and precisions in printf().

FossilOrigin-Name: 8e4ac2ce24415926247961b00a62425ae85d6ffb
 2015-04-07 15:39:29 +00:00
dan
8c069147ce Another change to avoid a problem caused by integer overflow in the printf() code. 
FossilOrigin-Name: 95625ef3adc3c408d67e70f877f390445fbb8292
 2015-04-07 14:38:57 +00:00
drh
a30d22a7a6 Further changes to guard against integer overflow in the width and precision 
of printf() arguments.

FossilOrigin-Name: 5ce4e7d7651e5c72a59f03f7aeb366291e62ab57
 2015-04-07 13:28:41 +00:00
drh
74b42275ec Guard against excessive width and precision in floating-point conversions 
in the printf routines.

FossilOrigin-Name: c494171f77dc2e5e04cb6d865e688448f04e5920
 2015-04-07 12:41:17 +00:00
dan
e3cdbad274 Fix a problem with fts3 prefix terms within phrase queries on "order=DESC" tables with a mix of negative and positive rowids. 
FossilOrigin-Name: 3ad829e50faca538db3abb2afb898b5521550c5c
 2015-04-06 11:04:51 +00:00
dan
4b0000c9a8 Fix a problem with fts3 prefix terms within phrase queries on "order=DESC" tables with a mix of negative and positive rowids. 
FossilOrigin-Name: 0cdf502885ea7e5805d7ba3719f055f5d48fc78d
 2015-04-06 09:05:29 +00:00
dan
cf860700e5 Fix a problem with resolving ORDER BY clauses that feature COLLATE clauses attached to compound SELECT statements. 
FossilOrigin-Name: edc1de2a588fd50c0049bb2be76d3f6783443165
 2015-04-04 16:49:04 +00:00
dan
b33c50f215 Fix a problem with resolving ORDER BY clauses that feature COLLATE clauses attached to compound SELECT statements. 
FossilOrigin-Name: 427b50fba7362e5b447e79d39050f25ed2ef10af
 2015-04-04 16:43:16 +00:00
drh
62ca61ee61 Disable the SQLITE_FCNTL_WAL_BLOCK feature for now. It needs more work and 
is not yet ready for release.

FossilOrigin-Name: 4ae9a3acc4eeeb7998769eb856c97c2233476f72
 2015-04-03 20:33:33 +00:00
drh
eaf2640237 Add source code to the "showlocks" utility program in the tool/ subdirectory. 
FossilOrigin-Name: 6868cc66d2be67b7f03776c982962ffa4b30de11
 2015-04-03 18:33:40 +00:00
dan
5f1731f670 Disable e_walauto.test on OpenBSD, as it requires a coherent cache. 
FossilOrigin-Name: 90701227085b8b8eb10a8eebe8d55f38b4778574
 2015-04-02 15:24:53 +00:00
drh
ccf46d0b90 Improved detection and suppression of endless loops in clearDatabasePage(). 
FossilOrigin-Name: 30011ad2f55cfcacaf23a58ebcc17b17a7b9355e
 2015-04-01 13:21:33 +00:00
drh
f9d02f3663 On windows, flush the mapping view when syncing content to disk. 
FossilOrigin-Name: a828e73dc1ae50189bdf73f60caeb7308738ad7a
 2015-03-31 19:40:05 +00:00
drh
4c45196a76 Add the "mptest" target to main.mk. Change TRUNCATE and PERSIST to DELETE 
for mptest.c on Windows because of problems trying to delete the journal.

FossilOrigin-Name: ea697e6d9ff1f4d77774589a02ba4a18feafbf03
 2015-03-31 18:05:49 +00:00
drh
8237f6d180 Change the sqlite3_log() message generated on a retry after delay in os_win 
to be an SQLITE_NOTICE instead of SQLITE_IOERR.

FossilOrigin-Name: 5d533eee049e63b3700f5ef7c28c588afccde57a
 2015-03-31 17:32:06 +00:00
drh
d881ce8fa7 Fix configure.ac and Makefile.in so that they generate pkgIndex.tcl correctly. 
FossilOrigin-Name: 3deff25249c59b7fc1b6eb65dda39736955679c6
 2015-03-31 17:01:52 +00:00
mistachkin
4d2daba467 Minor tweaks to the MSVC Makefile. 
FossilOrigin-Name: 7244ea59ede8aa2c7d1dc2c85268e12ddd452e27
 2015-03-31 16:42:16 +00:00
drh
6b5f0ebe97 Handle very large URI pathnames for in-memory shared-cache databases. 
FossilOrigin-Name: 586a94e85bc13700a2093734711c1367fa814b8c
 2015-03-31 16:33:08 +00:00
drh
1cc0d11a16 Fix harmless compiler warnings in lemon.c 
FossilOrigin-Name: bbe7dcda689a25860f2104804f00ba0a720c1372
 2015-03-31 15:15:48 +00:00
drh
96e285692a Fix the corruptJ.test case so that it works with and without 
SQLITE_SECURE_DELETE.

FossilOrigin-Name: 0c0ecfd68573957553b966229a67bfcd10ce4b99
 2015-03-31 14:31:41 +00:00
drh
8773b858e1 Additional logging information output by mptester. 
FossilOrigin-Name: 0cbbf6e4571ffef102c0e515f29166f2f2022126
 2015-03-31 14:18:29 +00:00
drh
fe0ba71112 Add the "mptest" target to Makefile.msc 
FossilOrigin-Name: 1e814e0bd116ad5a05ab9f0ebed7e21b23ed0681
 2015-03-31 13:46:13 +00:00
drh
bc8a6b31b6 Ensure that comparison operators do not mess up the MEM_Dyn flag on registers 
when reverting affinity changes.

FossilOrigin-Name: 02e3c88fbf6abdcf3975fb0fb71972b0ab30da30
 2015-03-31 11:42:23 +00:00
drh
116f0be024 Prevent a possible infinite loop when trying to DROP a table from 
a corrupt database.

FossilOrigin-Name: 395bb3e677a6551b06ba96fc58c393132b93d1e8
 2015-03-30 23:43:56 +00:00
mistachkin
30d1dcabf5 Merge updates from trunk. 
FossilOrigin-Name: 45acf6a85150839d591316418dad59ae20ce3aa4
 2015-03-27 18:22:01 +00:00
mistachkin
ad1e55e55a Enhancements to OSTRACE usage in the Win32 VFS. 
FossilOrigin-Name: ab5800291e1908b5b51d912feeacf748dc9be14b
 2015-03-27 18:20:25 +00:00
drh
6f5a37a464 Fix the ".testctrl imposter" command in the command-line shell to be 
consistent in error reporting and results with the other .testctrl
commands.

FossilOrigin-Name: 0ec08ba8a0fa188146b071a489908332693ba59a
 2015-03-27 02:27:20 +00:00
mistachkin
9871a933c1 Using MSVC, get the sqlite3IoTrace variable working with the USE_STDCALL and/or DYNAMIC_SHELL options. 
FossilOrigin-Name: fe976c9130f6eecfa0a10347ee3f800f32051b89
 2015-03-27 00:21:52 +00:00
mistachkin
34a8065f49 In the MSVC Makefile, make the DYNAMIC_SHELL option work without USE_STDCALL. 
FossilOrigin-Name: 25b46a9c7e03a84bee2ffddc6d7fd6ae280e9d7b
 2015-03-27 00:19:31 +00:00
mistachkin
ccb43714da When syncing a memory mapped file on Windows, flush the mapped view as well. 
FossilOrigin-Name: df204049b9ec8dd3e43ed7dc251eaecedc05af4b
 2015-03-26 23:36:35 +00:00
mistachkin
56d89cbee3 Revise Win32 locking test to account for recent log message changes. 
FossilOrigin-Name: 1bc76339e8542770bff7829a3dd346680950c0a5
 2015-03-26 18:24:26 +00:00
drh
592f0cb15e Avoid leaving the malloc subsystem in a partially initialized state if 
the low-level initialization callback fails.

FossilOrigin-Name: 3e872011ff5e27738c282f46d2b5803d94fe4b76
 2015-03-26 17:04:23 +00:00
drh
21aa6a1acb Provide source code line numbers for errors in the Windows VFS generated 
by the winLogIoerr() routine.

FossilOrigin-Name: b5da0d93cd1a3c0917399af3775a32327b883c8e
 2015-03-26 15:27:32 +00:00
drh
f3e8748683 Fix a harmless compiler warning in FTS3. 
FossilOrigin-Name: 1688f60c08cc9270948402d98a2333382aa32681
 2015-03-26 14:29:51 +00:00
drh
606a357288 Change an unreachable branch into an assert(). 
FossilOrigin-Name: fb076b28c36975ff2e41440f22fe5de115c195da
 2015-03-25 18:29:10 +00:00
drh
d2f83139f3 Fix the saveCursorPosition() routine in btree.c so that it works 
correctly for a eState=CURSOR_SKIPNEXT cursor.

FossilOrigin-Name: 37866b4d483296ab9b7fcb9f5486695d4c2b8ddd
 2015-03-25 17:35:01 +00:00