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
13,071 Commits 1,785 Branches 392 Tags
threadtest3
Commit Graph

9576 Commits

Author SHA1 Message Date
drh
fce4da1b73 Test cases for hex literals. 
FossilOrigin-Name: 19054339c47448bcdfd1f7be35daa3826c409077
 2014-07-23 01:56:32 +00:00
drh
28e048c618 Add support for parsing C-style hexadecimal literals. 
FossilOrigin-Name: 34a1f38b7a23c64f5c6e5b34c19a20480be53961
 2014-07-23 01:26:51 +00:00
drh
0f65cce825 When running ANALYZE, it is not necessary to check the right-most key column 
for changes since that column will always change if none of the previous
columns have.

FossilOrigin-Name: 48f40861db4fbd10725a2b8b606d44fe16d5bd27
 2014-07-22 22:46:54 +00:00
drh
3526319b48 Add the OP_ReopenIdx opcode that works like OP_OpenRead except that it becomes 
a no-op if the cursor is already open on the same index.  Update the
OR-optimization logic to make use of OP_ReopenIdx in order to avoid
unnecessary cursor open requests sent to the B-Tree layer.

FossilOrigin-Name: 77f412caf0192d3e7fecb377d6d72123d8b64424
 2014-07-22 20:02:19 +00:00
drh
a45fdc7b1e The optimization of check-in [b67a6e33f2] does not work (it generates 
incorrect VDBE code) if an OR term is AND-ed with a constant expression.
So back that optimization out and add a test case to make sure it does not
get added back in.

FossilOrigin-Name: eed754fe93644f4df082eac0c0a7ffc5c78ccd10
 2014-07-22 19:14:42 +00:00
drh
d08b27988c Correction: The maximum SQLITE_MAX_ATTACHED value to avoid overflowing a 
signed 8-bit integer is 125, not 127.

FossilOrigin-Name: 48e378029528dac33d29866016128d236a7995d9
 2014-07-22 15:33:31 +00:00
drh
25df48d967 Enhance the sqlite_stat1.stat parsing to allow additional text parameters 
at the end.  Unrecognized parameters are silently ignored.

FossilOrigin-Name: ca2a5a2c770fa94cd8db1b1b241ede058a7c58e2
 2014-07-22 14:58:12 +00:00
drh
358406fc57 Expire prepared statements after running ANALYZE. 
FossilOrigin-Name: b083a961f8ac3a6158e822574d73cd63e3103b09
 2014-07-22 14:42:16 +00:00
drh
83a305f20e Enhance the comment on whereLoopAddBtree(). No changes to code. 
FossilOrigin-Name: b22dd165da227a52d88b17a91e80a1701dce61ad
 2014-07-22 12:05:32 +00:00
drh
53ad7e48ab For the OR-optimization, avoid generating OP_OpenRead opcodes that reopen 
exactly the same index.

FossilOrigin-Name: b67a6e33f23ce5f5d9a545fa9d6700a7ed636901
 2014-07-22 00:40:45 +00:00
drh
215c0c82fa Limit the maximum SQLITE_MAX_ATTACHED to 127, since a signed character 
is sometimes used to store the database index.

FossilOrigin-Name: f1c76c7c4c7d16855db60d16e23ecdf8d7ca862a
 2014-07-21 20:07:17 +00:00
drh
a7ab6d8165 Allow the SQLITE_MAX_ATTACHED compile-time option to be larger than 62. The 
default limit on the number of attached databases remains 10.

FossilOrigin-Name: 1a817ae2f35fa0396148dda2782cd4f919bf5c6f
 2014-07-21 15:44:39 +00:00
dan
857745c089 Update the sqlite3_stmt_busy() function so that it correctly returns true for "ROLLBACK" statements that have been stepped but not yet reset. 
FossilOrigin-Name: 61cee3c0678f5abd9131a29ab946a5e71f55643e
 2014-07-19 17:57:10 +00:00
drh
a6f5972c75 Improved documentation for checkpoints and the busy handler. No changes 
to code.

FossilOrigin-Name: ca92c0240681b199c4b8ecc557792b8aea71692d
 2014-07-18 19:06:39 +00:00
drh
56f674c8a0 Improvements to the ".fullschema" command in the command-line shell. 
FossilOrigin-Name: fa80c64caa573297bf43cb5b11d9e7db58567200
 2014-07-18 14:43:29 +00:00
dan
2eaf03d72b Change fts3/4 so that the "unicode61" is included in builds by default. It may now be excluded by defining SQLITE_DISABLE_FTS3_UNICODE. 
FossilOrigin-Name: 0cc0230ae9cfc9760fd8ef2c25e82576b052dbeb
 2014-07-03 12:18:22 +00:00
dan
39caccf83d Ensure that all fields are loaded from the stat4 table for records that correspond to indexes on WITHOUT ROWID tables with composite primary keys. 
FossilOrigin-Name: 21981e35062cc6b30e9576786cbf55265a7a4d41
 2014-07-01 11:54:02 +00:00
drh
6614181610 Merge the latest trunk changes into the threads branch. 
FossilOrigin-Name: ae23a65eb1547fbe8b86ab71477071990a22d31d
 2014-06-30 20:25:03 +00:00
drh
855f63908f Attempt to use STAT4 information to estimate the selectivity of WHERE clause 
terms when using the skip-scan optimization.

FossilOrigin-Name: d09ca6d5efad3e4cfa93a4dc711e6ba6079d4b4b
 2014-06-30 19:07:58 +00:00
dan
fd984b8114 Fix a problem in where.c with using the stat4 sample data of an index on a WITHOUT ROWID table. 
FossilOrigin-Name: 053a210e3169732c58f84cb54c9b6f6df3a8f4ea
 2014-06-30 18:02:20 +00:00
drh
ec9e55d358 Fix the STAT4 information for WITHOUT ROWID tables. 
FossilOrigin-Name: 5d8628fdffbcf837313958f0ee1ed8a2043d384e
 2014-06-30 17:07:39 +00:00
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