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
3,492 Commits 1,785 Branches 392 Tags
version-3.3.9
Commit Graph

111 Commits

Author SHA1 Message Date
drh
b900aaf34a First cut at adding the sqlite3_prepare_v2() API. Test cases added, but 
more testing would be useful.  Still need to update the documentation. (CVS 3506)

FossilOrigin-Name: f1efae9224170c9155afcf17ab3ee769a557b874
 2006-11-09 00:24:53 +00:00
drh
edb193b766 Changes so that it will build with SQLITE_OMIT_VIRTUALTABLE=1. (CVS 3309) 
FossilOrigin-Name: 5612b287059c75488f995625d447c4e9521d1637
 2006-06-27 13:20:21 +00:00
danielk1977
cc013f891c Clean up and clarify code in test8.c. (CVS 3289) 
FossilOrigin-Name: 4acf7594a6c47142e7112d2cd9766a563401879b
 2006-06-24 06:36:11 +00:00
danielk1977
212b218c88 Allow xDestroy methods to execute "DROP TABLE" statements. (CVS 3287) 
FossilOrigin-Name: a56bfa560425a5dc9273229f8838471dfc402024
 2006-06-23 14:32:08 +00:00
danielk1977
be71889703 Add tests and fixes for handling malloc() failures related to the virtual table feature. (CVS 3285) 
FossilOrigin-Name: 5d1d907189ff3ca7afada83033280cf258984ac0
 2006-06-23 08:05:19 +00:00
drh
9eff616750 Added code to iterate through virtual tables. All regression tests pass 
but the new code is completely untested. (CVS 3219)

FossilOrigin-Name: 010965433140fbe508a907d861dbad79343bf7c2
 2006-06-12 21:59:13 +00:00
drh
3bc0e05c61 Make provisions in the code to support Provisions to support caching of 
serialized statements in the SSE extension. (CVS 3139)

FossilOrigin-Name: 5048fae04227857c064c0ba48eb11bedeb467df0
 2006-03-16 14:05:14 +00:00
drh
74161705f1 Remove unused parameters on internal APIs. Suppress warnings from 
CodeWarrior. (CVS 3110)

FossilOrigin-Name: 4b22e4b847f8d5c29830baea541194ef3a0c4811
 2006-02-24 02:53:49 +00:00
drh
90669c1dca Fix and test the processing of sqlite3_result_error() withing aggregate 
functions.  Allow errors to come from the step function (a new
capability).  Ticket #1632. (CVS 2981)

FossilOrigin-Name: fd4a6bb1ac94d085dda247799c0a5c64aaeec046
 2006-01-20 15:45:36 +00:00
drh
76873ab240 Invalidate all VDBE cursor row caches in between calls to sqlite3_step() 
since the emphemeral content that those caches point to might change if
the statement is READ UNCOMMITTED. (CVS 2886)

FossilOrigin-Name: 0ae461313c1642a49a9f6cda608c42c7c0053ce4
 2006-01-07 18:48:26 +00:00
drh
d946db0064 Add serial-types 8 and 9 for integer constants of 0 and 1 that use zero 
bytes of storage.  Make the default file format 4.  Add the
SQLITE_DEFAULT_FILE_FORMAT compile-time option to lower the default
file format number so that newly created databases can be read and
written by older versions of SQLite. (CVS 2845)

FossilOrigin-Name: ae301db8a61a74bc72f67f5766811d89a3b3ec72
 2005-12-29 19:23:06 +00:00
danielk1977
94eb6a14cb Add the sqlite3_update_hook() API. (CVS 2820) 
FossilOrigin-Name: 36229018817eebfbfca7a66d2285e4faf7b39845
 2005-12-15 15:22:08 +00:00
drh
94c1f6f731 Preserve 64-bit last insert rowids across triggers. (CVS 2779) 
FossilOrigin-Name: 4dd7cfaa587fd5f76a0b60db0f02d5f57f801564
 2005-11-25 02:43:50 +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
bbdc2b94fc Work around limitations of MSVC++ 6. Tickets #1429, #1437, and #1440. (CVS 2720) 
FossilOrigin-Name: b2d1803c25b0b823c9cbe27989bacb730b18b45b
 2005-09-19 12:53:18 +00:00
drh
a10a34b88f Bug fixes in aggregate processing. Fewer tests fail. (CVS 2663) 
FossilOrigin-Name: c3ac58592f5e6305640868cdf42c129f1a25255d
 2005-09-07 22:09:48 +00:00
drh
13449892ef Rewrite the aggregate handling logic so that it runs in O(1) space. 
This is the first cut at the code.  Many regression tests fail. (CVS 2662)

