database/sqlite
1
0
Fork 0
mirror of https://github.com/sqlite/sqlite.git synced 2026-10-26 21:59:27 +03:00
Code Activity
17,822 Commits 1,786 Branches 392 Tags
bind-pointer
Commit Graph

6440 Commits

Author SHA1 Message Date
drh
2d05331444 Add the ability to have a table-valued function on the RHS of an IN operator. 
FossilOrigin-Name: ba1b441b6003808810667d749635fe6b2e8c6165
 2016-06-29 06:19:19 +00:00
drh
64131c15ab Another test case for the intarray($PTR,$N) virtual table. 
FossilOrigin-Name: 06e1fab7527c6b4330a58f8d8873afaf2d67ae86
 2016-06-29 05:08:01 +00:00
drh
4841624ab9 Add a prototype intarray($PTR,$N) table valued function. 
FossilOrigin-Name: 233b33382dc70de45f90b6dfdb5785f20b21489e
 2016-06-29 05:00:30 +00:00
drh
4b37cd49a6 Fix the handling of OP_Eq opcodes that compare a register against itself 
and that require an affinity change.

FossilOrigin-Name: 507014e4c7a70cd09410c89c8ed466c8edab39d2
 2016-06-25 11:43:47 +00:00
drh
f5fe00399f Fix the ctime.test script so that it works with clang. 
FossilOrigin-Name: 77e4f7a36e6e0ebe842bcb36b2557a5bfba90d3f
 2016-06-24 06:23:13 +00:00
dan
2b693d63e4 Allow LIKE operators that appear in a WHERE clause to be included in the cursor-hint for a cursor on the rhs of a LEFT JOIN. 
FossilOrigin-Name: 7455d932f5079ffe40462a8c119fc22b8a9bcbcc
 2016-06-20 17:22:06 +00:00
dan
e6912fd819 Include WHERE terms in the cursor-hint passed to a cursor opened for the rhs of a LEFT JOIN iff we can be sure that those terms will not evaluate to true if the LEFT JOIN generates a row of NULLs. 
FossilOrigin-Name: 998095aba01b75f685ed981b377e1dfe650d9bbf
 2016-06-17 19:27:13 +00:00
dan
c497441406 Fix a duplicate test name in cursorhint2.test. 
FossilOrigin-Name: fcd12b69cee1335224a65aa6d22c4e302b889398
 2016-06-17 14:59:40 +00:00
dan
419b03c1bb Fix a typo in the cursorhint2.test script. 
FossilOrigin-Name: c1a5a57cf10dca91082963dcbd3e3ffebc3707ef
 2016-06-17 14:47:37 +00:00
dan
b324cf756e If a table is on the rhs of a LEFT JOIN, include only terms from the joins ON(...) clause in the cursor-hint passed via OP_CursorHint. 
FossilOrigin-Name: 2a2346b04235c6d0b7a8e64c92ee31018285c29f
 2016-06-17 14:33:32 +00:00
drh
2ad96f5880 Add the json_quote() function to the JSON1 extension. 
FossilOrigin-Name: 2c3714aebf5e40e3728877a235b3c1f93defa33e
 2016-06-17 13:01:51 +00:00
drh
6c0e41b951 Fix the declaration of the table implemented by DBSTAT so that it uses 
correct datatypes.

FossilOrigin-Name: a1e1cdc51d1c68502f43ac72c28ba87cb1916a0d
 2016-06-13 15:59:37 +00:00
drh
edc4024b9d Fix the "onecolumn" and "exists" methods of the TCL interface so that they 
work in combination with the "profile" callback.

FossilOrigin-Name: d362ba157f993fc74a590cf15a9a2fa589278dd7
 2016-06-13 12:34:38 +00:00
drh
4d249e6128 Enhance "PRAGMA table_info" to that it provides information about eponymous 
virtual tables.

FossilOrigin-Name: 53a1e5d51304cb3de700c1807a2c945a40240576
 2016-06-10 22:49:01 +00:00
drh
8dc570b6af Prefer to use partial indexes for full table scans when that is possible. 
FossilOrigin-Name: fe1874321ba31cec9ae65387920c33d8d0178ed8
 2016-06-08 18:07:21 +00:00
drh
a83a5c3fbc Fix the walcrash4.test test module so that it works on windows. 
FossilOrigin-Name: 2091a4c9231c7871f27661adc27dd7df26500f6c
 2016-06-07 20:25:19 +00:00
drh
30e3fdf0ee Fix up speedtest1.c so that it will compile and run on SQLite versions prior 
to 3.6.18 (circa 2009-09-11).

FossilOrigin-Name: 9583c0fb39f357a76e0c99ea03b034aea3e03c75
 2016-06-04 16:33:48 +00:00
