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
13,505 Commits 1,786 Branches 392 Tags
expShell
Commit Graph

9855 Commits

Author SHA1 Message Date
dan
39129ce8d9 Fix where.c so that the primary key values appended to every index entry on a WITHOUT ROWID table may be used when useful. 
FossilOrigin-Name: 6624a61d16e47ad691c4195ca8a1d68b7348118d
 2014-06-30 15:23:57 +00:00
drh
971fd07135 Omit non-primary-key columns from the STAT4 samples for WITHOUT ROWID tables. 
Indexes, both rowid and without-rowid, still hold an exact copy
of the index entry.

FossilOrigin-Name: de826c31589258f0906f87d65796944103e36d5b
 2014-06-30 13:56:34 +00:00
drh
48be0c51d4 Generate complete samples for sqlite_stat4 on WITHOUT ROWID tables. 
Ticket [b2fa5424e6fcb15b5]

FossilOrigin-Name: 8cb43eddab83c68b2163441df70e0e9496d5fa33
 2014-06-30 13:32:39 +00:00
dan
6696ba3eab Add an OOM fault injection test for the new code on this branch. 
FossilOrigin-Name: c96de490ac77dd23c108004b95152cce4922fe27
 2014-06-28 19:06:49 +00:00
drh
0288b21e54 Add header comments on new routines. Rework the sqlite3Stat4Column() routine 
so that is (in theory) able to deal with corrupt samples.

FossilOrigin-Name: ef5cdf949bb53a2958fa34e176b4b9eeda269de5
 2014-06-28 16:06:44 +00:00
dan
fa8874542c Fix a problem with using stat4 samples of type text when estimating the rows visited by a range-query/skip-scan loop. 
FossilOrigin-Name: dfb09db6d412f3bc2a71bda393813783580dbad1
 2014-06-28 15:26:10 +00:00
drh
3eddb23e31 Change the VDBE to export the sqlite3MemCompare() routine and thus free 
where.c from the dependency on vdbeInt.h.

FossilOrigin-Name: d186d1ac3c47f0d814636c4b8386a6065a294750
 2014-06-28 14:28:06 +00:00
dan
4364dc5ea6 Merge fixes from trunk with this branch. 
FossilOrigin-Name: 6af219d1b83ec54b3fb4ad4e6216d9ad9ea0fc70
 2014-06-28 14:25:32 +00:00
dan
4e42ba4a35 Fix a couple of problems in estimating the number of rows visited by a range query that uses a skip-scan. 
FossilOrigin-Name: 219736f54dcd1448af3400e699f1c20755ac6876
 2014-06-27 20:14:25 +00:00
mistachkin
2d84ac480b Fix compilation issue when STAT4 is not enabled. 
FossilOrigin-Name: 74a5454a710e1b7d8575cec2f872e6110aefce17
 2014-06-26 21:32:09 +00:00
mistachkin
9bec6fb3ef Revise the affinity returned for expressions flagged as 'generic'. Fix for [9a8b09f8e6]. 
FossilOrigin-Name: 92f7ad43dbfe4e02490df2f932c3c74fb89064d6
 2014-06-26 21:28:21 +00:00
dan
b0b8290ecb Attempt to use sqlite_stat4 data to estimate the number of rows visited by a range query that uses a skip-scan. This code is largely untested. 
FossilOrigin-Name: 01dc8102592427b71a18c2cb82301d2266dd59c2
 2014-06-26 20:21:46 +00:00
drh
c1971541e4 Add the .fullschema command to the sqlite3.exe utility. This command shows 
the schema and the content of the sqlite_stat tables, all in one go.  Useful
when reporting problems with the query planner.

FossilOrigin-Name: ebec48921c092e20c9d7608242b63db40b40be5e
 2014-06-23 23:28:13 +00:00
dan
685ffb134a Fix a problem with SQLITE_OMIT_WSD builds. 
FossilOrigin-Name: 07dda49c1bf8997a18c3368acb81b6d863ea38d6
 2014-06-23 10:18:50 +00:00
dan
702eec1cea Fix a problem with SQLITE_OMIT_WAL builds. 
FossilOrigin-Name: 612b6d1b1f74eaf618520b90811eca10f978fc71
 2014-06-23 10:04:58 +00:00
drh
6c34e58e8f Fix a comment on the sqlite3Utf8Read() routine. No changes to code. 
FossilOrigin-Name: 5e514f6acebcfad4f18300d1a34f4917f1a746d9
 2014-06-18 15:24:40 +00:00
