Feature Requests item #2154105, was opened at 2008-10-09 03:02 Message generated for change (Comment added) made by mr-meltdown You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482471&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: None Group: None Status: Open Priority: 5 Private: No Submitted By: Stefan de Konink (skinkie) Assigned to: Niels Nes (nielsnes) >Summary: SQL: COPY INTO report line number or row on failure 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. ---------------------------------------------------------------------- >Comment By: Fabian (mr-meltdown) Date: 2009-12-01 10:29 Message: I think the new copy into code is a bit more friendly about reporting errors, but someone who worked on that should give the definite answer. ---------------------------------------------------------------------- Comment By: Romulo Goncalves (romulog) Date: 2008-12-01 19:48 Message: This report became a feature request report instead of bug report ---------------------------------------------------------------------- Comment By: Romulo Goncalves (romulog) Date: 2008-12-01 16:14 Message: I propose to change this report to a feature request report.... Niels, Do you agree? ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482471&aid=2154105&group_id=56967 ------------------------------------------------------------------------------ Join us December 9, 2009 for the Red Hat Virtual Experience, a free event focused on virtualization and cloud computing. Attend in-depth sessions from your desk. Your couch. Anywhere. http://p.sf.net/sfu/redhat-sfdev2dev _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
