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
8,321 Commits 1,782 Branches 392 Tags
branch-3.7.2
Commit Graph

8321 Commits

This Branch
This Branch
All Branches
Author SHA1 Message Date
drh
36e2d71d71 Backport check-in [62678be3df35cd]: 
When the same index is used for all OR-terms in a WHERE clause, then try to
use that index as a covering index.

FossilOrigin-Name: 865dfcbaa59431422b5980c66c8e29e80c4ed7c9
 2012-08-25 00:49:08 +00:00
drh
569d74dc5f Cherrypick the [3513bf6ee090d9] so that the sqlite_source_id() function works correctly even with newer versions of Fossil 
FossilOrigin-Name: 89d63a0e1db6a86fa173fb8a4e3a3904ef9e488c
 2011-10-25 21:18:17 +00:00
drh
9ca0b52623 Cherrypick changes [53f5cfe115] and [1f7ef0af8d] in order to fix an issue with DISTINCT 
FossilOrigin-Name: 14bc58ca70336aed62069f223324304835991c55
 2011-10-25 20:36:39 +00:00
drh
9b709c0b65 Cherrypick the recursion fix to test_vfs.c from [065e5a5ea4f82]. 
Also fix the nan.test module to handle upper/lower case changes in TCL.

FossilOrigin-Name: 41b5f86971ed9d7ddca31bd9b43d0a41f03f002b
 2011-08-26 17:17:50 +00:00
drh
a1bb9c0979 Cherrypicked from trunk: Do not try to use STAT2 for row estimates if the 
index is unique or nearly so.

FossilOrigin-Name: d55b64ef7e04e10a31360dea55751a33a0d591a4
 2011-07-13 18:53:13 +00:00
dan
436003fc52 Cherrypick change [9f14fa56ba] (the fix for [54844eea3f]) from the trunk. 
FossilOrigin-Name: 7afb2354d3791cbce00200ddee6d9f230b9452e2
 2011-07-12 14:48:56 +00:00
dan
8e3b333080 Cherrypick change [27c65d4d9c] into the 3.7.2 branch. 
FossilOrigin-Name: 9bbcd8c076ce1add222da1f45ff4ee5ea2fcfc2e
 2011-07-02 15:42:12 +00:00
dan
0ac2aa4ed0 Cherrypick [45e581bff7] into the 3.7.2 branch. 
FossilOrigin-Name: c593792ce00d0a6379f31cab1bca22f5e159ce18
 2011-07-02 13:34:15 +00:00
drh
7afd98dddb Backport check-ins [0900e35348f4b9bf3] and [4fead8e714c7e50] to the 3.7.2 
branch.  These check-ins provide hints to the btree layer for when it is
possible to use a hash table rather than a btree to implement an index.
The SQLite BTree layer does not use these hints, but alternative btree layers
might.

FossilOrigin-Name: 7155e6f3282671487f262fd51a7cb139dffdbde6
 2011-05-01 22:57:41 +00:00
drh
0b150dd857 Backport check-in [9f9f32882501ac9] to provide EXPLAIN QUERY PLAN output for 
the count(*) optimization.  Also backport check-in [a8761a9128de945aa] to
prevent unordered indices from being used on a full table scan.  The first
backport was necessary in order to test the second.

FossilOrigin-Name: 8d924e160703e02958db9c9bc1fd2c600e01e606
 2011-04-15 15:18:34 +00:00
drh
05d15a69a7 Back port the unordered-index-hack to the 3.7.2 branch. 
FossilOrigin-Name: 803530209f9c8d4dcf8ed51b5a96aee1766ef79f
 2011-04-09 03:30:25 +00:00
drh
a5f2bd7326 Backport test cases from trunk that seek to prove that the IS NOT NULL 
query optimization is working.

FossilOrigin-Name: 9eff470226c6f879bb1b24fb00b6786a816d8cfd
 2011-04-08 23:36:09 +00:00
drh
ef66331fe9 Make sure the query planner is able to correctly analyze NULL value 
samples in the sqlite_stat2 table.  This is a backport of changes
from check-in [f73a167b434f]

FossilOrigin-Name: 1d6378898aab5208e1fbaf2683a63650b4987c16
 2011-04-08 23:05:50 +00:00
drh
ecd2c06025 Make sure the left-hand side of the IS NOT NULL operator is a simple column 
and not a general expression before applying the IS NOT NULL
optimization.  This is a backport of check-in [543f75a6abe3].

FossilOrigin-Name: e8177e0149280ea775e9aac18307ce2528f72298
 2011-04-08 23:04:28 +00:00
drh
5bc564f0d3 Provide hints to the btree layer Next and Previous primitives to let them 
know if they can be no-ops if the underlying index is unique.

