database/sqlite
1
0
Fork 0
mirror of https://github.com/sqlite/sqlite.git synced 2026-10-23 21:49:02 +03:00
Code Activity
10,307 Commits 1,782 Branches 392 Tags
winFileMapping
Commit Graph

7475 Commits

Author SHA1 Message Date
mistachkin
ba2bba3c32 Silence harmless compiler warning seen with SQLITE_OMIT_DEPRECATED. 
FossilOrigin-Name: c5cee969322d14114e4136510c3891a2e743520d
 2012-09-18 23:21:32 +00:00
drh
dbaee5e342 Enhance IN processing to allow efficient use of indices with numeric affinities. 
Add test cases for IN processing that would have spotted the error in the
[2be661a48023f4] check-in.

FossilOrigin-Name: 5ded9b68388f4024425c11f09b03529ac89454ce
 2012-09-18 19:29:06 +00:00
drh
d4305ca61c Enhancements to the comments on sqlite3FindInIndex(). No code changes. 
FossilOrigin-Name: b1a4c394995eb90b3fb43ab204704bda03799303
 2012-09-18 17:08:33 +00:00
drh
3a94987819 Update the vdbe-compress.tcl script so that it accepts variable declarations 
inside of #ifdef...#endif.
This enhancement is needed due to the change of check-in [39866c0ede5d6ef4].

FossilOrigin-Name: e7db056a0d76b2411cadbae077890df189e49414
 2012-09-18 13:20:13 +00:00
drh
d2e2bf9ff7 Make sure the WHERE_IDX_ONLY flag is not set on query plans that will not 
be using an index.

FossilOrigin-Name: 698b2a28004a9a2f0eabaadf36d833da4400b2bf
 2012-09-17 21:24:01 +00:00
drh
de9a7b8a94 Add the ability to disable the covering-index-scan optimization at compile-time, 
start-time, or at run-time.  Add test cases to check this configurability.

FossilOrigin-Name: ccb8ecc30c8e6c7760131250297c2e452bbac43b
 2012-09-17 20:44:46 +00:00
drh
ee4b21e9f3 Merge recent trunk changes into the fullscan-covering-index branch. 
FossilOrigin-Name: 1c0bf0305ce9528a0d07c86a390c5872e16bdb57
 2012-09-17 19:26:02 +00:00
drh
f4af1089ab Remove obsolete bits from the bitvector that defines disabled optimizations 
in the SQLITE_TESTCTRL_OPTIMIZATIONS verb of sqlite3_test_control().

FossilOrigin-Name: 4c21ee2d26466f83dec525153e2b1506bd956701
 2012-09-17 19:12:39 +00:00
drh
4261096124 Remove an unnecessary parameter from sqlite3Utf8Read() resulting in a slight 
performance increase.

FossilOrigin-Name: 8b962c94a2f829f71efdd0ca770469b02feea3e1
 2012-09-17 18:56:32 +00:00
drh
e1a022e48b Make sure the KeyInfo.aSortOrder array is always allocated so that we never 
have to test for KeyInfo.aSortOrder==0 in performance-critical loops.

FossilOrigin-Name: 45793f0b844fee7445bc9269b403f89a58f77150
 2012-09-17 17:16:53 +00:00
drh
56690b3d49 Performance enhancement in the sqlite3VdbeSerialType() routine. 
FossilOrigin-Name: ad298f52efd0ff123a1a4d6a0fa16fbd4c6b6dad
 2012-09-17 15:36:31 +00:00
drh
3f4d1d1b02 Attempt to use a covering index even on a full table scan, under the theory 
that the index will be smaller and require less disk I/O and thus be faster.

FossilOrigin-Name: cfaa7bc12847a7006ccc93815f2395ad5259744a
 2012-09-15 18:45:54 +00:00
drh
55b4c226d1 Make sure the name of rollback journal files are double-zero terminated 
when they are passed into the VFS.

FossilOrigin-Name: 8711a8447d28275602287faf533de3d6e50d535d
 2012-09-15 13:39:24 +00:00
drh
5f08526937 Factor out the code that generates a co-routine for evaluating the SELECT 
on the RHS of an INSERT statement so that the same code can potentially
be reused in other places.

FossilOrigin-Name: a93ee09cdc15987848bf9023e69892ce9a5f989e
 2012-09-15 13:29:23 +00:00
drh
6ec6549158 Improved alignment of fields in the Expr object gives an 8-byte size 
reduction on 64-bit machines.

FossilOrigin-Name: 6b252a0d1a78db7bf2d650bafc214ea4064eef9e
 2012-09-13 19:59:09 +00:00
