database/sqlite
1
0
Fork 0
mirror of https://github.com/sqlite/sqlite.git synced 2025-08-08 14:02:16 +03:00
Code Activity
30,215 Commits 1,570 Branches 184 Tags
tcl-init
Commit Graph

2168 Commits

Author SHA1 Message Date
dan
de7ced37fe Remove a reference to JumpOnce from a comment in vdbe.c. No code changes. 
FossilOrigin-Name: ee662c039d67f118008485d95603c5a43fcac75f
 2012-12-10 09:08:17 +00:00
drh
bd36911f4d Pull the latest trunk changes into the sessions branch, and in particular 
the collating-sequence refactorization.

FossilOrigin-Name: 4f6d69ae94671df92b976525f75404c01270fef9
 2012-12-08 23:37:22 +00:00
drh
0ca10dfbed Fix the header comment on the OP_Compare operator. 
FossilOrigin-Name: 2722f4074fd8d189b7bd2b9107484b66500e5e9b
 2012-12-08 13:26:23 +00:00
drh
953f7611da Fix a long-standing issue with the distinct-as-aggregate optimization that 
only expressed when the new collating-sequence logic is turned on.

FossilOrigin-Name: 0aaf52a339808386984c30cca0c0c35ac2e70e7e
 2012-12-07 22:18:54 +00:00
drh
fc5e546641 Make sure that the optimization that set the maximum column that will be used 
on a particular query does not mistakenly change an opcode other than
OP_OpenRead or OP_OpenWrite.  In particular, make sure it does not overwrite
the P4 field of an OP_SorterOpen.

FossilOrigin-Name: b0c1ba655d69c0c46c16ea2aef4e6c9a3e6ce3fb
 2012-12-03 17:04:40 +00:00
drh
3dc2b9032f Pull all the latest trunk enhancements into the sessions branch. 
FossilOrigin-Name: fce667f2d93a4ba65ccf1e748469576a3cd7ffcc
 2012-10-30 21:03:48 +00:00
drh
980db4b67c Fix a typo in the header comment for the OpenPseudo opcode. 
FossilOrigin-Name: 4f1061230e0e5a66038a4db99f1ee6203e4d2b9f
 2012-10-30 14:44:14 +00:00
drh
a575967793 Make it possible to disable the subquery-by-coroutine optimization using 
sqlite3_test_control().  Remove an always-false conditional.

FossilOrigin-Name: 564631f3e45f8f8a8db69f1e0df0d1dadbad8a2c
 2012-10-30 14:39:12 +00:00
drh
21172c4cc0 Add an optimization that attempts to run a subquery as a coroutine rather 
than manifesting it into a temporary table.

FossilOrigin-Name: 7af3acbbd49a2114fcdada9ec907c68ba9b053bd
 2012-10-30 00:29:07 +00:00
drh
c4645dacfb Merge the latest trunk changes (especially "PRAGMA busy_timeout" and the 
ORDER BY query planner optimizations) into the sessions branch.

FossilOrigin-Name: 6ca8eae1f89d19ee23cbc3a869d85b57d29b4a7d
 2012-09-28 13:05:48 +00:00
drh
e8e4af7697 Consolidate more of the DISTINCT processing logic into a single spot in the 
code.  Reduce the number of OP_Column operations needed to perform a
WHERE_DISTINCT_ORDERED.

FossilOrigin-Name: 79e922f7ae29bbe06d639d648fbd72523cf9a28e
 2012-09-21 00:04:28 +00:00
drh
053a128f55 Tighter VDBE code for the WHERE_DISTINCT_ORDERED case of DISTINCT keyword 
handling.

FossilOrigin-Name: 94b48064db3cbb43e911fdf7183218b08146ec10
 2012-09-19 21:15:46 +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
mistachkin
59ee77c7d1 Fix an unused variable warning with SQLITE_OMIT_WAL. 
FossilOrigin-Name: 39866c0ede5d6ef4dd4fd57c797f0e86a2d0dc5d
 2012-09-13 15:26:44 +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
dan
7417cefec6 Update with latest trunk changes. 
FossilOrigin-Name: 87995dc9409482f0a7a367bfc51d78ac0f63b8c3
 2012-08-31 14:23: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
drh
16de7f4d32 Merge all the latest trunk changes into the sessions branch. 
FossilOrigin-Name: fc07a4795e027108674d1d41eb4350df629ddc8b
 2012-08-15 16:21:55 +00:00
