database/sqlite
1
0
Fork 0
mirror of https://github.com/sqlite/sqlite.git synced 2026-10-23 21:49:02 +03:00
Code Activity
10,307 Commits 1,782 Branches 392 Tags
winFileMapping
Commit Graph

7475 Commits

Author SHA1 Message Date
drh
ab35eaed1f Parser bug fix: Make sure the table constraints allowed by prior releases 
can still be parsed, even if they are technically not allowed by the
syntax diagram.

FossilOrigin-Name: e536ac041815b118c461ceee798f9b7283269f58
 2012-05-12 18:29:53 +00:00
drh
26d8b0fb49 Fix a harmless compiler warning inside an assert() statement within test code. 
FossilOrigin-Name: e68a3527decb434e8d0ac6b23a3cedba5992cedd
 2012-05-11 15:53:18 +00:00
drh
d187655341 Fix an evidence-mark typo in the comments of sqlite3.h. No changes to code. 
FossilOrigin-Name: 2b074085911d066a4411e46ce8e26a9d08cc0ce3
 2012-05-11 15:31:47 +00:00
drh
dd9819c4c1 Fix a harmless compiler warning. 
FossilOrigin-Name: 2b77301b9613c7caa02147095d728fd5b65dd120
 2012-05-11 11:28:40 +00:00
drh
882f87d826 Merge the table constraint parser fixes from trunk. 
FossilOrigin-Name: 12bb31dd6f0d8544406710d6f02f0b7c0fe6c537
 2012-05-10 13:03:28 +00:00
drh
aeb281c2ea Further changes to constraint parsing to support legacy syntax. 
FossilOrigin-Name: 38bf90af1ede6ee64ef7be66392e895e60c9126e
 2012-05-08 11:17:33 +00:00
mistachkin
b60803f4b9 Merge parser adjustments from the trunk. 
FossilOrigin-Name: 0d8b920b2c195f3735608e7a08f5d23724cdf806
 2012-05-07 22:29:19 +00:00
mistachkin
fcd2f12fc7 Merge Windows directory checking changes from trunk. 
FossilOrigin-Name: 7a7466f400e94d8c9e745efb2973300474a74d2a
 2012-05-07 20:28:19 +00:00
drh
4dc330dd33 Adjust the parser so that certain legacy schema constructs (that are not 
valid according to the syntax diagram) continue to be accepted, so that
older databases that happen to use those constructs are still readable.
This fixes an issue introduced by check-in [1b75f301affac6]

FossilOrigin-Name: a1c014d8a87c8940b3a037d8d8cc4d5678809802
 2012-05-07 19:21:36 +00:00
mistachkin
48a55aa988 Simplify directory checking for winOpen and add checking to winDelete. 
FossilOrigin-Name: b08530e1a02cba03afefd65dc101e074e8847c07
 2012-05-07 17:16:07 +00:00
drh
1e039a240f Do not do the AV retry loop on open if the file that is attempting to be 
opened is really a directory.

FossilOrigin-Name: 03875633f465e82fbe99829f96db25f6d32bd333
 2012-05-07 13:15:20 +00:00
drh
3badf8a96d Sync the latest trunk changes into the winRT branch. 
FossilOrigin-Name: be4ab188cffbe97ae4f1f0520591bb7f0df185de
 2012-05-04 23:11:21 +00:00
drh
a4c5860e6f Fix a minor deviation from the coding style guidelines. 
FossilOrigin-Name: 1e51bffe777587cd05bd7db5e02d6291c3eb8c1a
 2012-04-27 16:38:11 +00:00
drh
70331cd725 Enhance the processing of ORDER BY clauses on compound queries to better 
match terms of the order by against expressions in the result set, in order
to enable better query optimization.

FossilOrigin-Name: a49e909c8738317c8383ce93771c0a9c4cf270bc
 2012-04-27 01:09:06 +00:00
drh
9250581af4 All virtual table constructors to be invoked recursively. A test case for 
this has been added to TH3.

FossilOrigin-Name: 696a5a40bb28c4a54c9951f877b67015dc00bf55
 2012-04-26 22:47:20 +00:00
drh
b202d70a87 Fix a sign-extension problem for BLOB output in ".insert" mode of the 
command-line shell.

FossilOrigin-Name: 282f2a74c23aa3fca6087bdeaf5d961b4f5bbe47
 2012-04-24 12:12:57 +00:00
drh
9878123752 Update the ".table" command in the shell to show all tables in all 
attached databases, and to avoid using the deprecated sqlite3_get_table()
function.

FossilOrigin-Name: ce2d06e2533763a8008e7a405630293d8f9a3108
 2012-04-23 12:38:05 +00:00
drh
9b8d3572a9 If terminating interactive input to the command-line shell with ^D, issue 
an extra \n to move the cursor to the next line before exiting.