drh
5dfcfe7dc0 Merge in all recent changes from trunk, and especially the automatic index 
enhancements.

FossilOrigin-Name: 0e1b73496f861bd497f92f1ead936b2d94aa52d5
 2014-06-18 15:18:12 +00:00
drh
f9944b5053 Prevent an automatic index from taking the place of a declared index. 
FossilOrigin-Name: 0a52bddd9db49b2b79fc24888b50023d0fe74f7b
 2014-06-18 15:11:54 +00:00
drh
dabe36d9dd Prevent an automatic index from taking the place of a declared index. 
FossilOrigin-Name: 4ece839d445ff578a449a339ab579a32e64c9d28
 2014-06-17 20:16:43 +00:00
drh
ef3ad02d90 Fix a missing space in a "wheretrace" comment. No changes to production code. 
FossilOrigin-Name: b500f2a09721b49c95a69c47a0205bc2375af2cd
 2014-06-17 17:00:42 +00:00
drh
03202a97f8 Add the likely() function for symmetry with unlikely(). The likely(X) 
function means the same thing as likelihood(X,0.9375).

FossilOrigin-Name: 38965484199153e3e5b999f5196c1d66e5296f60
 2014-06-17 16:11:28 +00:00
drh
9740726121 A different approach to the autoindex problem that deletes query-planner code 
rather than adding it.

FossilOrigin-Name: f270fb6e9e0b5e77f918081962008c6195ab1e36
 2014-06-17 12:33:55 +00:00
drh
9f808299ff Simplification to the logic that prevents automatic indexes from being formed 
on constant expressions.

FossilOrigin-Name: 36d67e1dd2b4f4c22d02f3c3b8d372074de5523a
 2014-06-17 09:52:26 +00:00
drh
6b7ff748a1 Allow an automatic index on a WHERE constraint where the RHS is does not 
reference another table as long as the RHS is not a constant.

FossilOrigin-Name: 58acc2a8b38c5f13175c191697b4d2b663db1872
 2014-06-17 09:00:54 +00:00
drh
9978e6a680 Do not attempt to create an automatic index on a constant constraint, as 
doing so is pointless.

FossilOrigin-Name: d6883e960f61365729f279a3c1f2c050beb49a55
 2014-06-17 02:46:55 +00:00
mistachkin
6fe0338ca9 Fix CSV import issue, reported via the mailing list, in the shell when the file to be imported ends with an empty line. 
FossilOrigin-Name: fc918f7d332b8f7cabc79a0f1586bd6760d14d40
 2014-06-16 22:45:28 +00:00
drh
0ace74a19c In the "wheretrace" logic (disabled for normal builds) expand the print width 
of the flags field to be wide enough for all 17 bits.

FossilOrigin-Name: 3181d2069a788adc719decf65dc1bd2e16650c87
 2014-06-16 21:30:29 +00:00
drh
0bdbc90db8 Add the SQLITE_UNLINK_AFTER_CLOSE compile-time option. If enabled, the 
unlink of temporary files on unix is deferred until after the file is closed.

FossilOrigin-Name: e43a2f92b616ec885a1ee62911fa8f6991d277f7
 2014-06-16 18:35:06 +00:00
drh
3044b51d2f Back out the unix VFS changes that seeks to avoid fstat() calls after an 
unlink().  That change did not clear the problem on FuseFS.

FossilOrigin-Name: 0617e20a33e08754aea14e60db44e557c13978e3
 2014-06-16 16:41:52 +00:00
drh
6d36ffe8f3 Add the ".eqp" dot-command to the ".help" output in the command-line shell. 
This was accidently omitted when the ".eqp" command was originally implemented
for SQLite 3.8.4 (check-in [e6ecf7337658624]).

FossilOrigin-Name: b0b4c776c321ca4a792ef67efbc62351eeac247d
 2014-06-16 15:01:37 +00:00
drh
51ed298364 Add test cases for the fileio extension. 
FossilOrigin-Name: 8634333127c4d868d3ec27e88b5818f6479774f3
 2014-06-16 12:44:32 +00:00
drh
5b6e3b9781 Increase the WAL-mode SQLITE_PROTOCOL timeout to 10 seconds. 
FossilOrigin-Name: 2aeacf81df92b4fe5d1825c1dc1cd176b8af8bd9
 2014-06-12 17:10:18 +00:00
drh
696964d0e5 Simplify the estLog() routine. 
FossilOrigin-Name: 6c68d758bce3752f044752404a76bf3ba3eec48f
 2014-06-12 15:46:46 +00:00
