database/sqlite
1
0
Fork 0
mirror of https://github.com/sqlite/sqlite.git synced 2025-11-18 10:21:03 +03:00
Code Activity
29,836 Commits 1,610 Branches 185 Tags
json-opt
Commit Graph

19158 Commits

Author SHA1 Message Date
danielk1977
eca7e01a71 Fix a memory leak to do with the recent UNION ALL sub-select optimization. (CVS 5333) 
FossilOrigin-Name: 6ee71f4ddb4fa934f58c87dad2d30560af2e55d7
 2008-07-01 16:05:25 +00:00
danielk1977
4b86ef1d87 Fix a problem with LIMIT and OFFSET clauses on the parent query when optimizing a UNION ALL sub-select. (CVS 5332) 
FossilOrigin-Name: a79786a961dba8f4ffaddbe55e6467c14b12f7d6
 2008-07-01 14:39:35 +00:00
danielk1977
f23329a221 Optimize sub-selects and views that use UNION ALL. This optimization isn't very well tested yet. (CVS 5331) 
FossilOrigin-Name: 3ef468e7046b2091b5b6880fe19261ef1ee2887b
 2008-07-01 14:09:13 +00:00
danielk1977
daf79acb68 Call the query flattener while processing the parent query. Previously, it was called while processing the sub-queries. (CVS 5330) 
FossilOrigin-Name: 6fcb3bffe26ae1c21c72ce9019f1db1c118094a4
 2008-06-30 18:12:28 +00:00
danielk1977
63703a42f1 Changes to loadext.test so that it works on osx as well as linux. (CVS 5329) 
FossilOrigin-Name: 189cd85413a2e00696752bb82e7a442e86e621ac
 2008-06-30 15:09:29 +00:00
danielk1977
6cb427f5c4 Fix a malloc() failure related problem in os_unix.c. (CVS 5328) 
FossilOrigin-Name: ba8819a6f3dbc45d88346789de42971aacc0d246
 2008-06-30 10:16:04 +00:00
danielk1977
986fbb8e30 Remove an assert() that was failing if there were any open incremental blob handles when a statement transaction was rolled back. (CVS 5326) 
FossilOrigin-Name: f66491ab2ba3645d4e44e33ec6fa0ab94b2989be
 2008-06-28 15:33:24 +00:00
mihailim
65df9db007 Added reminder message to terminate SQL statements with a semicolon on shell startup. This closes #3099. (CVS 5325) 
FossilOrigin-Name: 0ab0b030dea03ec6693358b733329328828cf802
 2008-06-28 11:29:22 +00:00
danielk1977
e339d65a89 Rearrange some ENABLE_LOCKING_STYLE related code in os_unix.c. (CVS 5324) 
FossilOrigin-Name: f70d552bcd0df884eea2e2272bae558d35fc8845
 2008-06-28 11:23:00 +00:00
mihailim
7ffb2b5f35 Changed copy-paste error in comment. Fixes #3193. (CVS 5323) 
FossilOrigin-Name: 00eee53e8626591c4a0c61fe35735ec95ab3ef72
 2008-06-27 18:59:44 +00:00
drh
cf538f411d Documentation tweaks. (CVS 5322) 
FossilOrigin-Name: fcbd39344c0bf3a734bab6606d3988810b69b7d5
 2008-06-27 14:51:52 +00:00
danielk1977
0d84e5b2a7 Fix mem3.c (broken by (5320)). (CVS 5321) 
FossilOrigin-Name: fef90a21aea11f15371d3fcf44548d786dd8819b
 2008-06-27 14:05:24 +00:00
danielk1977
5099be5e85 Change mem5.c so that the minimum allocation size is runtime configurable. (CVS 5320) 
FossilOrigin-Name: 4f95f4cdf77e134fab42148e10198c7b008d4ae6
 2008-06-27 13:27:03 +00:00
drh
6fccc35a91 Remove unused variable. Fix a compiler warning. (CVS 5319) 
FossilOrigin-Name: 0b01ec5cf7725a02d4c12167df125cef578f6219
 2008-06-27 00:52:45 +00:00
drh
66ba23ce86 Tweaks to the IN expression code generator. Fix an an unrelated bug 
in the compound SELECT code generator. (CVS 5318)

FossilOrigin-Name: a4005782690f022e982df4873779a029b28b9306
 2008-06-27 00:47:28 +00:00
drh
3c31fc23b1 Fix a bug introduced by check-in (5316). Add some VDBE comments to 
the IN expression code generator. (CVS 5317)

FossilOrigin-Name: 1043a605e2dcad4b5222674efe392ee9915dc57d
 2008-06-26 21:45:26 +00:00
drh
ecc31805da Avoid generating unnecessary SCopy instructions with the RHS of an IN 
operator is a list of values. (CVS 5316)

FossilOrigin-Name: ec80474b1c157a29fb6978dd5575c396c57973b3
 2008-06-26 20:06:06 +00:00
drh
4ead1482d8 Documentation updates in sqlite.h.in. No changes to code. (CVS 5315) 
FossilOrigin-Name: 168fd6f83e2c837e91d02fa49fff3fe2f9538928
 2008-06-26 18:16:05 +00:00
