Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History of test/insert4.test
|
2019-04-04
| ||
| 17:58 | Add test cases to improve coverage of VDBE branches. Still some to go. file: [7802ada6] check-in: [4cef609d] user: dan branch: trunk, size: 16226 | |
|
2017-04-04
| ||
| 19:58 | 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. file: [46bead5f] check-in: [e5bb7db5] user: dan branch: trunk, size: 15637 | |
|
2015-04-19
| ||
| 22:41 | Fix a broken assert() and comparison for INSERT INTO ... SELECT when the SELECT uses an unknown collating sequence. file: [a20432f1] check-in: [e73ac0cb] user: drh branch: trunk, size: 14859 | |
|
2014-02-16
| ||
| 01:55 | 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. file: [4791662c] check-in: [aa2d8b0e] user: drh branch: insert-optimization, size: 14677 | |
|
2013-11-05
| ||
| 13:33 | 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. file: [b00ddf82] check-in: [54b22192] user: drh branch: omit-rowid, size: 14674 | |
|
2011-11-04
| ||
| 14:36 | 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. file: [87f6798f] check-in: [e3f368cd] user: drh branch: trunk, size: 14610 | |
| 00:23 | Make sure the INSERT INTO ... SELECT statement works correctly even when the destination table contains an INTEGER PRIMARY KEY ON CONFLICT... column. Ticket [676bc02b87176125]. file: [03f1644c] check-in: [6f9898db] user: drh branch: trunk, size: 12969 | |
|
2011-07-02
| ||
| 13:34 | Cherrypick [45e581bff7] into the 3.7.2 branch. file: [50e7a074] check-in: [c593792c] user: dan branch: branch-3.7.2, size: 8299 | |
|
2011-06-30
| ||
| 20:17 | Experimental changes to improve optimization of DISTINCT queries. file: [63ea672b] check-in: [f7ba0219] user: dan branch: experimental, size: 9802 | |
|
2011-04-24
| ||
| 22:56 | Disable the transfer optimization if the destination table contains any foreign key constraint and foreign key constraints are enabled. Ticket [6284df89debdf]. file: [b3e02648] check-in: [ddeea5ab] user: drh branch: trunk, size: 9802 | |
|
2010-01-07
| ||
| 15:17 | Fix the expression comparison logic to take the COLLATE operator into account. Ticket [360c6073e197] file: [c1469999] check-in: [44bb1bfe] user: drh branch: trunk, size: 8299 | |
|
2008-01-21
| ||
| 16:22 | Miscellaneous test coverage improvements. (CVS 4734) file: [6e382eaf] check-in: [720bc20a] user: drh branch: trunk, size: 7776 | |
|
2007-11-12
| ||
| 15:29 | Where possible, transform the DISTINCT qualifier to a GROUP BY clause. GROUP BY clauses may be optimized by indices, DISTINCT qualifiers cannot. (CVS 4538) file: [6919ddac] check-in: [e5633123] user: danielk1977 branch: trunk, size: 7126 | |
|
2007-10-09
| ||
| 08:29 | Fixes to the test suite (no code changes) so that quick.test runs with OMIT_ATTACH builds. #2706. (CVS 4480) file: [ac36af0e] check-in: [07c00fff] user: danielk1977 branch: trunk, size: 7126 | |
|
2007-09-12
| ||
| 17:01 | Fixes for compilation/testing when the various OMIT macros are defined. (CVS 4423) file: [d7d25679] check-in: [c8405b15] user: danielk1977 branch: trunk, size: 7052 | |
|
2007-09-03
| ||
| 17:30 | Remove an unreachable case from xferOptimization(). Also other minor test coverage improvements. (CVS 4383) file: [9b10c623] check-in: [75af7189] user: danielk1977 branch: trunk, size: 6997 | |
|
2007-04-12
| ||
| 21:25 | Changes toward fixes for tickets #2296 and #2291. (CVS 3838) file: [1e27f0a3] check-in: [0dd3e2e4] user: drh branch: trunk, size: 6365 | |
|
2007-04-10
| ||
| 18:17 | 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) file: [c5af4d3d] check-in: [34fec312] user: drh branch: trunk, size: 6370 | |
|
2007-02-24
| ||
| 15:18 | Additional test cases added. Improvements to the INSERT transfer optimization. (CVS 3662) file: [0bb119fe] check-in: [2bf5475b] user: drh branch: trunk, size: 6143 | |
| 13:53 | Additional tests and some improvements to the INSERT transfer optimization. More testing is needed. (CVS 3661) file: [319455dc] check-in: [83098581] user: drh branch: trunk, size: 3062 | |
| 13:23 | Make sure the INSERT xfer optimization does not trigger if the CHECK constraints on the two tables are not identical. Ticket #2252. (CVS 3660) file: [d733a334] check-in: [6fc18275] user: drh branch: trunk, size: 1804 Added | |