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
16,543 Commits 1,786 Branches 392 Tags
vector-compare
Commit Graph

11541 Commits

Author SHA1 Message Date
drh
0f825a7e26 Remove an unnecessary stack variable from sqlite3VdbeExec(). 
FossilOrigin-Name: c54bd9c82dd34951dc87848c0b19fcccaef928db
 2016-08-13 14:17:02 +00:00
drh
af69eda63e Improvements to commits. No code changes. 
FossilOrigin-Name: 18f5a3bee4f870be4644a6042a20081c46edb7d0
 2016-08-13 13:03:46 +00:00
drh
a2f629251f Fix to the vector less-than operator. All legacy tests passing now. 
FossilOrigin-Name: ec70a67ebc997f457be4d52d8affc37e142dc3ff
 2016-08-13 12:37:47 +00:00
drh
79752b6e63 Attempt to simplify the logic and generated code for vector comparisons. 
Basic comparison operators are working, but there are many indexing test
failures still to be worked through.

FossilOrigin-Name: dfc028cfbe7657d20727a2670ecadb1575eb8cbb
 2016-08-13 10:02:17 +00:00
drh
471b4b92bd Add VdbeCoverage() macros on newly added VDBE branch operations. 
FossilOrigin-Name: 381aa73141db8ec59adbcb09e71af660ee4ae5ce
 2016-08-12 11:25:49 +00:00
drh
a48d7e7749 Fix a post-OOM memory leak. 
FossilOrigin-Name: 14009b32b955b42cfd5f0c2ce7d4b3ce19ce201e
 2016-08-12 11:01:20 +00:00
drh
088645b090 Merge recent changes from trunk. 
FossilOrigin-Name: 959677b97ba15f786936c762e2e68df1151d7ed0
 2016-08-11 12:31:21 +00:00
dan
17994e3bca Fix some problems with handling "no such collation sequence" errors. 
FossilOrigin-Name: 8278be06fa69e3266866220bdaf5be45a5fcfa23
 2016-08-11 12:01:52 +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
drh
922802c44e Performance enhancement in the expression walker. 
FossilOrigin-Name: ebccbd96094ac64de39dbd0d220d3a7afd8cd40e
 2016-08-10 18:56:32 +00:00
drh
f5dbe7f8d8 Tweaks to pcache1TruncateUnsafe() to make it slightly smaller and faster and 
easier to test.

FossilOrigin-Name: 059f4e2efefb7b9deaf539110c19bceaeb10c6ce
 2016-08-10 15:02:49 +00:00
drh
167fbbe195 Rearrange the code inside sqlite3RunParser() routine so that sqlite3Parser() 
is only called from a single place.  This allows sqlite3Parser() to be
in-lined, which results in a 0.25% overall performance gain.

FossilOrigin-Name: 25d1d02b3ea126ade22b2a72649ae55509aa1777
 2016-08-10 14:40:00 +00:00
drh
d9fabbcc5b Fix pcache1TruncateUnsafe() run faster for the case where iLimit is 
very close to iMaxKey.

FossilOrigin-Name: b07a26df06a2ffb946ff8a1cc7f43eaf701a94b5
 2016-08-10 11:50:12 +00:00
dan
6256c1c242 Fix some cases involving row values and virtual tables. 
FossilOrigin-Name: 156a41f30a0afd9a70e6c26470dcc468a11bd402
 2016-08-08 20:15:41 +00:00
dan
1d9bc9b7a0 Fix the EXPLAIN QUERY PLAN output for row value range constaints that use an index. 
FossilOrigin-Name: bb60651163553c5e46bf7b2805490570cea647b8
 2016-08-08 18:42:08 +00:00
dan
adeb970da2 Merge trunk changes with this branch. 
FossilOrigin-Name: 0e927a7e0250a65fd8e97b322cd69e93fadd13f0
 2016-08-08 16:52:11 +00:00
drh
6da466e4f4 Fix documentation typos. No changes to code. 
FossilOrigin-Name: ebc396a19fa79bea208ecda277ffff5d02166d0b
 2016-08-07 18:52:11 +00:00
dan
43c1ce390f Undo commit [f250166bb]. It is required to handle IO and other errors that occur within a VACUUM of a Zipvfs database. 
FossilOrigin-Name: ae72513af37cd806a6d94aaa7c47a740e119d3b1
 2016-08-05 16:16:26 +00:00
drh
5360b55c6c Remove an incorrect ALWAYS() statement and add a test case to show when 
the condition is sometimes false.

FossilOrigin-Name: 0f57effa3642e66a863f32cc7fba86d167084af3
 2016-08-05 15:34:42 +00:00
drh
0aafa9c89c Fix a very obscure problem following OOM in sqlite3_declare_vtab(). 
FossilOrigin-Name: 68eac74874d0646369bef3650c6cb271cca62ab4
 2016-08-05 14:35:47 +00:00
drh
cc15313cc9 Add the experimental SQLITE_ENABLE_UNKNOWN_SQL_FUNCTION compile-time option. 
When enabled, the "unknown function" error is suppressed for EXPLAIN and
a no-op function named "unknown()" is substituted.  This facilitiates using
the command-line shell to analyze queries from applications that contain
many application-defined functions that are not normally available to the
shell.

FossilOrigin-Name: b7f30a9ff20d580fdaecdcf2b644d09ad6c2575e
 2016-08-04 12:35:17 +00:00
drh
dd545d3bf2 Make sure the ORDER BY LIMIT optimization is not applied if the inner-most 
loop can only have a single iteration and is hence not really a loop.

