database/sqlite
1
0
Fork 0
mirror of https://github.com/sqlite/sqlite.git synced 2025-11-12 13:01:09 +03:00
Code Activity
29,836 Commits 1,607 Branches 185 Tags
json-opt
Commit Graph

9709 Commits

Author SHA1 Message Date
drh
feb306f556 Unknown functions in the DEFAULT clause of a table cause an error when 
the DEFAULT value is needed.  Ticket [2d401a94287b5].

FossilOrigin-Name: 093917d7fda442012dfd1a1b2f20f85d2eefa093
 2009-08-18 16:05:46 +00:00
dan
02fa469619 First version of sqlite_stat2 (schema forces exactly 10 samples). 
FossilOrigin-Name: dd96bda2a85c1d94fb4a0bf5f27e2977f7f7e42e
 2009-08-17 17:06:58 +00:00
dan
3d6e060b48 Move error simulation code from the sqlite3_os_init() functions into a wrapper. 
FossilOrigin-Name: 67ad21abf88abb7a3e2eacddcaf1ab5d54149807
 2009-08-17 15:52:25 +00:00
shane
7c7c311da5 More documentation and comment updates for sqlite3_initialize/shutdown interface changes to handle failures. 
FossilOrigin-Name: 32509bc7339cd6a46cea4c243e3418546860cb2d
 2009-08-17 15:31:23 +00:00
dan
e1ab219309 Add tests to check that sqlite recovers from an error in sqlite3_initialize() correctly. 
FossilOrigin-Name: 904a371c6c9d3f20332b37767b06161fa0a78113
 2009-08-17 15:16:19 +00:00
dan
d768f944d9 Add a test to verify that 3.6.17 releases read-locks obtained to read the database schema even if the connection is not currently in auto-commit mode. 
FossilOrigin-Name: 78dfe8321db9debfcd4a7f3daf4223d0cbf23ab9
 2009-08-17 09:29:09 +00:00
dan
4361e79f14 Fix a case where SQLite may write past the end of a buffer as a result of a corrupted database file. 
FossilOrigin-Name: 43321a556031942389ca11b033c1eae46ac6141b
 2009-08-14 17:01:22 +00:00
drh
c4fa5315a5 Tweak to the new whereB.test file to make it more consistent. 
FossilOrigin-Name: 06098505fca5c67b627a9e1102451f93e490e192
 2009-08-13 19:54:26 +00:00
drh
320b3a7a3a Enhancements to the whereB.test to check more affinity corner cases. 
FossilOrigin-Name: 1048459824746307c9e4296cbc21716bf8b5449d
 2009-08-13 18:14:32 +00:00
drh
9fa7207b1b Add a test case for the affinity problem reported by ticket [93fb9f89d6]. 
FossilOrigin-Name: 149ec24e61437fac2b0dd6239276d3aa543c56cb
 2009-08-13 17:14:59 +00:00
drh
3da9a940b7 Merge the accidental fork. 
FossilOrigin-Name: 86a06dd0494c2fe83d4fde517557600956cedd9e
 2009-08-13 15:42:52 +00:00
dan
5236ac1d04 Changes to the query planner that improve the order in which tables/indexes are scanned in join queries. 
FossilOrigin-Name: 19f799b32f9d1be25d4185ce18b13f4dd502e199
 2009-08-13 07:09:33 +00:00
shane
d87873d19b Fixed some compiler warnings in WINCE only sections when using the MSVC compiler. 
FossilOrigin-Name: 1f0a93e17d6291268da909699ce1a5a7619ae637
 2009-08-12 15:34:02 +00:00
danielk1977
8f00a826ca Update a couple of tests in corrupt7.test to account for a change in the error message text emitted by SQLite. (CVS 6968) 
FossilOrigin-Name: 3172a296926c6b50af5b6edfe38013056e155fa0
 2009-08-10 10:18:07 +00:00
danielk1977
f77a367db4 Change mallocI.test to close a database connection that was being left open. (CVS 6966) 
FossilOrigin-Name: 4f0096d7ef43f4b9f32c4d78b3dfe34271f2120a
 2009-08-10 04:26:39 +00:00
drh
3d5f74b275 Alternative fix for ticket #3810. This is a replacement for check-in (6956). (CVS 6960) 
FossilOrigin-Name: ba1afc040171810d0c996708d7b9cb11abcd99d8
 2009-08-06 17:43:31 +00:00
drh
b4bc2b7a07 Make sure all database connections are closed at the end of the test case 
for ticket #3810. (CVS 6957)

FossilOrigin-Name: 9bca5a0e8f22da6be41b0eda298fd2e19f64e8b6
 2009-08-01 18:22:30 +00:00
drh
35ccb3d3bc Return a better error message when problems are encountered parsing a 
TEMP trigger or TEMP view that references objects in other databases that
have been modified or dropped.  Ticket #3810. (CVS 6956)

FossilOrigin-Name: 102785b9fbc5ab5dd740110243f080e3f3661e87
 2009-08-01 16:27:00 +00:00