FossilOrigin-Name: 17039ec3ff4396862beedf4a8af89654b2140f58
 2005-09-07 21:22:45 +00:00
drh
abfcea25ea Cleanup the processing of MEM_Agg elements. (CVS 2660) 
FossilOrigin-Name: 7ecf3654aa9a275a4cf0c3ec5f63a8c1e0a11fc9
 2005-09-06 20:36:48 +00:00
drh
4db38a7092 All regression tests now pass with the new bounded-memory sort code. 
There is still lots of opportunity for optimization, however. (CVS 2654)

FossilOrigin-Name: 81259a01f1e85ba50a1d017b1282bf841b16f0a5
 2005-09-01 12:16:28 +00:00
drh
0342b1f542 Sorting is now done using a sorting index rather than loading the entire 
result set into memory and doing a merge sort.  The old merge sort technique
was a carry-over from SQLite version 1.  The new method uses a bounded amount
of memory and scales to much larger result sets.  There are still errors:
some 39 regression tests fail. (CVS 2653)

FossilOrigin-Name: 09db0a24241f9248584250d1728117b8a3159626
 2005-09-01 03:07:44 +00:00
drh
19e2d37f1d Increase resolution of time-of-day on unix. Add an experimental 
sqlite3_profile() API. (CVS 2639)

FossilOrigin-Name: ed2ca0873fa89d6cfd123541d5d1c6b92c72b6ab
 2005-08-29 23:00:03 +00:00
drh
0f77f5dc0b Additional defense against the rowid-fifo overflow problem. (CVS 2622) 
FossilOrigin-Name: 881dcf5fb16997830ff347d2eb2610784b415f25
 2005-08-24 17:07:37 +00:00
drh
a01f79df49 Replace OP_List with OP_Fifo. This is the first step toward allowing 
recursive delete triggers and later foreign keys with cascading deletes. (CVS 2538)

FossilOrigin-Name: 94c120bb782fed53142317d1755e70c858930486
 2005-07-08 13:07:59 +00:00
drh
f0863fe568 Update older opcode names to be more meaningful in light of the latest 
code design. (CVS 2506)

FossilOrigin-Name: 36f2da1f8d8d434f861ecad55c9d86549751c954
 2005-06-12 21:35:51 +00:00
drh
495c09a49a Make the ORDER BY clause return equal elements in the same order they were 
seen (a stable sort).  It was returning them in exactly the reverse order. (CVS 2439)

FossilOrigin-Name: e8391491a68018406e30c2a699a4cab9e0de092c
 2005-04-01 10:47:40 +00:00
danielk1977
7a5147c5c9 Change 'stack' to the more descriptive 'no-push' in vdbe.c. (CVS 2429) 
FossilOrigin-Name: 7e54d3c7289c091d449844d21b923e553f1d1f5f
 2005-03-29 13:07:00 +00:00
danielk1977
bc04f8529d Reduce the space allocated for the runtime virtual machine stack. (CVS 2428) 
FossilOrigin-Name: 7d6818da33a87076d1faf35ffc15a3aada0533b3
 2005-03-29 08:26:13 +00:00
danielk1977
b3bce66232 Modify sub-query handling. Tickets #1083 and #1084. (CVS 2286) 
FossilOrigin-Name: b1b50f315873a8614920d1e3af4a07fb29a7ff6a
 2005-01-29 08:32:43 +00:00
drh
d89bd007ba Add the experimental sqlite3_expired() API. (CVS 2263) 
FossilOrigin-Name: df648d50c0696cf7ada2fe5973d285b494891964
 2005-01-22 03:03:54 +00:00
danielk1977
8b60e0f142 Tests to improve coverage of vdbeaux.c. (CVS 2201) 
FossilOrigin-Name: 2b3e21ce2e8126ec2851751546094c3a2c831942
 2005-01-12 09:10:39 +00:00
drh
81db88e630 Remove the unused sqlite3_context.isStep element. (CVS 2156) 
FossilOrigin-Name: 7b20f2b71f679e72b6cb3b78ccb31b4e7c4bd48b
 2004-12-07 12:29:17 +00:00
drh
344737f60a Merge the ListPush and ListPop VDBE opcodes into ContextPush and ContextPop. (CVS 1972) 
FossilOrigin-Name: eb9b501ad8b0fa0fd63a67ece05fe142d6a19114
 2004-09-19 00:50:20 +00:00
drh
9bb575fd72 Fix a naming conflict between sqlite versions 2 and 3. An open sqlite3 
connection now *must* be called "sqlite3".  You cannot call it "sqlite".
This might break existing code. (CVS 1941)

