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
9,301 Commits 1,782 Branches 392 Tags
stat3-3.7.2
Commit Graph

9301 Commits

This Branch
This Branch
All Branches
Author SHA1 Message Date
drh
8b7ca8c75b Veryquick and min.rc tests now passing. 
FossilOrigin-Name: a7e18468825622e518b2266a8724bdab99938b36
 2011-08-26 18:28:17 +00:00
drh
c66166d0c1 Merge the branch-3.7.2 changes into the stat3-3.7.2 subbranch. Also fix 
some test script issues.

FossilOrigin-Name: a42db19d52b679e5f3ce6970883903816e75a4e4
 2011-08-26 18:04:52 +00:00
drh
9b709c0b65 Cherrypick the recursion fix to test_vfs.c from [065e5a5ea4f82]. 
Also fix the nan.test module to handle upper/lower case changes in TCL.

FossilOrigin-Name: 41b5f86971ed9d7ddca31bd9b43d0a41f03f002b
 2011-08-26 17:17:50 +00:00
drh
895eab4e13 Get stat3 working after import from trunk-based the stat3-enhancement branch. 
There is still a problem in the wal2 test.

FossilOrigin-Name: 01cc4ff6af56a3dd08013862027bf8b91314986d
 2011-08-26 15:51:37 +00:00
drh
ab44853df2 Merge branches branch-3.7.2 and stat3-enhancement into a new branch for 
testing purposes.

FossilOrigin-Name: 0df04f920b3e6cfe8db7687cc9c392f65c11d9ce
 2011-08-26 13:52:23 +00:00
drh
8e3937ff0d Fix the stat3 analysis loader to be compatible with sqlite3_db_status(). 
Also fix some OOM issues with the stat3 analysis loader.

FossilOrigin-Name: eaf447ea87b0ff29ae06283204f522fcd005b284
 2011-08-18 13:45:23 +00:00
drh
fc0ce2a83e Fix a bug in the cleanup of stat tables on a DROP TABLE in autovacuum mode. 
FossilOrigin-Name: 3fe5d54f635f7b27851d256e417f21b91febb871
 2011-08-18 02:51:21 +00:00
drh
88ab5b08ad Fix an error with OOM processing in the ANALYZE logic. 
FossilOrigin-Name: b26ec79c69f44b55bc4bb11e293f11b3afa3b724
 2011-08-18 01:10:35 +00:00
drh
6825719667 Fix a few harmless compiler warnings. Add SQLITE_ENABLE_STAT3 to the 
standard compiler warning script.

FossilOrigin-Name: 3d68f9afee02f95103eb1682b8f2362f8d249437
 2011-08-16 17:06:21 +00:00
drh
8c2cd5dac5 Allow the sqlite3VdbeJumpHere() routine to accept a negative or zero address 
if a prior memory allocation error has occurred.  The new sqlite_stat3 logic
needs this.

FossilOrigin-Name: 9650d7962804d61f56cac944ff9bb2c7bc111957
 2011-08-16 02:07:04 +00:00
drh
461728d3d0 Add the analyze8.test test module for sqlite_stat3. 
FossilOrigin-Name: 2c83ac89dc5a6017587defb541c9f3731b98892a
 2011-08-16 01:15:12 +00:00
drh
50a1c56a2e Update some test cases to work with sqlite_stat3 instead of sqlite_stat2. 
FossilOrigin-Name: 2504bcfb0cf14b5ce51db0af1269ac28384714e0
 2011-08-15 12:58:23 +00:00
dan
23e7c4de7b Fix a couple of typos in comments in analyze.c. 
FossilOrigin-Name: ae31dc67aa0637150f964de31a6da6f5797b462a
 2011-08-15 12:02:21 +00:00
drh
4e50c5ec48 Further testing and bug fixing for sqlite_stat3. Added the Index.avgEq 
field to index statistics.  Fixed several problems in the query planner
associated with stat3.

FossilOrigin-Name: 89b2f70884cad0abdf4c66cb64ecddb2820ded74
 2011-08-13 19:35:19 +00:00
drh
f404c86ad7 Add the sqlite_stat3.nDLT field. Use an linear congruence PRNG to choose 
which samples to select from among those with the same nEq field.

FossilOrigin-Name: 1dcd24283e6c1cc638eb9ffac434046447f88769
 2011-08-13 15:25:10 +00:00
drh
ade3addfb5 The ANALYZE command picks for 15 samples for sqlite_stat3 with the largest 
nEq fields, plus 5 other evenly spaced samples.

FossilOrigin-Name: 8225924ea015a0c331b69134139922ec83f989f8
 2011-08-13 00:58:05 +00:00
