/ File History
Login

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