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
13,432 Commits 1,785 Branches 392 Tags
sqldiff-changeset
Commit Graph

5092 Commits

Author SHA1 Message Date
drh
e918aaba98 Fix foreign key CASCADE for cases where the parent key is an INTEGER PRIMARY 
KEY and the parent table contains other columns named "rowid", "_rowid_",
and "oid".

FossilOrigin-Name: ed3cbaab6ad49b0cb5b17e44def26c866919387a
 2015-04-10 12:04:57 +00:00
dan
75395ccd17 Do not allow virtual table constructors to be called recursively. 
FossilOrigin-Name: 0a72726da21581ab16cb3e964bd825b8f2e931e4
 2015-04-10 07:55:07 +00:00
drh
b6f47deb0c Avoid signed integer overflow when converting oversized in-line integer 
widths and precisions in printf().

FossilOrigin-Name: 8e4ac2ce24415926247961b00a62425ae85d6ffb
 2015-04-07 15:39:29 +00:00
dan
8c069147ce Another change to avoid a problem caused by integer overflow in the printf() code. 
FossilOrigin-Name: 95625ef3adc3c408d67e70f877f390445fbb8292
 2015-04-07 14:38:57 +00:00
drh
a30d22a7a6 Further changes to guard against integer overflow in the width and precision 
of printf() arguments.

FossilOrigin-Name: 5ce4e7d7651e5c72a59f03f7aeb366291e62ab57
 2015-04-07 13:28:41 +00:00
drh
74b42275ec Guard against excessive width and precision in floating-point conversions 
in the printf routines.

FossilOrigin-Name: c494171f77dc2e5e04cb6d865e688448f04e5920
 2015-04-07 12:41:17 +00:00
dan
e3cdbad274 Fix a problem with fts3 prefix terms within phrase queries on "order=DESC" tables with a mix of negative and positive rowids. 
FossilOrigin-Name: 3ad829e50faca538db3abb2afb898b5521550c5c
 2015-04-06 11:04:51 +00:00
dan
4b0000c9a8 Fix a problem with fts3 prefix terms within phrase queries on "order=DESC" tables with a mix of negative and positive rowids. 
FossilOrigin-Name: 0cdf502885ea7e5805d7ba3719f055f5d48fc78d
 2015-04-06 09:05:29 +00:00
dan
b33c50f215 Fix a problem with resolving ORDER BY clauses that feature COLLATE clauses attached to compound SELECT statements. 
FossilOrigin-Name: 427b50fba7362e5b447e79d39050f25ed2ef10af
 2015-04-04 16:43:16 +00:00
drh
62ca61ee61 Disable the SQLITE_FCNTL_WAL_BLOCK feature for now. It needs more work and 
is not yet ready for release.

FossilOrigin-Name: 4ae9a3acc4eeeb7998769eb856c97c2233476f72
 2015-04-03 20:33:33 +00:00
dan
5f1731f670 Disable e_walauto.test on OpenBSD, as it requires a coherent cache. 
FossilOrigin-Name: 90701227085b8b8eb10a8eebe8d55f38b4778574
 2015-04-02 15:24:53 +00:00
drh
6b5f0ebe97 Handle very large URI pathnames for in-memory shared-cache databases. 
FossilOrigin-Name: 586a94e85bc13700a2093734711c1367fa814b8c
 2015-03-31 16:33:08 +00:00
drh
96e285692a Fix the corruptJ.test case so that it works with and without 
SQLITE_SECURE_DELETE.

FossilOrigin-Name: 0c0ecfd68573957553b966229a67bfcd10ce4b99
 2015-03-31 14:31:41 +00:00
drh
116f0be024 Prevent a possible infinite loop when trying to DROP a table from 
a corrupt database.

FossilOrigin-Name: 395bb3e677a6551b06ba96fc58c393132b93d1e8
 2015-03-30 23:43:56 +00:00
mistachkin
56d89cbee3 Revise Win32 locking test to account for recent log message changes. 
FossilOrigin-Name: 1bc76339e8542770bff7829a3dd346680950c0a5
 2015-03-26 18:24:26 +00:00
drh
d2f83139f3 Fix the saveCursorPosition() routine in btree.c so that it works 
correctly for a eState=CURSOR_SKIPNEXT cursor.

FossilOrigin-Name: 37866b4d483296ab9b7fcb9f5486695d4c2b8ddd
 2015-03-25 17:35:01 +00:00
dan
428630cfcf Add tests to check that attempting to DROP a virtual table while it is use does not cause problems. 
FossilOrigin-Name: 5ee625b1980f9fab6294d308349dfd9ba960b60b
 2015-03-24 14:57:21 +00:00