danielk1977
0cdc022e88 Fix handling of "x IN (...)" and "x NOT IN (...)" expressions when the set contains an SQL NULL value. (CVS 5314) 
FossilOrigin-Name: d45a97be71fa61ab4a692bd807ab762130f7f5b9
 2008-06-26 18:04:03 +00:00
drh
9de1b35189 Document the rules for when an sqlite3_blob object expires. (CVS 5313) 
FossilOrigin-Name: e1de2287fd9b067f687cb8b427786b878af6c5b7
 2008-06-26 15:04:57 +00:00
danielk1977
b06a0b67c4 Change the TEMP_STORE preprocessor symbol to SQLITE_TEMP_STORE. (CVS 5312) 
FossilOrigin-Name: 1e3b8308021107d983d2152663f62b369cca091d
 2008-06-26 10:54:12 +00:00
danielk1977
29bafeabcd Change the OS_XXX pre-processor symbols to SQLITE_OS_XXX. Symbols "OS_UNIX", "OS_WIN", "OS_WINCE", "OS_OS2" and "OS_OTHER" are now "SQLITE_OS_UNIX", "SQLITE_OS_WIN", "SQLITE_OS_WINCE", "SQLITE_OS_OS2" and "SQLITE_OS_OTHER", respectively. (CVS 5311) 
FossilOrigin-Name: cdd4cf4ce2ab363ddc3f27c5e44896e17269a161
 2008-06-26 10:41:19 +00:00
danielk1977
71bc31c68d Fix a race condition in sqlite3_initialize(). (CVS 5310) 
FossilOrigin-Name: 70b2ed2afcf1757d1c58f3a83dad4a5fb226ae63
 2008-06-26 08:29:34 +00:00
drh
4766b29d95 Documentation updates. No changes to code. (CVS 5309) 
FossilOrigin-Name: cdc4e75a9f1e3c79ade92344cf32a4225222d44f
 2008-06-26 02:53:02 +00:00
danielk1977
c0fa4c5f32 Remove internal function sqlite3OsDefaultVfs(). The built-in VFS layers now register their VFS implementations by calling sqlite3_vfs_register() from within sqlite3_os_init(). (CVS 5307) 
FossilOrigin-Name: 8fa33b79d7369ec5777fd9ad3349f0fa31b98fd6
 2008-06-25 17:19:00 +00:00
danielk1977
6b39c2e40b Have mem3.c and mem5.c grab a mutex when required. Include them both in the amalgamation again. (CVS 5306) 
FossilOrigin-Name: 9e3c95ff4048cd8e4c56acf7a8ebedc49621e9c7
 2008-06-25 14:57:53 +00:00
danielk1977
c66c0e14a6 Fix the allocator in mem5.c so that it can be enabled at run time using the sqlite3_config() function. (CVS 5304) 
FossilOrigin-Name: 30ff6bb0b2d1068d28e86ac90bb9f454e4537a2d
 2008-06-25 14:26:07 +00:00
danielk1977
32155ef0ff Fix up some details to do with the mem3.c (memsys3) allocator. If the library is compiled with SQLITE_ENABLE_MEMSYS3, the memsys3 allocator can be selected at runtime. (CVS 5303) 
FossilOrigin-Name: 9c6c8e01b31abfe2bc8e650bbfdb504021dc7e59
 2008-06-25 10:34:34 +00:00
drh
ff354e91ba If a unique index covers any prefix of the ORDER BY clause then let it 
satisfy the ORDER BY clause. (CVS 5301)

FossilOrigin-Name: e53403b6d742be83c5b130ed6cef4035d081d613
 2008-06-25 02:47:57 +00:00
drh
0acb7e4849 The compound-select merge optimization passes quick.test with no errors. (CVS 5299) 
FossilOrigin-Name: 8bbfa97837a74ef0514e0c92ea2a6576f02cc361
 2008-06-25 00:12:41 +00:00
pweilbacher
91ef8f45c4 OS/2 fixes for pre-C99 compilers and a return code correction in os2Access(). (CVS 5298) 
FossilOrigin-Name: 3241a3bdd08f6abf3f1655152e296cc7ebe73bca
 2008-06-24 22:50:06 +00:00
danielk1977
57e5ea9327 Modify the memory allocation system in mem3.c so to fit in with the new sqlite3_mem_methods scheme. At this point it only "mostly" works. (CVS 5297) 
FossilOrigin-Name: 3febef548fb1c314336fe4bc359d72a4fe84e84e
 2008-06-24 19:02:55 +00:00
drh
f6e369a119 Fix a problem in sqlite3ExprIsInteger() causing failures on select1-4.9.2. 
Other bug fixes in compound-merge.  The compound-merge is still disabled
in this check-in using "#if 0" due to additional bugs. (CVS 5295)

FossilOrigin-Name: 95037e6dbf4ed0ffd38790f3270dcaa4c1ae64ed
 2008-06-24 12:46:30 +00:00
