Bugs item #2847009, was opened at 2009-08-29 22:45 Message generated for change (Settings changed) made by skinkie You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2847009&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: Closed >Resolution: Invalid Priority: 5 Private: No Submitted By: Stefan de Konink (skinkie) Assigned to: Niels Nes (nielsnes) Summary: SQL: regression in timestamp parsing from COPY INTO Initial Comment: Make a file /tmp/bla with: 123271, 3.5667269, 50.3409331, 1267, '2007-08-15T19:58:59', 3749088843704927238 CREATE TABLE nodes_legacy (id integer, long double, lat double, uid integer, timestamp timestamptz, zcurve bigint); COPY 1 RECORDS INTO nodes_legacy from '/tmp/bla.csv' USING DELIMITERS ',', '\n', ''''; !SQLException:sql:value ' '2007-08-15T19:58:59'' from line 1 field 5 not inserted, expecting type timestamp. !SQLException:importTable:failed to import table 0 tuples Oh really... insert into nodes_legacy values (123271, 3.5667269, 50.3409331, 1267, '2007-08-15T19:58:59', 3749088843704927238); 1 affected row ---------------------------------------------------------------------- >Comment By: Stefan de Konink (skinkie) Date: 2009-08-29 23:47 Message: See string space bug. Removing the space fixes this one. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2847009&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