drh
74893a4cdb Fix a potential NULL pointer dereference following a syntax error. 
FossilOrigin-Name: 8d27e3e16a9be79fe227e833f4770ebe09a9d90b
 2015-03-22 10:23:17 +00:00
dan
e10d87f65a Avoid a segfault if NULL is passed as the first argument to SQL scalar function fts3_tokenizer(). 
FossilOrigin-Name: 6d0989695b486275824c14d5f88357267c1e8104
 2015-03-21 19:35:09 +00:00
dan
d2f99333cf Change walblock.test to block an external process for 10 seconds, not 5. 5 seconds is not long enough to tell the difference between a blocking lock and a series of retries. 
FossilOrigin-Name: 717335fcdb15430ed977cbc98d30345b71728b66
 2015-03-21 16:40:24 +00:00
dan
998aaa03ea Avoid an integer overflow in fts3 causing gcc 4.7.1 with -O2 to behave counter-intuitively (perhaps because the behaviour is undefined). Add an "ifcapable trace" to a test in shell4.test. 
FossilOrigin-Name: e3e234649616f20610abce9ae9da1c572d3a4377
 2015-03-21 12:22:51 +00:00
dan
e56f53ef7c Add a missing "ifcapable fts3" to a test case in vtab2.test. 
FossilOrigin-Name: d845b0f69093178517d66e1fc5060e8f62c681c7
 2015-03-21 10:53:01 +00:00
drh
8f9d0b2b25 Correctly detect the error of having a "*" wildcard on a SELECT without 
a FROM clause on the left-hand side of a recursive CTE.

FossilOrigin-Name: b11d1793a06a44931edcbf12a615b49794d53a62
 2015-03-21 03:18:22 +00:00
drh
f063685079 If a column is both UNIQUE and a PRIMARY KEY, make sure the PRIMARY KEY 
designation takes precedence.

FossilOrigin-Name: d871a7921722bb0fef6d51e1110a9703ddff78c8
 2015-03-21 02:58:20 +00:00
dan
80103fc614 Fix a problem causing collation sequence names to be dequoted multiple times under some circumstances. 
FossilOrigin-Name: eddc05e7bb31fae74daa86e0504a3478b99fa0f2
 2015-03-20 08:43:59 +00:00
dan
7377945a7b Fix a problem with creating virtual table with names specified using malformed utf-8 within utf-16 databases. 
FossilOrigin-Name: 9969cff2d0553c9bfa88a437e1bb0cc4200d49d7
 2015-03-19 18:56:17 +00:00
dan
b7134d0863 Fix an FTS3/4 problem with handling empty tokenizer declarations (e.g. "CREATE VIRTUAL TABLE t(tokenize=);"). 
FossilOrigin-Name: 26d2def8a53094356008861636d66f9ae8f2448a
 2015-03-19 16:25:42 +00:00
dan
e0417626ea Silently ignore any attempt to add a prefix index for prefixes zero bytes in size to an fts3/4 table. Or any prefix index size so large that it overflows a 32-bit signed integer. 
FossilOrigin-Name: ad4b19d2ac0889a23fe3b0fd844286efc10cdd82
 2015-03-19 15:52:07 +00:00
drh
657b4a87e5 Fix a bug in error handling in the ".trace" command of the command-line shell. 
FossilOrigin-Name: 6a48b5d794e891fdd167547c76835d677eb5e31d
 2015-03-19 13:30:41 +00:00
drh
5572f7e42e Also merge the WAL blocking lock tests that were somehow missed on the 
previous check-in.

FossilOrigin-Name: 7214dab7443d35c105904dd69635c1f8b45b2fc8
 2015-03-17 17:08:35 +00:00
dan
363fc9e724 Add a test for the change on this branch. 
FossilOrigin-Name: e22dde187eb0b389d6d93e2e39a26fd0f4e6196e
 2015-03-17 16:01:29 +00:00
mistachkin
05b6048dbd Fix typo of test prefix in the new WHERE test file. 
FossilOrigin-Name: 34779c528f1817d6ec34216b58fb4277956b5167
 2015-03-16 18:08:56 +00:00
drh
29894b6d2b When the WHERE clause contains two OR-connected terms with identical 
operands but different operators, try to combine them into a single term.
Example:  (X=A OR X>A) becomes (X>=A).

FossilOrigin-Name: 8bdda827a3d268009297a0216e3d94bf0eceeb2e
 2015-03-16 17:48:12 +00:00