FossilOrigin-Name: feff1ef0b8f7b51ae80a9d34380b46a5103bf6cd
 2012-04-21 11:33:39 +00:00
mistachkin
045f09cbb9 Merge the latest trunk changes into the WinRT branch (fixes for tickets [2a5629202f] and [385a5b56b9]). 
FossilOrigin-Name: 25478dcff59690a5f59c3b96600374184057eae9
 2012-04-21 00:31:21 +00:00
dan
6a36f43586 Do not consider a DISTINCT clause redundant unless a subset of the result-set is collectively subject to a UNIQUE constraint and it can be guaranteed that all columns of the subset are NOT NULL (either due to NOT NULL constraints WHERE clause terms). Fix for [385a5b56b9]. 
FossilOrigin-Name: 7b8548b1872cc1225355ba8311e93dd08d6526e2
 2012-04-20 16:59:24 +00:00
dan
99f8fb66a4 Fix for 2a5629202f. When considering whether or not a UNIQUE index may be used to optimize an ORDER BY clause, do not assume that all index entries are distinct unless there is some reason to believe that the index contains no NULL values. 
FossilOrigin-Name: 9870e4c4fef10112c987c40cb1b95255a7214202
 2012-04-20 15:24:53 +00:00
mistachkin
c2f2d9280b Merge the latest trunk changes into the WinRT branch (fixes various MSVC compiler warnings). 
FossilOrigin-Name: 294a5cca5087b510c2483792631bbf98a415e254
 2012-04-20 08:23:32 +00:00
drh
83cc139231 Fix harmless compiler warnings on x64 MSVC, mostly in test code, but also in 
tclsqlite.c and in the FTS4 module.

FossilOrigin-Name: 3281972eaa46cb57fd9f0387063f47430dc0a3b4
 2012-04-19 18:04:28 +00:00
drh
7ed243b71a Fix a harmless compiler warning in tclsqlite.c for MSVC x64. Fix a test 
case associated with the FTS4 merge feature.

FossilOrigin-Name: de3f7187eb2ff24683a1854ae523e7d30c290893
 2012-04-19 17:19:51 +00:00
drh
d5a336ef58 Fix harmless compiler warnings (unused parameter warnings) in the aggregate 
query analyzer.

FossilOrigin-Name: 2d43562084316ec180a4c2cfc3fee08d58432204
 2012-04-19 15:49:19 +00:00
mistachkin
a749486e31 Import all the latest trunk changes into the WinRT branch. Refactor and/or remove WinCE-specific macros and functions used for file locking to improve clarity of presentation. 
FossilOrigin-Name: ad5cd15f49b286896f94ab1ff207077beee40e12
 2012-04-18 05:57:38 +00:00
drh
374fdce485 Improved handling of aggregate subqueries within an aggregate query. 
FossilOrigin-Name: 430bb59d798286a86c351de92c429345f016b3f0
 2012-04-17 16:38:53 +00:00
drh
d8621b90c9 Add an undocumented and possibly ephemeral ".breakpoint" command to the 
command-line shell, to call a no-op routine on which it is convenient to 
set a symbolic debugger breakpoint.

FossilOrigin-Name: 8e2363ad76446e863d03ead91fd621e59d5cb495
 2012-04-17 09:09:33 +00:00
drh
8c5058bbdb Fix a bug in the command-line shell logic that attempts to continue with a 
".dump" even after encountering database corruption.

FossilOrigin-Name: 020b5e90f950a42299074ff770612b9e68850d95
 2012-04-16 17:22:30 +00:00
drh
5adc60bab0 In the unix VFS, always set every open file to close-on-exec using either 
O_CLOEXEC at open (preferred) or FD_CLOEXEC in an ioctl after opening.  Before
this changes, many files were done this way, but not all.

FossilOrigin-Name: 9efbeb11ae0d480a13ff1353820c12f3a8bff452
 2012-04-14 13:25:11 +00:00
drh
2b32b9941d Fix a typo in a comment that is extracted for documentation. No changes to 
code.

FossilOrigin-Name: e87371c5081ce28431a4c7ceaa81ff966a378c66
 2012-04-14 11:48:25 +00:00
drh
a2acb0d769 Add a testcase() macro to ensure that the sqlite3AuthCheck() call inside 
the query flattener really is effective.

FossilOrigin-Name: a134e6e739cbb27701b092b33033244feb164cdf
 2012-04-11 23:22:37 +00:00
drh
85e7243acf Fix harmless static-analysis warnings, mosting having to do with memory 
leaks in the command-line shell.  Add a clang analysis of the command-line
shell to the "warnings-clang.sh" script.  Other minor cleanups to the
command-line shell code.