FossilOrigin-Name: a5aae1743a208e7792497dfebf3e8311140ae595
 2011-03-31 18:36:17 +00:00
drh
510eca1d25 Backport the "x IS NULL" query planner enhancement of [2353176811f] to 
the 3.7.2 branch.

FossilOrigin-Name: 68daf20d019a0a84764d635a91eaa9faeeabbab4
 2011-03-17 01:53:00 +00:00
shaneh
90828dde62 Backport the SQLITE_OMIT_UNIQUE_ENFORCEMENT change from checkin b86999436e on the trunk. 
FossilOrigin-Name: 668b91dbff036c6b76a5611cc3ebe455d277ed59
 2011-03-12 05:55:38 +00:00
drh
cda5b88f18 Backport the OP_Next and OP_Prev for UNIQUE indices patch from 
checkin [f000c9b2b7] on the trunk.

FossilOrigin-Name: 2d55234ea3b8a8d6f18683d51f05945394e97275
 2011-03-09 22:09:32 +00:00
drh
ac92abf2d0 Backport the query planner enhancement of [952f5e8c69904] to the 
3.7.2 branch.

FossilOrigin-Name: 440d995661c961257ca15833ab94c7ec7a5892c8
 2011-03-04 01:23:26 +00:00
drh
2dfea2f020 Fix the expected output on tests so that it corresponds to the new query 
planner results.  All of veryquick.test is now passing with
SQLITE_ENABLE_STAT2.

FossilOrigin-Name: f2a8b5ccfb46b6be5c8857bc495de14e55851bf4
 2011-02-12 14:23:48 +00:00
drh
d694cc5909 Fix problems in the backport, reducing the number of errors in the TCL tests 
to just a few dozen.  Most of the remaining errors seem to be real and
desirable changes of behavior.

FossilOrigin-Name: 9d2b0af266b85f10823e54ca6417e76950c1d531
 2011-02-12 05:34:43 +00:00
drh
6477f2a4f8 This is the beginning of an attempt to backport recent query planner 
enhancements to version 3.7.2.  The code in this version builds and runs and
seems to give correct answers, but it generates suboptimal query plans and
hence many of the test cases fail.  The test script gives up after 1000 errors.

FossilOrigin-Name: e72cf118cb25e9fed96f8d5cebbc0f637892479a
 2011-02-12 01:59:22 +00:00
drh
507f94d763 Version 3.7.2 release candidate 1 
FossilOrigin-Name: 42537b60566f288167f1b5864a5435986838e3a3
version-3.7.2 		2010-08-23 18:52:01 +00:00
dan
5f848c3a48 Fixes for the SQLITE_CHECK_PAGES debugging feature. 
FossilOrigin-Name: 21a1e5961bba148fda50cc0b7d472ca74f90808a
 2010-08-23 18:19:31 +00:00
drh
b8077be491 Update the version number in preparation for the 3.7.2 release. 
FossilOrigin-Name: 77889510fa67268043c604826047af81c8bd1ca7
 2010-08-23 17:09:23 +00:00
dan
f48c355b33 Fix for ticket [5e10420e8d]. 
FossilOrigin-Name: 255f1eefa373153942c67b18b22177933657911d
 2010-08-23 15:41:24 +00:00
drh
7d105f87fc Update the "showdb" debug utility to handle 64K page database and with 
extra options to decode the freelist structure.

FossilOrigin-Name: 1070918e3b68c0ba5bfab11a97214b87c601f93c
 2010-08-23 15:26:49 +00:00
drh
4396fb8d48 Version 3.7.1 release candidate 
FossilOrigin-Name: 3613b0695a5e990905ab146fadcab34dd04d5874
version-3.7.1 		2010-08-21 16:01:46 +00:00
dan
f5d3df405c Add some tests to e_expr.test and pagerfault.test. No code changes. 
FossilOrigin-Name: 44de3cab9c89eb28485c0dc36d791b1c61d56b34
 2010-08-21 15:51:05 +00:00
drh
5f77b2e0ea Fix the ptrmapPageno() routine so that it works correctly for an input of 1. 
FossilOrigin-Name: 699a9bf28377f43f58c509878cce60cb906dbf48
 2010-08-21 15:09:37 +00:00
drh
871919b493 Do not allow a backup to change the page size if a codec is in use. 
FossilOrigin-Name: 5523ecd32295c188e3bf5dbd57d92d2879461e32
 2010-08-20 15:32:21 +00:00
dan
4f05e38f09 Fix typo in backcompat.test. 
FossilOrigin-Name: 6a0cbb272c3f0c1dfdeed381ba92f2f2f16ae824
 2010-08-20 12:43:01 +00:00