drh
07b38959a4 Modify the fts3query.test script so that it works even when testfixture is 
built using a version of TCL that is unable to sort the
integer -9223372036854775808

FossilOrigin-Name: f61fd24b4d3b686911ea578f77612309099f0cc6
 2015-03-16 17:07:09 +00:00
drh
8426636cdc When a WHERE clause contains disjuncts with the same operands, try to 
combine them into a single operator.  Example:  (x=A OR x>A) becomes
(x>=A).

FossilOrigin-Name: 7a3097689d17625fb0dfc4372712f375f3bdb9a1
 2015-03-16 12:13:31 +00:00
dan
a0d56aef18 Another test case for the planner change on this branch. 
FossilOrigin-Name: f2207a0691ed361061719f4dacf021a677a9d892
 2015-03-16 09:21:30 +00:00
dan
a3d0c13654 When estimating the number of rows visited by a range scan for which the keys consist of more than one field, consider prefixes of stat4 samples as well as the full samples. 
FossilOrigin-Name: e1caf93c9ad0ee15d42030af95619f212d3fcf9d
 2015-03-14 18:59:58 +00:00
dan
dfac7016a7 Add tests to ensure "PRAGMA incremental_vacuum" and "PRAGMA auto_vacuum = incremental" handle corrupt databases correctly. 
FossilOrigin-Name: 1c2166cb2a387a0856f41b399c3648bf8c5fce73
 2015-03-13 15:44:36 +00:00
dan
3df3059252 Extra tests for commit [0f250957]. 
FossilOrigin-Name: 5aa522dcb9bfa18d49683f7cc889516984e2bcd2
 2015-03-13 08:31:54 +00:00
drh
e9b9f7599a Remove debugging logic accidently included in the previous check-in. 
FossilOrigin-Name: 2887fb38ffc28712c34028cd38db2b7993d864eb
 2015-03-13 00:11:09 +00:00
drh
3df79a9a1f Fix the "now" option for date-time functions for cases when STAT4 is disabled. 
FossilOrigin-Name: 3ac1f6a3cf1a8fd3ab1ca96b2564c13c4b8d2234
 2015-03-12 23:48:27 +00:00
drh
3795f3cee3 When STAT4 is enabled, allow probes of the STAT4 table using the value 
of constant functions computed at compile-time.

FossilOrigin-Name: 0f250957cd82be63e44eb99be6cc10760f4fdfc4
 2015-03-12 21:22:08 +00:00
dan
63c088e783 Disable multiplexing of master-journal files in the test_multiplex.c module. 
FossilOrigin-Name: b8684df395b5585a9428417c2bfd076515560f19
 2015-03-12 19:12:30 +00:00
dan
18bf807689 Allow the query planner to evaluate deterministic scalar SQL functions used in WHERE constraints if all arguments are SQL literals in order to compare the results with sqlite_stat4 sample data. 
FossilOrigin-Name: b7f1fc26d24012e1e7c7f6b3cc0b84ad2b02b8ad
 2015-03-11 20:06:40 +00:00
drh
94929646f1 Fix an incrblob2 test case so that it works on 32-bit systems. 
FossilOrigin-Name: 8d0b11c96e15556dd65ced05708a832aef134e69
 2015-03-10 15:34:47 +00:00
drh
9b5d76bf57 Revise test cases in malloc5.test to accommodate varying allocation 
sizes returned by some system malloc() implementations.

FossilOrigin-Name: fbae6bafd74d8da9c72be5f562a62f80b01cc846
 2015-03-10 13:50:18 +00:00
drh
560b7c72be New test cases for LIKE and GLOB with BLOB left-hand side values. 
FossilOrigin-Name: 50fa3c5fae90bd3b2f4121e99ab52d79963a6fda
 2015-03-07 12:58:52 +00:00
drh
b7c60ba668 Fix problems with reverse order sorting and indexes in the LIKE optimization. 
FossilOrigin-Name: 564b8fe79475d7584a21078e6098840b8ce6a6e1
 2015-03-07 02:51:59 +00:00
drh
16897072b5 Refactor some jump opcodes in the VDBE. Add JumpZeroIncr and DecrJumpZero. 
Fix the LIKE optimization to work with DESC sort order.

FossilOrigin-Name: 26cb5145bf52f8c3fffa8c69b6c24aee4d974883
 2015-03-07 00:57:37 +00:00
drh
a9c18a9067 Test cases added. Comments fixed. Proposed solution for 
ticket [05f43be8fdda9fbd9].

FossilOrigin-Name: 6b993bd54035b67f4d84941e3f444ca79b7feee1
 2015-03-06 20:49:52 +00:00