Bugs item #2539357, was opened at 2009-01-27 04:52 Message generated for change (Comment added) made by romulog 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: Romulo Goncalves (romulog) Date: 2009-02-09 15:22 Message: Niels, Is this a feature request or bug? ---------------------------------------------------------------------- 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 ------------------------------------------------------------------------------ Create and Deploy Rich Internet Apps outside the browser with Adobe(R)AIR(TM) software. With Adobe AIR, Ajax developers can use existing skills and code to build responsive, highly engaging applications that combine the power of local resources and data with the reach of the web. Download the Adobe AIR SDK and Ajax docs to start building applications today-http://p.sf.net/sfu/adobe-com _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
