Bugs item #2539357, was opened at 2009-01-27 04:52 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=2539357&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: Regression in timestampz handling Initial Comment: CREATE TABLE nodes_legacy (id integer, long double, lat double, username varchar(255), timestamp timestamptz); COPY 6833589 RECORDS INTO nodes_legacy from '/mnt/dv/adt/temp/tmp/nodes.csv' USING DELIMITERS ',', '\n', ''''; !SQLException:sql:value '2008-10-11T06:54:34Z' while parsing '2008-10-11T06:54:34Z'' from line 0 field 4 not inserted, expecting type timestamp !SQLException:importTable:failed to import table 35835479, 51.9745073, 7.2971406, 'Fam-Os', '2008-10-11T06:54:34Z' 53989466, 51.974842, 7.2967195, 'Fam-Os', '2008-10-11T06:54:34Z' 53989477, 51.9781241, 7.2954519, 'Fam-Os', '2008-10-11T06:54:34Z' 53989479, 51.9789966, 7.2952828, 'Fam-Os', '2008-10-11T06:54:34Z' 53989481, 51.9795392, 7.2952676, 'Fam-Os', '2008-10-11T06:54:34Z' 53989483, 51.9805516, 7.294534, 'Fam-Os', '2008-10-11T06:54:34Z' 53989485, 51.981326, 7.2940894, 'Fam-Os', '2008-10-11T06:54:34Z' 53989546, 51.9750623, 7.2964489, 'Fam-Os', '2008-10-11T06:54:34Z' 53989558, 51.9785337, 7.295313, 'Fam-Os', '2008-10-11T06:54:34Z' 53989562, 51.9778826, 7.2955678, 'Fam-Os', '2008-10-11T06:54:34Z' 54354966, 51.9791179, 7.2952621, 'Fam-Os', '2008-10-11T06:54:34Z' 291835846, 51.9782565, 7.2953858, 'Fam-Os', '2008-10-11T06:54:34Z' 301779697, 51.9786924, 7.2953026, 'Fam-Os', '2008-10-11T06:54:34Z' 301779712, 51.9786557, 7.295305, 'Fam-Os', '2008-10-11T06:54:34Z' 303693820, 51.9803148, 7.2947056, 'Fam-Os', '2008-10-11T06:54:34Z' (likewise without '') ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2539357&group_id=56967 ------------------------------------------------------------------------------ This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
