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
9,441 Commits 1,785 Branches 392 Tags
or-opt
Commit Graph

6856 Commits

Author SHA1 Message Date
drh
0a61df670e Add testcase() macros to ensure good test coverage. 
FossilOrigin-Name: 5c132592820e9dc2355e26ea14e155c797c335b3
 2011-10-07 17:45:58 +00:00
drh
9ef61f4f4e Prevent infinite recursion of in the query planner for some pathological 
test cases by disabling OR-clause processing upon first recursion.

FossilOrigin-Name: 9fca05eac503d712886a05d03794f76c61fb39ed
 2011-10-07 14:40:59 +00:00
drh
8871ef5afd Begin an effort to enhance the query planner to do a better job with OR terms 
in the WHERE clause.  This change allows ANDs outside of the OR to be factored
into the OR terms if that is helpful in finding better indices.

FossilOrigin-Name: 876bd21aaac444c7e056730e35696a74e9a1af0a
 2011-10-07 13:33:10 +00:00
drh
f3259997c0 Enhance the sqlite3_data_count() routine so that it can be used to determine 
if SQLITE_DONE has been seen on the prepared statement.

FossilOrigin-Name: 9913996e7b0f94ba1c51200b61433193002f3638
 2011-10-07 12:59:23 +00:00
dan
2cf7e0a712 Fix test code related to reporting the size of overflow pages in zipvfs databases. 
FossilOrigin-Name: ad7c9eed8bbd607babce4f5965f587c873e7bc02
 2011-10-05 17:36:27 +00:00
drh
c47167a6a8 When finding the appropriate file permissions for journal files with 
SQLITE_ENABLE_8_3_NAMES, ignore "-" characters in the name of the
containing directory.

FossilOrigin-Name: 328cc1867ffbbf1c953dfd843649f5f209c8e6ec
 2011-10-05 15:26:13 +00:00
drh
d4b0ff9926 Merge the STAT3 changes into trunk. 
FossilOrigin-Name: 774d0842bcce8862f2aac371f1689536ed234a0a
 2011-10-03 15:30:33 +00:00
dan
1696124db7 Disable the xfer optimization if "PRAGMA count_changes=1" is configured. Ticket [c48d99d690]. 
FossilOrigin-Name: 9ddfe1e41300413bc9af7e5ce0ec9d1daf9136b1
 2011-09-30 12:01:01 +00:00
drh
7b075e3a1c In the shell, allow arbitrary table names on the ".import" command. 
Ticket [d1d84037b90a449].

FossilOrigin-Name: f4dd32d30ed54f847319664cf749fd0b92b4af3f
 2011-09-28 01:10:00 +00:00
drh
4c9f129d60 Enhance the stat VFS to report out the total size of all pages used by 
a table, even if the ZIPVFS compression backend is in play.  Update
the sqlite3_analyzer logic to use these new outputs.

FossilOrigin-Name: 19b8eaaf70db82d401d33beb7fd36045d5e8326f
 2011-09-28 00:50:14 +00:00
drh
3051dc1c7f If an open as read/write fails, do not try to reopen as read-only if in 
exclusive access mode.

FossilOrigin-Name: 263c5fb2802f8c84835e42fc66acb1065b7e42b9
 2011-09-25 17:49:26 +00:00
drh
497ffc4c5d If an open as read/write fails, do not try to reopen as read-only if in 
exclusive access mode.

FossilOrigin-Name: 4a153f010037db83107314269b240c0ece8430f8
 2011-09-25 17:47:58 +00:00
drh
c78e6e4c4b Add SQLITE_DBSTATUS_CACHE_HIT and _MISS to the ".stat" command in the shell. 
FossilOrigin-Name: d279e1a309909a0897b6082753a0fadb5066c31a
 2011-09-23 18:58:23 +00:00
drh
790a55171e Merge the latest trunk changes into the stat3-trunk branch. 
FossilOrigin-Name: 0beb88a92c8f75231df120bef54616c7e4bb68c8
 2011-09-23 14:40:31 +00:00
drh
567211ed0e Testability enhancements. 
FossilOrigin-Name: be44928cf2a3c063c8228b769d90947acbfad1ef
 2011-09-23 13:59:33 +00:00
drh
369980189b Fix typos in the format description comment of analyze.c. 
FossilOrigin-Name: 74e27fad339a2d7899c1f42805e615128929f07a
 2011-09-23 13:25:03 +00:00
drh
2b9cf669d8 Remove the restriction on the number of entries per index in sqlite_stat3. 
FossilOrigin-Name: 374343c8ad53829c4ad715ed623d16635797de9a
 2011-09-22 20:52:56 +00:00