danielk1977
c001fc3c24 Fix a typo in the documentation for the sqlite3_bind_XXX() APIs. (CVS 5292) 
FossilOrigin-Name: 839457f128c91a20aeae7ba570b4840792d41239
 2008-06-24 09:52:39 +00:00
drh
92b01d53c2 The compound-select merge optimization is mostly working with this check-in. 
But there are still a few problems and so the optimization is disabled by
and "#if 0".  This check-in is to synchronize with the other changes happening
in parallel. (CVS 5291)

FossilOrigin-Name: e2ba324cbcac0ba35bbde50048677e085abb092b
 2008-06-24 00:32:35 +00:00
pweilbacher
261696416b Update OS/2 mutex implementation: make methods static and don't use them by the old names any more. Held/Notheld should be debug only. (CVS 5290) 
FossilOrigin-Name: d92418ca502f5f58dc968668e11c42955a7b1e52
 2008-06-23 22:13:27 +00:00
mihailim
57c591aa92 Reverted previous checkin (on second thought, changing case could break badly written homegrown parsers such as sometimes encountered in embedded firmware.) (CVS 5289) 
FossilOrigin-Name: bf2e283d6fd40cabe55864b06b502524eb8a3b07
 2008-06-23 21:26:05 +00:00
mihailim
d3d259dcb7 Changed HTML mode output to use lowercase tags making good on the XHTML output promise (the DTDs indeed mandate lowercase) and closing #450. (CVS 5288) 
FossilOrigin-Name: e07ed82caf5e4706ef564271830112d31e8cff7c
 2008-06-23 21:18:10 +00:00
danielk1977
f7b9d66fd4 Fix a bug in handling queries on the sqlite_master table with an empty (0 bytes in size) database file. (CVS 5286) 
FossilOrigin-Name: f8238770bf41e17014c6de05363b759304fc80de
 2008-06-23 18:49:43 +00:00
danielk1977
27a430cc84 Fix a failure to report a failed malloc() within sqlite3_create_module(). (CVS 5284) 
FossilOrigin-Name: 3ca7dab88e030cc945e0d358d7f53ddca35bc221
 2008-06-23 17:44:18 +00:00
danielk1977
8cf6c554c0 Fix a bug causing the pager-cache size to be reset to its default value whenever the database schema was reloaded. (CVS 5283) 
FossilOrigin-Name: 6dbe67da5cb0141e011b4fdcc3964a20f68be843
 2008-06-23 16:53:46 +00:00
danielk1977
950292fbb8 Handle a real system malloc() failure in mem1.c. (CVS 5281) 
FossilOrigin-Name: 006fd69bf56f05448fd9aa82d3b1cdcc175369ad
 2008-06-23 15:10:24 +00:00
danielk1977
834a5aab16 Remove a non-ansi construct from mem1.c - an assert() statement before the variable declarations in a function. (CVS 5280) 
FossilOrigin-Name: 1de98da6b4c2039e5dc594cc9bfc7d49ae36697c
 2008-06-23 14:40:18 +00:00
danielk1977
ca02679635 Avoid passing "void(*)(void)" as an argument to va_arg(). Codewarrior doesn't like it. (CVS 5279) 
FossilOrigin-Name: edae76d6ff5918007c0a802a34e65412f8f0ebb6
 2008-06-23 14:15:52 +00:00
danielk1977
867d05a019 Fix some codewarrior compilation problems. (CVS 5278) 
FossilOrigin-Name: e6ea8f87c102bd36ab0f2fbc8360fde49f4e3422
 2008-06-23 14:03:45 +00:00
danielk1977
5dfecba1a4 Fix a compilation problem with SQLITE_OMIT_VIRTUAL_TABLE is defined. (CVS 5277) 
FossilOrigin-Name: 0421c09967a191fb62338eb8b1bd766be42f61cc
 2008-06-23 13:57:21 +00:00
mihailim
bda2e62c55 Fixed wrong type in sqlite3_create_collation16 declaration and definition (UTF-16 string had been passed as const char* instead of const void*) (CVS 5276) 
FossilOrigin-Name: 4215e3e5ae3376bd46e5e12eec14b8209c164830
 2008-06-23 11:23:14 +00:00
danielk1977
8468024da8 Correct comments above sqlite3_release_memory() and sqlite3_soft_heap_limit(). Ticket #3138. (CVS 5275) 
FossilOrigin-Name: 3240446853a11f5a1e379d4841d0268873aad64d
 2008-06-23 11:11:35 +00:00
danielk1977
171bfed311 Fix a bug whereby opening a connection to an existing shared-cache caused the cache-size (the value configured by "PRAGMA cache_size") to revert to its default value. (CVS 5274) 
FossilOrigin-Name: 0492aa8ed3c35dd2cdfc69c9cb87e43ef0460826
 2008-06-23 09:50:50 +00:00
mihailim
421dfca16b Removed INVARIANTS sections in the experimental extension loading API that I should not have added in the first place. No changes to code. (CVS 5273) 
FossilOrigin-Name: e7610890b4df78af5bb8f3e8f8d05ef5cf36e186
 2008-06-22 16:35:48 +00:00