drh
77ae7ca643 Avoid an unnecessary initialization of the szFile field of unixFile in 
the unix VFS.

FossilOrigin-Name: 6484fb5a25c2a0e5d26694285a4908a22c67ba17
 2014-06-09 20:39:03 +00:00
drh
f5154c6a1c Enhance the unix VFS so that it keeps track of the size of unlinked files 
internally and thus avoids the need to call fstat() on those files, since
fstat() does not work reliably on unlinked files on some implementations of
FuseFS.

FossilOrigin-Name: c41df393c6afbfbfdc4d1b885024e083c6f6de1f
 2014-06-09 20:06:01 +00:00
drh
c94b2f7d6b Make sure the estLog() routine in the query planner handles negative 
values correctly (always returning 1).  Prior to this change, estLog(-1)
would return a large number which could throw off the cost computations
in the query planner in obscure circumstances.

FossilOrigin-Name: 75437bee4905949c66dc7694ea234d4d5aefd981
 2014-06-06 20:20:09 +00:00
drh
94aa7e091b Fix an obsolete comment on the whereRangeScanEst() routine. No 
changes to code.

FossilOrigin-Name: b16bf8518b7c50f6a939aa54900fea91b1098470
 2014-06-06 17:09:52 +00:00
drh
33ca481923 Bring the threads branch up-to-date with the 3.8.5 release. 
FossilOrigin-Name: e4b01676d7e7ac14f5120ca3a618cc34dbf5dab2
 2014-06-05 13:22:52 +00:00
drh
d0dc5d4984 Avoid closing a pseudo-table associated with sorting in a co-routine since 
that pseudo-table might be used again in an outer loop.

FossilOrigin-Name: 6d81805298ea882f5fee99504d5a95f1a762a90b
 2014-06-03 14:42:34 +00:00
drh
7f80c7146f Remove the WHERE_LIKELIHOOD bit, as it does not seem to effect any result. 
FossilOrigin-Name: 1cbe7a0883e081611a50524517d70e0b6c5199d2
 2014-06-02 21:00:34 +00:00
drh
2504c6c632 Fix the query planner so that it once again knows that queries without a 
FROM clause will never return more than one row and hence do not require
sorting.

FossilOrigin-Name: 9f18b303cd1bc5779d82669884f802c7889b4947
 2014-06-02 11:26:33 +00:00
drh
01f3754dcd Fix a harmless "scan-build" compiler warning in the command-line shell. 
FossilOrigin-Name: 39fafe0a19ff346a2354f00b03f8e8e4b8b0524c
 2014-05-31 15:43:33 +00:00
drh
7ef4d1c403 Fix a compile of harmless static analyzer warnings. 
FossilOrigin-Name: 7e287f2055dcd82c92d1711aec97cb6552a354bb
 2014-05-31 15:39:53 +00:00
mistachkin
110e0ebe6d Revise locking retry semantics in Win32 VFS to abort early if the file handle is reported as invalid. 
FossilOrigin-Name: a4df4a5b34111f755ffd9ee6f089ff05d03ebc7a
 2014-05-30 21:01:41 +00:00
mistachkin
6b98d67b2b Add tests for the invalid file handle detection logic in the winLock() function. 
FossilOrigin-Name: ed5a9eb4f30a395bc641e79254217c7d7cf0aa5d
 2014-05-30 16:42:35 +00:00
drh
3c4461f47a Fix a harmless compiler warning in the command-line shell code. 
FossilOrigin-Name: a80527f60b4856e869f25e7b13afde351bc26a25
 2014-05-29 20:39:59 +00:00
drh
ff14013496 Merge changes from the trunk into the threads branch. 
FossilOrigin-Name: 416cb091267de91b9cadee9f7453b8627570b7d3
 2014-05-29 20:24:20 +00:00
drh
b463fef3fd Fix to the EXPLAIN indentation logic in the command-line shell. 
FossilOrigin-Name: 8f916ed1e185ac728e00624d90e1d7bd2dda4469
 2014-05-29 20:17:57 +00:00
drh
c2ce0bea88 Improvements to error messages for errors in the dot-commands of the 
command-line shell.  Add the ".once" command.  The output of ".help"
now goes to the designated output channel.

FossilOrigin-Name: 48dce821a07ac29da6ce05e92cf3f6e52b6eb388
 2014-05-29 12:36:14 +00:00
drh
dcb3e3d62c Only quote the arguments to the ".shell" and ".system" commands if they 
contain spaces.

FossilOrigin-Name: e58f4bd39d51c4c1a28684dab6427de81173d564
 2014-05-29 03:17:29 +00:00