Bugs item #2833696, was opened at 2009-08-07 15:43 Message generated for change (Settings changed) made by sjoerd You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2833696&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: Fixed Priority: 5 Private: No Submitted By: Stefan de Konink (skinkie) Assigned to: Niels Nes (nielsnes) >Summary: Copy into error off by one Initial Comment: COPY 664 RECORDS INTO haltesgeo FROM '/home/skinkie/clean.csv' USING DELIMITERS ';', '\n'; !SQLException:sql:value '4.9.036' while parsing '4.9.036' from line 80 field 2 not inserted, expecting type dbl !SQLException:importTable:failed to import table 0 tuples Now this line is actually 81 in the file. ---------------------------------------------------------------------- Comment By: Stefan de Konink (skinkie) Date: 2009-08-07 16:12 Message: create table number (isanumber integer); COPY 2 RECORDS INTO number FROM '/home/skinkie/notanumber' USING DELIMITERS '\n'; notanumber: 1 bla !SQLException:sql:value 'bla' while parsing 'bla' from line 1 field 0 not inserted, expecting type int should be: !SQLException:sql:value 'bla' while parsing 'bla' from line 2 field 1 not inserted, expecting type int (I think field one sounds much better too) ---------------------------------------------------------------------- Comment By: Niels Nes (nielsnes) Date: 2009-08-07 16:10 Message: return current inserted count + 1, for line number. This should still be corrected for the skip value! ---------------------------------------------------------------------- Comment By: Niels Nes (nielsnes) Date: 2009-08-07 16:09 Message: fix checked into current. Could you validate that it works? ---------------------------------------------------------------------- Comment By: Niels Nes (nielsnes) Date: 2009-08-07 16:04 Message: could you please create an example which could be run in the test set? ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2833696&group_id=56967 ------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