FossilOrigin-Name: 13e3bd3de6b434b6182ef36be108d7ee0be8ca53
 2016-08-04 09:09:44 +00:00
dan
3d1fb1dd75 Fix a problem with estimating the number of rows visited by a query that uses a multi-column IN(SELECT...) constraint. 
FossilOrigin-Name: 3c2f908f5b7312570cfa74afcf4252a857cb5237
 2016-08-03 18:00:49 +00:00
dan
2c628ea9d9 Fix another problem involving vector range constraints and mixed ASC/DESC indexes. 
FossilOrigin-Name: 1559f4c43473e107f7196eea3ee91c53ede22999
 2016-08-03 16:39:04 +00:00
dan
d66e5794d1 Fix stat4-based cost estimates for vector range constraints. 
FossilOrigin-Name: 18af74abc8ceae47ab9fbee3e3e5bb37db8fcba5
 2016-08-03 16:14:33 +00:00
drh
c0d269e96c Fix a typo in a comment in btree.c. No changes to code. 
FossilOrigin-Name: 722c12816347ee9fce7a090cfebef2c5841e7445
 2016-08-03 14:51:16 +00:00
drh
c330887291 Fix a unused variable that comes up with -DSQLITE_OMIT_DATETIME_FUNCS. 
FossilOrigin-Name: e2f9919e34c70761e4e275eeffca8ccf9159223c
 2016-08-02 20:42:24 +00:00
dan
51d82d1d24 Add tests and fixes for vector operations that use sub-queries with different combinations of LIMIT, OFFSET and ORDER BY clauses. 
FossilOrigin-Name: 092b1c5ff53c9f3cfed079c46e3353d93f99303e
 2016-08-02 18:50:15 +00:00
dan
f9b2e05c75 Fix SQLITE_OMIT_SUBQUERY builds. 
FossilOrigin-Name: 339f85f414a484e44d2502d1ff7281caf9b7c838
 2016-08-02 17:45:00 +00:00
dan
d05a7144cd Fix a problem with vector range constraints and mixed ASC/DESC indexes. 
FossilOrigin-Name: e2ad30c8b5366fd8e50f36c62345ed03ec613c47
 2016-08-02 17:07:51 +00:00
dan
080508a186 Merge latest trunk changes into this branch. 
FossilOrigin-Name: d468101b421e073e9debd7381bde1d36af31369e
 2016-08-02 16:24:10 +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
drh
b7203cde29 Updates to requirements marks. No changes to code. 
FossilOrigin-Name: b23c10ac8f65bc88a6c7d88e140217222eb4cbe5
 2016-08-02 13:26:34 +00:00
dan
914b7e4238 Fix a problem introduced by [77948b5eceab92a7] causing duplicate calls to be made to the xSavepoint() method of virtual tables under some circumstances. 
FossilOrigin-Name: e64a4173d2899acf13b73e6e28f2e164fd638a75
 2016-08-02 11:29:16 +00:00
drh
38b802dfd7 Fix harmless compiler warnings in sqlite3_status(). 
FossilOrigin-Name: 7c38a79cdd42aaa45715aea330d10ca859098837
 2016-08-02 08:45:26 +00:00
dan
553168c706 Fix a problem with vector range constraints involving the rowid column. And other issues. 
FossilOrigin-Name: 3ef75d45ebcd8ede91596d69e55fe7d685008a60
 2016-08-01 20:14:31 +00:00
drh
b0df540d7a Fix other harmless compiler warnings. 
FossilOrigin-Name: 90d2c490fc2ed4e073711b84f989ca4d496dcfb5
 2016-08-01 17:06:44 +00:00
dan
4df049faec Remove a duplicate typedef from loadext.c (remaining copy is in sqlite3ext.h). 
FossilOrigin-Name: fd184e5a8f4577aa9a817eb55e771d8d1021b946
 2016-08-01 16:57:30 +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
drh
32c83c8b9e Avoid making unnecessary changes to the signatures of the 
sqlite3_auto_extension() and sqlite3_cancel_auto_extension() interfaces.

FossilOrigin-Name: b6ea2f21f602031ef4dbd47462ac11b0bb0d5de6
 2016-08-01 14:35:48 +00:00
dan
5c288b929a Fix problems with vector == comparisons and NULL values. 
FossilOrigin-Name: 059d0d05354e6efab7892c97b339ffa0b5303587
 2016-07-30 21:02:33 +00:00
mistachkin
19e76b2a7c Fix harmless compiler warning seen with MSVC. 
FossilOrigin-Name: 390a38a142d36d2c57b3f21aab72edcde450125d
 2016-07-30 18:54:54 +00:00
dan
cb17ce9300 Merge latest trunk with this branch. 
FossilOrigin-Name: 63ae02d084a332250ff6fd8d8c80e53bf5422a68
 2016-07-30 17:59:39 +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
mistachkin
11f69b879c Using the header file 'intrin.h' requires MSVC 2005 or later. 
FossilOrigin-Name: 9fae75c08b7d3b3e13734193ad8398ef6971cbac
 2016-07-29 17:36:27 +00:00
drh
e363d50db8 Further refinement to the calling convention macros. 
FossilOrigin-Name: 45588de385d2a721b3e9f04beb6c7b789dd27d42
 2016-07-29 01:49:36 +00:00
drh
99bbcc8287 Undo some unhelpful changes to skip-scan scoring that were added 
by the check-in [9e2b2681] that improved scoring of index scan.

FossilOrigin-Name: c7d51934a4f30d096bb79fc509fc9dd0df5d89a4
 2016-07-29 01:32:36 +00:00