FossilOrigin-Name: 3ddf5a9d1c480a2e3aa32685879063b11afddbe1
 2004-09-06 17:24:11 +00:00
drh
92f02c31d4 Transactions commit on the last sqlite3_step(), not on sqlite3_finalize(). 
This allows the sqlite3_step() to return SQLITE_BUSY if the commit is
blocked by a lock.  Ticket #885. (CVS 1928)

FossilOrigin-Name: d1b29156558f1c576002cdb2544dffaa693da39b
 2004-09-02 14:57:08 +00:00
drh
febe1060f9 Memory handling fixes and optimizations in the VDBE. Ticket #862. (CVS 1909) 
FossilOrigin-Name: 5f8d246852c7cefd5941b8c7bb22177dfc7157c5
 2004-08-28 18:17:48 +00:00
drh
290c19482e Optimizations to the code generator. (CVS 1899) 
FossilOrigin-Name: bd6649c5aae1bf182610eb267b546c297a34481d
 2004-08-21 17:54:45 +00:00
drh
895d747226 Add support for named wildcards in SQL statements. (CVS 1897) 
FossilOrigin-Name: d3be0b7c5a39c02b9b2d6d85f1595d591984a569
 2004-08-20 16:02:39 +00:00
drh
3f7d4e49d8 Fix more problems with deferred execution of CREATE. Still need to do DROP. 
There is now a memory leak. (CVS 1865)

FossilOrigin-Name: 6db3f122aad25b5226670ce682b7263d55c0d301
 2004-07-24 14:35:58 +00:00
drh
91b48aa1af When a statement causes a ROLLBACK due to an ON CONFLICT clause, other active 
VMs abort. (CVS 1778)

FossilOrigin-Name: 0fedf74e30026afe2c8caacff3d62cf5c1b1f528
 2004-06-30 11:14:18 +00:00
drh
6a6124e27a Fix a bug in the handling of Mems inside of vdbe.c. (CVS 1745) 
FossilOrigin-Name: ad65c6e24e15966d5fd15d60f81487ff97788da4
 2004-06-27 01:56:33 +00:00
drh
1b743be858 Be careful to initialize the Mem.xDel field to zero for static Mems. (CVS 1671) 
FossilOrigin-Name: e17ea666b1eb1df12a1d4d78bda2e025e2aa30bd
 2004-06-22 22:04:46 +00:00
drh
efad99959b Patch around compilers that do not support "long long int". (CVS 1656) 
FossilOrigin-Name: d98b1502e2947d24ab9f4a5d2e5b9a95dde92faf
 2004-06-22 12:13:55 +00:00
danielk1977
e159fdf21c Avoid opening a temp table for aggregate queries with no GROUP BY clause. (CVS 1649) 
FossilOrigin-Name: 4d02df63496091a1e643601f84313f42130d6282
 2004-06-21 10:45:06 +00:00
danielk1977
b28af71a22 Update sqlite3_changes() to match the documentation and add 
sqlite3_total_changes(). (CVS 1645)

FossilOrigin-Name: ae2f4a0943854fedbbb6fab1dc3aaf972722ed95
 2004-06-21 06:50:26 +00:00
drh
f92c7ff74a Clear up another zero-length array. This seems to fix the segfault in 
func-13.4 too. (CVS 1641)

FossilOrigin-Name: 70680a34b4b617286d92730bd3042b8b569b3371
 2004-06-19 15:40:23 +00:00
drh
998da3a287 Fix problems with the WatCom C compiler: Arrays must contain at least one 
element.  sqlite3FreeX declared properly.  Don't allow run-time expression
(the SQLITE_UTF16NATIVE macro) in an array initializer. (CVS 1640)

FossilOrigin-Name: fbfc3c95a8abf25bb9e2b44cfeb7186c5b0591d7
 2004-06-19 15:22:56 +00:00
danielk1977
5314c4d7ab Fix a couple of gcc warnings. (CVS 1615) 
FossilOrigin-Name: 960f55f3ecbef4581c8cb7be860023ba10de4e96
 2004-06-18 06:02:35 +00:00
danielk1977
bfd6cce56b Optimisation for unicode encoding conversion routines. (CVS 1614) 
FossilOrigin-Name: 39a415eaa65964742e40b7ea4d471fa04007c6c9
 2004-06-18 04:24:54 +00:00
danielk1977
b20e56b451 Memory leak fixes for tests in file select1.test. (CVS 1599) 
FossilOrigin-Name: 59db58ebd30cd7c79c32f5a725620e740eff661d
 2004-06-15 13:36:30 +00:00