drh
f0755fc85e The OR optimization is usable on virtual tables with LIKE, REGEXP and/or GLOB 
terms in the WHERE clause.

FossilOrigin-Name: fa3a89fc0b88d5ad7f5c232198847b3483eef611
 2016-06-03 18:59:37 +00:00
drh
7edcf627af Disallow access to the rowid column on WITHOUT ROWID virtual tables. 
FossilOrigin-Name: d31c25972bfb6d04caad05534505698776e7e6d5
 2016-06-03 17:27:14 +00:00
drh
ac9c3d2c18 Performance optimizations on the CSV virtual table. Disallow WITHOUT ROWID 
virtual tables that have an xUpdate method, for now.

FossilOrigin-Name: 3134b3266c36c9d018e8d365ef46ef638c0792f4
 2016-06-03 01:01:57 +00:00
drh
35db31b24b Add the CSV extension to the test fixture. Fix a memory leak in the CSV 
extension.  Add test cases for the CSV extension, including one that uses
a WITHOUT ROWID virtual table participating in the OR optimization.

FossilOrigin-Name: 95f483e86e30ae68108904400e18ed41d389446b
 2016-06-02 23:13:21 +00:00
dan
dbd2dcbd5e Experimental change to allow virtual tables to take advantage of LIKE, REGEXP and GLOB terms that are part of OR expressions within WHERE clauses. 
FossilOrigin-Name: 242507b4ff96bc4c7c7844dbe1c2b8508dbf1d01
 2016-05-28 18:53:55 +00:00
drh
8dc8247eab Fix Lemon so that it actually works with -DYYSTACKDEPTH=0. 
FossilOrigin-Name: a9be4c2d56d08fea2cd1aab20b19092a45ef7620
 2016-05-27 04:10:47 +00:00
drh
f34a25a23b Minor change to the walcrash4.test module so that it works when 
SQLITE_DEFAULT_WAL_SYNCHRONOUS is set to something other than 2.

FossilOrigin-Name: 61e239bc4310eff172e1e50d51522ecc75dd997e
 2016-05-24 18:50:41 +00:00
dan
fe912510ea Fix an obscure problem with transactions written in "PRAGMA synchronous=full" mode on systems that do not support POWERSAFE_OVERWRITE causing an xSync() call to be omitted if the last frame written by a transaction is aligned to a sector boundary. This means that if a power failure or OS crash occurs very soon after such a transaction is committed, it may be lost following system recovery. 
FossilOrigin-Name: 37de3eab67f12ae1ce5bc8d5e541c64fc6b1fd80
 2016-05-24 16:20:51 +00:00
drh
73fa4737ce A few simple test cases for the ORDER BY LIMIT optimization. 
FossilOrigin-Name: 08849eab0f6ef29eaf6d2ce9c692de9b953dbd27
 2016-05-20 00:21:42 +00:00
dan
21690ff7fc Add test cases to test some fts3/4 edge case behaviour surrounding the '*' character. 
FossilOrigin-Name: 1f577e1f08159aeaaf19a7020d9004dd6103d57b
 2016-05-19 16:21:30 +00:00
dan
ee7de914d4 Do not run snapshot_fault.test as part of the inmemory_journal permutation. 
FossilOrigin-Name: 995c084bde44e678facc5f5d95a2335ce61e57b0
 2016-05-16 14:35:15 +00:00
drh
697c9eaa90 Disable shell.exe test cases for UTF8 filenames as they do not work on MinGW. 
FossilOrigin-Name: 386bcbba8ed733ee84958e6bd6e9d33c150e6c18
 2016-05-16 11:55:09 +00:00
dan
78d1c90567 Add another test case to temptable3.test. 
FossilOrigin-Name: 223640243efc52c14bb2bb540833a2a624eaa41a
 2016-05-10 20:16:43 +00:00
drh
d12bc6022b Fix a problem in sqlite3PagerMovepage() when working on a temp table for which 
pages have been spilled.

FossilOrigin-Name: 20cf8811caf705b482be100baecb3ef72aee2d5a
 2016-05-10 20:03:08 +00:00
drh
3791c9c288 Fixes to requirements marks. No changes to code. 
FossilOrigin-Name: 79ecd0ef20c12198e950a730871444a980a0f1b2
 2016-05-09 23:11:47 +00:00
drh
83561932a5 Enhancements to test/sort5.test so that it works with SEE. 
FossilOrigin-Name: 8a39c8ee49e6e80c83613546cf328801c80b7c4d
 2016-05-09 22:35:06 +00:00
drh
f52a697e04 Remove some forgotten debugging lines from test/sort5.test. 
FossilOrigin-Name: f5875489810101c13a7917bde86e6a23b088e386
 2016-05-09 22:32:18 +00:00
