database/sqlite
1
0
Fork 0
mirror of https://github.com/sqlite/sqlite.git synced 2026-10-26 21:59:27 +03:00
Code Activity
19,152 Commits 1,786 Branches 392 Tags
cell-overwrite-prototype
Commit Graph

65 Commits

Author SHA1 Message Date
drh
cb23e5d5d1 All the OR optimization to proceed even if the OR is also converted into 
an IN operator.

FossilOrigin-Name: e252c6540db266b93beeb47a8f7dbf3b275f8c782cd2d36ba4c00648c382f63f
 2018-04-24 16:41:37 +00:00
drh
e28eb64d09 Fix a memory leak in the processing of nested row values. This problem has 
existed every since row values support was added (version 3.15.0, 2016-10-14)
but was only just now detected by OSSFuzz.

FossilOrigin-Name: 2df6bbf1b8ca881c8a465d6624de66fde4c5975ccae6b2f2dda392b137f577de
 2018-02-18 17:50:03 +00:00
drh
33f763d154 Fix the query planner so that it takes into account dependencies in the 
arguments to table-valued functions in subexpressions in the WHERE clause.
Fix for ticket [80177f0c226ff54f6dd].

FossilOrigin-Name: 7daa687340e475972d6849f84fe1419a1f5700934f53fd80656849adc73d6d04
 2018-01-26 22:41:59 +00:00
mistachkin
53be36b026 Fix harmless compiler warnings. 
FossilOrigin-Name: d088c5a3f1a803118cb67560fc35c11178e1b7e54c0e1511677559906b9da980
 2017-11-03 06:45:37 +00:00
drh
70efa84da7 Add new routines to simplify dealing with collating sequences in expressions: 
sqlite3ExprNNCollSeq() and sqlite3ExprCollSeqMatch().

FossilOrigin-Name: 490e488ea963fe725b16212822c8608f2b6abce688931b611446bc2cbfe6b87c
 2017-09-28 01:58:23 +00:00
drh
303a69b5ad Refactor names of constants and functions associated with the auxiliary 
operators for xBestIndex.

FossilOrigin-Name: 0fb992af669e765760a94d2b6e2330b21a98f39f18445a94b0a2290560368d58
 2017-09-11 19:47:37 +00:00
dan
d03024d814 Enhance the vtab interface to handle IS, !=, IS NOT, IS NULL and IS NOT NULL 
constraints.

FossilOrigin-Name: 34c8e952616013deb6fffec701ac5989afac9bef1bf92458a2e4ba92c7ee924f
 2017-09-09 19:41:12 +00:00
drh
f41a8d3d9a Simplification to the like optimization logic. Remove unnecessary branches. 
FossilOrigin-Name: 9466d952e169a6a60f6e575e679a61f05887b51c693505764edaf10f62cd829f
 2017-08-11 03:47:21 +00:00
drh
b8313cc998 Fix a faulty signed/unsigned character comparison in the LIKE optimization 
logic.

FossilOrigin-Name: f4a4b1497355c1b27d3d0770550fffcc3b2d2d51ab284101f19e8fc4264ee675
 2017-08-08 21:30:43 +00:00
drh
1d42ea71c2 Enhance the like optimization so that it works with an ESCAPE clause. 
FossilOrigin-Name: f5d330f495d07a704e115595bbdf5422ddb68fd8191114c5a12c9c873d983f7c
 2017-07-27 20:24:29 +00:00
drh
e24b92bce7 Small performance optimization in sqlite3WhereExprUsage(). 
FossilOrigin-Name: 38edc6770e54e456500e77389d42fdf39e9a7ed258a4e1fed3c6dd8fdf4dfcb7
 2017-07-10 15:26:09 +00:00
dan
d3930b1266 Fix another problem on this branch. 
FossilOrigin-Name: a4fc98113aeb10860834f68a2fdcef690ea15d8303d23b6dd416994a4b7edab6
 2017-07-10 15:17:30 +00:00
drh
37f906087b Merge the in the latest enhancements from trunk. 
FossilOrigin-Name: 8f63c5863231eba7f853f9587b58a81102c31708402fa9962a6e91aa622fad13
 2017-06-28 18:07:29 +00:00
drh
a5e906f307 Add SQLITE_DBCONFIG_ENABLE_QPSG that forces the query planner stability 
guarantee.  This is the fix for ticket [b9f010107724c]

FossilOrigin-Name: b82efd2a24914ace39acf99df75175042471fd73a8d31d66a40b15f63b342e10
 2017-06-27 23:36:44 +00:00
dan
210ec4c855 Fix a virtual table problem that can occur when the vtab is on the RHS of a 
LEFT JOIN and there is a MATCH constraint in the ON clause, or when the vtab
is in a sub-query that is the RHS of a LEFT JOIN and there is a MATCH
constraint in the WHERE clause of the sub-query.

