Unrelevant error message when copying bad length field #2358
Milestone
Comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
{{ message }}
Date: 2010-04-23 05:55:55 +0200
From: Matthieu Guamis <>
To: SQL devs <>
Version: 2.40.1 (Oct2010) [obsolete]
CC: matthieu.guamis, @njnes, @drstmane
Last updated: 2011-03-28 17:31:28 +0200
Comment 13215
Date: 2010-04-23 17:55:55 +0200
From: Matthieu Guamis <>
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: root@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
Comment 13216
Date: 2010-05-04 09:32:09 +0200
From: Pseudo user for Sourceforge import <>
This bug was previously known as tracker item 2991447 at http://sourceforge.net/support/tracker.php?aid=2991447
The original assignee of this bug does not have
an account here. Reassigning to the default assignee
for the component, bugs-common@monetdb.org.
Previous assignee was nobody@users.sourceforge.net.
Comment 14102
Date: 2010-06-14 15:37:06 +0200
From: @grobian
Changeset a3590f983661 made by Fabian Groffen fabian@cwi.nl in the MonetDB repo, refers to this bug.
For complete details, see http//devmonetdborg/hg/MonetDB?cmd=changeset;node=a3590f983661
Changeset description:
Comment 14103
Date: 2010-06-14 15:37:40 +0200
From: @grobian
bug still applies to release candidate (Jun2010)
Comment 14104
Date: 2010-06-14 15:41:31 +0200
From: @grobian
Changeset 138abbed9155 made by Fabian Groffen fabian@cwi.nl in the MonetDB repo, refers to this bug.
For complete details, see http//devmonetdborg/hg/MonetDB?cmd=changeset;node=138abbed9155
Changeset description:
Comment 14733
Date: 2010-08-19 16:43:46 +0200
From: @sjoerdmullender
Is this still a problem? The test seems to be working.
We do need a changelog entry...
Comment 14742
Date: 2010-08-20 13:16:36 +0200
From: @sjoerdmullender
Changeset 7c07e1c16195 made by Sjoerd Mullender sjoerd@acm.org in the MonetDB repo, refers to this bug.
For complete details, see http//devmonetdborg/hg/MonetDB?cmd=changeset;node=7c07e1c16195
Changeset description:
Comment 14743
Date: 2010-08-20 13:17:15 +0200
From: @sjoerdmullender
Bug is still in Jun2010-SP1.
Comment 14844
Date: 2010-08-30 09:23:21 +0200
From: @sjoerdmullender
The Jun2010-SP2 version has been released.
Comment 15063
Date: 2010-10-18 19:41:28 +0200
From: @drstmane
Appears to work in Oct2010, since the error message has been approved from
!SQLException:importTable:value 'abcd' from line 1 field 1 not inserted, value too long for type (var)char(3)
to
!SQLException:importTable:value 'abcd' from line 1 field 1 not inserted, expecting type varchar(3)
in changeset http://dev.monetdb.org/hg/MonetDB/rev/bd70cf18b649
Is this as intended?
Comment 15624
Date: 2011-03-28 17:31:28 +0200
From: @sjoerdmullender
The Mar2011 version has been released.
The text was updated successfully, but these errors were encountered: