Bugs item #2539357, was opened at 2009-01-27 04:52 Message generated for change (Comment added) made by lsidir 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 '') ---------------------------------------------------------------------- >Comment By: Lefteris Sidirourgos (lsidir) Date: 2009-01-27 08:49 Message: Indeed the time module does not parse the Z (at least that was the case in M4 and I am guessing that is the case also in M5). I would suggest to add the Z in the parsing of timestamps, also because the XQuery dateTimes use Z too:) ---------------------------------------------------------------------- Comment By: Stefan de Konink (skinkie) Date: 2009-01-27 05:10 Message: Seems the problem fixes it self by removing the 'Z' from the data time... ---------------------------------------------------------------------- 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
