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
19,676 Commits 1,785 Branches 392 Tags
version-3.25.3
Commit Graph

19676 Commits

This Branch
This Branch
All Branches
Author SHA1 Message Date
drh
ea6eb55ebe Version 3.25.3 
FossilOrigin-Name: 89e099fbe5e13c33e683bef07361231ca525b88f7907be7092058007b75036f2
version-3.25.3 		2018-11-05 20:37:38 +00:00
drh
2fb34b92ca Disable the IS NOT NULL optimization when the IS NOT NULL operator is part 
of the ON clause of a LEFT JOIN. Fix for ticket [65eb38f6e46de8c75e188a17ec].

FossilOrigin-Name: 8d09ce5d738bb00c4524c663ec69555fe917ac733d58b06a302675ce7fe33fca
 2018-11-05 13:48:50 +00:00
drh
aa05f52eae Add extra defenses against strategically corrupt databases to fts3/4. 
FossilOrigin-Name: 940f2adc8541a838c19ceeb62105074117c906efa0f36610a0d3e8d6f859154f
 2018-11-05 13:43:03 +00:00
drh
d6b318bdee Increase the version number to 3.25.3. 
FossilOrigin-Name: 1250ab8f22c1e34ed478588c2a858af78c45c128db30f703ece41b17c8d42a09
 2018-11-05 13:37:19 +00:00
drh
413a0dc8c6 Fix a assert() in the query planner that can arise when doing row-value 
operations on a PRIMARY KEY that contains duplicate columns.
Ticket [1a84668dcfdebaf12415d].

FossilOrigin-Name: 1309c84ad36b6ac6dedd103892445bf60dbf27167ef71e7722e934f2175a4199
 2018-11-05 13:35:11 +00:00
drh
ae8cb0a4e0 In the WHERE-constraint propagation optimization, if there are duplicate 
constraint, make sure only one of them propagates.  Proposed fix for
ticket [cf5ed20fc8621b165].

FossilOrigin-Name: caebf8792576752d1cd8af29f00ba3909b2448018c830287007328f6c31072c1
 2018-10-25 15:25:10 +00:00
drh
f12723725f Fix a potential crash that can occur while reading an index from a corrupt 
database file.  The corruption is a record-header-size that is larger than
0x7fffffff.  Problem detected by OSSFuzz against GDAL and reported to us 
(with a suggested fix) by Even Rouault.  The test case is in TH3.

FossilOrigin-Name: 5d2916589649421b53c599417577c8707352583378b0f47c899ee779cbd523c7
 2018-10-01 14:05:03 +00:00
drh
9def1920e4 Ensure that the OP_VColumn opcode does set sqlite3_vtab_nochange() unless 
the OPFLAG_NOCHNG bit is set in P5.  Fix for ticket
[69d642332d25aa3b7315a6d385]

FossilOrigin-Name: 31ac8dbae4d5d3d5aee28959e9b1bfcb72a2f878541c0cbd74be46b0193df89c
 2018-10-01 11:00:00 +00:00
drh
2d9505c5db Disallow the use of window functions in the recursive part of a recursive CTE. 
Fix for ticket [e8275b415a2f03bee].

FossilOrigin-Name: b2849570967555d486e797cb1807e45706cb55036a4b9074be267b5e4940ec91
 2018-09-27 13:10:37 +00:00
drh
653b4f6078 Version 3.25.2 
FossilOrigin-Name: fb90e7189ae6d62e77ba3a308ca5d683f90bbe633cf681865365b8e92792d1c7
version-3.25.2 		2018-09-25 19:08:10 +00:00
dan
b67fd17b5f Fix a problem in releasetest.tcl causing configuration "Fast-One" to fail. 
FossilOrigin-Name: 32ac0014266706baa4e98de808eb5a6d0ffdb39dc37b4e37668f339e9e238183
 2018-09-25 13:52:54 +00:00
drh
e4b1eb90b7 Bump the version number to 3.25.2. 
FossilOrigin-Name: 996d74f501a45ae12ddc16fe66f849993142e47ccb8b068c412d2ea9bd301ec2
 2018-09-25 01:38:00 +00:00