dan
428c218c90 When reusing pages as part of creating a new index, allocate the leaves from each free-list trunk page in ascending order, instead of trying to maximize localization for each individual allocation. This increases the chance that pages will be written to disk in ascending order by a large CREATE INDEX statement, improving overall performance. 
FossilOrigin-Name: d045f8b2d44e388d8c4549ff02d4ca7eff4e2038
 2012-08-06 18:50:11 +00:00
drh
8973a04e3b Merge all trunk changes, including the WinRT enhancements, into the 
sessions branch.

FossilOrigin-Name: c62140398344fd1a68a3e6dfe8b4fab280731ebb
 2012-06-07 23:58:36 +00:00
drh
155812d318 Documentation and evidence mark updates. Remove a redundant assert(). 
FossilOrigin-Name: cfcbf9375fddd0aae0dd17bdc76a710ab77ef667
 2012-06-07 17:57:23 +00:00
drh
bae591a960 Merge the latest trunk changes into shared-schema branch. Also fix a C99-ism 
in that branch.

FossilOrigin-Name: 42338e9e6979bb497823527f8f39e96f63623c59
 2012-06-05 19:20:03 +00:00
drh
14bcd7d25e Merge the unicode61 tokenizer and the shared-cache-memory database changes 
into the sessions branch.

FossilOrigin-Name: df817e70afc3f41e680d8f84dfa5772d5b3ae4d9
 2012-05-28 18:22:41 +00:00
drh
d4e0bb0e65 Have user interfaces report out the filename of in-memory databases as an 
empty string, as it always has.  This simplifies the changes.

FossilOrigin-Name: 595dfdbffefb2598cba89980f885289d1c5f5833
 2012-05-27 01:19:04 +00:00
drh
81028a455d The former sqlite3ResetInternalSchema() routine was really two different 
routines, selected by parameter, each with a confused mission.  So split
this routine up into three separate smaller routines, calling each
separately as needed.  Hopefully this will make further refactoring and
schema reset collateral damage containment easier.

FossilOrigin-Name: aa0c3493d3647d7efe527067e9fcccefda8e3008
 2012-05-15 18:28:27 +00:00
drh
bd91913dc0 Import all the latest trunk changes into the sessions branch. 
FossilOrigin-Name: 87a0eab5d98fff93aa2147c04c4af27be42fb365
 2012-04-18 01:41:37 +00:00
drh
31f100556c Do not abort pending queries on a RELEASE of a nested SAVEPOINT. 
This is a candidate fix for ticket [27ca74af3c083f787].

FossilOrigin-Name: 79a4a3a84f0b367d54da5e69e64ffca474264717
 2012-03-31 17:17:26 +00:00
drh
108606837e Merge all recent trunk changes into the sessions branch. 
FossilOrigin-Name: fb9b9987de965e194fef56bca563ee65c49f0950
 2012-03-30 17:30:33 +00:00
drh
ac5e749be8 Minor changes to the core of OP_Column for performance and to clarify the 
critical path.

FossilOrigin-Name: 868394761e41b7483a5874426ee052dfb3a9e2be
 2012-03-28 16:14:50 +00:00
drh
dda5c08bf6 Improvements to comments. Minor changes to code in the hot path of 
OP_Column - with the hope of get a few cycles of performance improvement.

FossilOrigin-Name: ca093103437f141caa3eb11539c6eb7b4dd65175
 2012-03-28 13:41:10 +00:00
drh
a748fdcc43 Evaluate typeof(X) and length(Y) where X is any column and Y is a blob column 
without actually loading X and Y from disk.

FossilOrigin-Name: b899dbeb60752843287e2c6ad3577e1d00f0d587
 2012-03-28 01:34:47 +00:00
drh
ddf01aeb16 Merge in the latest trunk changes. 
FossilOrigin-Name: ff86875ca35e04cea6c3d5e1b5117a4f227a6b15
 2012-03-05 16:26:00 +00:00
drh
a40eb7cfee A simple change that allows the SQLITE_32BIT_ROWID compile-time option to 
work better.

FossilOrigin-Name: f9df4063fbd100ce306a89fc649c1860fd801f31
 2012-02-24 00:02:28 +00:00
drh
21021a5cbf Add the new SQLITE_ABORT_ROLLBACK extended error code to be returned for 
statements that are cancelled due to a rollback.

