database/sqlite
1
0
Fork 0
mirror of https://github.com/sqlite/sqlite.git synced 2025-07-22 00:02:13 +03:00
Code Activity
30,154 Commits 1,565 Branches 181 Tags
empty-table-optimizations
Commit Graph

343 Commits

Author SHA1 Message Date
drh
cf1ef10b62 Import recent bug fixes from trunk. 
FossilOrigin-Name: 20eeee4cd34a9bffe6bf65962126ddf8ca04eb3e
 2013-11-12 15:39:01 +00:00
dan
e3ab729a9c Update test command [explain_i] to handle the opcodes used by virtual tables (VNext, VFilter etc.). 
FossilOrigin-Name: 1b215ee3219750d3beda8f3628c8673efd517061
 2013-11-12 12:30:09 +00:00
drh
cbf1b8ef7d Merge in the WITHOUT ROWID changes. A few tests are failing now. They will 
be fixed in a follow-on check-in.

FossilOrigin-Name: 5addd1234ded59ce60fb633b76ac87d483377edd
 2013-11-11 22:55:26 +00:00
dan
5c663c3002 Use ansi escape codes to use different colored text for opcode names in the output of [explain_i]: Red for opcodes that insert or delete b-tree elements, blue for opcodes that move cursors and green for the ResultRow opcode. 
FossilOrigin-Name: 4be2b64b3e5237ee1fb156c06cffaf7d96f6c532
 2013-11-06 14:52:40 +00:00
dan
427ebba10c Unless the destination table is completely empty, disable the xfer optimization for WITHOUT ROWID tables. 
FossilOrigin-Name: 3877c9f50582b51817dcf3cd75d836891a34e590
 2013-11-05 16:39:31 +00:00
dan
e83267da54 Add tests for updates of without-rowid tables that use non-BINARY collation sequences for the primary key columns. And a minor bugfix to the same. 
FossilOrigin-Name: 99b1fa4b1664a79eae1dddce2b9a848384cdb1d7
 2013-11-05 14:19:22 +00:00
drh
5f9742e0ff Merge from trunk: (1) Recent bug fixes (2) STAT4 support (3) win32-longpath 
support.

FossilOrigin-Name: e7ebc8f74fe91dee26f952fdf49e427b45448667
 2013-08-29 15:08:38 +00:00
mistachkin
1d406e0dfd Small enhancements to unit testing infrastructure. 
FossilOrigin-Name: 9229aeb361f9805894321327d05aba855b8799f3
 2013-08-29 01:09:14 +00:00
drh
fd64cedc4b Bring the sessions branch up-to-date with all the latest trunk changes. 
FossilOrigin-Name: 086a127236ee99d67513490fb7b5549e8b752c44
 2013-06-26 13:31:50 +00:00
drh
70bdcc738e The expected result in a test case can be of the form "*glob*" or "~*glob*" to 
match or not match the GLOB pattern.  This is useful for matching
EXPLAIN QUERY PLAN output that contains regular expression syntax characters
like "?", "(", and ")".

FossilOrigin-Name: a3b4e261bd7e278f150872cce7b020af5ad8d2ed
 2013-05-30 19:28:34 +00:00
drh
ef86637655 Use the NGQP plan for EXPLAIN QUERY PLAN output. This change causes 207 
errors in veryquick.test, many of which are benign.

FossilOrigin-Name: f783e8e6b10de44029c7c5f57e4648a4a677ca1b
 2013-05-22 20:49:02 +00:00
drh
16fb176814 Merge the latest trunk changes into the sessions branch. 
FossilOrigin-Name: 6994826c0784280f2e9728dfa4185848846d03df
 2013-04-22 23:59:06 +00:00
drh
cca17c303b Add the "warning" command to the TCL test infrastructure. Fix problems 
with the loadext.test module.

FossilOrigin-Name: 514adbbd8cf3e296f55e8f803bddaac8ad8b2c96
 2013-04-19 12:32:52 +00:00
drh
8dd661aad1 Merge the changes for the 3.7.16.1 release candidate into the sessions branch. 
FossilOrigin-Name: ee35a89712b8ea9f4e70d61a29150348896b519f
 2013-03-28 01:19:26 +00:00
mistachkin
48864df97d Many spelling fixes in comments. No changes to code. 
FossilOrigin-Name: 6f6e2d50941e444ebc83604daddcc034137a05b7
 2013-03-21 21:20:32 +00:00