drh
5bc4851d00 Fix a compilation issue in the "userauth" extension. Also fix a few test 
script errors that occur with SQLITE_USER_AUTHENTICATION=1 builds.

FossilOrigin-Name: e7db5f59ee62bb8bf61e17a75ecf89f7472fccf68d6d02b892e349142db1f47e
 2018-09-25 01:35:17 +00:00
drh
77f136a4a4 Fix a problem building on Android with SQLITE_ENABLE_BATCH_ATOMIC_WRITE set. 
FossilOrigin-Name: b9ffa77c92cbc47618da16f412df7745cbf92a7098d3f015724f9b66dca8a2e1
 2018-09-25 01:17:50 +00:00
drh
4195437504 Avoid incrementing the SQLITE_LOOKASIDE_MISS_SIZE stat before sqlite3_open() 
returns. Fix test script problem in lookaside.test.

FossilOrigin-Name: 3bd94e431783085a22733102218c0fe24a26376033cf9fe4380f6890aba8c79a
 2018-09-24 21:07:35 +00:00
drh
75d1119500 Fix missing space in 'configure.ac' reported on the mailing list. 
FossilOrigin-Name: 4407e15ac953cca0e33d76bd1e6500d70ae9cb239ea2d776a19a13f59532b3f6
 2018-09-24 20:50:14 +00:00
drh
ca446b3ccd Add the "PRAGMA legacy_alter_table=ON" command to enable the pre-3.25.0 
behavior of ALTER TABLE that does not modify the bodies of triggers or
views or the WHERE clause of a partial index.  Enable the legacy behavior
by default when running the xRename method of virtual tables.

FossilOrigin-Name: 31dc8b191c3b7921f1e9ac1a07854d2bd9e39bc4a20cf2a70a28c41cdb0d0e95
 2018-09-24 20:48:20 +00:00
drh
d4c1fdafd3 Allow a writable virtual table to have a schema with an INTEGER PRIMARY KEY 
and WITHOUT ROWID.  This fixes ticket
[f25d5ceebe1d710ff61a571e395356869d8272ef].  Test case in TH3.

FossilOrigin-Name: 3139af9910e484682d37eeac9dca188a73859b3241017bde31bc6cb597b40d3c
 2018-09-24 19:41:12 +00:00
drh
30b281b5dc Fix a faulty assert() in the validation logic for the LEFT JOIN strength 
reduction optimization.  Problem found by OSSFuzz.

FossilOrigin-Name: 8694c3d565f6f8209e24230765efa476e10048abb69a300b9df5cbaa45824ab8
 2018-09-24 19:32:16 +00:00
drh
579e80cd2f Fix the "sqlite3" command in the TCL interface so that it correctly returns 
an error if invoked with no arguments.

FossilOrigin-Name: 8a82fcf05fa84def1433489f71dc28b47c1e082d044512b8756ec1bb4b913fab
 2018-09-24 19:21:46 +00:00
drh
8f25fe573b Fix a problem with views that use window functions as part of complex expressions. 
FossilOrigin-Name: 1c0ecbbdf1f309feaca747230d8925e61ddc6049a46c1dbbac7344bb933ab5e3
 2018-09-24 18:29:21 +00:00
drh
aaec593fbc Version 3.25.1 
FossilOrigin-Name: 2ac9003de44da7dafa3fbb1915ac5725a9275c86bf2f3b7aa19321bf1460b386
version-3.25.1 		2018-09-18 20:20:44 +00:00
drh
ccc6551307 Disable the ORDER BY LIMIT optimization in queries using window functions. 
This fixes a problem that was introduced by check-in [206720129ed2fa8875a286]
which attempted to fix ticket [9936b2fa443fec03ff25f9].  This changes is
a fix for the follow-in tocket [510cde277783b5fb5de628].

FossilOrigin-Name: 36c75fd5b7cddb48be74f4f86fafe588b3e597a80d226eeb43b77cbd3817572e
 2018-09-17 15:25:21 +00:00
drh
25f801305a Fix a false-positive in the post-ALTER-TABLE schema verification logic that 
prevents ALTER TABLE from working if the table being altered has a trigger
that references any column of a virtual table. Ticket [b41031ea2b537237].

