Date: 2014-05-01 16:54:58 +0200
From: @hannesmuehleisen
To: MonetDB5 devs <>
Version: 11.17.13 (Jan2014-SP1)
CC: @njnes

Last updated: 2014-05-22 09:52:27 +0200

Comment 19790

Date: 2014-05-01 16:54:58 +0200
From: @hannesmuehleisen

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

One of the Java examples (http://dev.monetdb.org/hg/MonetDB/file/fe1fb3ce0c9b/java/example/SQLcopyinto.java) uses COPY INTO FROM stdin over a low-level MAPI socket as an example for bulk load. However, if multiple such COPY INTO statements are used, none are executed. In addition, strange characters appear on the MAPI socket.

Reproducible: Always

Steps to Reproduce:

See attached Python script

Actual Results:

No tables created, no content inserted, strange characters appear.

Expected Results:

Statements are executed.

Comment 19791

Date: 2014-05-01 16:55:18 +0200
From: @hannesmuehleisen

Created attachment 285
Python script to provoke the issue

Attached file: test.py (text/x-python, 919 bytes)
Description: Python script to provoke the issue

Comment 19792

Date: 2014-05-01 16:57:02 +0200
From: @hannesmuehleisen

MAPI Response looks like this:

&4 f (transaction start)
&3 (create table)
[Strange special characters]

Comment 19793

Date: 2014-05-05 10:21:33 +0200
From: @njnes

This is because we get an 'SQLException:sql.affectedRows:failed' in the second copy into.

Comment 19794

Date: 2014-05-05 10:45:35 +0200
From: @njnes

tablet (csv reader) always does a read_more which its not supposed to do, its should only try to read more if it needs it (ie empty (non read) buffer).

Comment 19798

Date: 2014-05-05 11:16:11 +0200
From: @sjoerdmullender

I fixed this issue in changeset d633b25eb73e I don't know why this wasn't recorded in the tracker.