SQL bulk load should ignore leading/trailing spaces also with type decimal (as with integers & real/double)

[monetdb-team]

Date: 2014-10-07 20:36:25 +0200
From: @drstmane
To: SQL devs <>
Version: -- development
CC: @njnes

Last updated: 2014-10-31 14:14:38 +0100

Comment 20259

Date: 2014-10-07 20:36:25 +0200
From: @drstmane

While the MonetDB SQL bulk loader ("COPY INTO table FROM file") does (by now; not sure since when; possibly only after Jan2014 release, but possibly still in Jan2014 branch) ignore whitespaces around integer and floating-point numbers (of all supported sizes), it does not (yet) ignore whitespaces around fixed-point (decimal) numbers.

Comment 20262

Date: 2014-10-08 13:08:31 +0200
From: @njnes

whitespace skipping is added in the oct branch

Comment 20267

Date: 2014-10-08 16:01:10 +0200
From: @njnes

Changeset 4237cf8af7d9 made by Niels Nes niels@cwi.nl in the MonetDB repo, refers to this bug.

For complete details, see http//devmonetdborg/hg/MonetDB?cmd=changeset;node=4237cf8af7d9

Changeset description:

skip whitespace when loading decimals fixes bug #3598

Comment 20383

Date: 2014-10-31 14:14:38 +0100
From: @sjoerdmullender

Oct2014 has been released.