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
18,472 Commits 1,785 Branches 392 Tags
lemon-improvements
Commit Graph

2075 Commits

Author SHA1 Message Date
dan
c8f44d245c Fix crashes that could occur if SQL NULL values were passed to the built-in 
FTS5 snippet function. Edit: breaks amalgamation builds.

FossilOrigin-Name: 6a790b67a0a5c698526db16ea262b13ecdd1b6ca74e80bdccfcad88ddbdc933a
 2017-12-26 14:32:25 +00:00
drh
efc88d020c Modify the new sqlite3_vtab_collation() interface so that it takes a 
pointer to the sqlite3_index_info object passed into xBestIndex rather than
an sqlite3 connection pointer, which the xBestIndex method might not have
access to.

FossilOrigin-Name: 5c1fe6666019147a26480b5db1bf2f474a5d072c234c736f16ed5d2a9a040b3f
 2017-12-22 00:52:50 +00:00
drh
36e31c6915 Change the name of SQLITE_DBCONFIG_FULL_EQP to be SQLITE_DBCONFIG_TRIGGER_EQP 
(which we can do without breaking compatibility because the former name has
not yet appeared in an official release) and streamline its implementation.

FossilOrigin-Name: fffc7685d19f78ec322a4e834ad727af20a17e2e1c35680e4b1c4162c4786f60
 2017-12-21 18:23:26 +00:00
drh
fafd6fbb49 Add the experimental ".expert" command to the sqlite3.exe shell. 
FossilOrigin-Name: 0821bae7afefed98102c81104b4a477e81816bb1f43353c80865411771e3c5a7
 2017-12-21 02:17:02 +00:00
drh
0872e268ab Lowercase local variable names in the SHA3 extension in order to avoid 
collisions with macros in termios.h.

FossilOrigin-Name: 3ec7371161bd617e40328aa015b09acc2b37b0b5d269a87050a0c57163f92801
 2017-12-20 23:46:29 +00:00
dan
e42e1bc594 Fix crash in sqlite3_vtab_collation() when called for an IS NOT NULL 
constraint.

FossilOrigin-Name: ad38d2c4f073705c02c7b38675e8ae86fe4a794d54eb796e7ed51a905824d5f5
 2017-12-19 18:56:28 +00:00
dan
43efc18669 Experimentally add the SQLite expert functionality to the shell tool. 
FossilOrigin-Name: 51068dbaeaef13bb80af8126b8c4f3a454dee63de5127d706db50bf789533e60
 2017-12-19 17:42:13 +00:00
dan
11546779b7 Merge latest trunk changes into this branch. 
FossilOrigin-Name: d5b597b52a1213cdf382d96f4df3535727be0852b25bafd12bbef54da946c5f2
 2017-12-16 19:16:24 +00:00
drh
468c649331 Add unnecessary initializations to some local variables in the rtree module 
to suppress false-positive compiler warnings coming out of MSVC.

FossilOrigin-Name: 64487d658cb3b6c8c67f1e198c70813c963de52599f3ea974bdc2aa432e74de9
 2017-12-16 04:37:15 +00:00
dan
2c44e370f1 Enhance the "swarmvtab" extension. See header comments in ext/misc/unionvtab.c 
for details.

FossilOrigin-Name: 01c173651ab22b7b0c139eded6f2ad8504efd09088df8ae6a3471230ebf2306f
 2017-12-15 20:21:17 +00:00
dan
34aebb88da Change some LSM code internal typenames from "Blob" and "Pgno" to "LsmBlob" 
and "LsmPgno". This allows the LSM code to be compiled as a single unit with
sqlite3.c.

FossilOrigin-Name: 30bf38d589adf0b2eb613e184ffb03ed7e625736cb04fd5c341328f72bc5ef4d
 2017-12-13 15:32:33 +00:00
dan
62128540ef Add script to amalgamate all LSM files into "lsm1.c". 
FossilOrigin-Name: e32b69d73062e233b0ac853611d10b24546a346a603289ab0e339a3604ae2af4
 2017-12-13 14:22:48 +00:00