drh
b05567ed4b Merge all the latest trunk changes into the sessions branch. 
FossilOrigin-Name: d69d21903b883067c66dbcdefe6b369a6fe328b0
 2013-03-06 02:12:18 +00:00
dan
b88e24fd59 Enhancements to test scripts. No code changes. 
FossilOrigin-Name: ccab94c10d54e585de918bbf82dec188287d93b2
 2013-02-23 18:58:11 +00:00
drh
dab942860c Enhancements to the query planner to make use of indices for ORDER BY even 
when IN constraints are in the WHERE clause.  Add extended error codes for
all SQLITE_CONSTRAINT errors.

FossilOrigin-Name: 7e14dc734d7d941da5c3aa6612e26d93b5b929bd
 2013-02-13 13:42:50 +00:00
drh
433dccfb52 Rename SQLITE_CONSTRAINT_RAISE to SQLITE_CONSTRAINT_TRIGGER. Put the 
extended constraint error codes in alphabetical order.  Add many test cases
for the extended constraint error codes.

FossilOrigin-Name: 3f67437536591a1b0742a25b983707933aaa16d5
 2013-02-09 15:37:11 +00:00
drh
c4645dacfb Merge the latest trunk changes (especially "PRAGMA busy_timeout" and the 
ORDER BY query planner optimizations) into the sessions branch.

FossilOrigin-Name: 6ca8eae1f89d19ee23cbc3a869d85b57d29b4a7d
 2012-09-28 13:05:48 +00:00
drh
5343b2d4a8 More test cases an bug fixes for the ORDER BY optimization of joins. All 
veryquick tests now pass.

FossilOrigin-Name: 0d573320057b0903a5589cabfb1b1ece1c57958e
 2012-09-27 19:53:38 +00:00
mistachkin
c60941f814 Allow SQLite to work on Win32 with SQLITE_OS_WINNT=0 as long as WAL is disabled. 
FossilOrigin-Name: c1a8557008e56aa9bcb4565e4178fc57295c563d
 2012-09-13 01:51:02 +00:00
drh
8973a04e3b Merge all trunk changes, including the WinRT enhancements, into the 
sessions branch.

FossilOrigin-Name: c62140398344fd1a68a3e6dfe8b4fab280731ebb
 2012-06-07 23:58:36 +00:00
mistachkin
4ec0100f35 Merge updates from trunk. 
FossilOrigin-Name: 224c65e4a5c6ede076c364c93933cedd17f1e70b
 2012-05-17 21:04:26 +00:00
dan
3581020e53 Update sessions branch with trunk changes. 
FossilOrigin-Name: 3f4848a871a4229ff6951eefaf7673de46d2c43f
 2012-05-12 11:50:41 +00:00
dan
64b95bbcdc Before running each test script, make sure the FTS enhanced query syntax is disabled. 
FossilOrigin-Name: f84d87bcc0e4f6f56d01556b2b1dc27ebef9ce26
 2012-05-12 05:30:29 +00:00
drh
0d7706f41a Update the sessions branch with all the latest changes from trunk. 
FossilOrigin-Name: 0f347fbfc7d8821f56f1ae0d1a9472a375631e65
 2012-05-04 23:31:14 +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
3f17aefb35 Enhance the do_test proc in the test suite so that if the expected result 
is of the form "/.../" or "~/.../" then regular expression matching is done
between result and the "..." part of the expectation.  In the ~/.../ case,
we expect there to be no match.

FossilOrigin-Name: c9a734406c016329e80d887f7438206e41c52ce7
 2012-04-27 01:08:02 +00:00
drh
8df9185ce4 Move the shell test scripts into the test/ subfolder so that they are 
run automatically by "make test".

FossilOrigin-Name: 9fb7da6904e479f4671eeebf1a4b7e4e4e4f2b7b
 2012-04-24 12:46:05 +00:00
dan
6d972c1b98 Merge the latest trunk changes into the sessions branch. 
FossilOrigin-Name: 2277c70b6f14e2f8043112a5c49a8bc18b7504f3
 2012-03-19 11:17:17 +00:00
mistachkin
776f5c96f4 Merge test current directory value fix from trunk and fix uri tests. 
FossilOrigin-Name: 88963c33c19a051280f7f31bdc1b322d6837cf43
 2012-03-08 20:39:08 +00:00
mistachkin
533b8f6d47 On Windows, make sure the returned test current directory value does not contain any backslashes. 
FossilOrigin-Name: efee39e64bd95c284220fdb0ae8ee6c1847fadab
 2012-03-08 20:28:31 +00:00
