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
10,307 Commits 1,785 Branches 392 Tags
winFileMapping
Commit Graph

7475 Commits

Author SHA1 Message Date
drh
b24d83fb35 Add a testcase macro to ensure testing a boundary case in DISTINCT processing. 
FossilOrigin-Name: ff9fc722dc481df1ce6a9733db1f033b88141d5d
 2011-07-02 19:12:05 +00:00
dan
969e5595e8 Ensure that automatic indexes are only created in scenarios where they may be used more than once. 
FossilOrigin-Name: 27c65d4d9c58bfc4ea8f9337fa15090459fb26c5
 2011-07-02 15:32:57 +00:00
dan
94e08d92f9 Fix a broken assert() in where.c. 
FossilOrigin-Name: 090b29177fbc9faa83b560d92ddc3710d291776e
 2011-07-02 06:44:05 +00:00
dan
bac8158a85 Merge latest trunk changes with experimental branch. 
FossilOrigin-Name: e56be74eabc03d1a524d96aa4e87102dea4e348e
 2011-07-01 18:43:13 +00:00
dan
6f3439697e Improve use of indexes to optimize DISTINCT queries. 
FossilOrigin-Name: 6c202ea0247ff509f696eee3839975a88ed26cf2
 2011-07-01 18:26:40 +00:00
dan
50118cdfdb Improvements and tests for detection of redundant DISTINCT qualifiers. 
FossilOrigin-Name: 7337293c87fb563604dd6ad284f2d1e30c938b4c
 2011-07-01 14:21:38 +00:00
drh
6fea83e52c Ignore the database name on the target table when parsing a CREATE TABLE 
statement out of the sqlite_master table.  This is a fix for
ticket [d6ddba6706353] that preserves backwards compatibility.

FossilOrigin-Name: 009c96ea7836edf75d65b150055e920079bb45e3
 2011-07-01 13:50:44 +00:00
dan
38cc40c216 Experimental changes to improve optimization of DISTINCT queries. 
FossilOrigin-Name: f7ba0219ef2f235543c258be736955d91ca5ecce
 2011-06-30 20:17:15 +00:00
drh
e1b4f0f177 Pass the BTREE_UNORDERED hint into both sqlite3BtreeOpen() and into 
sqlite3BtreeCreateTable().

FossilOrigin-Name: 591de898f41630156cc0fc6ef17dd3ee5e7c479f
 2011-06-29 17:11:39 +00:00
dan
0ea2517c4e Changes to allow FTS to be compiled as a loadable module again. 
FossilOrigin-Name: 29e69f389cb0078e125ba5814a68b3fe8cf634c6
 2011-06-28 07:15:43 +00:00
dan
08f5f4c57d Remove an unnecessary assignment from vdbeapi.c. 
FossilOrigin-Name: 6c871ac1fa3c79baa0053dc49ab106cb3db4cfa0
 2011-06-27 19:37:23 +00:00
dan
c431fd5580 Add a case to permutations.test to run the veryquick test suite using sqlite3_prepare() instead of sqlite3_prepare_v2(). This helps to test the fix for bug [25ee812710]. 
FossilOrigin-Name: d9f7993bfa2ecb30c44455de538eb6f8a4a59087
 2011-06-27 16:55:50 +00:00
drh
aab910c459 Make sure all new statements begin life unexpired, even if they registered 
functions or did other actions during preparation that would have expired
all statements.  Fix for ticket [25ee81271091]

FossilOrigin-Name: faa38c8724d3eebad97197bfa44d11e75cfe6c69
 2011-06-27 00:01:22 +00:00
dan
28e4e35586 Explicitly cast an argument to printf() to (int), in case the result of the pointer arithmetic expression is a 64-bit integer on some platforms. 
FossilOrigin-Name: 90cfeaf7b68eebc2cd75bc60b1bb86823646fe30
 2011-06-24 18:43:23 +00:00
drh
df3aa16e2b Fix some harmless compiler warnings that were occurring with THREADSAFE=0. 
FossilOrigin-Name: 9b191bb4c7c1e1b12b188c0b3eee1f8f587887c8
 2011-06-24 11:29:51 +00:00
drh
097ce2caab Add a bit to the SQLITE_TESTCTRL_OPTIMIZATIONS setting that will disable 
affinity when writing to any index, regardless of whether or not the index
is on a manifestation of a view.  This allows better testing of the fix
for ticket [91e2e8ba6ff2e2].