drh
a0e0d8ea98 Add a testcase for ticket #3810. (CVS 6955) 
FossilOrigin-Name: 29972f7445cede64d99c2433742572120c92b393
 2009-08-01 15:54:25 +00:00
danielk1977
f51d1bd665 Fix a bug in where.c that could cause SQLite to write to freed memory while compiling a query with many terms in the WHERE clause. (CVS 6952) 
FossilOrigin-Name: 8161af840e8fd2b06457e75023f934e1b8fe5fd6
 2009-07-31 06:14:51 +00:00
danielk1977
1a4eaf0be2 Add a test to mallocI.test to show that a shared lock is correctly released if an OOM condition occurs while parsing a database schema. (CVS 6951) 
FossilOrigin-Name: 5a82620efa1298530760e69e4e34d446a30233b8
 2009-07-29 06:04:56 +00:00
danielk1977
ee0484c1b5 Add the experimental API sqlite3_strnicmp(). Modify fts3 so that in terms like 'column_name:token' the column_name is interpreted in a case-insenstive fashion. Ticket #3996. (CVS 6950) 
FossilOrigin-Name: 4571aa9e9142db465ae8250b0adf27e0a094331a
 2009-07-28 16:44:26 +00:00
danielk1977
0a458e5e2f When flattening a SELECT query, do not discard collation sequences explicitly attached to expressions in the parent query. Fix for #3997. (CVS 6949) 
FossilOrigin-Name: b2784cf5d8b520fb714efdb2d2746b2c88b56edf
 2009-07-28 13:30:30 +00:00
danielk1977
c7538b5f63 When extracting values from a record to use in an UPDATEd version of that record, apply OP_RealAffinity if required. Fix for #3992. (CVS 6945) 
FossilOrigin-Name: 3616766a6f5c8179cc55444c29ecf29cc69f88ce
 2009-07-27 10:05:04 +00:00
danielk1977
8c924fe002 Remove the "proc zeroblob" implementation from incrvacuum2.test. It is no longer required as of (6906) and, as #3988 points out, unreliable. (CVS 6936) 
FossilOrigin-Name: 03153831635342a744ee42f14cb041499cdece2a
 2009-07-25 13:42:50 +00:00
drh
8a938f9808 Add assert() statements to more tightly constrain the state of pager.c. 
Remove the three pager*.test scripts since they violate the constraints
asserted above by modifying the state of the system in ways that it cannot
be modified in a live system. (CVS 6933)

FossilOrigin-Name: 3b6d370ed68eaf9636b26c7240a8b3a43d2edd70
 2009-07-25 04:12:02 +00:00
danielk1977
595a523a10 Allow virtual tables to be used in shared-cache mode. (CVS 6928) 
FossilOrigin-Name: 5d9e767a05e381235e064061043e30cc03a11a07
 2009-07-24 17:58:53 +00:00
drh
ad7516c45f Simplifications to pager.c in support of structural coverage testing. (CVS 6927) 
FossilOrigin-Name: 7222ad2667b95d6021d9ae47f548b76b224f46aa
 2009-07-24 16:32:00 +00:00
danielk1977
257d9dc748 Changes to test code (only) to allow veryquick.test to run with OMIT_UTF16 builsd. Ticket #3985. (CVS 6919) 
FossilOrigin-Name: 7f3fc7f20f6dc205eedbe445e35f5071f1c01185
 2009-07-22 07:27:56 +00:00
danielk1977
89bc4bc645 Change getAndInitPage() (btree.c) to use only PagerAcquire(), not PagerLookup() and PagerAcquire(). (CVS 6916) 
FossilOrigin-Name: 0b41dfc066b60ccabbf1a9ab4db41ebcb73a2799
 2009-07-21 19:25:24 +00:00
danielk1977
f16c62464d Add some code to sqlite3VdbeMemSetZeroBlob() so that it works (less efficiently) even when OMIT_INCRBLOB is defined. Ticket #3977. (CVS 6906) 
FossilOrigin-Name: f5f7259d811ce8c2bf0bc64128256c4cd95f676a
 2009-07-18 14:36:23 +00:00
danielk1977
5368f29ac4 When the asynchronous IO backend opens a file with the EXCLUSIVE flag set, make sure only a single file-descriptor is opened (not one for reading and one for writing). This change fixes #3978. (CVS 6905) 
FossilOrigin-Name: 630e669b97a81f9125d4bdc18517738b74eecdec
 2009-07-18 11:52:04 +00:00
danielk1977
627a3d6ab4 Changes to test scripts so that (make test) works when OMIT_INCRBLOB is defined. (CVS 6904) 
FossilOrigin-Name: 1dd834a3d61496dfa138c36676a5fa6afaa4c817
 2009-07-18 08:30:44 +00:00
shane
9a8cee7f73 Skip all tests in tableapi.test if SQLITE_OMIT_GET_TABLE defined. Ticket #3975. (CVS 6901) 
FossilOrigin-Name: 0219a543367638013ccd06295eeb9efc822e2dd1
 2009-07-17 14:37:24 +00:00
drh
e64ca7ba11 Code simplifications and comment improvements in support of structural 
coverage testing. (CVS 6899)