FossilOrigin-Name: 5ce568c0e73c8cd258c8fe21e6c5088cfbe3ac017460a014a4b832daecc0cdf7
 2018-09-17 14:18:41 +00:00
drh
01191f66f5 Increase the version number to 3.25.1. 
FossilOrigin-Name: f3c8cfdb35c6f0786bb21cafcc8c7e751e48a465f3e5a01292399f40e068e1d6
 2018-09-17 11:36:20 +00:00
drh
f7d3b7a56c Version 3.25.0 
FossilOrigin-Name: b63af6c3bd33152742648d5d2e8dc5d5fcbcdd27df409272b6aea00a6f761760
version-3.25.0 		2018-09-15 04:01:47 +00:00
drh
9fd8425467 Fix minor typos in comments that get carried over into documentation. 
No changes to code.

FossilOrigin-Name: 7921dd91a1745aa79ea157b91b22c380e9331800050861ee6ca1f0efa0a97628
 2018-09-14 17:42:47 +00:00
dan
f86ff13206 Update releasetest.tcl to run "make test" as part of the "Fast-One" 
configuration.

FossilOrigin-Name: d5ebfe1c75d336dac374d9cfa257e45e77ab51f9c2f24d1af615cbbe9dd83d9b
 2018-09-13 17:11:51 +00:00
drh
af524a6343 Make sure the %z optimization for printf() is not invoked if there has been 
a prior error (SQLITE_NOMEM or SQLITE_TOOBIG) associated with the same
printf() call.

FossilOrigin-Name: a2304a3474b0ca35eee0af64286ce2f7cb24d181323e128d5f04f7fe6e1c0980
 2018-09-13 17:07:12 +00:00
drh
396a103612 Fix a requirement mark on a test script. No changes to code. 
FossilOrigin-Name: 628d5c0aa057c05c7cf84c330a51b8a44720c97250eadf0e5e8c750b7a2969c3
 2018-09-13 13:17:14 +00:00
dan
a86acc2132 Fix an assert() in os_unix.c that is not true when using RBU. 
FossilOrigin-Name: 028ed8618af012b51104a06cc155b45d98bc4ff833d4431b9c38fd6851a74e82
 2018-09-12 20:32:19 +00:00
drh
16b870d804 Restrict the scope of internal-use functions in alter.c. 
FossilOrigin-Name: 4396914f8e1a847d86c22fb0b91e7431cf19aa260cbec520af3564248d6897ad
 2018-09-12 15:51:56 +00:00
drh
83a9d14fcd Improvements to the documentation for SQLITE_FCNTL_DATA_VERSION. 
No changes to code.

FossilOrigin-Name: 27837624336d2883f721310bd4dceedb77085d1008af5e12557f634936d48b8c
 2018-09-12 14:28:45 +00:00
dan
e8ab40d219 Fix an invalid pointer comparison triggered by renaming a table column when 
there are views with explicit column names in the schema.

FossilOrigin-Name: 572de7e4e33562c72cd90790b267ba389370f21ddcaebc4db609fd76ae9b7ada
 2018-09-12 08:51:48 +00:00
mistachkin
ed008ecede Fix some harmless compiler warnings seen with MSVC. 
FossilOrigin-Name: 78862252da7f59d4737ed16f4ccf100cea27d8b421db31051afbaa8d96f24de3
 2018-09-12 01:05:26 +00:00
mistachkin
90d6f4807b For MSVC, migrate some commonly used shell compilation options to the library. 
FossilOrigin-Name: 68a71e5f4e9cbd15eb64d271008e29f40913480bac467b90fb64f0269ad75818
 2018-09-12 00:48:17 +00:00
drh
8741d0ddb0 Fix a harmless compiler warning that arose from the ENABLE_CURSOR_HINTS 
fix of check-in [0af18674ca5b34e67e]

FossilOrigin-Name: f578e62ae6f6cc78d8281adab9fa93f3f58711879c2860bbe19f291d257dc0af
 2018-09-12 00:21:11 +00:00
