Bugs item #2991400, was opened at 2010-04-23 16:26
Message generated for change (Comment added) made by mguamis
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2991400&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: None
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Matthieu Guamis (mguamis)
Assigned to: Niels Nes (nielsnes)
Summary: Embedded record separator in quoted fields
Initial Comment:
COPY INTO TABLE with embedded record separator in quoted fields fails with
message
SQLException:sql:End of string (") missing in "
" at line 2 field 0
SQLException:importTable:failed to import table
This can be reproduce using statements:
sql>create table t (c varchar(3));
sql>COPY 1 RECORDS INTO t FROM STDIN USING DELIMITERS '|','
more>','"' NULL AS '';"a
more>c"
more>
SQLException:sql:End of string (") missing in "
" at line 2 field 0
SQLException:importTable:failed to import table
It's the same with other records separators.
It works with embedded *field* seperator.
Best regards
----------------------------------------------------------------------
>Comment By: Matthieu Guamis (mguamis)
Date: 2010-04-23 16:27
Message:
$ mserver5 --version
MonetDB server v5.18.3 (64-bit), based on kernel v1.36.3 (64-bit oids)
Copyright (c) 1993-July 2008 CWI
Copyright (c) August 2008-2010 MonetDB B.V., all rights reserved
Visit http://monetdb.cwi.nl/ for further information
Found 2.0GiB available memory, 2 available cpu cores
Configured for prefix: /usr
Libraries:
libpcre: 7.8 2008-09-05 (compiled with 7.8)
openssl: OpenSSL 0.9.8g 19 Oct 2007 (compiled with OpenSSL 0.9.8g 19 Oct
2007)
libxml2: 2.7.5 (compiled with 2.7.5)
Compiled by: r...@ubuntu-karmic-64 (x86_64-pc-linux-gnu)
Compilation: gcc -O2 -Wall -O2 -O6 -fomit-frame-pointer
-finline-functions -falign-loops=4 -falign-jumps=4
-falign-functions=4 -fexpensive-optimizations
-funroll-loops -frerun-cse-after-loop -frerun-loop-opt -ftree-vectorize
Linking : ld -IPA -m elf_x86_64 -Wl,-Bsymbolic-functions
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2991400&group_id=56967
------------------------------------------------------------------------------
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
