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
16,515 Commits 1,785 Branches 392 Tags
vacuum-attached-db
Commit Graph

11510 Commits

Author SHA1 Message Date
drh
6a754dc767 Disable row counting on queries run while doing a VACUUM. 
FossilOrigin-Name: ad35ef116296e5d6aaeb9ef260bf35bee3bd6d20
 2016-08-19 15:12:38 +00:00
drh
9ef5e7708a Add the capability to VACUUM an attached database by specifying the schema 
name as an argument to the VACUUM command.  Since version 2.0, VACUUM has
accepted an argument which was silently ignored.  Now it has meaning.

FossilOrigin-Name: 29d63059b4d2bb612523ac55ebfef040d054a64f
 2016-08-19 14:20:56 +00:00
drh
e59be01072 Fix a zName to zDbSName conversion missed in the previous check-in. 
FossilOrigin-Name: d7cf423cdccada2b0a4b7cc79ccf5f35d6f43212
 2016-08-18 20:56:39 +00:00
drh
69c338263a Rename the Db.zName field to Db.zDbSName to make it more descriptive and to 
distinguish it from all of the other "zName" variables scattered throughout
the code.

FossilOrigin-Name: 92a22f01343a898455fd61c3b8e7d7c954f5b569
 2016-08-18 14:33:11 +00:00
dan
1bf4ca7c42 Add the "modeof=<filename>" URI parameter to os_unix.c - used to specify a file to copy permissions from when a new database is created. Also allow passing NULL as the second parameter to sqlite3rbu_vacuum(). 
FossilOrigin-Name: ed406d31ff54ee3de8db91690a966e5c561f8f94
 2016-08-11 18:05:47 +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
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
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
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
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
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
mistachkin
19e76b2a7c Fix harmless compiler warning seen with MSVC. 
FossilOrigin-Name: 390a38a142d36d2c57b3f21aab72edcde450125d
 2016-07-30 18:54:54 +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
mistachkin
85bd982ba0 More compiler warning fixes for GCC related to the auto-extension mechanism. 
FossilOrigin-Name: b8218129bc848c61fa6910feae4141dac6ad86fc
 2016-07-28 22:53:10 +00:00
mistachkin
78d5e02f99 The return type used by the auto-extension entry points is 'int', not 'void'. 
FossilOrigin-Name: bf9c86c74f30136a106f37603a6c7dcc76caf41d
 2016-07-28 22:46:53 +00:00
mistachkin
177d0f0b47 Make sure all the auto-extension mechanism function signatures match up precisely. 
FossilOrigin-Name: 87ba69b5ca4a8e4ef2bbaaf07a0ff13fc5cd4721
 2016-07-28 22:38:31 +00:00
mistachkin
44e95d4f02 Make the extension auto-loading mechanism work with the __stdcall calling convention. Also, fix a couple Tcl command calling conventions missed in the previous check-in. 
FossilOrigin-Name: 3ea567c4b07b2a7a027b9b5cb8250ab687803698
 2016-07-28 22:23:26 +00:00
drh
3a22fdab9a Decorate all interfaces with calling convention macros. 
FossilOrigin-Name: fd784887e125bf95f4799ad09cbcba6795173487
 2016-07-28 18:55:57 +00:00
drh
a8914faaaa Disable the authorizer callback when reparsing the schema. This avoids 
undesirable authorization failures following an ALTER TABLE.

FossilOrigin-Name: 805d01cdabb48a69eb986a7f084e53eb25d76b7f
 2016-07-28 18:38:13 +00:00
mistachkin
a121cc7c60 Adjustments to get 'testfixture.exe' compiling with Tcl 8.6 when __stdcall is enabled. 
FossilOrigin-Name: 90e89ec9c8efff057a9e43c612427fc5c97ab52d
 2016-07-28 18:06:52 +00:00
drh
aa0325872f Improvements to the way the COMPILER compile-time option is set when compiling 
with Clang.

FossilOrigin-Name: 81f9cf86c48f3cd43755ded4dc97388ec650f8af
 2016-07-28 17:24:16 +00:00
mistachkin
7617e4a8a4 Make sure the SQLITE_TCLAPI macro is always defined. 
FossilOrigin-Name: f2f1323cc4d2ad2d6794dbfae8d50b747213e85d
 2016-07-28 17:11:20 +00:00
drh
4194ff6598 Change mksqlite3h.tcl to automatically insert the SQLITE_CALLBACK calling 
convention macros.

FossilOrigin-Name: 11ab9c9ab562df98c20abf126a8bac178aef77a8
 2016-07-28 15:09:02 +00:00
mistachkin
52b1dbb5fc Allow the 'testfixture.exe' target to be compiled with the __stdcall calling convention. 
FossilOrigin-Name: e8be3dfeabaa31b3490793cf8230faae1204be15
 2016-07-28 14:37:04 +00:00
mistachkin
69def7ff2f Work in progress on setting a calling convention for all callback functions. 
FossilOrigin-Name: 02b8040e1add02734d2dbc6c59737ab74ff8fb18
 2016-07-28 04:14:37 +00:00
drh
5f26e00761 Enhance the query planner cost estimation for index scans to take into account 
WHERE clause terms that can be computed using only the index and that do not
require looking up rows in the original table.  This fixes an obscure
performance regression that arose when the ORDER BY LIMIT optimization was
added by check-in [bf46179d44843].

FossilOrigin-Name: 9e2b26811452a5011d0a97a689636fa4409da856
 2016-07-27 19:30:53 +00:00
drh
e604ec0be0 Add test cases and fix a comment. 
FossilOrigin-Name: 50f8ea37fb9647c4a9da2c269a4d6f54b10ce96b
 2016-07-27 19:20:58 +00:00
drh
2409f8a112 When estimating the cost of an index scan, factor in the cost savings of 
being able to use the index to evaluate some WHERE clause terms without
having to do a table lookup.

FossilOrigin-Name: a59b5622f7cc6e502d71aabc12c053582cd03609
 2016-07-27 18:27:02 +00:00
dan
d93ba6271b Initialize a variable in where.c to avoid a valgrind warning. 
FossilOrigin-Name: 4d59df02d3713b3e3804e1a88e676749b2794286
 2016-07-27 16:03:54 +00:00
drh
9d60875901 Copy the cache_spill setting from the main database over to the 
vacuum_db transient database when running a VACUUM.

FossilOrigin-Name: c0e7d98ef2a13ede5ae865083ede1aaffdf43310
 2016-07-26 04:49:43 +00:00
drh
426f4ab009 Make sure affinity is applied correctly on lower-bound range constraints 
in the min() optimization.  Fix for ticket [a0bac8b3c3d1bb].

FossilOrigin-Name: b819bace9c2a0b0159122b26db96a8f50a6f0eac
 2016-07-26 04:31:14 +00:00
drh
2b62b5def8 In the VACUUM command, set the cache_size of the transient vacuum_db database 
to be the same as the database being vacuumed.

FossilOrigin-Name: b78d99548ac53ac10dcc38368cc4b29c8cbcb09b
 2016-07-25 22:40:12 +00:00
drh
a522473c65 Add a new %ifdef to parse.y so that the build works with SQLITE_OMIT_SUBQUERY. 
FossilOrigin-Name: 38a48cfb9a8212970c4a4f8458643c22ed067e8b
 2016-07-25 14:40:43 +00:00
drh
5d513ba08c If both MEMSYS3 and MEMSYS5 are enabled, than automatically disable MEMSYS3. 
FossilOrigin-Name: ccc22e14dc5d910d632807f49484be54dc2fde83
 2016-07-25 11:57:21 +00:00