drh
3eead27022 Fix typo in the intpkey-17.2 test. 
FossilOrigin-Name: a45fda657d987f5c923d141584841a6c62dfb504
 2016-05-07 12:15:15 +00:00
drh
f09c48233a Simplification to the logic used to decide between OP_Seek and OP_NotExists. 
Use OP_NotExists for both DELETE and UPDATE.

FossilOrigin-Name: 3a695263183303e3f64eb2320752d0fdef53eaf2
 2016-05-06 20:23:12 +00:00
drh
bcf6884afd In the WHERE generator, when building code for a DELETE operation, make sure 
that seeks to the main table are not deferred.
This is a better fix for the [16c9801ceba49] bug than the previous.

FossilOrigin-Name: 150dd09ebd7b17234a79e1811a0fae8b0a7a40d5
 2016-05-06 16:06:59 +00:00
drh
70077d1733 Do not scan indexes that have the integer primary key as their left-most 
column.  This fixes the crash of ticket [16c9801ceba] but it seems like
the wrong fix.  More investigation needed.

FossilOrigin-Name: 50312273ffaf1bd4bfdc73865fa0b19166968429
 2016-05-06 11:31:10 +00:00
dan
c88ae52d86 Disable the PagerDontWrite() optimization for temp tables. It can cause database corruption if a page passed to PagerDontWrite() is dirty at the start of a transaction that is subsequently rolled back. 
FossilOrigin-Name: 6341ab2ffef298ca16b323358afbea4a4c1fb0e1
 2016-05-04 11:28:03 +00:00
mistachkin
1b361ff381 Add the experimental SQLITE_FCNTL_WIN32_GET_HANDLE file control. 
FossilOrigin-Name: b6ddabe1818c36007c476a31e2e35755630a5f14
 2016-05-03 19:36:54 +00:00
drh
5e18d40200 Turn the session extension off by default. Enable using --enable-session on 
configure scripts, or using the SESSION=1 argument to nmake on Windows.

FossilOrigin-Name: e462cde2a50c39cc2f8d8624aada19280b8226eb
 2016-05-03 13:14:18 +00:00
dan
39f98c52d0 Remove some randomness from test script temptable2.test. 
FossilOrigin-Name: 5830cf72e9e870830d088399f1ccb03ed6522582
 2016-05-02 19:05:05 +00:00
drh
b1c6995c58 Fix a test case in temptable2.test so that it works on systems that 
lack a coherient cache (ex: OpenBSD) and thus do not support the
"PRAGMA mmap_size" command.

FossilOrigin-Name: 088cf83872f6477c3b297c58d6f8a5def7025daf
 2016-05-02 16:59:49 +00:00
drh
57a07ba9a9 Disable the multi-row one-pass DELETE optimization when the WHERE clause 
contains a subquery.  Fix for ticket [dc6ebeda9396087].

FossilOrigin-Name: 3f221f592a9a19009076e568566c59801cd3fc32
 2016-05-02 12:18:56 +00:00
dan
40cf36ff17 Change the way tester.tcl handes $argv so that in "permutations.test <permutation> <filename>" <filename> may be the name of any file in the test/ directory. 
FossilOrigin-Name: 820c57bb24ad3d8663ca512e4022268b940bb2ee
 2016-04-30 19:23:10 +00:00
dan
4a030c6430 Fix test script temptable2.test so that it works with the "inmemory_journal" and "journaltest" permutations. 
FossilOrigin-Name: b7bec7f2d3d08d0c14f77654be2c5cedf1619e58
 2016-04-29 14:12:48 +00:00
dan
20ae3264b8 Merge latest trunk changes, including test case fixes, with this branch. 
FossilOrigin-Name: 99794aca7b6cb40f08ce4db9889a989fc597eac9
 2016-04-29 11:35:28 +00:00
dan
14cee38be8 Avoid running sessionfault.test and sessionfault2.test as part of the "inmemory_journal" permutation. 
FossilOrigin-Name: 5973d3bf2e5aa979ccc9a4a3a0eb08b67098b499
 2016-04-28 14:54:54 +00:00
dan
3104c4d6f4 Ensure that quota.test deletes the directory named "test.db" that it creates. 
FossilOrigin-Name: 045edd4b17c6b76079ac90773c035d8c1f8d525d
 2016-04-28 09:53:14 +00:00
dan
05accd2216 Modify the permutations.test script so as to set any permutation specific configuration values before running each individual test script. 
FossilOrigin-Name: 2662d8fef791f7b8b3b14f9c27dfedec84620dee
 2016-04-27 18:54:49 +00:00