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,720 Commits 1,570 Branches 184 Tags
bedrock
Commit Graph

289 Commits

Author SHA1 Message Date
drh
1db639cef3 Registerification of the WHERE clause logic. (CVS 4716) 
FossilOrigin-Name: b3a141b2b0c09bf3c7704deeade290d71b7c9b77
 2008-01-17 02:36:28 +00:00
drh
b765411161 Continuing work toward converting the VM into a register machine. (CVS 4707) 
FossilOrigin-Name: a6dddebcc5ccbbf3009c9d06163a8b59036331de
 2008-01-12 12:48:07 +00:00
drh
2d401ab8f9 More work toward converting the VM into a register-based machine. (CVS 4704) 
FossilOrigin-Name: 8cbd46517f407b3b1ce187b623db10f00aa415ea
 2008-01-10 23:50:11 +00:00
drh
98757157ee All essential opcodes can now operate out of registers and completely 
avoid the stack.  Many still optionally use the stack to support legacy
code generation, but the stack is not required.  The next step is to
update all code generation to avoid using the stack. (CVS 4700)

FossilOrigin-Name: e3cf1c1c114bcda8fe577beb5ee55b4a651b96db
 2008-01-09 23:04:12 +00:00
drh
3557335658 Registerify the comparison opcodes. (CVS 4697) 
FossilOrigin-Name: 8862ce9ceefba4f5d1ffbd51d824c05f42a58c22
 2008-01-08 23:54:25 +00:00
drh
5b6afba924 Registerify binary operators. Add register tracing to debugging output. (CVS 4686) 
FossilOrigin-Name: 66396d2f0289e36b5fc0af5078c08d1b17f342ae
 2008-01-05 16:29:28 +00:00
drh
8558cde1ab Register-ify the OP_AddImm and all casting opcodes. Omit the 
OP_MemIncr opcode. (CVS 4683)

FossilOrigin-Name: 3e8a07dd3cc9921ad39e379576abb0b485a42202
 2008-01-05 05:20:10 +00:00
drh
b1fdb2adea Get rid of OP_Dup, OP_MemStore, OP_MemLoad, and OP_MemMove. Replace 
with OP_Copy, OP_SCopy, and OP_Move.  Add the infrastructure for
operation properties in1, in2, in3, out2, and out3 but do not yet
use any of these. (CVS 4682)

FossilOrigin-Name: cc149eb9ca3c672cc6fea3528353234ac2ed5745
 2008-01-05 04:06:03 +00:00
drh
4c583128bd Implement the out2-prerelease opcode design pattern. (CVS 4681) 
FossilOrigin-Name: fe057a88d0038ac349ea41883b979ceba6ae410a
 2008-01-04 22:01:03 +00:00
drh
0a07c107a6 Registers (aka memory cells) in the VM are now numbered starting with 1 
instead of 0.  A register number of 0 means "no such register". (CVS 4669)

FossilOrigin-Name: 0b849805c3a0f562d50623f406279b400d335639
 2008-01-03 18:03:08 +00:00
danielk1977
1f4aa337cd Change the OP_Insert opcode to read the key and data to insert from memory cells, not the stack. (CVS 4666) 
FossilOrigin-Name: 46501f490a5f5577ea31c758df749e02c7c65f39
 2008-01-03 09:51:55 +00:00
danielk1977
207872a488 Change OP_OpenRead and OP_OpenWrite so that the database number is read from the P3 operand, not the stack. (CVS 4663) 
FossilOrigin-Name: 35da261daf602b1e938f05bbad1ff99213d9f4b9
 2008-01-03 07:54:23 +00:00
drh
66a5167b47 Refactoring the VM. The P3 parameter is changed to P4. A P5 parameter is 
added (though not currently used.)  Add routines sqlite3VdbeAddOpX() where
X is one of 0, 1, 2, 3, or 4. (CVS 4660)