dan
2e6ca188c4 Fix a buffer overwrite in fts5 that could occur when processing a prefix 
query.

FossilOrigin-Name: 92fc146bc2b781e7e2d7138b00e5ea649c6fee1c2b8449420460a1b3e5c9661b
 2017-12-11 17:20:37 +00:00
dan
21540ae479 Add compile time switch SQLITE_ENABLE_ICU_COLLATIONS. For enabling ICU 
collations without also enabling the tokenizer, the LIKE operator, the
REGEXP operator, or the unicode aware upper()/lower() scalar functions.

FossilOrigin-Name: a079f914522d7bc4b3d27d70114eb09adedfac936a64883e6ed8d382c428dd0e
 2017-12-08 16:23:38 +00:00
drh
70fedc584d Fix harmless compiler warnings in the rot13 extension. 
FossilOrigin-Name: 113470772b04210b9300803124c06af2c0b33278313b311fefe6f80594b24e4a
 2017-12-07 16:51:25 +00:00
dan
3d9c7c3a4f Merge latest trunk changes into this branch. 
FossilOrigin-Name: 373fa21bffd37053bb1a741d3ace2f003a5639bf373c20ea7bb24a31080888b3
 2017-11-29 16:16:29 +00:00
dan
d37ce8396a Add the "^" syntax from fts3/4 to fts5. 
FossilOrigin-Name: 24d7058e2799133dd681d2fef341025ca50554861bb4cd39e93ee87ae1d8a605
 2017-11-24 19:24:44 +00:00
dan
cda185d3a2 Ensure that empty space on pages is zeroed before they are written to disk. 
This helps with compressed databases, and stops valgrind complaining about
uninitialized bytes and write().

FossilOrigin-Name: 5ffec5db33137251090d45e2ca7e3e7823e3215ae89822d905923424ceba2ac2
 2017-11-16 20:48:47 +00:00
dan
3e846cb81f Fix a problem causing LSM to add unnecessary padding to empty segments in 
compressed databases.

FossilOrigin-Name: 1bc2d04645c5239ba9a30a13f6fb3c8cc46461c864e7927012bc0ad305eb705e
 2017-11-08 11:14:53 +00:00
dan
0e90ad6a37 Fix handling of partial indexes in checkindex.c (sqlite3_checker). 
FossilOrigin-Name: 31932a9eb8dbb33d5535715ae8bbfdc55ce66b1a1a0abd57cefe720eeb31e231
 2017-11-07 19:02:00 +00:00
drh
0714a0dee1 Add the --trace option to the sqlite3_checker utility program. 
FossilOrigin-Name: dc217b7cfe680044d8742e317701abd0269162da8f5cb097361ae7f47fd9ba2d
 2017-11-07 16:54:20 +00:00
drh
7031b12c57 Enhance the checkindex.c virtual table so that it will output the 
index_name and after_key parameters.  Also add a new diagnostic output
column named scanner_sql which shows the SQL statement used to implement
the current index scan.

FossilOrigin-Name: 32e2520ce91351acceda845d81c9567f7a634257dc2b5b90fe6fb6583d8c0f87
 2017-11-07 16:23:24 +00:00
dan
a3bc84255a Fix an LSM problem with read-only connections and compression (not 
compression-factory) callbacks.

FossilOrigin-Name: 51ee5188b03c4b9508e94afaee4bf1f224aef28875efabda8ce09a5ab641d99e
 2017-11-04 08:53:37 +00:00
drh
537e70289f The extensions functions in spellfix are all deterministic. 
FossilOrigin-Name: 29ec855e13e0dcd675dcf12948b42f9e669d0a31c5d9efb95857888aba0beeee
 2017-11-03 08:46:48 +00:00
drh
a48a290bcc Fix harmless compiler warnings in sqlite3_checker.exe 
FossilOrigin-Name: 491f867b377b3b9e00bd713fb07df00207673f9eca0e7d5b7af7974082c8e3f0
 2017-11-01 19:58:25 +00:00
