Bugs item #2991447, was opened at 2010-04-23 17:55
Message generated for change (Tracker Item Submitted) made by mguamis
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2991447&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: None
Group: None
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Matthieu Guamis (mguamis)
Assigned to: Nobody/Anonymous (nobody)
Summary: Unrelevant error message when copying bad length field
Initial Comment:
COPY INTO TABLE with "too long' field fails with message
SQLException:sql:value 'abcd' from line 1 field 1 not inserted, expecting type
str
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 '';"abcd"
more>
more>
SQLException:sql:value 'abcd' from line 1 field 1 not inserted, expecting type
str
SQLException:importTable:failed to import table
Error message is much more relevant using insert statement:
sql>insert into t values ('abcd');
SQLException:str_cast:value too long for type (var)char(3)
Best regards
$ 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=2991447&group_id=56967
------------------------------------------------------------------------------
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