FossilOrigin-Name: 87b381663398f029f52cb5598aadd069b03034b6f833ce80ba762b406075a44e
 2017-06-27 16:39:01 +00:00
drh
7df7475d0d Make sure sqlite3VdbeSetVarmask() is never invoked when QPSG is enabled. 
FossilOrigin-Name: ebcfa73e1c8ebb4fc371a6dcf77f97b6e06e405a299c66182aa4b20423d519ec
 2017-06-26 14:46:05 +00:00
dan
5aa550cf3b Consider the values bound to SQL variables when determining whether or not a 
partial index may be used.

FossilOrigin-Name: 7b59c353b805c64689b4ae9df347705acbb5f116346ad77af8ce087da7893747
 2017-06-24 18:10:29 +00:00
drh
f43ce0b445 The TK_IF_NULL_ROW expression node must be treated as a variable that 
references the table Expr.iTable.
Proposed fix for ticket [7fde638e94287d2c].

FossilOrigin-Name: 77fc23013cebc7797985864b91d78db5d0e2469511732044ebfaf02b891c979a
 2017-05-25 00:08:48 +00:00
drh
e97c9ff49a Smaller and faster implementation of exprMightBeIndexed(). 
FossilOrigin-Name: 76cd611d41465fcec61c21520d55172cb236530f38386b7d4a5544ba87de2353
 2017-04-11 18:06:48 +00:00
drh
f9463dfbcf Fix indexes on expressions so that they can be actually used with 
a COLLATE clause.

FossilOrigin-Name: e464b919f76520b45bb58983c6702db59d820ee4
 2017-02-11 14:59:58 +00:00
drh
1c84bd4787 Enhance the LIKE optimization so that it works for arbitrary expressions on 
the LHS as long as the pattern on the RHS does not begin with a digit or
a minus sign.

FossilOrigin-Name: 158290c0abafde67ee3f2363f0b6646887841df3
 2017-02-10 21:37:57 +00:00
drh
8e36ddd37e Throw an error if the ON clause of a LEFT JOIN references tables to the right 
of the ON clause.  Fix for ticket [25e335f802dd].

FossilOrigin-Name: c92ecff2ec5f178433d21f25c653d0fdd9128d7c
 2017-01-10 17:33:43 +00:00
drh
d9bcb32ebb Fix a potential assertion fault discovered by OSS-Fuzz. 
FossilOrigin-Name: 71c03b59b645884ebd6b9e18713cd2eb8c949870
 2017-01-10 15:08:06 +00:00
drh
abfd35ea03 Performance improvement and size reduction in the Expr node allocator 
function sqlite3PExpr().

FossilOrigin-Name: 2a81763e68cdf9b8c46389b1e1a87bc2084b53e7
 2016-12-06 22:47:23 +00:00
drh
0f85b2ff09 Prevent a possible use-after-free bug in the query optimizer. 
FossilOrigin-Name: 0a98c8d76ac86412d5eb68de994658c250989349
 2016-11-20 12:00:27 +00:00
drh
c52496f57f Make sure left-join markings are transferred to the virtual scalar 
subexpressions when decomposing a vector comparison in the ON clause of
a LEFT JOIN.
Fix for ticket [fef4bb4bd9185ec8f].

FossilOrigin-Name: 619f5cc71774a37648e185c8502d7af14eb09b7f
 2016-10-27 01:02:20 +00:00
drh
87c05f0c58 Avoid unnecessary memset() calls in the query optimizer. 
FossilOrigin-Name: 5bb7cde0731d23411e9df02a957010f94203397b
 2016-10-03 14:44:47 +00:00
drh
e1c03b6233 Use sqlite3ExprAlloc() instead of sqlite3PExpr() for leaf nodes in the 
expression tree, where appropriate.  This is both smaller and faster.

FossilOrigin-Name: afac0709cec577a7851e3711730712cf12eeb6af
 2016-09-23 20:59:31 +00:00
drh
1431807a0b Fix corer cases of vector IN operators where the RHS is a compound SELECT 
that includes an ORDER BY clause.

FossilOrigin-Name: 8329ac6f8d1edcc19c3e0559abe9a8011dbe1497
 2016-09-06 18:51:25 +00:00
drh
b29e60c448 Catch vector size mismatch problems during name resolution to avoid later 
problems.

FossilOrigin-Name: 56562a0346170cf7b72445976864b058437a8ac3
 2016-09-05 12:02:34 +00:00
drh
64bcb8cfbb Comment improvements. Put ALWAYS and NEVER macros on three unreachable 
branches.

FossilOrigin-Name: 397617009e07004596476d6f5644fdf84c376f54
 2016-08-26 03:42:57 +00:00