drh
faacf17cc1 Begin a branch that experimentally replaces sqlite_stat2 with a new table 
called sqlite_stat3 that will hopefully facilitate better query
planning decisions.

FossilOrigin-Name: 52e1d7e8ddd4bb5ef3a9d00fd2d719a8a784f807
 2011-08-12 01:51:45 +00:00
drh
90315a2417 Make the openDirectory routine in os_unix.c overrideable so that it can 
be turned into a harmless no-op for the chromium sandbox.

FossilOrigin-Name: 6b236069e1ea3c99ff0a007a790d4baebda70b13
 2011-08-10 01:52:12 +00:00
drh
f6cee7d100 Add command-line utilities "offsets.c" and "extract.c" for use in 
low-level analyzsis of database files.

FossilOrigin-Name: dfa22ed4387f9526b74d5265503c7c8e9d559903
 2011-08-09 18:14:36 +00:00
drh
0059eae367 In os_unix.c, do not open the directory containing the database file when 
the database file is opened.  Instead, wait until time to fsync() the
directory.  And do not report an error if the open fails, since some
systems (Ex: AIX and a chromium sandbox) are unable to open and fsync
directories.

FossilOrigin-Name: 713b1b7dc1296e9cee42aeaad8c85528155f721d
 2011-08-08 23:48:40 +00:00
drh
036ac7fa90 Allow the unlink() system call to be overridden in os_unix.c. 
FossilOrigin-Name: 8d1b5c3ac027ac00d57a250aad45230a09645617
 2011-08-08 23:18:05 +00:00
drh
a5ae4c330b Remove relevant elements from the sqlite_stat2 table when doing a DROP 
INDEX or DROP TABLE.

FossilOrigin-Name: 3c8f97ae527e380bf2583c7cf8ceac9509f29bfe
 2011-08-07 01:31:52 +00:00
drh
f9042e9682 Merge the winopen-retry-logic branch into trunk. The biggest change here 
is to test scripts, which should now use such as copy_file and
delete_file from tester.tcl rather than the raw file commands of TCL.

FossilOrigin-Name: b90c28be3840169651022ef36cd7cf416bc22305
 2011-08-03 22:06:39 +00:00
drh
52043d7d45 Update the OP_Move opcode to shift the pScopyFrom pointer of aliases when 
compiled with SQLITE_DEBUG.  Ticket [d63523637517386191].

FossilOrigin-Name: a2135ad13049c170b33315a949b1544e6a136183
 2011-08-03 16:40:15 +00:00
mistachkin
85e444cab4 Add explanatory comment to the win32lock-2.2 test case. 
FossilOrigin-Name: 4cb17881d9676fa3359394391b9ba53f08e5809a
 2011-08-02 23:45:53 +00:00
mistachkin
176f1b47e5 Correct subtle timing issues in the win32lock test cases and in the lock_win32_file Tcl command. Also, eliminate superfluous MSVC compiler warnings. 
FossilOrigin-Name: 7baf02946e14eb889d864984ff3b3822aad8a3c9
 2011-08-02 23:34:00 +00:00
mistachkin
1b466a605d Fix missing info exists check for win32lock-2.2 (the one previously applied to win32lock-1.2). 
FossilOrigin-Name: 8a52698e642f40a32d09a6a00b63f25ac38f3fda
 2011-08-02 20:19:48 +00:00
drh
8b0228f1a6 Exclude the 8_3_names.test script from the inmemory_journal permutation. 
FossilOrigin-Name: 78fc94c8d1229a8bdc9390e98b53c57aeef7fc46
 2011-08-02 20:14:55 +00:00
mistachkin
5ea4298c81 Replace the missed 'file copy' in malloc_common.tcl with copy_file. 
FossilOrigin-Name: cd20b4ef6020c0cffe918362afc2b491fb95eb92
 2011-08-02 20:03:36 +00:00
drh
6c486cbce2 Merge in the permutation changes from trunk. 
FossilOrigin-Name: b30a5e307fd5485d23e4c4f8ed1c47525a0fe6d3
 2011-08-02 20:01:06 +00:00
drh
82be3b03a8 Also exclude backcompat.test from inmemory_journal since inmemory_journal 
is not compatible with WAL mode.

FossilOrigin-Name: 861a5b62430d0ada07a46d0e394fcf0b0faab1cd
 2011-08-02 19:59:39 +00:00
drh
ba2019ffae Merge the latest trunk changes into the winopen-retry-logic branch. 
FossilOrigin-Name: 8bef97a0eb2f56d0ac374d97e97e0a44c7f99aee
 2011-08-02 19:42:38 +00:00
drh
d88d10566c Omit backcompat.test from the journaltest permutation because it uses WAL 
mode which is incompatible with journaltest.

