/ All files named "test/insert4.test"
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

History for test/insert4.test

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