dan
a3e63c4a74 Merge leaf created by accident. 
FossilOrigin-Name: 1f680cb37584baa106cee0544d5be63049d55858
 2010-08-20 12:33:59 +00:00
dan
3d5790596e Avoid assuming that the user has "." in their path when running multi-process tests. 
FossilOrigin-Name: daa5d461b98fc068cbba52d338ca8690edd27bc9
 2010-08-20 12:31:30 +00:00
drh
a6c4196604 Do not attempt run backwards compatibility tests if no historical 
"testfixture" binaries are available.

FossilOrigin-Name: 40e11aabc7668e1c9db43d9183edb445996254bd
 2010-08-20 10:28:28 +00:00
drh
96dd6a16af Disable the MEMSYS2 auxiliary routines if MEMSYS2 is changed to an alternative 
memory allocator using SQLITE_CONFIG_MALLOC.

FossilOrigin-Name: 541dd3b870f123a5fddf0b710474693566a1d659
 2010-08-20 09:53:19 +00:00
drh
c8f503a8d3 Fix the sqlite3_release_memory() interface so that it does not attempt 
to free SQLITE_CONFIG_PAGECACHE memory.

FossilOrigin-Name: 0426cd62d5ef2bd09570835c78f8fc3bcb7cdd49
 2010-08-20 09:14:13 +00:00
shaneh
5ad723f412 Adjust filename globbing in backcompat.test for Windows. 
FossilOrigin-Name: b0f4796306a2cb11d6897d5c33f5da05c7473e07
 2010-08-19 18:05:46 +00:00
dan
9ab7fe87e5 Fix backcompat.test so that it works with windows mandatory locking. 
FossilOrigin-Name: 8d05f66db7d6e8b8916fcf22fa92159d863d2610
 2010-08-19 17:16:11 +00:00
dan
fc5026d3c2 Add tests for WAL mode to test/backcompat.test. 
FossilOrigin-Name: 7999910e85b1f24c5860425ba47e7ab10c22e887
 2010-08-19 15:48:47 +00:00
dan
a1f8da1848 Merge two leaves. 
FossilOrigin-Name: b03091fc3592896fcf1ec563ae9682a8e0a05baa
 2010-08-19 15:12:54 +00:00
dan
a35dafcdea Modify the code for reading hot-journal files so that it can handle journals generated by versions 3.5.7 and earlier. 
FossilOrigin-Name: b9170f2903c480bca2bdc986e98aaeadfdb9ad2b
 2010-08-19 15:11:34 +00:00
shaneh
8128bb2910 Fix typo in TCL stubs support for configure in Makefile.in 
FossilOrigin-Name: 4c7ad73d22b7e8c90955730c2dbb79ed53cd750b
 2010-08-19 14:41:58 +00:00
drh
6b47fcacb4 Remove a NEVER from balance_quick() that can occur in WAL mode on 
a corrupt database file.

FossilOrigin-Name: b273891ab05a18b68a76c870ea3be9f1a56c40a9
 2010-08-19 14:22:42 +00:00
dan
8311c47d83 Add new test script backcompat.test, for testing database/journal/wal file compatibility against previous versions. 
FossilOrigin-Name: 8804f4989d157707911488781109ce0641c0ad0b
 2010-08-19 11:05:53 +00:00
drh
e22e03e210 Fix two asserts in the btree logic so that they work correctly even for 
maximum-size index entries for 32K and 64K pages.

FossilOrigin-Name: e127192d106bd7e036caacf01bf7725eeaa85dbe
 2010-08-18 21:19:03 +00:00
shaneh
1b8f78ca57 Updated tests for CLI. Added some basic tests for the .import command. 
FossilOrigin-Name: d46567e5d75a2b9fe96d2a7a30708b2827a0d490
 2010-08-18 17:16:26 +00:00
dan
5a9e07eb40 Disable the SQLITE_MAX_PAGE_SIZE compile time option (it is now always set to 65536). Fix some other problems in test files. 
FossilOrigin-Name: 56cc883d3af5574c9dafecef8aa96d1d05c01b83
 2010-08-18 15:25:17 +00:00
shaneh
35cf908a86 Fix issue with wal.test on Windows. 
FossilOrigin-Name: 3497f54ac2f85746c50fe6f94380a22033f2464b
 2010-08-18 14:54:03 +00:00
shaneh
1df2db7fd1 Fix some compiler warnings in the MSVC build. 
FossilOrigin-Name: 1f5662b7db5d623c8d99c45a8d97a0aa4427593f
 2010-08-18 02:28:48 +00:00