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
drh
b6e8fd105c Fix some incorrect comments and typos in comments. Add testcase() macros 
to some of the new record comparison code.

FossilOrigin-Name: b83cfe899d84fe9d61540e9984321ca30401638c
 2014-03-06 01:56:33 +00:00
drh
0503cf491f Merge in various obscure bug fixes and the removal of Mem.memType from trunk. 
FossilOrigin-Name: 0828975d580d309a1c66da4b6caeb65b21a01199
 2014-03-05 14:49:51 +00:00
mistachkin
afc14f72ef Experimental simplification of memory flags/type handling. 
FossilOrigin-Name: bac2820e13a79d91d0f8938c643134a9d6900327
 2014-03-05 01:29:18 +00:00
drh
7826a9b83f Merge the performance enhancements of trunk (and some obscure bug fixes) 
into the sessions branch.

FossilOrigin-Name: 7f51ad97f0b24c57453d58faf25eee68861faa23
 2014-03-04 14:34:14 +00:00
dan
900defa07a Merge latest trunk changes. 
FossilOrigin-Name: e00ed717fbe456010ec6c746490d7c3e9d94ec5a
 2014-03-03 14:45:06 +00:00
drh
c91b2fd310 Change the MEM_Dyn flag so that it means that Mem.xDel exists and must be 
used to free the string or blob.  Add tighter invariant checks on Mem.

FossilOrigin-Name: 44e1c33767cae3bf2cbd2238831fe67197009b43
 2014-03-01 18:13:23 +00:00
drh
75fd054201 Factor the Mem invariant checker into a separate procedure (rather than a 
macro) so that it can be more easily extended.

FossilOrigin-Name: 354699d50e7d251504a7b3d6fbec9e5bcf99557f
 2014-03-01 16:24:44 +00:00
drh
defbd9dade Add extra assert() statements trying to catch a Mem object in an inconsistent 
state.

FossilOrigin-Name: 4aeb3ae435c78070232fef21a147fde4e1c5cd31
 2014-03-01 14:45:18 +00:00
dan
1fed5dab0d Attempt to speed up sqlite3VdbeRecordCompare() by various means. This code is in an interim state. 
FossilOrigin-Name: 85206e0bbac29adab52bef795f6d1479f2ae2c0e
 2014-02-25 21:01:25 +00:00
drh
15ab9418d9 Remove an unused variable from the VDBE_PROFILE compile-time option. Keep the 
opcode count in an u32 instead of an int.

FossilOrigin-Name: 4df0ac9023d9261145a4425a508ba009a10276fc
 2014-02-24 14:24:01 +00:00
drh
4d87aaed56 Fix the text of a comment used to generate VDBE opcode documentation so that 
it omits symbols that can be mistaken for a hyperlink by the parser.

FossilOrigin-Name: b46d4e8923e6e367412bba7aeac07039bbcbabd1
 2014-02-20 19:42:00 +00:00
drh
5655c549aa Add the VdbeCoverageNeverTaken() macro, and comments that better describe how 
the VDBE branch coverage measurement works.  Add some tags to provide 100%
VDBE branch coverage.

FossilOrigin-Name: c1e94169dd8eb80b4d18c73be9f81585330d11ad
 2014-02-19 19:14:34 +00:00
drh
3d77dee935 Add the SQLITE_NOTNULL P5 code for comparison operations - really a composite 
of SQLITE_NULLEQ and SQLITE_JUMPIFNULL.  This flag indicates that NULL operands
are not possible and raises and assert() if NULL operands are seen.
Also omit an unnecessary scan of the sqlite_sequence table when writing
into an AUTOINCREMENT table.

FossilOrigin-Name: d2c047f304848e49864ed8c216b48fd671fa3916
 2014-02-19 14:20:49 +00:00
drh
f4345e40a0 Fix VDBE branch accounting on comparison operators. 
FossilOrigin-Name: b287520c9226f7a9fab98142f5c207bfe959cd7e
 2014-02-18 11:31:59 +00:00
drh
688852ab15 Add logic to do test coverage measurements on the VDBE code. 
FossilOrigin-Name: ce184c7bb16988641d37c908d9b3042456d4be3d
 2014-02-17 22:40:43 +00:00
drh
57bf4a8eeb Avoid unnecessary calls to applyAffinity() during INSERT and UPDATE 
operations, especially for table that have indices and tables for which
all columns have affinity "NONE".

FossilOrigin-Name: 35b4d6e938164fabaf30b504c54cfd9a69060cee
 2014-02-17 14:59:22 +00:00
drh
05a86c5c0f Enhance the code generator for INSERT INTO ... SELECT so that the SELECT 
generates output directly in the registers that INSERT INTO will be using,
in many cases, and OP_SCopy operations can thus be avoided.

FossilOrigin-Name: aa2d8b0e8154dd2f5e2c837dc11ab362b083495b
 2014-02-16 01:55:49 +00:00