mistachkin
59ee77c7d1 Fix an unused variable warning with SQLITE_OMIT_WAL. 
FossilOrigin-Name: 39866c0ede5d6ef4dd4fd57c797f0e86a2d0dc5d
 2012-09-13 15:26:44 +00:00
mistachkin
7ea11af2d6 Improved reporting of filename translation errors in the Windows VFS. 
FossilOrigin-Name: eb0f1c292e6fb00c4d9dbb2317fdc4717c5be96b
 2012-09-13 15:24:29 +00:00
drh
d815f17dab Reduce the size of the Table object by 16 bytes on 64-bit machines, mostly 
by avoiding intermixing pointer fields with integer fields.

FossilOrigin-Name: 1cb9aedfcf81f0086fa741cb29a062ee87724a5e
 2012-09-13 14:42:43 +00:00
drh
a371ace426 Change boolean fields in the Column object from unsigned characters into 
bits in a single bit mask variable.

FossilOrigin-Name: 4163f5f194741bc2bdf141973912661c6aac70f1
 2012-09-13 14:22:47 +00:00
drh
df32414d99 Add the RTREE_INT_ONLY configuration parameter to the compile-time options 
logic.

FossilOrigin-Name: 98b971fb24e0ee5f881b13401c7af51fc6effd0e
 2012-09-13 12:10:55 +00:00
mistachkin
c60941f814 Allow SQLite to work on Win32 with SQLITE_OS_WINNT=0 as long as WAL is disabled. 
FossilOrigin-Name: c1a8557008e56aa9bcb4565e4178fc57295c563d
 2012-09-13 01:51:02 +00:00
mistachkin
5dac843233 Added sqlite3_errstr API to translate a result code to the corresponding error message. 
FossilOrigin-Name: bf8a9ca5b58404112a8af666f5840b462b7bbfe1
 2012-09-11 02:00:25 +00:00
drh
0fdbdbea03 Remove the stale implementation of the ifnull and coalesce functions - code 
that has been commented out for ages.  No functional changes.

FossilOrigin-Name: c2ad691174b8af2e8b158d8840cfc93f75d7db71
 2012-09-10 15:02:32 +00:00
mistachkin
9dc2a73662 Avoid using the sqlite3ErrStr function in the Tcl package if USE_SYSTEM_SQLITE is defined. 
FossilOrigin-Name: a716b9a3091072774d067c0a1258b0f4c39a4180
 2012-09-10 09:33:09 +00:00
mistachkin
8765b4660e Make header comments for some Tcl test commands more consistent. No changes to code. 
FossilOrigin-Name: af870ca9827d2079a35dbb545660f670c7ca9512
 2012-09-10 08:48:05 +00:00
mistachkin
540ebf8271 Refine error messages in the sqlite3 Tcl command when a NULL database connection is returned from sqlite3_open_v2. 
FossilOrigin-Name: f260d7d567a1239c483c437d0b18a95bd0c96724
 2012-09-10 07:29:29 +00:00
mistachkin
60a7523bd3 Fix typo in documentation for sqlite3_open_v2. No changes to code. 
FossilOrigin-Name: b532120a4a567a3fa54b87dd8ab94cc2c0347c7c
 2012-09-10 06:02:57 +00:00
drh
c0c7b5ee74 Have PRAGMA busy_timeout return 0 if the busy handler has been changed 
or cancelled.

FossilOrigin-Name: 7be5bc36798d30f50658b70fc0bd31af897f3a87
 2012-09-07 18:49:57 +00:00
drh
f360396c47 Add an experimental busy_timeout pragma to facilitate access to the 
sqlite3_busy_timeout() interfaces for programmers that are working from
behind a language wrapper that does not expose that interface.

FossilOrigin-Name: 22ebc668516bc3dd5782d6d3d42dc7fd2eed7d79
 2012-09-07 16:46:59 +00:00
drh
37f58e9902 Avoid repeating calls to the sqlite3_trace() callback when the same statement 
is evaluted multiple times by sqlite3_step() due to an SQLITE_SCHEMA
reprepare.

FossilOrigin-Name: 39f763bfc04174ee0fe2cdf6a92b7c12f726bd1b
 2012-09-04 21:34:26 +00:00
drh
9265d0bdc2 Fix compiler warnings in test_spellfix1.c 
FossilOrigin-Name: ebb08d0b4d1ed674e4a23c3754206ca2df9063ff
 2012-09-03 12:40:32 +00:00
mistachkin
4d9d1f4722 Add Win32 version resources to the applicable binaries built by the MSVC makefile. 
FossilOrigin-Name: e2f27d28b590164bc6b0d856e79c9345e2188d03
 2012-09-03 10:32:32 +00:00
drh
e0d058c6d8 In the spellfix phonehash() function, add letter W into the same character 
class as V.

