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
14,676 Commits 1,785 Branches 392 Tags
omit-awk
Commit Graph

10418 Commits

Author SHA1 Message Date
mistachkin
91a3ecb0ad Fix typo in comments. No changes to code. 
FossilOrigin-Name: a05f903c64edeba8a9748aad68f5981943e68b3c
 2015-10-06 21:49:55 +00:00
drh
8b0cf38a12 Simplifications to the VDBE bytecode that handles LIMIT and OFFSET. 
FossilOrigin-Name: 041df7c2f14b95868a08090354ebb3308050790e
 2015-10-06 21:07:06 +00:00
drh
9f1ef45f6a Fix the LIMIT and OFFSET handling for UNION ALL queries that contain a 
subquery with ORDER BY on the right-hand side.  Fix for ticket
[b65cb2c8d91f668584].

FossilOrigin-Name: 4b631364354068af95a01630469cb6fbfe8b52fd
 2015-10-06 17:27:18 +00:00
mistachkin
8d9837acd5 Adjustments to sqlite3MemoryBarrier() when compiling with MSVC and/or WinCE. 
FossilOrigin-Name: 3168326ebfa1c961d8fc6435453b02be23d910cc
 2015-10-06 01:44:53 +00:00
drh
9b5351d439 Fix an assert() in btree.c that is only true for non-corrupt databases. 
FossilOrigin-Name: 29f7227ff127202c53fe7c3b6558b3c101b0a7bc
 2015-09-30 14:19:08 +00:00
dan
e755e10a78 Clear the BTCF_ValidNKey flag when putting a cursor into REQUIRESEEK state. Fix for [1b266395]. 
FossilOrigin-Name: a6d5e4e8693bea3739c35fe9769ac9abfb9ed056
 2015-09-30 12:59:12 +00:00
dan
d95bb39c52 Improve error handling in shell command ".tables". 
FossilOrigin-Name: 31a91ee7d32af8580a170903eb857ed9222fdb0a
 2015-09-30 11:19:05 +00:00
drh
4b92f98ccc Use symbolic names XN_ROWID and XN_EXPR in place of the (-1) and (-2) 
magic numbers in Index.aiColumn[].  Add asserts to help verify that
Index.aiColumn[] is always used correctly.  Fix one place in FK processing
where Index.aiColumn[] was not being used correctly.

FossilOrigin-Name: 7d272aa62cd4cbbf4b5d04e3b918de27671e8301
 2015-09-29 17:20:14 +00:00
dan
e60856980a Add the sqlite3_index_info.idxFlags field, allowing xBestIndex() implementations to specify to SQLite that a strategy may visit at most one row. Add support for this to fts3/4. Omit the statement journal from virtual table UPDATE and DELETE operations that are guaranteed not to affect more than one row. 
FossilOrigin-Name: a1d08fd3d0419da8c22355d48c6d83eed6fd7e07
 2015-09-29 16:47:53 +00:00
dan
65c4f591be Ensure that the xSavepoint() virtual table method is correctly invoked if there are already open savepoints (or statement transactions) the first time a virtual table is written within a transaction. 
FossilOrigin-Name: 77948b5eceab92a77c39d0864ac15ad453a76fd7
 2015-09-29 16:41:23 +00:00
drh
e2b7d7a0a1 Remove dead code, replacing with assert() statements that make sure the 
code really was dead.

FossilOrigin-Name: 0e317dda5dfd35b742afd70dacb5bfb39aa3fc4a
 2015-09-29 15:50:04 +00:00
drh
c149f18f4d Create the sqlite3IsToplevel(Parse*) interface to check to see if a top-level 
VDBE is being coded (versus a trigger) and use that interface.

FossilOrigin-Name: 59662cd2b65255a30e1a420331c07c51b644621a
 2015-09-29 13:25:15 +00:00
drh
94f26a1e22 Fix compiler warnings. 
FossilOrigin-Name: d1a0783854d2e9272320d9ddfa58362532f58d1a
 2015-09-29 12:32:56 +00:00
dan
91742c45a9 Merge latest trunk change into this branch. 
FossilOrigin-Name: b519c0d67a8fc39d65c17eccc9300a6187bd5661
 2015-09-29 11:59:25 +00:00
dan
b3deb4ea64 Change the name of the new sqlite3_index_info.flags field to "idxFlags". Add documentation for the same to sqlite.h.in. 
FossilOrigin-Name: f61203bc0fb0b62e12d6270e8d9063e445a5a252
 2015-09-29 11:57:20 +00:00
dan
354474ad6d Add tests for fts3 and onepass update/delete operations. Also fix a problem with onepass updates that do not affect any rows. 
FossilOrigin-Name: 820c804468abff692742952de670c5d906a50956
 2015-09-29 10:11:26 +00:00