drh
4a1d365903 Add OP_IdxGT and OP_IdxLE as distinct opcodes. Formerly these operations where 
done using OP_IdxGE and OP_IdxLT with the P5 flag set.  But VDBE code is easier
to read with distinct opcode names.  Also change OP_SeekGe to OP_SeekGE, and
so forth, so that the capitalization is consistent.  The whole point of this
change is to improve the readability of VDBE listings.

FossilOrigin-Name: b6bea903ac8e1717ed50b221d73bd0be061c7663
 2014-02-14 15:13:36 +00:00
drh
e0670b6220 Remove the "rowid cache" that sought to remember the largest rowid for a 
table and thereby speed up OP_NewRowid.  That cache was ineffective.
Removing it results in a performance increase of 0.4%, less memory usage,
and a slightly smaller library size.

FossilOrigin-Name: 56bc5ce8958c8e6250531b4052b905d7ac993db3
 2014-02-12 21:31:12 +00:00
drh
5671ef69ec Sync the latest trunk changes, and in particular the STAT4 IS NOT NULL fix. 
FossilOrigin-Name: b006792695d23980e1923b21915d5c1138ecf29d
 2014-02-11 04:30:29 +00:00
drh
60830e3c53 Improvements to a "Synopsis:" comment in the VDBE engine. 
FossilOrigin-Name: 0dfa7ee9157ea6b1c745732d6c3fcd066cf4f849
 2014-02-10 15:56:34 +00:00
drh
1b27b8c0a0 Faster and smaller implementation of sqlite3_value_type(). 
FossilOrigin-Name: 5708bc24b8cab623b833121183042b43e5a7021b
 2014-02-10 03:21:57 +00:00
drh
5f61229504 Do away with the "multi-register pseudo-table" abstration. Instead, just 
use an OP_SCopy to load results directory from the result registers of
the co-routine.

FossilOrigin-Name: 1e64dd782a126f48d78c43a664844a41d0e6334e
 2014-02-08 23:20:32 +00:00
drh
826af37865 Change the OP_Found opcode so that it expands zero-blobs prior to comparing 
them.  Fix for ticket [fccbde530a6583b]

FossilOrigin-Name: e2303d1b0c17b6e7494fb7db8264f4c2ac193723
 2014-02-08 19:12:21 +00:00
drh
aceb31b120 Change the OP_Trace opcode to OP_Init and give it the ability to jump to the 
initialization code at the bottom of the program, thus avoiding the need for
an extra OP_Goto.

FossilOrigin-Name: 192dea97316144f15f6dd0eabff08a0bf9ef203e
 2014-02-08 01:40:27 +00:00
drh
ed71a839fd Change the OP_InitCoroutine instruction to jump over the co-routine 
implementation.

FossilOrigin-Name: a522f364a6b8ca6f69c353b30609a2166f6e94cf
 2014-02-07 19:18:10 +00:00
drh
81cf13ec7b Get rid of the OP_Undef and OP_IsUndef opcodes in favor of higher-level 
OP_InitCoroutine and OP_EndCoroutine.

FossilOrigin-Name: 1ec0e9dd4b26d9f597adc8e062317d4866c5a6a6
 2014-02-07 18:27:53 +00:00
drh
a5750cfe01 Add the OP_Undef and OP_IsUndef opcodes. With these, use the first register 
in the result register range as the flag to indicate EOF on an INSERT from
a SELECT, rather than allocating a separate boolean register for that task.

FossilOrigin-Name: 6fb7448550f28a3c93053e125faeaf11de1011d0
 2014-02-07 13:20:31 +00:00
mistachkin
21a919f630 More comment updates. No changes to code. 
FossilOrigin-Name: be24fbc22106e508975e316abe0471edd3833291
 2014-02-07 03:28:02 +00:00
drh
0fd613542c Update comments in vdbe.c. No changes to code. 
FossilOrigin-Name: 1122b410de68a3c79b4c719a3a4cc4dc6a5bb39d
 2014-02-07 02:29:45 +00:00
drh
b22f7c831f Delete the OP_VerifySchema opcode. Enhance OP_Transaction to do the schema 
version checks that OP_VerifySchema used to do.

FossilOrigin-Name: 2f3376ebf13df44e6acf27cb1f07172cd8b34033
 2014-02-06 23:56:27 +00:00
drh
e39a732ce2 Provide hints to the btree layer Next and Previous primitives to let them 
know if they can be no-ops if the underlying index is unique.

FossilOrigin-Name: 6c643e45c274e755dc5a1a65673df79261c774be
 2014-02-03 14:04:11 +00:00
drh
19913f4419 Bring in the latest updates from trunk. 
FossilOrigin-Name: 7b5f3773867ed0e4ed17bd473ba972d500035318
 2014-01-28 18:06:17 +00:00
