database/sqlite
1
0
Fork 0
mirror of https://github.com/sqlite/sqlite.git synced 2025-08-05 15:55:57 +03:00
Code Activity
30,154 Commits 1,570 Branches 183 Tags
empty-table-optimizations
Commit Graph

9780 Commits

Author SHA1 Message Date
danielk1977
85574e31cb Allow INDEXED BY and NOT INDEXED clauses in SELECT statements. (CVS 5766) 
FossilOrigin-Name: 98ca5580f5acd2e7b3ce512520ec0527f221505e
 2008-10-06 05:32:18 +00:00
danielk1977
98c408289c Modifications to bind.test to account for different values of SQLITE_MAX_VARIABLE_NUMBER. Ticket #3409. (CVS 5765) 
FossilOrigin-Name: 1a91f3fd58608e258b60305d1d18c3d07d2e9c46
 2008-10-03 09:10:45 +00:00
danielk1977
740ed546fc Change one of the test cases in incrblob2.test to avoid allocating a 10MB block of heap memory. (CVS 5764) 
FossilOrigin-Name: 83b7dd737a16555b9eb4ad9faacac3d705b0a90e
 2008-10-03 08:44:54 +00:00
danielk1977
a8b3018da4 Fix for sqlite3_blob_write(): If either 3rd or 4th argument is less than zero, return SQLITE_ERROR. H17879. (CVS 5762) 
FossilOrigin-Name: f6074c0b9b5ba51d131509dba2aec80d0fcf3b7e
 2008-10-02 14:49:01 +00:00
danielk1977
41a05b7bee Optimize queries that contain "WHERE rowid IN (x, y, z...)" by using an intkey btree to store the (x, y, z...) set instead of an index btree. (CVS 5760) 
FossilOrigin-Name: 803a1736d56b3c07b8ad38715fe0e39196ecc507
 2008-10-02 13:50:55 +00:00
drh
0368072905 Adjust the memory usage bounds on the memsubsys1.test script so that 
it works on amd64. (CVS 5759)

FossilOrigin-Name: aabde23fe19bd95371fdebdde66ac553dfd53f8e
 2008-10-01 13:55:50 +00:00
danielk1977
2d60549926 Fix a bug in where.c where a non-temp register was being incorrectly deallocated. Ticket #3408. (CVS 5758) 
FossilOrigin-Name: 59d2e89e2181c26b18eac68ccc80ea3018f70a5e
 2008-10-01 08:43:03 +00:00
drh
798fadd14c A few minor changes to test scripts so that they work on linux-amd64. (CVS 5752) 
FossilOrigin-Name: 78d075ff38d96cc58659a7097dec0e49402aa960
 2008-09-30 00:31:38 +00:00
danielk1977
47dd228e60 Do not run vacuum.test as part of the "exclusive" permutation test. (CVS 5749) 
FossilOrigin-Name: 2fb15ae9e9af716a5684a21826814bc4c332a596
 2008-09-29 14:27:41 +00:00
danielk1977
7aad2983c9 Update shared_err.test to work with (5668) (return SQLITE_CORRUPT if rollback fails). (CVS 5748) 
FossilOrigin-Name: 292acaf7c4e68b532cc8d1763e02aa79d90ea20c
 2008-09-29 14:12:56 +00:00
danielk1977
71d5d2cd49 Instead of storing a pointer to the parent page in the MemPage structure, have each B-Tree cursor keep track of the ancestry of the current page. (CVS 5747) 
FossilOrigin-Name: 40425e93421286cca1965d7a5769084526210c7a
 2008-09-29 11:49:47 +00:00
drh
04335886a1 Add the "truncate" journal mode which commits transactions by truncating the 
rollback journal file to zero length and not calling fsync(). (CVS 5745)

FossilOrigin-Name: 7c561f2e9264de676c1028943f6c3d06542fd802
 2008-09-26 21:08:08 +00:00
danielk1977
e5dd389698 On windows, avoid running those tests in exclusive.test that require the journal file to be externally accessed while SQLite is holding it open. This doesn't work on windows. (CVS 5742) 
FossilOrigin-Name: 5debf12fa46520946ac5da44c03448fffbc9940c
 2008-09-24 14:03:43 +00:00
danielk1977
0afae93fa4 Fix some function declarations (change "int foo()" to "int foo(void)"). Ticket #3399. (CVS 5740) 
FossilOrigin-Name: 0fb98c35353d8c0a8d669bbe45fe84e3a5060621
 2008-09-24 09:12:46 +00:00
danielk1977
98c21903bd Always transform error code SQLITE_IOERR_NOMEM to SQLITE_NOMEM before returning. This was already happening in most places. (CVS 5738) 
FossilOrigin-Name: 046ef07261d520c9399bd8cdfdfd5281956b7a27
 2008-09-23 16:41:29 +00:00
danielk1977
77eb5bb6f7 Fix a memory leak that can follow a malloc failure in sqlite3_initialize. (CVS 5731) 
FossilOrigin-Name: 118dc0ba082dd9abba5602dafc86bd56e756db86
 2008-09-22 17:22:19 +00:00
