Bugs item #2154105, was opened at 2008-10-09 03:02 Message generated for change (Tracker Item Submitted) made by Item Submitter You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2154105&group_id=56967
Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: SQL/Core Group: SQL CVS Head Status: Open Resolution: None Priority: 5 Private: No Submitted By: Stefan de Konink (skinkie) Assigned to: Niels Nes (nielsnes) Summary: Copy into artifact Initial Comment: I'm trying to debug an issue with probably a duplicate primary key. For that I reduce the actual amount of rows I want to insert using copy into. insertme4.sql: START TRANSACTION; CREATE TABLE way_tags (way integer, k varchar(255), v varchar(1024), primary key (way, k), foreign key(way) references ways); COPY 2000000 RECORDS INTO way_tags from '/mnt/dv/split/way_tags.csv' USING DELIMITERS ',', '\n', ''''; COMMIT; If I execute this code multiple times I end up in 4000000 inserted rows. The strange thing is, when I actually try to insert 4000000 rows I end up in: ERROR = !SQLException:assert:INSERT INTO: PRIMARY KEY constraint 'way_tags.way_tags_way_k_pkey' violated (the same error as I had before) Now because that number was so nice round and pretty I have tried to insert 2000001 tags where I end up in: 4000002 But this actually *matches* what is inserted in that table: sql>select count(*) from way_tags; +---------+ | count_ | +=========+ | 4000002 | +---------+ Feature request: >From debugging perspective it would be very nice if a copy into primary key >problem also returned the actual 'line' or broken thing. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2154105&group_id=56967 ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