dan
0f40037eee Also allow UPDATE on virtual tables to use the onepass strategy. 
FossilOrigin-Name: 1aa27d706db9b2e21737ce4b94b47ecd12c2570f
 2015-09-28 20:03:49 +00:00
drh
a722821eb5 Extra information provided by .wheretrace on input flags to the query planner 
and on the result of sqlite3WhereOkOnePass().

FossilOrigin-Name: c5566bb39c8d9b58f77380b81a873429575c7d5c
 2015-09-28 17:05:22 +00:00
dan
076e0f9674 Changes to allow DELETE operations on virtual tables to use the onepass strategy under some circumstances. 
FossilOrigin-Name: e73f919fae1833c6ffb36eddbc76d9a8d9324214
 2015-09-28 15:20:58 +00:00
drh
63c85a7a66 Fix a database corruption bug caused by the ONEPASS optimization added 
in check-in [8b93cc5937000535].  Bug detected (prior to release) by
[https://www.sqlite.org/sqllogictest|sqllogictest].  Test cases to follow.

FossilOrigin-Name: 9d057f52217e7ef9c3f3eb84117abe3365503f44
 2015-09-28 14:40:20 +00:00
drh
2f20e13b83 Enable adding JSON1 by appending the json1.c source file to the amalgamation 
and compiling with -DSQLITE_ENABLE_JSON1

FossilOrigin-Name: 33404b2029120d4aabe1e25d484871810777e934
 2015-09-26 17:44:59 +00:00
drh
32498f1321 Fix a memory leak that can occur following a syntax error in CREATE VIEW. 
FossilOrigin-Name: f4704035a6134f702c00110358e36f1579e2ea78
 2015-09-26 11:15:44 +00:00
drh
c4cdb29a0e Fix the title of the documentation on sqlite3_value_subtype(). This is a 
comment change only.

FossilOrigin-Name: b79023542458f7e839469c5e313694f1e4cf223a
 2015-09-26 03:31:47 +00:00
drh
539482b76a Expand the header comment to clarify the purpose for the 
sqlite3MemoryBarrier() function.

FossilOrigin-Name: b89495ae09aa0e9652475b2ba1943dfd87c73e07
 2015-09-26 03:23:29 +00:00
drh
17db155fed Remove an assert in the windows worker-thread logic that can fail in a race 
condition.

FossilOrigin-Name: d7bfb96092a6b812af194f32b22283a0f6a7da96
 2015-09-26 01:28:46 +00:00
drh
2ea31b1286 Fix threads.c so that setting sqlite3FaultSim(200) using the 
SQLITE_TESTCTRL_FAULT_INSTALL callback causes both unix and windows worker
threads to be sequential and deterministic, so that they can be tested
reliably.

FossilOrigin-Name: 2d867c054d6d3e1e841ba9ca524e986bc6993ac3
 2015-09-25 23:40:01 +00:00
drh
68391acd5f Fix PRAGMA integrity_check so that it works with a UNIQUE index over 
expressions.

FossilOrigin-Name: 113181cec4db418b07640d6b1967923992efd71a
 2015-09-25 20:49:16 +00:00
drh
2679f14fd9 Report an error if the number of named columns in a VIEW is different 
from the number of result columns in the SELECT statement that implements
the VIEW.

FossilOrigin-Name: 6e4ac0be2de1a16fcbb2a314504122ad95aa257e
 2015-09-25 13:42:55 +00:00
drh
8ffddeb708 Fix a problem computing affinities for indexes during skip-scan code 
generation when SQLITE_ENABLE_STAT4 is on.  Bug introduced by
check-in [1ee089a72d789002].

FossilOrigin-Name: 1350dd42d056508337b1a07ad8b1c9c97593f8d3
 2015-09-25 01:09:27 +00:00
drh
dae26fe518 Enhance the query planner so that it is able to use indexed expressions 
to help fulfill an ORDER BY clause.

FossilOrigin-Name: 668fc1ebaf426f9eed3ed7865e41f1023dafebfb
 2015-09-24 18:47:59 +00:00
drh
76226dd28d Fix over-length source code lines in where.c. No logic changes. 
FossilOrigin-Name: 1c8c5380a8b45c9e04d9663c3cb8182ef3a61b81
 2015-09-24 17:38:01 +00:00
drh
22c733da64 Strengthen the implementations of xShmMemoryBarrier on both the unix and 
windows VFSes, so that they likely work even if SQLITE_THREADSAFE=0 is used.

FossilOrigin-Name: c6ab807b72ddfc1462f61aa91442b6fac04ace8a
 2015-09-24 12:40:43 +00:00
drh
c5de2d0a05 Make sure joins work correctly when both sides of the join are connected 
using indexed expressions.

FossilOrigin-Name: c2fcb03299f2872d7f97a540ea145519f8b2e5cc
 2015-09-24 12:19:17 +00:00
drh
7269443281 Correctly handle the case of a WHERE-clause term with indexed expressions on 
both sides of the == sign.

FossilOrigin-Name: d9b716a6bd6145b2e7733c04d86227df777cd473
 2015-09-24 11:26:45 +00:00
drh
58cb6dbe0d Take care that the number of reserved bits per page is consistent between 
the source and destination databases when doing the back-copy on a VACUUM.

FossilOrigin-Name: 5b61b72f5424a2d9bb4e68eb95026cd63f003db9
 2015-09-23 19:17:23 +00:00
drh
78ac109c7f Fix an overly-strict assert() in the btree logic. 
FossilOrigin-Name: 825ce3201df21c6b9d5c57dcc6726c306df05220
 2015-09-20 22:57:47 +00:00
drh
6230212f4a Do not allow table-valued function syntax to be used on a view. 
FossilOrigin-Name: 97cfe346e140e42a604375551f8168276bdbea11
 2015-09-19 20:27:08 +00:00
dan
80b7198f2b Add an assert() statement to delete.c. 
FossilOrigin-Name: 40fce67ecf0e71db3c8f3da3f72cc80a3d0f8fb2
 2015-09-19 18:11:18 +00:00
drh
8faee877cb Fix compiler warnings. 
FossilOrigin-Name: 5c31ee62a196b914673384a611534fd778dc64b0
 2015-09-19 18:08:13 +00:00
drh
c02c4d4900 Fix a documentation typo in sqlite3_bind_parameter_index(). No code changes. 
FossilOrigin-Name: 650605a820f3860b1d6e955cdda23aaff01dfdb5
 2015-09-19 12:04:27 +00:00
drh
4cbc54b042 Do not allow rowid in a UNIQUE or PRIMARY KEY constraint. (This restores the 
same behavior exhibited by all prior releases.)

FossilOrigin-Name: b1278301e37220a075c1bae88c0fcca2ef7a7d5c
 2015-09-19 03:07:30 +00:00
drh
e63e8a6c78 Fix a crash that can occur with a skip-scan on an index with 
expressions when SQLITE_ENABLE_EXPLAIN_COMMENTS is defined.

FossilOrigin-Name: 25f34cb9b576a2d4250a06a7dbf88010b1c11675
 2015-09-18 18:09:28 +00:00
dan
ad41f5eda3 Ensure that "PRAGMA integrity_check" reports an error if the free-list count header field contains a value smaller than the actual number of pages on the database free-list. 
FossilOrigin-Name: 26f64986d1ed59c554a7cb9e00e86a7f148f1fc6
 2015-09-18 14:45:01 +00:00
drh
b77ebd828b Reformat some code to make it easier to merge with sessions. No logic changes. 
FossilOrigin-Name: eade355fafec558fc13dc4b08ca0b07713a2cd84
 2015-09-15 13:42:16 +00:00
drh
b79d5529af Testability improvements for the ONEPASS_MULTI enhancement. 
FossilOrigin-Name: d2df93f26fc0cf6fe01acfeaf2946972e9d8cca2
 2015-09-14 19:26:37 +00:00
drh
b1ff90673c Fix a typo in an SQLITE_USER_AUTHENTICATION macro. 
FossilOrigin-Name: 379455af9fdfb299a857d46f35f0a76ed6daa08a
 2015-09-14 14:49:23 +00:00
drh
b0264eeca1 Use symbolic names ONEPASS_OFF, ONEPASS_SINGLE, and ONEPASS_MULTI for the 
various modes of the one-pass optimization.

FossilOrigin-Name: 16e56bdadef903c6439a487f2683388aeeb0c625
 2015-09-14 14:45:50 +00:00
drh
66336f3755 Fix a compiler warning and providing missing VdbeCoverage() calls. 
FossilOrigin-Name: 2edd2e5edd60210e18db58bce1e096dd211b6ece
 2015-09-14 14:08:25 +00:00
dan
e402dc57ae Use a single-pass approach for DELETE statements on non-virtual tables that do not require trigger or foreign key processing. 
FossilOrigin-Name: 8b93cc5937000535c35c763c9326507a19892a6e
 2015-09-14 11:09:58 +00:00
dan
c6157e1971 Avoid calling sqlite3VdbeCursorMoveto() from more than one point in vdbe.c. Doing so prevents it from being inlined as part of OP_Column. 
FossilOrigin-Name: 166d5af8914c6954fb24a06e9686f194c0d0acde
 2015-09-14 09:23:47 +00:00