Unrelevant error message when copying bad length field

[monetdb-team]

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:

Add script from bug #2358

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:

Reapplying commit [a3590f983661](https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=a3590f983661) 
this time only the test for bug #2358

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:

Changed error output to more closely match the intention of the bug report.
This shows that the bug (bug #2358) is still there.

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.