|
Revision tags: release, version-3.50.2, version-3.50.1, major-release, version-3.50.0, version-3.49.2, patch-release, version-3.44.4, version-3.49.1, version-3.49.0, major-relase, relase, version-3.48.0, version-3.47.2, version-3.47.1, version-3.47.0, version-3.46.1, version-3.46.0, version-3.45.3, version-3.44.3, version-3.45.2, version-3.45.1, vesion-3.45.1, version-3.45.0, version-3.44.2, version-3.44.1, version-3.44.0, version-3.43.2, version-3.43.1, version-3.43.0, version-3.42.0, version-3.41.2, version-3.41.1, version-3.41.0, version-3.40.1, version-3.40.0, version-3.39.4, version-3.39.3, version-3.39.2, version-3.39.1, version-3.39.0, version-3.38.5, version-3.38.4, relese, version-3.38.3, version-3.38.2, version-3.38.1 |
|
| #
935c3722 |
| 28-Feb-2022 |
drh <> |
Fix the Xfer-optimization on the INSERT statement so that it is omitted if
there is a RETURNING clause, since that optimization is not able to deal
with RETURNING. See [forum:/forumpost/595e132f71|f
Fix the Xfer-optimization on the INSERT statement so that it is omitted if
there is a RETURNING clause, since that optimization is not able to deal
with RETURNING. See [forum:/forumpost/595e132f71|forum thread 595e132f71]
for details.
FossilOrigin-Name: 1d3760a517b8bd2a6be82d2d5788945f49397cdc539fe28fd23e2c0c62a1dbe2
show more ...
|
|
Revision tags: version-3.38.0, version-3.37.2, version-3.37.1, version-3.37.0, version-3.36.0, version-3.35.5, version-3.35.4, version-3.35.3, same-as-3.35.3, version-3.35.2, version-3.35.1, version-3.35.0, patch, version-3.34.1, version-3.34.0 |
|
| #
92e21ef0 |
| 27-Aug-2020 |
drh <[email protected]> |
Include the original text of the CHECK constraint in the error message for
anonymous CHECK constraints.
FossilOrigin-Name: 5ce34a955bb36d77edc9951cb7ac2ef9c876d7d3ff5852af682f558e248f428c
|
|
Revision tags: version-3.33.0, version-3.32.3, version-3.32.2, version-3.32.1, version-3.32.0, version-3.31.1, version-3.31.0 |
|
| #
66c48907 |
| 29-Oct-2019 |
drh <[email protected]> |
Remove the legacy_file_format PRAGMA. In its place, provide the
SQLITE_DBCONFIG_LEGACY_FILE_FORMAT option to sqlite3_db_config().
Fix for ticket [6484e6ce678fffab]
FossilOrigin-Name: 4d424f3047b48f
Remove the legacy_file_format PRAGMA. In its place, provide the
SQLITE_DBCONFIG_LEGACY_FILE_FORMAT option to sqlite3_db_config().
Fix for ticket [6484e6ce678fffab]
FossilOrigin-Name: 4d424f3047b48fc441475137f30a719d2f079390c86fe2617710ddfb05c5e240
show more ...
|
|
Revision tags: version-3.30.1, version-3.30.0, version-3.29.0, version-3.28.0 |
|
| #
b84b38fd |
| 04-Apr-2019 |
dan <[email protected]> |
Add test cases to improve coverage of VDBE branches. Still some to go.
FossilOrigin-Name: 4cef609d61de272cfdc2b39e1d49c7cd56ec834086bd63095116ff98f4d402bd
|
|
Revision tags: version-3.27.2, version-3.27.1, version-3.27.0, version-3.26.0, version-3.25.3, version-3.25.2, version-3.25.1, version-3.25.0, version-3.24.0, version-3.23.2, version-3.23.1, version-3.23.0, version-3.22.0, version-3.21.0, version-3.20.1, version-3.19.4, version-3.20.0, version-3.18.2, version-3.18.1, version-3.19.3, version-3.19.2, version-3.19.1, version-3.19.0 |
|
| #
75f95588 |
| 04-Apr-2017 |
dan <[email protected]> |
Fix a problem causing "PRAGMA integrity_check" to disable the xfer
optimization for subsequent VACUUM operations on tables with one or more CHECK
constraints. This could result in VACUUM producing sl
Fix a problem causing "PRAGMA integrity_check" to disable the xfer
optimization for subsequent VACUUM operations on tables with one or more CHECK
constraints. This could result in VACUUM producing slightly larger database
files.
FossilOrigin-Name: e5bb7db51cdfd8124c60329782798cea398733545594dab55cb892b2a08c4d29
show more ...
|
|
Revision tags: version-3.18.0, version-3.17.0, version-3.16.2, version-3.16.1, version-3.16.0, version-3.15.2, version-3.15.1, version-3.15.0, version-3.14.2, version-3.14.1, version-3.14.0, version-3.13.0, version-3.12.2, version-3.12.1, version-3.9.3, version-3.12.0, version-3.11.1, version-3.11.0, version-3.10.2, version-3.10.1, version-3.10.0, version-3.9.2, version-3.9.1, version-3.9.0, version-3.8.11.1, version-3.8.11, version-3.8.10.2, version-3.8.10.1, version-3.8.10 |
|
| #
992590be |
| 19-Apr-2015 |
drh <[email protected]> |
Fix a broken assert() and comparison for INSERT INTO ... SELECT when the
SELECT uses an unknown collating sequence.
FossilOrigin-Name: e73ac0cbac257d2d2b28e51423e30d7449b6c7b5
|
|
Revision tags: version-3.8.9, version-3.8.8.3, version-3.8.8.2, version-3.8.8.1, version-3.8.8, version-3.8.7.4, version-3.8.7.3, version-3.8.7.2, version-3.8.7.1, version-3.8.6.1, version-3.8.7, version-3.8.6, version-3.8.5, version-3.8.4.3, version-3.8.4.2, version-3.8.4.1, version-3.8.4 |
|
| #
05a86c5c |
| 16-Feb-2014 |
drh <[email protected]> |
Enhance the code generator for INSERT INTO ... SELECT so that the SELECT
generates output directly in the registers that INSERT INTO will be using,
in many cases, and OP_SCopy operations can thus be
Enhance the code generator for INSERT INTO ... SELECT so that the SELECT
generates output directly in the registers that INSERT INTO will be using,
in many cases, and OP_SCopy operations can thus be avoided.
FossilOrigin-Name: aa2d8b0e8154dd2f5e2c837dc11ab362b083495b
show more ...
|
|
Revision tags: version-3.8.3.1, version-3.8.3, version-3.8.2 |
|
| #
f9c8ce3c |
| 05-Nov-2013 |
drh <[email protected]> |
Standardize the error messages generated by constraint failures to a format
of "$TYPE constraint failed: $DETAIL". This involves many changes to the
expected output of test cases.
FossilOrigin-Name
Standardize the error messages generated by constraint failures to a format
of "$TYPE constraint failed: $DETAIL". This involves many changes to the
expected output of test cases.
FossilOrigin-Name: 54b221929744b1bcdbcc2030fef2e510618afd41
show more ...
|
|
Revision tags: version-3.8.1, version-3.8.0.2, version-3.8.0.1, version-3.8.0, version-3.7.17, version-3.7.16.2, version-3.7.16.1, version-3.7.16, version-3.7.15.2, version-3.7.15.1, version-3.7.15, version-3.7.14.1, version-3.7.14, version-3.7.13, version-3.7.12.1, version-3.7.12, mountain-lion, version-3.7.11, version-3.7.10 |
|
| #
ccdf1bae |
| 04-Nov-2011 |
drh <[email protected]> |
Update the xfer optimization code so that the xfer optimization can be used
with INTEGER PRIMARY KEY ON CONFLICT ... as long as the destination table
is initially empty. Improvements to the comments
Update the xfer optimization code so that the xfer optimization can be used
with INTEGER PRIMARY KEY ON CONFLICT ... as long as the destination table
is initially empty. Improvements to the comments on the xfer optimization.
New test cases added.
FossilOrigin-Name: e3f368cd5ef66a56fd4bd05a77276039e26b9e0e
show more ...
|
| #
e7224a01 |
| 04-Nov-2011 |
drh <[email protected]> |
Make sure the INSERT INTO ... SELECT statement works correctly even when
the destination table contains an INTEGER PRIMARY KEY ON CONFLICT... column.
Ticket [676bc02b87176125].
FossilOrigin-Name: 6f
Make sure the INSERT INTO ... SELECT statement works correctly even when
the destination table contains an INTEGER PRIMARY KEY ON CONFLICT... column.
Ticket [676bc02b87176125].
FossilOrigin-Name: 6f9898db7ff0730cc03f561f9c32ef3dee7e5d81
show more ...
|
|
Revision tags: version-3.7.9, version-3.7.8 |
|
| #
38cc40c2 |
| 30-Jun-2011 |
dan <[email protected]> |
Experimental changes to improve optimization of DISTINCT queries.
FossilOrigin-Name: f7ba0219ef2f235543c258be736955d91ca5ecce
|
|
Revision tags: version-3.7.7.1, version-3.7.7, version-3.7.6.3 |
|
| #
713de341 |
| 24-Apr-2011 |
drh <[email protected]> |
Disable the transfer optimization if the destination table contains
any foreign key constraint and foreign key constraints are enabled.
Ticket [6284df89debdf].
FossilOrigin-Name: ddeea5ab5f6c0c4a86c
Disable the transfer optimization if the destination table contains
any foreign key constraint and foreign key constraints are enabled.
Ticket [6284df89debdf].
FossilOrigin-Name: ddeea5ab5f6c0c4a86cdfbbb9f24d9d54bf8d301
show more ...
|
|
Revision tags: version-3.7.6.2, version-3.7.6.1, version-3.7.6, version-3.7.5, version-3.7.4, experimental, version-3.7.2 |
|
| #
1d9da70a |
| 07-Jan-2010 |
drh <[email protected]> |
Fix the expression comparison logic to take the COLLATE operator into account.
Ticket [360c6073e197]
FossilOrigin-Name: 44bb1bfe5dedd8054ddd933941ee4112ed8d3b68
|
|
Revision tags: fts3-refactor, cvs-to-fossil-cutover, version-3.6.15, version-3.6.10 |
|
| #
60a713c6 |
| 21-Jan-2008 |
drh <[email protected]> |
Miscellaneous test coverage improvements. (CVS 4734)
FossilOrigin-Name: 720bc20a11275ffe139df9203f23e0683b9b4db1
|
| #
3c4809a2 |
| 12-Nov-2007 |
danielk1977 <[email protected]> |
Where possible, transform the DISTINCT qualifier to a GROUP BY clause. GROUP BY clauses may be optimized by indices, DISTINCT qualifiers cannot. (CVS 4538)
FossilOrigin-Name: e56331234791cf3d830a30e
Where possible, transform the DISTINCT qualifier to a GROUP BY clause. GROUP BY clauses may be optimized by indices, DISTINCT qualifiers cannot. (CVS 4538)
FossilOrigin-Name: e56331234791cf3d830a30e4cfa66682bdf2eed1
show more ...
|
| #
5a8f9374 |
| 09-Oct-2007 |
danielk1977 <[email protected]> |
Fixes to the test suite (no code changes) so that quick.test runs with OMIT_ATTACH builds. #2706. (CVS 4480)
FossilOrigin-Name: 07c00fffe50e8380748f7ae02328531a75d64610
|
| #
4152e677 |
| 12-Sep-2007 |
danielk1977 <[email protected]> |
Fixes for compilation/testing when the various OMIT macros are defined. (CVS 4423)
FossilOrigin-Name: c8405b15c074c94dab5e33272cf1471f458d11df
|
| #
5ce240a6 |
| 03-Sep-2007 |
danielk1977 <[email protected]> |
Remove an unreachable case from xferOptimization(). Also other minor test coverage improvements. (CVS 4383)
FossilOrigin-Name: 75af7189c0ed1b24a32cff6960af7f17326cbc17
|
| #
994c80af |
| 12-Apr-2007 |
drh <[email protected]> |
Changes toward fixes for tickets #2296 and #2291. (CVS 3838)
FossilOrigin-Name: 0dd3e2e47b09156838edfa4dea0d82f9cf22d94d
|
| #
f33c9fad |
| 10-Apr-2007 |
drh <[email protected]> |
Preliminary fix for ticket #2291. This fixes the immediate problem. But
we really need to write more tests for the xfer optimization in order to
look for other related problems before closing this
Preliminary fix for ticket #2291. This fixes the immediate problem. But
we really need to write more tests for the xfer optimization in order to
look for other related problems before closing this ticket. (CVS 3835)
FossilOrigin-Name: 34fec312fd1aeabb04e07d6aa061991775c7b8a1
show more ...
|
| #
fb658ded |
| 24-Feb-2007 |
drh <[email protected]> |
Additional test cases added. Improvements to the INSERT transfer
optimization. (CVS 3662)
FossilOrigin-Name: 2bf5475bde763f73f7f4dd9cac7d13a631a7d2aa
|
| #
dd73521b |
| 24-Feb-2007 |
drh <[email protected]> |
Additional tests and some improvements to the INSERT transfer
optimization. More testing is needed. (CVS 3661)
FossilOrigin-Name: 830985814345f71ba2def3c206e36aabe9e1ee7c
|
| #
8103b7d2 |
| 24-Feb-2007 |
drh <[email protected]> |
Make sure the INSERT xfer optimization does not trigger if the CHECK
constraints on the two tables are not identical. Ticket #2252. (CVS 3660)
FossilOrigin-Name: 6fc18275230563437f2985eac3795e4dfe8
Make sure the INSERT xfer optimization does not trigger if the CHECK
constraints on the two tables are not identical. Ticket #2252. (CVS 3660)
FossilOrigin-Name: 6fc18275230563437f2985eac3795e4dfe8eb9de
show more ...
|