FossilOrigin-Name: b61a76a53af04f731fe7617f7b6b4fb2aef6587b
 2011-06-23 17:29:33 +00:00
drh
7571327233 Do not do affinity transformations on inserts into an index for the 
manifestation of a view or subquery.  Fix for ticket [91e2e8ba6ff2e2].

FossilOrigin-Name: 0b3174e0b1364ccc31853dce02bce5f7d3d431db
 2011-06-23 16:18:26 +00:00
drh
24e713d9b3 Provide the SQLITE_MAX_SCHEMA_RETRY compile-time parameter for adjusting the 
number of reparse attempts after a schema change.

FossilOrigin-Name: 8dca748b23fa6f9abf47a186dcd1766f4dcf3ab7
 2011-06-23 01:42:53 +00:00
drh
e3f031686d Remove unused variables from test_vfs.c 
FossilOrigin-Name: 07884cc218e6899efd163448ab116f296722f7b8
 2011-06-23 01:07:49 +00:00
shaneh
7c5d8fb730 Add a flush of stdout so some test code reading from a command pipe works correctly on Windows. 
FossilOrigin-Name: 6705f21effaa2f72dc5e17e888d679b8d35c2c3a
 2011-06-22 14:21:31 +00:00
dan
328876c0ac Modify the implementation of the test code in test_vfs.c so that test VFS objects may be invoked recursively. 
FossilOrigin-Name: 065e5a5ea4f82f0d3fbb2e80d3a977af96c95683
 2011-06-22 10:37:19 +00:00
drh
1f93a08070 Give the osLocaltime() function file scope in date.c. 
FossilOrigin-Name: 1577484595b5e5aab93722d76b273c911a04dc2c
 2011-06-21 15:54:24 +00:00
dan
0d37f58184 Initialize a variable introduced as part of the fix for [bd484a090c8077] in order to silence a compiler warning. 
FossilOrigin-Name: 6b9877fa43bf29a9740285f0c40a6e6cf21f8190
 2011-06-21 15:38:05 +00:00
dan
dec6f79d40 Add a missing initializer for sqlite3GlobalConfig.bLocaltimeFault. 
FossilOrigin-Name: 7fe8ba2ec762d258b04e775766c82e5e541ab5d1
 2011-06-21 15:27:54 +00:00
drh
a924acad0f Rework the localtime logic yet again in order to make all branches reachable 
and to follow GNU standards for HAVE_LOCALTIME_R-type macros.
Ticket [bd484a090c8077].

FossilOrigin-Name: 176248095b8056443ebcbff819e575bd100f5e50
 2011-06-21 15:01:25 +00:00
drh
8720aeb564 Simplifications to the localtime() interface. Fix the case where 
localtime_r() is available so that it works.  Ticket [bd484a090c8077].

FossilOrigin-Name: 5b68dae320d0fa3dc433826811e5018a47461de7
 2011-06-21 14:35:30 +00:00
dan
7c8b355e65 Change the error message returned when localtime_r() fails to "local time unavailable". 
FossilOrigin-Name: 0e82175fd86f0ca5da90676aaee3118a70264d85
 2011-06-21 13:46:11 +00:00
dan
30ce189dc9 Fix an error made in the previous commit. The parameters to localtime_s() were accidentally reversed. 
FossilOrigin-Name: 97e86ec6df4d893527fe9f43eb46163d9b06416a
 2011-06-21 12:53:14 +00:00
dan
c17d696c14 Return an error if localtime_r() fails within one of the date/time functions. Fix for [bd484a090c]. 
FossilOrigin-Name: 76ae8257efc1df6e20ce5718d4824adbbde423ec
 2011-06-21 12:47:30 +00:00
drh
ef8662bb65 Fix more documentation typos. 
FossilOrigin-Name: b9cbab739a62f497545161f30195272f4e687a7f
 2011-06-20 21:47:58 +00:00
shaneh
eeb5d8aae8 Add additional error check for disk full on Windows. 
FossilOrigin-Name: 3ee5d1a51d6347858734b7b595771ae9cd2cc89d
 2011-06-20 20:48:09 +00:00
drh
8a17be02f1 Fix documentation typos. No changes to code. 
FossilOrigin-Name: 3276f3f7c90e356a9715f6b0a95cf48169f8d9f0
 2011-06-20 20:39:12 +00:00
drh
a1dd92c57f Remove the SQLITE_OMIT_CONFLICT_CLAUSE preprocessor define which was no 
longer in use.

FossilOrigin-Name: 9024955973e90661c99efa2aad1f8c421ee93802
 2011-06-20 20:15:53 +00:00
