Bugs item #2847050, was opened at 2009-08-29 23:38 Message generated for change (Comment added) made by mlkersten You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2847050&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: None Priority: 5 Private: No Submitted By: Stefan de Konink (skinkie) >Assigned to: Martin Kersten (mlkersten) Summary: SQL: regression in string parsing at COPY INTO Initial Comment: 2246, 'created_by', 'JOSM' Where before above line using: COPY 1 RECORDS INTO way_tags from '/tmp/bla1.csv' USING DELIMITERS ',', '\n', ''''; Was imported as: 2246 created_by JOSM It is now imported as 2246 [space]'created_by' [space]'JOSM' While testing different variations the following came on the server console: >##SQLworker exists (null) It seems that when the space is removed after the seperator the field is imported with the other separator undone as well. ---------------------------------------------------------------------- >Comment By: Martin Kersten (mlkersten) Date: 2009-09-03 22:23 Message: Yes, leading white spaces are never ignored anymore! This means that a string field started after a separator should immediately start with a quote, if it is the intention to enter a quoted string. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2847050&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