FossilOrigin-Name: 945251798144110787b197f9eb552a2dd4a25cb4
 2009-07-16 18:21:17 +00:00
drh
6be240e546 Make sure the IN operator works with zeroblobs. Ticket #3965. 
Other simplifications associated with structural testing. (CVS 6890)

FossilOrigin-Name: 25dd342283046aaf66a679348ef1c7364c616402
 2009-07-14 02:33:02 +00:00
danielk1977
8f880a8cfb Remove an assert ("assert( subpage>0 )") from btree.c that may not be true for a corrupt database. Also add comments and other assert() statements to btree.c function moveToRoot(). (CVS 6886) 
FossilOrigin-Name: 3151dab9c78106217ec80ebadc666dfd11b42029
 2009-07-13 09:41:45 +00:00
danielk1977
bd5969a268 Fix a case where deleting a row from a corrupt database could cause an assert to fail. (CVS 6881) 
FossilOrigin-Name: 6994b41a94a60f6460cf9814767db321ab3851f7
 2009-07-11 17:39:42 +00:00
danielk1977
93caf5ad93 Modify the integrity-check code so that each b-tree page inspected is reinitialized while doing so, even if an initialized copy exists in the cache. This prevents an assert from failing when running integrity_check on a corrupt database. (CVS 6877) 
FossilOrigin-Name: 709576c670f802bf4b6e5c0e8db2bbde2cc16a90
 2009-07-11 06:55:33 +00:00
danielk1977
e932ba260e Fix a double-free that can occur when using the fts3 legacy syntax '-' operator. Add tests for the same operator. Ticket #3960. (CVS 6874) 
FossilOrigin-Name: c19d419e8cf94a26d9bb6ad478e84841168a882e
 2009-07-10 09:24:43 +00:00
shane
20a35fd826 removed unused functions from test3.c (test code only); (CVS 6867) 
FossilOrigin-Name: 0eb69e8dda13e2d52a06f66a71480f59fd766271
 2009-07-09 02:48:23 +00:00
drh
b1819a0b95 Make explicit the restrictions on UPDATE, DELETE, and INSERT statement syntax 
within triggers.  Ticket #3947. (CVS 6840)

FossilOrigin-Name: c8bf40df7be728b11bb633516d1988c6064a9d70
 2009-07-03 15:37:27 +00:00
danielk1977
34acdc9573 Fix to sqlite3AuthRead to accommodate "new" or "old" references that are used in a context where a column reference may also be used (i.e. "SELECT new.<col> FROM <tble>"). Ticket #3944. (CVS 6838) 
FossilOrigin-Name: 45fd5419a7cde29eb6ab5d98141bd642af0d78fb
 2009-07-02 18:40:34 +00:00
danielk1977
94b30733f7 When a b-tree transaction is committed when there are open cursors, downgrade shared-cache write-locks to read-locks instead of relinquishing all locks. Fix for #3942. (CVS 6837) 
FossilOrigin-Name: 611e704fdf90a3d3932ca1cbab4be7e282bf1ddf
 2009-07-02 17:21:57 +00:00
danielk1977
8b32282795 Change to test code and scripts allowing memsys3 to be tested using a build that has both memsys3 and memsys5 enabled. (CVS 6834) 
FossilOrigin-Name: a00aeec21cca7ccf19d4cdef618149aa2773c005
 2009-07-01 18:09:01 +00:00
danielk1977
bd1a0a4f61 Report an error if a USING or ON clause is specified following a from-list element that is not to the right of a join operator. Fix for #3846. (CVS 6832) 
FossilOrigin-Name: 29b48972b65a17dab343b063a620cf8d456a923c
 2009-07-01 16:12:07 +00:00
danielk1977
9b87d7b904 Do not ignore alias "a" in a query of the form "SELECT ... FROM (...) AS a" Fix for #3935. Also expand upon (6751) to fix some similar obscure memory leaks. (CVS 6831) 
FossilOrigin-Name: 42f9d1e56483a59353bff57d75f09ed67e1d9c3c
 2009-07-01 14:56:39 +00:00
danielk1977
96d48e963a Cause incremental-blob read/write operations lock shared-cache tables in the same way as normal SQL read/writes. Add complex assert statements to make sure tehe correct shared-cache locks are held when accessing the database. Eliminate some redundant checks from btree.c. (CVS 6830) 
FossilOrigin-Name: f17ef37897da9bcaf20b5acdce6840522c0a0b16
 2009-06-29 06:00:37 +00:00
drh
9ed7a9953e Remove the priorNewRowid field from the sqlite3 structure. Use the 
last_insert_rowid as the initial value when searching for a new random
rowid in the OP_NewRowid opcode. (CVS 6824)

FossilOrigin-Name: 96729b2d499f029bfaec6648a592e8ec697d9521
 2009-06-26 15:14:55 +00:00
shane
389ae2c52d Skip a couple tests requiring working 64bit int support on platforms without that support. Test code change only. (CVS 6823) 
FossilOrigin-Name: d8c8145c9d28d014eb9218b3f1312b957ccc72b7
 2009-06-26 14:17:47 +00:00