drh
5c62486cd8 Fix an issue in ANALYZE when STAT3 is disabled but both sqlite_stat2 and 
sqlite_stat3 tables exist.  Also add testability tweaks to the STAT3 code.

FossilOrigin-Name: 3ca7e449e2e20d95e516cf7fe87bfa0b51c07086
 2011-09-22 18:46:34 +00:00
dan
b5126dde0d Remove the SQLITE_PAGECACHE_BLOCKALLOC compilation option. 
FossilOrigin-Name: 4eb4689834b538b9eeec5a5803528260e1aff78d
 2011-09-22 14:56:31 +00:00
dan
58ca31c905 Add the SQLITE_DB_STATUS_CACHE_HIT and MISS options. For querying the number of cache hits and misses on a per-connection basis. 
FossilOrigin-Name: 5100b6e9dc5107f0f835d0aac26fe6d4938ffc73
 2011-09-22 14:41:16 +00:00
drh
93c6384ca6 Fix an uninitialized variable and a misuse of memcpy(). 
FossilOrigin-Name: ee110d5a4a6f29400bb632a9a18c7dcd04638657
 2011-09-22 00:28:55 +00:00
dan
0ae479dff2 Change the way the sqlite3_analyzer executable is built. 
FossilOrigin-Name: 05e3cced8a884e8bca6f208d2f09e335d3929eac
 2011-09-21 16:43:07 +00:00
drh
d3ed73406c Pull in the latest changes from trunk. Update the STAT3 documentation. 
FossilOrigin-Name: 63fc3e4bea6a7f5dc34b2af83f30458eb10b8fe0
 2011-09-21 00:09:41 +00:00
drh
9d56acdcfc Minor comment change in the description of the different memory allocator 
options.  No changes to code.

FossilOrigin-Name: 36be31ff0af7f811fe2c6f7e26f058cffb7257e1
 2011-09-19 20:56:59 +00:00
drh
72949adc95 Merge in all changes through the 3.7.8 release. 
FossilOrigin-Name: 9607600b6ca9b546dd248982fd8e8d64f708be5c
 2011-09-19 20:36:42 +00:00
drh
432e0bc6dc Increase the default lookaside cache line size from 100 to 128 bytes. 
FossilOrigin-Name: db019465036171fcad31181bec7d6ac185f50430
 2011-09-19 13:01:53 +00:00
dan
73ac46da31 Remove a stray merge-sort related change from pager.c and pager.h. 
FossilOrigin-Name: 69823ed163049d6fa1e24a9810c3c99f2a8fdd46
 2011-09-19 11:57:34 +00:00
mistachkin
f1c40f4fd4 Make sure the file structure is zeroed prior to calling the VFS to open a file. 
FossilOrigin-Name: 29c4d0dd43d41650e54824afd70dd40f1b91cc86
 2011-09-17 15:34:50 +00:00
drh
dfd2d9f6c9 Fix a problem with SQLITE_OMIT_TRACE that was introduced by the recent 
OP_Once change.

FossilOrigin-Name: 96be3f7b59b3ed4703b907e29db629df34b2b56f
 2011-09-16 22:10:57 +00:00
mistachkin
c377f3106b Fix #if's in winSync to avoid compiler warnings about unused local variables. Also, update version numbers in the MSVC makefile. 
FossilOrigin-Name: 2e66e41457422449ac5918b16be443e737dfb149
 2011-09-16 20:43:44 +00:00
mistachkin
a3b2ff5182 Silence harmless compiler warning about redefinition of the _CRT_SECURE_NO_WARNINGS macro by shell.c. 
FossilOrigin-Name: 690220717f3d92d4fb7bd72226fc8d5f38f5fbcf
 2011-09-16 20:16:36 +00:00
drh
5c4e5e53fe Merge all the latest trunk changes into the experimental STAT3 branch. 
FossilOrigin-Name: 51908c8f2bc6c086570f7493a29b096f0a40ce34
 2011-09-16 19:29:58 +00:00
drh
a464c23429 Remove unreachable branches from the previous change. Add additional 
test cases.

FossilOrigin-Name: cf51ef8ab8a610ddf64f66970dd689fe1df405b8
 2011-09-16 19:04:03 +00:00
drh
8850177924 When analyzing the right-hand side of IN operators to see if the IN operator 
can work with an index, be sure to decend into nested subqueries.
Fix for ticket [1a1308d2538d7]

FossilOrigin-Name: 0156f10e23daca0e2504cd293a67ed0233d254d0
 2011-09-16 17:43:06 +00:00