drh
7fd3392981 More compiler warning fixes. 
FossilOrigin-Name: ed2dda9329ca42e9c0be1986c78b091051e7598f
 2011-06-20 19:00:30 +00:00
drh
dbe4b88aac Rework the autoconf script to better deal with utime() and dlopen(). 
FossilOrigin-Name: f69ed286ffb3f62f5cb5c1f7df55fa4d2468b472
 2011-06-20 18:00:17 +00:00
dan
6764a70086 Fix a problem where FTS test code was not being included in the testfixture build when SQLITE_ENABLE_FTS4 was defined. 
FossilOrigin-Name: e539d08a4dda073dc67dc39a104f89374d3bd8e9
 2011-06-20 11:15:06 +00:00
dan
b0a328324f Add a couple of pointer type casts to test file test_quota.c. 
FossilOrigin-Name: 0df061b0554c749cade4ec8ddabe453934825bb2
 2011-06-15 17:04:43 +00:00
drh
1aa4f3e529 Fix a couple of compiler warnings. 
FossilOrigin-Name: 3899f3b95ed50773a72d907b39b451fefce69c9e
 2011-06-15 12:43:36 +00:00
dan
5f84e14add Fix a memory leak that can follow an OOM error in a user-function that uses sqlite3_set_auxdata(). 
FossilOrigin-Name: 0185c4b689d18d66e6aa39b4a7bddc279e3c9d17
 2011-06-14 14:18:45 +00:00
dan
c72f9d98cb Merge recent trunk changes into fts3-prefix-search branch. 
FossilOrigin-Name: 135ce30f62ebd6a1b239c18dbbd9c926ea507db4
 2011-06-14 07:22:30 +00:00
drh
0a32fa6d81 Use only unsigned values in the implementatin of LIKE and GLOB so that 
values won't overflow to negative when dealing with malformed UTF8.

FossilOrigin-Name: 77f01578bb565d1bc884b374b68bae10ce34a084
 2011-06-13 12:19:21 +00:00
dan
99ebad90e3 Fix a bug exposed by combining matchinfo(), NEAR and "ORDER BY rowid DESC". 
FossilOrigin-Name: 5f6b87f420f21749aa7c72e020c50aca74890086
 2011-06-13 09:11:01 +00:00
dan
7006c18e00 When updating a field that requires foreign key constraints be checked, ensure that the indexes and tables are consistent when the FK logic is run. Otherwise, it may detect the inconsistency and report database corruption. 
FossilOrigin-Name: 2b3d9996a829c62fbaf7c92d50e44636340b07c6
 2011-06-10 18:33:35 +00:00
dan
b328debc6a Fix minor problems with foreign key constraints where the parent table is the same as the child table. 
FossilOrigin-Name: 442d8d8bfe443797482354ba8766d97d3d6acaae
 2011-06-10 16:33:25 +00:00
dan
9dde7cbbad Fix a line in pcache1.c where a global data structure is accessed without using the GLOBAL() macro. This causes a subtle malfunction on test systems that use SQLITE_OMIT_WSD. 
FossilOrigin-Name: b11b2e1f8ccadf78bebe2278f05a8e3d3e543328
 2011-06-09 17:53:43 +00:00
drh
55a0959a18 Fix a comment type on the description of the Schema object. 
FossilOrigin-Name: 095cd9a6ec175b703ff3fcafeffb3349f21bd831
 2011-06-07 18:31:14 +00:00
drh
2ce71b4e7a Add assert() statements to verify that u16 pointers associated with 
the enhancement in [897f56a158] are always 2-byte aligned.

FossilOrigin-Name: 98ccfa930e8e5f10808a518e3e22e85e8a8a65c2
 2011-06-06 13:38:11 +00:00
drh
afb9817f8c Performance improvement to the btree search routine. 
FossilOrigin-Name: 65db822f200bafe9abe59b33b17b2c643c17c5e8
 2011-06-04 01:43:53 +00:00
drh
61d2fe955c Performance improvements on memory copies inside of btree by moving 2 bytes 
at a time instead of just 1 byte at a time.

FossilOrigin-Name: 897f56a158ebe62758c9998e4941ae046c75fb99
 2011-06-03 23:28:33 +00:00
drh
3a61a5a2b5 Performance enhancement to the blob-literal tokenizer. 
FossilOrigin-Name: 61aa2031f1c5ae05e31077588a55194a9546262a
 2011-06-03 21:34:45 +00:00