drh
693e671936 Fixes for various clang warnings. 
FossilOrigin-Name: 87bf60637e5863c54c5e2d05aaaca0835b7aace8
 2014-01-24 22:58:00 +00:00
drh
c187698614 Bring in all the latest trunk changes, including the Common Table 
Expressions implementation.

FossilOrigin-Name: 9b43e559195680e558264c4c00d34dc9cf9d9146
 2014-01-24 14:05:18 +00:00
drh
e73f059093 Change the recursive common table expression algorithm to use a queue instead 
of a pair of tables.  Runs about 25% faster on the sudoku solver query. 
The OP_SwapCursors opcode is no longer required.  The current implementation
uses just a fifo, but the plan is to change it into a queue that will support 
ORDER BY and LIMIT in a recursive query.

FossilOrigin-Name: b2671e1133d2f1fbd36e7cd4b86d6cc7b528aa97
 2014-01-21 22:25:45 +00:00
drh
75303a2c68 Add asserts() for a couple of unreachable conditions. Add the Mandelbrot Set 
query as a test case.

FossilOrigin-Name: 2ad4583c0cc7988f0dfe78fd0a2eb0fdb92d835a
 2014-01-18 15:22:53 +00:00
dan
eae73fbfb9 Allow only a single recursive reference in a recursive CTE. Also require that this reference is not part of a sub-query. 
FossilOrigin-Name: a296b73360d34c9364eceb2cc09a9a92adc4abb8
 2014-01-16 18:34:33 +00:00
dan
eede6a538d Fixes so that SQLITE_OMIT_CTE builds work. 
FossilOrigin-Name: 3908e2ea2e7e5f466cbbbffdc27e0fe8dc9751ac
 2014-01-15 19:42:23 +00:00
dan
8ce7184bc2 Add code to handle recursive CTEs. 
FossilOrigin-Name: a5c2a54a07d35166911abc792008c05dea897742
 2014-01-14 20:14:09 +00:00
drh
d9e3c267b4 Merge the latest trunk changes into the sessions branch. 
FossilOrigin-Name: cfd110bf5db2c1993a5e2ca718648bd9c17ee22c
 2013-12-24 12:09:42 +00:00
drh
58c960816f Remove a stray tab character. 
FossilOrigin-Name: 25b8a1c9ba77df3b7c78cbce922cb593d661696d
 2013-12-23 11:33:32 +00:00
drh
4eded604ea Combine adjacent single-register OP_Copy instructions into a single 
multi-register OP_Copy, where possible.  Fix the Synopsis comment for
multi-register OP_Copy instructions to show the correct register ranges.

FossilOrigin-Name: 2ae22dc0cbed2feca4baf89d02aaace0331971d6
 2013-12-20 15:59:20 +00:00
drh
c8d985e09c Merge in all recent preformance enhancements from trunk. 
FossilOrigin-Name: 32477642d79615fb85680bdac812ad9655cf6902
 2013-12-14 18:24:46 +00:00
drh
a9ab481fca Fix harmless compiler warnings. 
FossilOrigin-Name: a7e5fcd66659750eb2f4675082df324e7cf35427
 2013-12-11 11:00:44 +00:00
drh
2dc0648a80 Do not run the tool/vdbe-compress.tcl script that generates the 
vdbeExecUnion object that reduces the size of the sqlite3VdbeExec()
stack frame unless the SQLITE_SMALL_STACK compile-time option is
specified as on of the OPTS in the makefile.  The vdbeExecUnion object
gets in the way of C-compiler optimizer and results in slightly slower code.

FossilOrigin-Name: 4d0781473a465b4ab0a307914014f3d2ddd0ce33
 2013-12-11 00:59:10 +00:00
drh
024045fe6e Avoid unnecessary calls to sqlite3VdbeSerialType() from within 
sqlite3VdbeSerialPut().

FossilOrigin-Name: 079c04a5013074b68f7d90f1ce8bf8e7092ad8a2
 2013-12-10 21:38:08 +00:00
drh
3e6c060fac In the OP_MakeRecord opcode, factor out affinity changes into separate loop, 
for a slight performance advantage.

FossilOrigin-Name: 1c6ee9b85f61e5cdb5d9b7815cddf526dc78aaa7
 2013-12-10 20:53:01 +00:00
drh
038b7bc4ef Simplifications to the OP_MakeRecord opcode and the sqlite3VdbeSerialPut() 
helper function.

FossilOrigin-Name: 7277a769694787e0332d1a4efc02041834661e2a
 2013-12-09 23:17:22 +00:00
drh
a2a3028d5f Reduce the number of times that OP_Column calls sqlite3VdbeMemMakeWriteable(). 
FossilOrigin-Name: 6b51863553e51334880fb322bdf74e51e35d0e61
 2013-12-09 21:06:46 +00:00