drh
9e730f0bb8 Improvements to the vector comparison splitter in exprAnalyze(). 
FossilOrigin-Name: a3ffd283bc931b04170ef737e56bced33d27f06d
 2016-08-20 12:00:05 +00:00
drh
a1251bc40d Add support for vector assignments in the SET clause of an UPDATE statement. 
FossilOrigin-Name: f320d47d6b7b08d9552c8444004bc256348bda90
 2016-08-20 00:51:37 +00:00
drh
fc7f27b9d2 Change the way TK_SELECT_COLUMN is handled so that the subquery is only 
generated once even if part of the vector comparison is used for indexing
and the other part is now.  This change also is a pathway to vector assignment
in UPDATE statements.

FossilOrigin-Name: d8feea7dcde83179bff303072426561cfe825e58
 2016-08-20 00:07:01 +00:00
drh
8d25cb90cd Replace the magic number (-2) with its symbol XN_EXPR in the 
exprMightBeIndexed() routine.  No logic changes.

FossilOrigin-Name: d4a5af69cc3bde6f8c02075c07b4d47a0252392d
 2016-08-19 19:58:06 +00:00
drh
088645b090 Merge recent changes from trunk. 
FossilOrigin-Name: 959677b97ba15f786936c762e2e68df1151d7ed0
 2016-08-11 12:31:21 +00:00
drh
93ca3933d1 Optimization to sqlite3WhereExprUsage(). 
FossilOrigin-Name: 95493058fcf40306727a281f21c5a2a0011b7d02
 2016-08-10 20:02:21 +00:00
drh
e104dd3cc3 List of MATCH operator names in isMatchOfColumn() should be constant. 
FossilOrigin-Name: 7319d676aaf95ba7391379f4cdf193b6aa898893
 2016-08-10 19:43:29 +00:00
dan
95a08c065a Add missing comments and make some code on this branch clearer. 
FossilOrigin-Name: 6937677cc2c2db6b21f997559f88a339466cd15b
 2016-08-02 16:18:35 +00:00
dan
870a0705fe Fix a problem with IN(...) constraints where the LHS is a sub-select that is an aggregate query. 
FossilOrigin-Name: 1f4dba87da4a44ad26223ad965731164c0d9bad9
 2016-08-01 16:37:43 +00:00
dan
625015e0c9 Remove the EP_Vector expression flag. 
FossilOrigin-Name: e9d9c6d46b46160fad6aa6e3441a65a09157515f
 2016-07-30 16:39:28 +00:00
dan
19ff12dd76 Fix some issues with vector range constraints and the column cache. Also vector range constraints and rowid columns. 
FossilOrigin-Name: 42607366bfc2dceb1013797a973b3b8df75dcb4d
 2016-07-29 20:58:19 +00:00
dan
145b4ea519 Change the way "(a, b) = (SELECT *)" expressions are handled in where.c if there is an index on one of the columns only. 
FossilOrigin-Name: 4dfebff2924f46284d5b9cda69175f79b29d6028
 2016-07-29 18:12:12 +00:00
dan
7b35a77b1a Fix further issues with multi-column IN(...) operators. Also some error handling cases surrounding row values. 
FossilOrigin-Name: cc3f6542bec99b00d2698889bcea2aa0b587efa0
 2016-07-28 19:47:15 +00:00
dan
8da209b169 Fix where.c handling of "IN (SELECT ...)" expressions when the SELECT returns more than one result column. Also error handling for other row value constructor cases. 
FossilOrigin-Name: 061b8006034f06a0311b4304c8b14d2c8b0153df
 2016-07-26 18:06:08 +00:00
dan
71c57db099 Add some support for using row value constructors in certain parts of SQL expressions. There are many bugs on this branch. 
FossilOrigin-Name: b2204215b231202aef7a218411cc2ddaecf28f35
 2016-07-09 20:23:55 +00:00
drh
a2fbe3bec6 Proposed fix for a problem in the query planner. 
FossilOrigin-Name: a33d23560959a127e37d8213dc00210cd4b05352
 2016-06-28 22:27:56 +00:00
dan
dbd2dcbd5e Experimental change to allow virtual tables to take advantage of LIKE, REGEXP and GLOB terms that are part of OR expressions within WHERE clauses. 
FossilOrigin-Name: 242507b4ff96bc4c7c7844dbe1c2b8508dbf1d01
 2016-05-28 18:53:55 +00:00
drh
926957f0a6 Performance improvements in sqlite3WhereExprUsage(). 
FossilOrigin-Name: fdf752394b48fb7b9afe7b8a7d83f859985cc2d2
 2016-04-12 00:00:33 +00:00
drh
81fd3497f4 Make sure WhereClause objects are fully initialized before use when 
planning OR queries.

FossilOrigin-Name: 162053021795ff40c447498a76de4d31d58aa808
 2016-02-19 14:10:44 +00:00