FossilOrigin-Name: 2bbf3150a4b7108e88ed81c1d40af6f06089e148
 2011-08-02 19:30:20 +00:00
drh
b4256996c4 Make sure IS NOT NULL constraints work on virtual tables. 
Fix for ticket [6c14288a473ceff].

FossilOrigin-Name: a55f4ab99952a731e4cd8f6ef17389062e5ed4c5
 2011-08-02 01:57:39 +00:00
mistachkin
fda06befd5 Add retry logic for AV defense to winOpen. Also, refactor test suite to allow the key Tcl file operations (e.g. copy and delete) to be retried. 
FossilOrigin-Name: 9007586fdabed8dbcc78581ea9821cfd1f9a4c8c
 2011-08-02 00:57:34 +00:00
drh
c8eee5e5e1 Fix a (humorous) typo in the lemon documentation. 
FossilOrigin-Name: ed630b012f468d6779b83dd8c4dbf3a8dafee573
 2011-07-30 23:50:12 +00:00
mistachkin
5b7f786e7e Merge changes for the new sqlite3_file_control() that will cause the -wal and -shm files to persist after the last database connection closes. 
FossilOrigin-Name: 1b56677bdfb102d070a2057a65ba424fec81131d
 2011-07-28 20:48:38 +00:00
mistachkin
4e6b49b409 Remove redundant sub-expression from retry loop invariant in winAccess. Also, make check for SQLITE_ACCESS_READWRITE formally correct. 
FossilOrigin-Name: 93079a92c49edf72eb289f352cd5ed7ab2faaff3
 2011-07-28 19:16:41 +00:00
mistachkin
e75a717dc8 Fix conditional for retry logic in winAccess and add missing call to logIoerr. 
FossilOrigin-Name: 8a145863d1a8711953ae72d706404fb96f6fec06
 2011-07-28 07:34:44 +00:00
drh
58384f1720 Use osStat() instead of stat() consistently in os_unix.c 
FossilOrigin-Name: 9109128cb5640d687251dfbefa2fd998063cd9fb
 2011-07-28 00:14:45 +00:00
drh
253cea5c6f Test cases added. Fix the query mode. 
FossilOrigin-Name: a9d8794ae949df570466a84836882bc8bed95c7c
 2011-07-26 16:23:25 +00:00
drh
f0b190d94c Prototype change for a new sqlite3_file_control() that will cause the 
-wal and -shm files to persist after the last database connection closes.

FossilOrigin-Name: e34c553bf04761e86f3bd72f91439c05886caa5c
 2011-07-26 16:03:07 +00:00
drh
7d2dc7156c Enable the SQLITE_FCNTL_SIZE_HINT on unix even if SQLITE_FCNTL_CHUNK_SIZE 
has not been set.

FossilOrigin-Name: 05c9832e5f6eb705f1dce4e65cf4e2d56512ff6b
 2011-07-25 23:25:47 +00:00
drh
5d22e41f2d Merge the winAccess retry logic from the anti-antivirus branch 
into the trunk.

FossilOrigin-Name: 08d0e8799e1441ef063b1cdf9e4107071a0f81ca
 2011-07-23 13:54:34 +00:00
drh
11cce77042 In the multiplexor, close auxiliary files before deleting them when doing 
a truncate.

FossilOrigin-Name: 6fb7cfc2efb32dd5c8921a90b853390bc44d4794
 2011-07-23 13:11:02 +00:00
drh
fdf6db12a4 Add retry logic for AV defense to winAccess(). Also allow OS tracing to be 
enabled by a compile-time option.

FossilOrigin-Name: a6b85c73406caa3bf0585341c8ebc9897a1884f4
 2011-07-22 21:25:57 +00:00
drh
75e7bc1db7 Also add the sqlite3-all.c target to the MSVC makefile. 
FossilOrigin-Name: 8ce2b74a82264550b0e19da3e0e1a145db940a1c
 2011-07-22 11:23:49 +00:00
drh
07516dd5df Add makefile targets sqlite3-all.c. 
FossilOrigin-Name: 71f7be586f5a18493cd516f89c4ecc460bb24462
 2011-07-22 11:16:39 +00:00
drh
fe34996549 Adjust the maximum number of open database connections in wal3.test down 
for OpenBSD.

FossilOrigin-Name: b38e52f67574997de9f4b4318f2eb68ff0133f35
 2011-07-22 10:53:05 +00:00
drh
16b92eef35 Use $(TCLSH_CMD) instead of tclsh in the autoconf makefile. 
FossilOrigin-Name: fd36d8067b5a29d9acbf8c96b9d837406d0c0cce
 2011-07-22 10:33:04 +00:00