FossilOrigin-Name: 027875e4d4c4bd7686dc880c6917a968049b2fec
 2008-01-03 00:01:23 +00:00
drh
a2a49dc9df Add opcodes OP_ResultRow and OP_RegMakeRec which are register-based 
equivalents to OP_Callback and OP_MakeRecord.  Use the new opcodes. (CVS 4656)

FossilOrigin-Name: 4c7f35da7751c61a9b61b1d95adddcc37fff3266
 2008-01-02 14:28:13 +00:00
drh
d4e70ebd6f Begin setting a foundation on which to convert the VM from a stack-based 
to a register-based machine.  Everything is still mostly stack based with
this check-in.  This change merely begins adding infrastructure to support
a register-based architecture. (CVS 4652)

FossilOrigin-Name: 051ec01f2799e095516015f2ef0180e50fac387c
 2008-01-02 00:34:36 +00:00
danielk1977
b8b4bfa061 Fix a segfault that can occur after a malloc failure in an ANALYZE statement. Ticket #2772. (CVS 4544) 
FossilOrigin-Name: d05eb67dd6e171cfe8b9528aa3c7c953780d8c82
 2007-11-15 13:10:22 +00:00
drh
ff0587c632 Improvements to mutex asserts. The quick test runs to completion without 
assertion faults. (CVS 4324)

FossilOrigin-Name: 2732af0ec77dbc90c0439b6a61d893d9ea3b5697
 2007-08-29 17:43:19 +00:00
drh
1fee73e74a Better asserts(). But now some of the tests are busted again. (CVS 4320) 
FossilOrigin-Name: e8060f85e7871572e2a38dc96f03e6e1f34cc8fd
 2007-08-29 04:00:57 +00:00
danielk1977
1e5369531e More work on refactoring of malloc() interfaces. There are still many errors. (CVS 4233) 
FossilOrigin-Name: 77b1671351fe94b0ebc126a63140643deae2aa64
 2007-08-16 10:09:01 +00:00
drh
174357527a Half-way through a major refactoring of the memory allocation. 
I have not even attempted to compile so I am certain there are
countless errors. (CVS 4231)

FossilOrigin-Name: deb7ecd65f7b83eaf0ba610eeef3b0ede61db1c3
 2007-08-16 04:30:38 +00:00
drh
4c1038388e Fix comment typo in analyze.c. Ticket #2434. (CVS 4101) 
FossilOrigin-Name: df9957b94737b76ed7b1de77bb22bb27c7ae2dcf
 2007-06-20 13:37:31 +00:00
drh
cf1be45fe2 Make the ANALYZE command robust in the face of malloc() failures. (CVS 3989) 
FossilOrigin-Name: c08658e1f8598941ebddddb98942b98cfcb86e7a
 2007-05-12 12:08:51 +00:00
drh
e4d9081307 Change BtreeMoveto so that it can be biased to the right or to the center. 
Use a right bias when appending and a center bias when searching.  This
gives about a 15% reduction in calls to sqlite3VdbeRecordCompare. (CVS 3741)

FossilOrigin-Name: ad4a6b1a91bcefd8a4c75e8dc99c1153c72c31a3
 2007-03-29 05:51:49 +00:00
danielk1977
b3bf556ef6 Store collation sequence names instead of pointers in sharable schema data structures. (CVS 2904) 
FossilOrigin-Name: 0f0213be4d064b3d24e31ff93ec16f6862003d26
 2006-01-10 17:58:23 +00:00
danielk1977
e501b89ada Rename DbSchema to "Schema" and SqliteTsd to "ThreadData". (CVS 2893) 
FossilOrigin-Name: 82b81f69c78cb3f54634d9aea4f6a838474dc5e5
 2006-01-09 06:29:47 +00:00
drh
15007a99e4 Get LIMIT and OFFSET working again for negative limits and offsets. 
Ticket #1586. (CVS 2889)

FossilOrigin-Name: b2ac0be07ec76ab23b7e5b800c0bc62d0bc97f4b
 2006-01-08 18:10:17 +00:00