drh
7dcde38f59 Make sure the JSON1 extension is available to sqlite3_checker.exe 
FossilOrigin-Name: a946a8ed46ba76b9a09bcbac58000d3d92db1f08a98f6cc12365be696d8921de
 2017-11-01 19:50:11 +00:00
drh
9b37b366c2 Adjust page numbers in the ext/repair/test/checkfreelist01.test module due to 
the fact that the pending-byte page is no longer shifted down to a low-numbered
page but is in its rightful place.

FossilOrigin-Name: c1641affae31a4350727ce940c92499263880e672dc2c3f47e78e1c23ae99b78
 2017-11-01 19:22:08 +00:00
drh
3680e89b1e Add the "sqlite3_imposter DB SCHEMA ROOT SQL" command to sqlite3_checker. 
Use it to fix the checkindex01.test module.  There are still errors reported
by the checkfreelist01.test module.

FossilOrigin-Name: 0593a2ba74c886afe8a65cea1310025bb9777c320d093278044719210c9f6ba2
 2017-11-01 18:31:34 +00:00
drh
37ab9523fa Move the test scripts for checkfreelist and checkindex over into the 
ext/repair/test directory.  Run them now using the sqlite3_checker utility
with the --test option.  Some tests are currently failing due to an
incomplete port.  This is an incremental check-in.

FossilOrigin-Name: 17f8d5e111a9fe5b074f946e23936ae5a2a7a8d8018bad4212660d8eb81c04b7
 2017-11-01 18:05:32 +00:00
drh
02c21b7e34 Minor cleanup in checkindex.c. Add progress displays when checking a 
single index in the top-level TCL script for sqlite3_checker.

FossilOrigin-Name: 3ca31cc3ffe1cce4a9961d29801eebd47f0093d1b53d0ea63386338a1d434fd3
 2017-11-01 13:09:02 +00:00
drh
24fa4d57a7 When sqlite3_checker finds a problem, show the row key as part of the error 
message, not the row index number.

FossilOrigin-Name: 6ffe917d10e298cd80cd3a8c8c5116a2819145a176fb8cfccd5dbd88b10f39df
 2017-11-01 01:05:41 +00:00
drh
1fae37319e Actually perform index checks when running sqlite3_checker 
FossilOrigin-Name: 54530020260ea9e4cfd021f5ffccb74d78c469b717dce377d3df6eaf84b63719
 2017-11-01 01:01:20 +00:00
drh
4e8ad3bc14 Begin putting functionality into the sqlite3_checker binary. 
FossilOrigin-Name: e82e883b93128e4d1105a82abe8d1860c0a15505b6ca421e187b9bbbc2fdc659
 2017-11-01 00:10:34 +00:00
drh
927dd51fce Add the checkfreelist extension to the sqlite3_checker binary. 
FossilOrigin-Name: 0c22f0d6d19e595c0577b0bad416522e71647f54d2eb5cda587e2ccc5f63dd6a
 2017-10-31 18:09:40 +00:00
drh
2737fa0376 Add build infrastructure for the sqlite3_checker command-line utility. 
FossilOrigin-Name: 429e3c3c85d6b677038be93567f93e69eb756442bb421bb02ee5d5d69290fa09
 2017-10-31 15:49:19 +00:00
dan
7eded5925b Fix a couple of issues in incremental_index_check to do with CREATE INDEX 
statements that contain embedded SQL comments.

FossilOrigin-Name: 2aef41815a9f1786ebdf09d8f6cfa59a8e7d733253eafeae24fa6e2a093bb1d8
 2017-10-31 12:01:01 +00:00
dan
e7a579d27d Add support for indexes on expressions to incremental_index_check. 
FossilOrigin-Name: 8c1c701fdbe0d56ee7f6f7d7b583aafde9fa14acc93ee8ecaddc8bb311e2bf52
 2017-10-30 19:38:41 +00:00