FossilOrigin-Name: 549f4fd00d8325c10099b100e5202b77ee1d83ad
 2012-02-13 17:01:51 +00:00
drh
0f198a7409 Change the ROLLBACK command so that pending statements to not block it. The 
pending statements instead return SQLITE_ABORT upon next access.  Note: This
causes separate shared-cache connections in read_uncommitted mode to abort as
well.

FossilOrigin-Name: 9b66c79e054c8a109d1ee8d35fed1c42814c330d
 2012-02-13 16:43:16 +00:00
drh
fdf1795618 Pull all the latest trunk changes into the sessions branch. 
FossilOrigin-Name: 361fb66a799f4f253e61ca94d999accde2c75b2c
 2012-02-10 17:54:52 +00:00
drh
7a95789c0c For queries of the form "SELECT p, max(q) FROM t1", the value of column p 
returned is the one on the same row that holds the maximum value of q.

FossilOrigin-Name: adb29232b659c5332b6841776372407fcc350b08
 2012-02-02 17:35:43 +00:00
drh
a451017d62 Data structure cleanup. Remove unused fields. Rearrange other files for 
tighter packing and reduced memory usage.

FossilOrigin-Name: 0bc594e861ae1142e8c6c83f39b095e1432856bf
 2012-02-02 15:50:17 +00:00
drh
4d0d91666c Only invalidate the schema when the OP_ParseSchema opcode fails, not 
on any general failure of a vdbe program.

FossilOrigin-Name: 11f68d997da4aadf3f51c12c5139f3fdda8678bf
 2012-01-25 20:43:22 +00:00
drh
3f4aab1cc9 Remove a redundant assignment from the VM. 
FossilOrigin-Name: d0dabe2f37b5fa7c2c6bb728b8591af00cdd835b
 2012-01-18 01:14:42 +00:00
dan
af49af7f9e Update sessions branch with latest changes from trunk. 
FossilOrigin-Name: 01c84fd391a0ca1f5245c7eff0644d0cc6cff86b
 2012-01-14 13:50:12 +00:00
drh
45d29309a7 Fix typos in commands. Combine the ExpandBlob and expandBlob macros into one. 
FossilOrigin-Name: fc9179e154751b51ddef429600d30a89d4a098bd
 2012-01-08 22:18:33 +00:00
drh
54cced185c Merge all of the latest trunk changes into the sessions branch. 
FossilOrigin-Name: a9bcb432f58b96f079a73c456efd4851c582221e
 2012-01-05 13:02:36 +00:00
drh
e4c88c0c38 Fix typos and comments and make minor changes to a few function names, 
as suggested by readership.

FossilOrigin-Name: e9d05cbb7676cbda83f1b3b71447404d7edde898
 2012-01-04 12:57:45 +00:00
drh
b8a45bbdb8 Fix typos in comments. No changes to code. 
FossilOrigin-Name: 6827338ecbe43e28da88d919851ebffde9f6d398
 2011-12-31 21:51:55 +00:00
drh
ec86c724ac Take out the OP_JumpOnce opcode. Revert compound SELECT to use OP_IfNot, 
which is the correct behavior.  Mark trigger registers as initially
invalid.

FossilOrigin-Name: 6a9fb47d5060fe641915f5f99cc9265409a4583b
 2011-12-09 17:27:51 +00:00
drh
b8475df809 Make no assumptions about the initial state of VDBE registers. 
FossilOrigin-Name: 521d72bdf67b4b1972331307345a18c231a6e1d6
 2011-12-09 16:21:19 +00:00
dan
1d8cb21fdb Modify the OP_Once opcode so that it works correctly in trigger sub-programs. This is a candidate fix for [7bbfb7d442]. 
FossilOrigin-Name: 557c69055a300b4082830b5f4803091dca1c3140
 2011-12-09 13:24:16 +00:00
dan
0c733f67d8 Where possible, take advantage of the rowid at the end of index records to optimize range constraints (<, >, <=, >=) on the rowid column. 
FossilOrigin-Name: 3b58f5f06648205a47e5cace0201269c406e476a
 2011-11-16 15:27:09 +00:00
drh
f004e1d69e Merge in all changes found in the version 3.7.9 release candidate. 
FossilOrigin-Name: 23580718e1c15ddb89682d0e7566da4d7276bfe9
 2011-10-31 14:34:31 +00:00