drh
7157e8eac1 Further streamlining of the subquery materializer. New test cases for 
ticket [002caede898a]

FossilOrigin-Name: ff8b76b25b42497a7374de56c6a8f34cbe70cd6a
 2011-09-16 16:00:51 +00:00
drh
48f2d3b10a Add the new OP_Once opcode. Use it to clean up and simplify various 
one-time initialization sections in the code, including the fix for
ticket [002caede898ae].

FossilOrigin-Name: 7f00552b739fad79517b042a6ed61abe743a917b
 2011-09-16 01:34:43 +00:00
drh
5b6a9ed495 Materialize subqueries using a subroutine and invoke that subroutine 
prior to each use of the subqueries manifestation.  Fix for
ticket [002caede898aee4]

FossilOrigin-Name: 4b8357ee3c4ccdbd34e0cd077efd84cca677f496
 2011-09-15 23:58:14 +00:00
mistachkin
0fe5f95c7f Remove 'const' from a variable that might actually be written when an OOM error occurs. Also, fix a couple MSVC/Win32 compiler warnings. 
FossilOrigin-Name: 3035dc1c7398791d550f4c02774ef7f961b4bb02
 2011-09-14 18:19:08 +00:00
drh
244b632cf7 Remove unused parameters from internal routines in vdbesort.c. This is 
an additional simplification made possible by recent optimizations.

FossilOrigin-Name: a1f3aeeb0988c848d40ce8f6da6e902935a997e2
 2011-09-14 13:41:40 +00:00
drh
59ebc99161 Remove code from vdbesort.c that was made unreachable by the recent 
sqlite3VdbeRecordUnpack() optimizations.

FossilOrigin-Name: 607aba6cd7020973200fa376cf8df55360165266
 2011-09-14 13:23:21 +00:00
drh
5a9f90b574 Merge the latest trunk changes into the stat3-trunk branch. 
FossilOrigin-Name: 11ca4ed8bf850dae1a24b7182f70039f32bd8dd1
 2011-09-13 19:09:28 +00:00
dan
42acb3e597 Fix a minor performance regression in btreeMoveto(). 
FossilOrigin-Name: d0712dfb24867a807c9cddcc12bd0aebe1d3e085
 2011-09-05 20:16:38 +00:00
dan
03e9cfc223 Refactor the sqlite3VdbeRecordUnpack() interface to better accommodate the vdbesort.c module. 
FossilOrigin-Name: f115b2303509c678dbe83b2fa3d9c40d82882813
 2011-09-05 14:20:27 +00:00
drh
19c88c1a99 Fix a compiler warning about an unused parameter in the merge-sort code. 
FossilOrigin-Name: 6b657ae75035eb10b0ad640998d3c9eadfdffa6e
 2011-09-04 01:27:00 +00:00
drh
c2bb3282f1 Improve the testability of the merge-sort logic. 
FossilOrigin-Name: b5179baf87aa00ed5cecbdcaa65bee10e112a9e9
 2011-09-04 01:11:46 +00:00
drh
d40807ddef Performance improvements to the external merge-sorter. Keep content on an 
in-memory linked lists rather than an ephemeral table prior to spilling to
disk.  Use the external merge-sorter to implement ORDER BY and GROUP BY
in addition to CREATE INDEX.

FossilOrigin-Name: 4c43e8b2d2c1d8dcba3cd1c3f2ec4e19ab419430
 2011-09-03 17:07:26 +00:00
drh
04a962fe02 Simplification and performance tweaks in vdbeSorterMerge(). 
FossilOrigin-Name: 99e34bdce4ccca15b79159b03b96787e7a7ff85b
 2011-09-03 16:42:38 +00:00
dan
8b1ea14f8c Reduce the number of VdbeRecordUnpack() calls made in vdbesort.c. 
FossilOrigin-Name: 666c2c3cff51dac2ba5689b75705d99c3705673b
 2011-09-03 14:36:13 +00:00
drh
ca892a7252 The build works again with -DSQLITE_OMIT_MERGE_SORT. The merge-sorter now 
avoids spilling to disk (letting the in-memory linked list grow without
bound) if PRAGMA temp_store=3.

FossilOrigin-Name: 68e26c4487696d194ee85370380e4b0e56d206ee
 2011-09-03 00:17:51 +00:00
drh
34163c6831 Remove some dead code. Fix a faulty assert(). Improve some variable names. 
FossilOrigin-Name: a9a64592cf88580cb254fb0aac65a2f2085976ec
 2011-09-02 21:42:33 +00:00