FossilOrigin-Name: 93a0f452a7023898ad3d62ee81b39a80477c332f
 2012-04-11 11:38:53 +00:00
drh
c00ce490c5 Add new interfaces to the test_quota.c module: sqlite3_quota_ftruncate(), 
sqlite3_quota_file_size(), sqlite3_quota_file_truesize(), and
sqlite3_quota_file_mtime().

FossilOrigin-Name: 2fa9f54309aea9927fb3695a986febd4963df7d1
 2012-04-10 17:53:47 +00:00
drh
35c86a94cf Fix a copy/paste error in a comment in the fuzzer. No changes to code. 
FossilOrigin-Name: 7433f2b5508ebf09d0e3e32a995f1126eaab8999
 2012-04-10 16:05:27 +00:00
drh
89d5d6a2a7 Fix the application-defined function logic so that functions with a variable 
number of parameters can be replaced or deleted correctly.  Also refactor
some of the function-finder code for clarity of presentation.

FossilOrigin-Name: 09d5581c81fb6a9bf6a369d0abf5ef6b54637576
 2012-04-07 00:09:21 +00:00
drh
b8af4b7919 Ignore the value of SQLITE_FCNTL_CHUNK_SIZE if it is negative. 
FossilOrigin-Name: 1b08fef9451f4d59148548faed115d1a5d0bcd98
 2012-04-05 20:04:39 +00:00
drh
3343b43915 Performance improvements for the RowSet object when it undergoes many 
cycles between RowSetInsert and RowSetTest.

FossilOrigin-Name: 49d20ede5f4c0895a165126d5cf7c95a0510ba35
 2012-04-05 01:37:32 +00:00
drh
42f64e52ee Add the ".trace" option to the command-line shell. 
FossilOrigin-Name: b9ac3d7e340eb616fd23cc7dbdef6fdd66a79fe4
 2012-04-04 16:56:23 +00:00
drh
689453dbf0 Fix the multiplexor logging so that it works with SQLITE_ENABLE_8_3_NAMES. 
FossilOrigin-Name: 9e1e2fe2950bb96784413eae934314d95bce08e7
 2012-04-04 13:58:19 +00:00
drh
1779efd483 In the multiplexor extension, improve the error logging when a chunk fails 
to open.

FossilOrigin-Name: 781453c686656a7bd4a274a3b3204ceb6ecae8df
 2012-04-04 13:43:13 +00:00
dan
1235bb1815 Modify the integrity-check code to reduce the size of the large allocation from 4 bytes to 1 bit for each page in the database file. 
FossilOrigin-Name: fa3a498dfe9ed59c30da5eaa0d7cad167fd4e393
 2012-04-03 17:43:28 +00:00
drh
f439fbdab5 The SQLITE_RTREE_INT_ONLY compile-time option causes the RTree extension 
to use only integer math and store only integer coordinates.

FossilOrigin-Name: 02b7640f5118e0a635b68f65765191bb3171b7bd
 2012-04-02 21:35:42 +00:00
drh
a477a8670f Fix a compiler warning by removing a redundant variable. 
FossilOrigin-Name: af602d87736b52802a4e760ffeeaa28112b99d9a
 2012-03-31 19:12:23 +00:00
drh
31f100556c Do not abort pending queries on a RELEASE of a nested SAVEPOINT. 
This is a candidate fix for ticket [27ca74af3c083f787].

FossilOrigin-Name: 79a4a3a84f0b367d54da5e69e64ffca474264717
 2012-03-31 17:17:26 +00:00
dan
8c2e0f02ba Modify selectColumnsFromExprList() to avoid ever incorrectly returning SQLITE_NOMEM. 
FossilOrigin-Name: e7cb6b73ac079d0751b3f9429d0f6a35ca8ec853
 2012-03-31 15:08:56 +00:00
dan
2b9ee77fd6 Fix a bug in the EXPLAIN code for listing trigger programs that was causing an out-of-bounds read. 
FossilOrigin-Name: c9342ca58105499a5eb61c3e6d016559b6072c95
 2012-03-31 09:59:44 +00:00
drh
5fb52caadf Do more aggressive optimization of the AND operator where one side or the 
other is always false.

FossilOrigin-Name: f9a7e179cbbeeab5e57bbf392bef89750215546b
 2012-03-31 02:34:35 +00:00
mistachkin
00fa55d7da Avoid using the OVERLAPPED struct on WinCE. 
FossilOrigin-Name: 196ca3a8b007b9f792e969893d981f6c5aa2fccc
 2012-03-30 16:44:33 +00:00
drh
f0146403a6 Simplify the winRead and winWrite VFS functions to reduce the number 
of system calls.

FossilOrigin-Name: b34491869c4fb31d2fdd14c94a7db2e1c0e572ba
 2012-03-30 15:57:45 +00:00