mistachkin
6aa18c95f1 Merge and manually resolve testing updates from trunk. 
FossilOrigin-Name: 5eecdb44dd809e91002b8ecf59ada72f4b56549a
 2012-03-08 20:22:42 +00:00
mistachkin
f8a784645c On Windows, make sure the current directory value used by the test suite is 'normalized' to what the parent command shell sees. Also, clean the test directories used by the quota2.test file. 
FossilOrigin-Name: 82bcd7ec1531f6d71c079578434c58d3ce46a1de
 2012-03-08 20:00:36 +00:00
mistachkin
4a41f34552 Fix for test issues when there is no current directory support due to being compiled for WinRT. 
FossilOrigin-Name: a811cb01528beab8afd899411d187d4d960ddcc8
 2012-03-06 03:00:49 +00:00
mistachkin
c548465435 Add compile-time define to indicate if the VFS supports the concept of a current directory (as WinCE and WinRT do not). Avoid using the GetTempPath and GetFullPathName APIs on WinRT. Some tests still need adjustments. 
FossilOrigin-Name: 86c049a171acc3f4a43771f3e7176a90210d7799
 2012-03-05 22:52:33 +00:00
drh
54cced185c Merge all of the latest trunk changes into the sessions branch. 
FossilOrigin-Name: a9bcb432f58b96f079a73c456efd4851c582221e
 2012-01-05 13:02:36 +00:00
mistachkin
6c3c1a0951 Make sure to flag benign malloc failures in the Windows VFS as such. Expand use of the DO_OS_MALLOC_TEST to cover the VFS functions that can now return an out of memory error. Support an experimental --match option to the test suite that will run only those tests matching the specified pattern. 
FossilOrigin-Name: 76dec8aa9dbbc39e0a7c3b358b58ce7f7a477a2b
 2011-11-12 03:17:40 +00:00
drh
7cca2e6259 Merge the latest trunk changes into the sessions branch. 
FossilOrigin-Name: eb036d6f81e15bac013316bf5b1b2ba3e0bd4605
 2011-08-26 19:20:47 +00:00
mistachkin
fda06befd5 Add retry logic for AV defense to winOpen. Also, refactor test suite to allow the key Tcl file operations (e.g. copy and delete) to be retried. 
FossilOrigin-Name: 9007586fdabed8dbcc78581ea9821cfd1f9a4c8c
 2011-08-02 00:57:34 +00:00
dan
6f3439697e Improve use of indexes to optimize DISTINCT queries. 
FossilOrigin-Name: 6c202ea0247ff509f696eee3839975a88ed26cf2
 2011-07-01 18:26:40 +00:00
dan
53ae686bfb Update sessions branch with latest trunk changes. 
FossilOrigin-Name: 48d5cab3ac08b25ec94d6ecfd25779320558110f
 2011-06-22 12:01:08 +00:00
shaneh
285a18fa45 Fix typo in previous tester.tcl commit. 
FossilOrigin-Name: c2e5faca144d2c25aada2a77b4ddefa5ca6ea925
 2011-06-21 19:39:59 +00:00
shaneh
c489640779 Update filepath_normalize for unix. 
FossilOrigin-Name: 30dd4f887989354b5d01cc80bd9c4bd3528d3ae1
 2011-06-21 19:38:16 +00:00
shaneh
5550517e2b Update a few of the uri tests to work on Windows. 
FossilOrigin-Name: a2a0cd4aa4a6723a849bbba590c22fd065fab55e
 2011-06-21 19:30:19 +00:00
drh
34ffcfff02 Merge the latest trunk changes into the sessions branch. 
FossilOrigin-Name: f3d148e0d10e16cd744ec88a2961fd617368c5ed
 2011-06-21 01:29:16 +00:00
shaneh
4f529e87fe Update a couple test scripts to account for more floating point variation under various Windows-based versions of TCL. 
Update a couple test scripts to account for more floating point display variation in Windows-based versions of TCL.

FossilOrigin-Name: a4a8402bfec381dd23b7a96c2f4b52c0dd728a7a
 2011-06-20 17:41:41 +00:00
drh
8863f35f5c Merge the latest trunk changes into the sessions branch. 
FossilOrigin-Name: 4c5e276c902e0b93cfc05bf2e1db966ecdac0ed0
 2011-06-20 10:44:10 +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