dan
75650d4f94 In checkindex.c, use C code instead of SQL/group_concat() to compose various 
SQL clauses. This is to make it easier to support indexes on expressions.

FossilOrigin-Name: 940606b3af059eb3f79d71fec871ea88df8bce0349f5b33b79c147a85610e269
 2017-10-30 17:05:18 +00:00
dan
6fc6617909 Fix an issue in incremental_index_check with indexes that use non-default 
collation sequences.

FossilOrigin-Name: 3ebb2351e2650d263029d2c0042683cba3529c9d3f76b5f994f2e737b84d3f67
 2017-10-30 08:04:38 +00:00
dan
19465e7380 Fix "after" parameter handling in the incremental_index_check code. 
FossilOrigin-Name: c40c3c62e996044f31ca49ffc2edb2cc0320e69956f7ee6fe3e9012200e0d9a0
 2017-10-28 20:31:25 +00:00
dan
bde13e2694 Add the start of the "incremental_index_check" virtual table in 
ext/repair/checkindex.c. For incremental verification of index contents.

FossilOrigin-Name: d5b9dada471358a2864727759648b763bf6890fc2521fac53c0d8216017d39b7
 2017-10-27 20:53:16 +00:00
dan
7e2b38c53b Add tests cases and fix minor issues in the rtreecheck() function. 
FossilOrigin-Name: d6130cd226c0ca95e02f0cbabfdc27071acdcf83e0d0cb0eaa47d992479ed9a1
 2017-10-25 18:17:24 +00:00
mistachkin
8c66e5b73e Fix compilation issue (C99-ism) seen with MSVC. 
FossilOrigin-Name: 61870b42b033189509b244c76d28932f7a447b887ffe04a3c81461148e54cfb5
 2017-10-25 18:00:58 +00:00
dan
1917e92fdb Add SQL scalar function rtreecheck() to the rtree module. For running checks 
to ensure the shadow tables used by an rtree virtual table are internally
consistent.

FossilOrigin-Name: dde0bb3eab1316c3247b1755594527ca70955aab4ad4907190731f7ec092b327
 2017-10-25 16:38:34 +00:00
drh
98d529b541 Add the sqlite_btreeinfo eponymous-only table for introspecting the schema 
and estimating the sizes of various btrees.

FossilOrigin-Name: 1e30f4772db1e1086096f72d32e87c552923be8b264aa13cf822fae754eb083d
 2017-10-25 01:34:24 +00:00
dan
b5ef728db6 In lsm (not SQLite), avoid opening the *-shm file before the database file is 
locked. Otherwise, there is a race condition whereby a connection in another
process process may unlink() it while it is still in use.

FossilOrigin-Name: c8b8b9b573665c2b4d278bb679a48ac407374b8d860f0c3f4d50a303043464ad
 2017-10-23 11:48:00 +00:00
drh
277ee81bab Create the new ext/repair folder and move checkfreelist.c there. Remove 
checkfreelist.c from the command-line shell (undoing check-in [48418f2e]).

FossilOrigin-Name: dfdebd12bfc80b91d234ab328cb6106d5d37ccb79b58e36e556c1a8af640a4ab
 2017-10-12 19:50:28 +00:00
dan
518e3f0673 Merge latest trunk changes with this branch. 
FossilOrigin-Name: 2719cf5c5bbe8e31d18368d54d968af3878ad2e15f0666e18d7b567d7439c451
 2017-10-11 20:26:07 +00:00
drh
f294ce648b Add the checkfreelist extension to the command-line shell. 
FossilOrigin-Name: 48418f2ed5ab1cb270776166141ce32ed3ebf22ed4e33a66a204d4fde9d11f52
 2017-10-11 18:26:26 +00:00
dan
7d157f91f4 Check that the leaf count on each freelist trunk page is in range as part of 
checkfreelist processing.

FossilOrigin-Name: 4e89406248f51d3b83d61e5472fb493f3d3b4ff2a69bf256c7e15445eeb2f3ec
 2017-10-11 18:21:44 +00:00