danielk1977
c00da10565 In shared-cache mode, lock all required tables before beginning to execute the body of the statement program. (CVS 2881) 
FossilOrigin-Name: 23b587b05b89727248805e6d9e5141e018cf2152
 2006-01-07 13:21:04 +00:00
danielk1977
da18423620 Add the shared schema/pager modifications. Very few tests so far. (CVS 2859) 
FossilOrigin-Name: deeda0dc06c1595aedd8d06a0c4e88a8abf78cf7
 2006-01-05 11:34:32 +00:00
drh
8a51256c0c Create separate affinities for INTEGER and REAL. (CVS 2766) 
FossilOrigin-Name: ce06c123d0c5663dbaf263c2e0aaf5d9cdeb2ccd
 2005-11-14 22:29:05 +00:00
drh
8df447f0e6 Omit the SQLITE_AFF_INTEGER type affinity. All numeric values are now 
of type real, though an integer representation is still sometimes used
internally for efficiency. (CVS 2753)

FossilOrigin-Name: e0d6f61c7de2c03b8fd17ef37cf1a0add36ee618
 2005-11-01 15:48:24 +00:00
drh
d654be803f Code cleanup and simplification. Three new Mem opcodes added. 
The sqlite3VdbeJumpHere function added. (CVS 2730)

FossilOrigin-Name: 2471957feee57538e5e1e50a704a337f0927d10e
 2005-09-20 17:42:23 +00:00
drh
0c35667b02 The shell does not output the sqlite_stat1 table on .dump or .schema. 
The ANALYZE command now gathers statistics on tables that have only
a single index because this sometimes helps when reordering tables
in a join. (CVS 2686)

FossilOrigin-Name: 26565b8931419031f9a8dd3947e1e2bd23ccbff2
 2005-09-10 22:40:53 +00:00
drh
1ec43c9a5a Fix ANALYZE so that it works even if the empty_result_callbacks pragma is 
enabled. Ticket #1409. (CVS 2659)

FossilOrigin-Name: bfdaef1224d741deefe211e1e607bac4c80f2d89
 2005-09-06 10:26:47 +00:00
drh
51147baa6d A new optimizer that breaks a lot of tests. But none of them critically, I 
think.  Nevertheless, there is a lot of work ahead to stabilize the code. (CVS 2564)

FossilOrigin-Name: 86ce56ccea8297b1fba2b9ee53b5f1a3f228662f
 2005-07-23 22:59:55 +00:00
drh
17a18f2f36 Store the total number of rows as part of the ANALYZE statistics. (CVS 2563) 
FossilOrigin-Name: 868279c78e056d27b2d1bea81127fe689b2ce478
 2005-07-23 14:52:12 +00:00
drh
497e446d76 The results of ANALYZE are now loaded into internal data structures where 
they can be used.  But they are not actually used yet. (CVS 2562)

FossilOrigin-Name: 1996bacfb97180965304e2a6d6784b6ecbbf8575
 2005-07-23 03:18:40 +00:00
drh
e6e049694d Full-coverage testing and documentation for the ANALYZE command. The 
results of analysis are still not loaded or used, however. (CVS 2561)

FossilOrigin-Name: bd7583a5d63412785a9c5de54d25b509da241605
 2005-07-23 02:17:03 +00:00
drh
ff2d5ea408 First code for the ANALYZE command. Mostly untested. The analysis is 
not loaded into the symbol tables and is not used by the optimizer. (CVS 2560)

FossilOrigin-Name: a4886b114d2ccb3841d3d219f6b97f67745b13c2
 2005-07-23 00:41:48 +00:00
drh
9f18e8a0c4 Add infrastructure for the ANALYZE command. Does not yet actually 
do anything. (CVS 2537)

FossilOrigin-Name: 05b6ac9a76fd5765c50e81588f8e71c59fe35ce4
 2005-07-08 12:13:04 +00:00