Date: 2020-07-04 07:52:58 +0200
From: @mlkersten
To: SQL devs <>
Version: -- development

Last updated: 2020-07-27 09:30:15 +0200

Comment 27889

Date: 2020-07-04 07:52:58 +0200
From: @mlkersten

User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.13; rv:77.0) Gecko/20100101 Firefox/77.0
Build Identifier:

If you take an input file as shown below, where a few lines have an extra space, than the decimal parsing fails. This does not happen when reading from STDIN

sql>select * from sys.rejects();
+-------+-------+-------------------------------------------------+--------+
| rowid | fldid | message | input |
+=======+=======+=================================================+========+
| 8 | 2 | line 8 field d 'decimal(8,3)' expected in '5 ' | 0,5 |
| 9 | 2 | line 9 field d 'decimal(8,3)' expected in '67 ' | 0,67 |
+-------+-------+-------------------------------------------------+--------+

Reproducible: Always

Steps to Reproduce:

create table tmpcopy(i integer, d decimal(8,3));
copy into tmpcopy from '/path/input' delimiters ',','\n' best effort;

select * from sys.rejects();
select * from tmpcopy;
drop table tmpcopy;

and use an input file containing
0,1.2
0,2.34
0,3.456
0,4.456
0,5
0,67
0,890
0,5
0,67
0,890

Expected Results:

Proper parsing of the decimal ignoring the white space after it.

Comment 27924

Date: 2020-07-21 09:25:38 +0200
From: @sjoerdmullender

Test added: https://dev.monetdb.org/hg/MonetDB/rev/7d8a14cb4fc1
Fix added: https://dev.monetdb.org/hg/MonetDB/rev/2b2f95657916