FossilOrigin-Name: 7536101317c00fbb5bf555120feb55b9bc40e8ba
 2012-08-31 14:55:05 +00:00
drh
19038f1b79 Changes for ERROR_PATH_NOT_FOUND in addition to ERROR_FILE_NOT_FOUND in 
winAccess().

FossilOrigin-Name: 527340abff18aedbcb0f82ac1296a9f548e24ac4
 2012-08-31 12:31:18 +00:00
dan
9454876ddc Fix an out-of-bounds read in the demonstration code in test_spellfix.c. 
FossilOrigin-Name: 59194311543b95c2aeebe2aba83da3c29b7c6460
 2012-08-30 11:22:16 +00:00
drh
b5b407e5ab Fix a typo in a comment in vdbe.c. No changes to code. 
FossilOrigin-Name: 9fbe858b625a346690d5cefca3a6fa2a557bea11
 2012-08-29 10:28:43 +00:00
dan
67c70142d9 Fix a case where SQLite was failing to detect a syntax error in queries like "SELECT ... FROM (<select-1> UNION ALL <select-2>)" when <select-1> and <select-2> return different numbers of result columns. 
FossilOrigin-Name: 200a81358c3117401d2258dd06bb8d2ea4f0ef51
 2012-08-28 14:45:50 +00:00
mistachkin
af52973724 Issue a log message if the temporary directory has not been set when running on WinRT. 
FossilOrigin-Name: 9ee39102942d4a4830417f61f0969f29ac0282a1
 2012-08-28 04:20:56 +00:00
drh
7a5d80e929 Formatting changes to the C code example in the documentation for 
sqlite3_temp_directory().  No changes to code.

FossilOrigin-Name: 5b4b39788ed9ac5962a17315d5549fc5e3f38c5e
 2012-08-28 00:17:56 +00:00
mistachkin
40e6319b61 Update API docs to include notes about the WinRT temporary directory. No changes to code. 
FossilOrigin-Name: eaeeb0699297dde824788e2907a0cfd2acd8f642
 2012-08-28 00:09:58 +00:00
drh
67ceaa6b9b Add to #undef statements to the command-line shell, go make sure that the 
macros definitions that follow do not collide with system definitions.

FossilOrigin-Name: 24420d6d2077d745cc26dd269e76b48c8a3eeb3c
 2012-08-27 21:19:03 +00:00
drh
04f2e3403f Fix an incorrect assert in the virtual table logic - it could fire following 
an I/O error after sqlite3_close_v2() was added.

FossilOrigin-Name: 4ccc18e999c51f7f6637ee48ccca35c7706bfe6d
 2012-08-27 14:39:47 +00:00
mistachkin
d5578433ff Fix all known instances of 'repeated the' style typos in comments. No changes to code. 
FossilOrigin-Name: 9b19b847533f944f289d93dcdba29c0d67bf251c
 2012-08-25 10:01:29 +00:00
drh
b0367fb8b0 Fix a harmless compiler warning. 
FossilOrigin-Name: 929b51840b83ee1ca5add8fe430913e7c4e2a3d6
 2012-08-25 02:11:13 +00:00
drh
d40e208726 Move field WhereLevel.pCovidx inside the union to WhereLevel.u.pCovidx. 
FossilOrigin-Name: b722143d075979ba3d92b7b29e576ce2307187d1
 2012-08-24 23:24:15 +00:00
drh
7b36ba3da3 Remove a NEVER() that is in fact reachable on an OOM. This probably 
has nothing to do with the multi-or-covering-index change but just happened
to be found while testing that change.

FossilOrigin-Name: 5499af53ebcdc21ae288aa2347aa21f6891d79ef
 2012-08-24 21:54:11 +00:00
dan
0efb72c969 Fix a problem to do with multi-or queries and automatic indexes. 
FossilOrigin-Name: a3e26038a1d9f3331239f777c67d1920d904aab0
 2012-08-24 18:44:56 +00:00
dan
bfca6a4066 Experimental change to support the covering index optimization for queries with OR terms in the WHERE clause that search a single index more than once. 
FossilOrigin-Name: 1dc8c7c741a82bb98a07f3fdb8142d8bc8d8a98b
 2012-08-24 10:52:35 +00:00
drh
fb0a60819b Merge the nested aggregate query enhancements into trunk. 
FossilOrigin-Name: d4cd6017c9875947a05b1dc36538d4272fb18739
 2012-08-24 01:07:52 +00:00
drh
ed551b95a4 Add test cases and fix bugs associated with the previous check-in 
enhancements to nested aggregate subquery processing.

FossilOrigin-Name: 00b1dc71be4c3420730b5f7840af824ea86165e7
 2012-08-23 19:46:11 +00:00