drh
15c42942b3 Do not do the byte-by-byte modifications in the resetdb.test script if the 
reserved-byte flag in the DB header is non-zero, because in that case the
bytes will be in the wrong place and the test won't work.

FossilOrigin-Name: 0af18674ca5b34e67e1685be3adcdd99a7b8650589c6a7cde7ad9ef1852a8777
 2018-09-11 19:05:32 +00:00
dan
e3e79213b1 Fix a problem causing ENABLE_CURSOR_HINTS builds to segfault. 
FossilOrigin-Name: e7033104fa8bd974a9a3d173200aa07a3aa3daade86e7eb65cad5d00b086969e
 2018-09-11 13:38:35 +00:00
dan
30a7d7ddc5 Fix a test script issue in fts3ao.test. 
FossilOrigin-Name: 74c381b573817d0212153278b5ee5d2238a27a727dcf7ee769365c47bb9fc40d
 2018-09-10 19:34:06 +00:00
dan
be312ae9fd Fix a minor problem causing an incorrect cursor-hint to be generated in some 
cases.

FossilOrigin-Name: d879c47d7d145cbe99602b2cf70294ddc946709e8d61040942085d29e2c5b6cd
 2018-09-10 19:27:12 +00:00
drh
173e7823df Add the ability for loadable extensions to access the new 
sqlite3_create_window_function() interface.

FossilOrigin-Name: 3def6d8ef11702eb03ad56aeb01763ec8e4ca8ed3b570ffb680164c5c3679e4f
 2018-09-10 17:21:17 +00:00
dan
d2f65014bb Fix a broken assert() in fts3.c. 
FossilOrigin-Name: 564fa75195c5179d0bc86431aaff06136fc65ec63aa9839cd1114b1fbfac928b
 2018-09-10 16:38:25 +00:00
drh
473dc7347e New testcase() macros on virtual table xBestIndex logic. 
FossilOrigin-Name: 3bbd9c5f2f1990f7d187951474a86996650dcede12c2608484d43250ae0b30d6
 2018-09-10 14:43:15 +00:00
drh
b7a002f836 Fix the LIKE optimization so that it is disabled when the LHS of the 
expression does not have TEXT affinity and the RHS is the pattern '/%'
or the RHS begins with the escape character. Fix for ticket
[c94369cae9b561b1f996d0054b].

FossilOrigin-Name: f191431d63aba187000b5cbaf3e072ff5f1b1eef6a2a407fb4d1629bda4e4e8f
 2018-09-10 12:40:57 +00:00
dan
eb3fe0b9d4 Fix a problem with processing a "vtab.col IS NULL" expression within 
the WHERE clause of a query when "vtab" is a virtual table on the rhs of a
LEFT JOIN.

FossilOrigin-Name: 83da4d4104ee1870a2a95bb5fa15ee6584c655d8b314b6b8ab97592dad4ee811
 2018-09-10 12:17:16 +00:00
drh
f7ded14792 Fix an unreachable branch in the new sqlite3WhereOrderByLimitOptLabel() 
function of the query planner.

FossilOrigin-Name: 5a954533edbde58aa7158572ece7ceeb1c6e610b71f3ae45d0b8371d74f9fea5
 2018-09-08 20:29:04 +00:00
drh
6ee5a7b481 Fix multiple issues with the ORDER BY LIMIT optimization. This is the 
proposed resolution to ticket [9936b2fa443fec03ff25].

FossilOrigin-Name: 206720129ed2fa8875a286266d05b99fb2caf8671e4b74b26a6286a2073fcd8b
 2018-09-08 20:09:46 +00:00
mistachkin
c93c614543 Add a missing call to free() in Lemon. 
FossilOrigin-Name: 8b4cf33aafe09d9009119dcbd464b54be9605af5701002ee458819efa6e2e1f9
 2018-09-08 16:55:18 +00:00
mistachkin
42cb6ec4e6 Fix typo in the Win32-specific code for the fileio extension. 
FossilOrigin-Name: e812e5d59a699e8b82c51d465d9c0f09df6a1e6996b5499814dca99c5f8020d5
 2018-09-08 16:53:47 +00:00