Date: 2013-03-30 22:30:12 +0100
From: @skinkie
To: SQL devs <>
Version: 11.15.7 (Feb2013-SP2)

Last updated: 2013-07-03 08:48:01 +0200

Comment 18659

Date: 2013-03-30 22:30:12 +0100
From: @skinkie

User-Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.31 (KHTML, like Gecko) Chrome/26.0.1410.40 Safari/537.31
Build Identifier:

create table test (x decimal(9,9));
insert into test values (0.123456789); [works]

COPY 1 RECORDS INTO "sys"."test" FROM stdin USING DELIMITERS '\t','\n','"';
0.123456789

value '0.123456789' from line 1 field 1 not inserted, expecting type decimal(9,9)
failed to import table

Reproducible: Always

MonetDB 5 server v11.15.4 (64-bit, 64-bit oids)
This is an unreleased version
Copyright (c) 1993-July 2008 CWI
Copyright (c) August 2008-2013 MonetDB B.V., all rights reserved
Visit http://www.monetdb.org/ for further information
Found 15.6GiB available memory, 4 available cpu cores
Libraries:
libpcre: 8.32 2012-11-30 (compiled with 8.32)
openssl: OpenSSL 1.0.1e 11 Feb 2013 (compiled with OpenSSL 1.0.1e 11 Feb 2013)
libxml2: 2.9.0 (compiled with 2.9.0)
Compiled by: root@openkvk.nl (x86_64-unknown-linux-gnu)
Compilation: gcc -g -Werror -Wall -Wextra -W -Werror-implicit-function-declaration -Wpointer-arith -Wdeclaration-after-statement -Wundef -Wformat=2 -Wno-format-nonliteral -Winit-self -Winvalid-pch -Wmissing-declarations -Wmissing-format-attribute -Wmissing-prototypes -Wold-style-definition -Wpacked -Wunknown-pragmas -Wvariadic-macros -fstack-protector-all -Wstack-protector -Wpacked-bitfield-compat -Wsync-nand -Wjump-misses-init -Wmissing-include-dirs -Wlogical-op -Wunreachable-code
Linking : /usr/x86_64-pc-linux-gnu/bin/ld -m elf_x86_64

Comment 18717

Date: 2013-05-06 17:14:00 +0200
From: MonetDB Mercurial Repository <>

Changeset 21a4449a8c0e 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=21a4449a8c0e

Changeset description:

Don't count leading zeros when importing decimals.
This fixes bug #3265.
Also added test.