drh
695ba06f23 Do not run the async tests if the async module is not installed. (CVS 5722) 
FossilOrigin-Name: 4de71a4e2f59d302156e10efcb288efa23e18598
 2008-09-18 18:18:29 +00:00
danielk1977
b11bcfde08 Changes to test script nan.test to work on symbian. (CVS 5718) 
FossilOrigin-Name: 0889b22a2949160c3f2d06beaa05a867b4c228b3
 2008-09-18 11:30:12 +00:00
danielk1977
3e37f5df5b Changes to test script io.test to work on symbian. (CVS 5717) 
FossilOrigin-Name: 2b41c4959da2ef5a882a658e85ee34d07d31f379
 2008-09-18 11:18:41 +00:00
danielk1977
89bae3ed7a Changes to test scripts to support running on symbian. (CVS 5714) 
FossilOrigin-Name: 6ef34e9d3118965781c69011deaede1ebbb19b12
 2008-09-17 16:14:10 +00:00
drh
d176611b44 Fix for tickets #3378 and #3381 that preserves the aliasing optimization. 
And yet, this fix feels uncomfortable.  Seeking an alternative... (CVS 5712)

FossilOrigin-Name: f8b759f1977915c314be874840ebf18e6bc69b57
 2008-09-17 00:13:12 +00:00
drh
f44ed02790 Add test cases for ticket #3378 and #3381. Add a temporary hack to get those 
to problems fixed.  The hack causes failures in alias.test, but those are much
less serious than the aforementioned tickets.  This is a stop-gap until we can
figure out a proper fix. (CVS 5711)

FossilOrigin-Name: a67da9dd2ff6acc163de4ce2b836b03e3f159a88
 2008-09-16 18:02:47 +00:00
danielk1977
181ddaa184 Use (file nativename (pwd)) instead of just (pwd) to find the name of the current directory to pass to "PRAGMA temp_store_directory" in pragma.test. This helps the test pass on non-unix systems. (CVS 5709) 
FossilOrigin-Name: 50feaa3707f4f61202bc855802ab2e405365d801
 2008-09-16 15:50:11 +00:00
drh
ec8d24279b Add test script selectC.test which demonstrates ticket #3381. (CVS 5708) 
FossilOrigin-Name: 3847faff55d4bd7574785c3b18d5c95e687c7598
 2008-09-16 15:09:53 +00:00
danielk1977
fab1127bd1 If the xAccess() call used by "PRAGMA temp_store_directory = /new/path/" to determine if the supplied directory is writable returns an error, assume the directory is not writable. (CVS 5707) 
FossilOrigin-Name: e8418588f2c23487cefda702849d4546202fd8ec
 2008-09-16 14:38:02 +00:00
drh
5a70d286f5 Add test case for ticket #3376. (CVS 5705) 
FossilOrigin-Name: c64260579d353df3eae8c355b082b8206bc6185b
 2008-09-16 11:58:20 +00:00
drh
b5774cfa8f Adjust the page recycling algorithm so that the number of pages allocated 
to each connection does not exceed its cache_size limit. (CVS 5701)

FossilOrigin-Name: 3bc221b940565133ae8d95f59b3b120e57df0124
 2008-09-15 15:36:57 +00:00
danielk1977
4ff6202642 Fix the async.test test script so that it invokes (finish_test) even if the asynchronous backend is not included in the build (and no tests are run). (CVS 5700) 
FossilOrigin-Name: 5c954b40ecb71203b1013c23cdac54ff83484b0a
 2008-09-15 14:47:21 +00:00
danielk1977
78a906552d Fix the shared_err.test script so that it works if the device supports SQLITE_IOCAP_SAFEAPPEND. (CVS 5699) 
FossilOrigin-Name: 38e5ea070a38fe1656e0f5c3024f28ce67eae725
 2008-09-15 14:42:38 +00:00
drh
f018cc2ef0 Fix issues with bizarrely quoted column names. Tickets #3370, #3371, 
and #3372. (CVS 5696)

FossilOrigin-Name: ced6bbd228b4a324ddb9c5ff15fd027811c8806a
 2008-09-13 01:20:14 +00:00
drh
8578611b95 Fix the NEAR connector in FTS3 so that it can take ranges in excess of 9. 
The maximum range is now 32767. (CVS 5695)

FossilOrigin-Name: 8e9b9553115c42dae38cad0612d98d9a0c453a5c
 2008-09-12 18:25:30 +00:00
danielk1977
755339ec0f Add a case to permutations.test to run tests with the IOCAP_SAFEAPPEND property set. (CVS 5693) 
FossilOrigin-Name: 80bdaafa77ec5c967f633eaaf5ee6f493a6e5a56
 2008-09-12 10:22:40 +00:00
danielk1977
540cf6a192 Add a couple of (fconfigure) commands to configure the incremental blob channels used by test file incrblob.test. This is required so that the tests work on windows and other platforms that have a default -translation mode other than 'lf'. (CVS 5692) 
FossilOrigin-Name: 753caa20ca50bc42d747d934ccc61438790e7f32
 2008-09-11 11:27:59 +00:00
danielk1977
67fd7a9a98 Fix some trivial cases where database corruption was causing an error code other than SQLITE_CORRUPT to be returned. (CVS 5690) 
FossilOrigin-Name: 89fda074f6b4959c32f1083badba3c73cffb4995
 2008-09-10 17:53:35 +00:00
danielk1977
9f580ad886 Fix for handling database files corrupted in such a was as to make a b-tree page a direct or indirect descendant of itself. (CVS 5689) 
FossilOrigin-Name: 93545861a70c190d67b0d1effdd8fe038d28811c
 2008-09-10 14:45:57 +00:00
danielk1977
38816ecf99 Avoid deleting a file while it is still open in corrupt2.test. Not all platforms support this. (CVS 5687) 
FossilOrigin-Name: 099adfd31167a78d803e2992e5f50cf4e292dd43
 2008-09-10 11:28:37 +00:00
danielk1977
f8b10a855e Fix some test script details so that the test suite runs with an SQLITE_DEFAULT_AUTOVACUUM=2 build. (CVS 5686) 
FossilOrigin-Name: 300a64b725a111ee66e38de099314f03b064c6eb
 2008-09-10 10:57:27 +00:00
danielk1977
f2fb044bca Add fuzz3.test. For testing the library's response to corrupted database files. (CVS 5685) 
FossilOrigin-Name: 7fd4dd95791974b0ef6cf30a186b32df25ee2211
 2008-09-09 18:28:06 +00:00
drh
e3602be8fd Calling sqlite3_create_function with nArg==(-1) does not override prior 
calls on the same function name with nArg>=0.  Ticket #3345.  Add the
new -argcount option to the "function" method in the TCL interface. (CVS 5684)

FossilOrigin-Name: 5aa5b8044a14f59559c1839dc0799b0d2f990809
 2008-09-09 12:31:33 +00:00
danielk1977
ff9b2e75b4 If the 'rootpage' column of the sqlite_master table contains a NULL value, return SQLITE_CORRUPT to the caller. (CVS 5681) 
FossilOrigin-Name: a7b7b126e9e9b0cd2d68643d8dff321cf41ce2ee
 2008-09-08 09:06:18 +00:00
danielk1977
fdd8e5bab8 Deallocate a temp register allocated by codeEqualityTerm() in where.c. If it is not deallocated, its value may be reused by the column-cache mechanism. However, by the time it is used, the value may have been clobbered by a sub-routine that also uses the same temp register. Fix for #3357. (CVS 5679) 
FossilOrigin-Name: 7c0f638ef3d7ff9156f07d6fb01448453ffcf5ac
 2008-09-06 14:19:11 +00:00
danielk1977
f7cbfae96a Change pcache.test so that it works if sqlite is configured to create auto-vacuum databases by default. (CVS 5678) 
FossilOrigin-Name: 55e677569ec131c388841f6f453291f737738076
 2008-09-05 05:29:08 +00:00
danielk1977
518002e4ba Fix a problem in btree.c preventing an OOM error from being propagated up to the caller. (CVS 5677) 
FossilOrigin-Name: 0b8ee83f2ebadab099ccd6490f6995949dafdd6f
 2008-09-05 05:02:46 +00:00
drh
cc91e7f83e Make the default threading mode multithread (-nomutex) in the TCL interface. (CVS 5670) 
FossilOrigin-Name: d9e826942673ad048d611c014bfbee39ab5535c8
 2008-09-03 01:08:00 +00:00
drh
039963ad33 Add support for SQLITE_OPEN_FULLMUTEX. (CVS 5669) 
FossilOrigin-Name: f2f361a5e2fb81fb0f99e83ecf8bae9a750723b1
 2008-09-03 00:43:15 +00:00
drh
78f82d1e6c Continuing work on adding full support for the SQLITE_OMIT_WSD 
compile-time option. (CVS 5658)

FossilOrigin-Name: ef26ea5c46d3915d206f8ff7f82a24f4c8955f1f
 2008-09-02 00:52:52 +00:00
drh
588a9a1a1c Defer deleting Table objects associated with flattened subqueries until 
all code has been generated, in case some expression node still references
the Table object.  Ticket #3346. (CVS 5650)

FossilOrigin-Name: d04d70336727a0db959c672e6c22cdaa0505dce5
 2008-09-01 15:52:10 +00:00
drh
5393b651c6 Run permutation subtests in sorted order. (CVS 5646) 
FossilOrigin-Name: 4cd1bdf3ce8077e10dcd8ae4fe2df0dd9bb0f56b
 2008-08-30 16:07:03 +00:00
danielk1977
c1def3e0af Add some code to permutations.test to make sure no test file modifies the shared-cache setting. (CVS 5645) 
FossilOrigin-Name: 8565b7c66525dc7808a2a266deb1a0d995c99917
 2008-08-30 13:25:10 +00:00
danielk1977
3dbb0572d7 Make sure thread003.test waits for all spawned threads to finish before continuing. (CVS 5644) 
FossilOrigin-Name: 87c7e82f54cd446721d553d5c48ca2571b063669
 2008-08-30 09:10:16 +00:00