Crash on remote table schema mismatch

[monetdb-team]

Date: 2015-07-28 16:01:22 +0200
From: @hannesmuehleisen
To: SQL devs <>
Version: -- development
CC: @njnes

Last updated: 2015-09-28 15:37:30 +0200

Comment 21063

Date: 2015-07-28 16:01:22 +0200
From: @hannesmuehleisen

User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_10_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/44.0.2403.107 Safari/537.36
Build Identifier:

Create a table on remote node, say
CREATE TABLE sometable_0(A BIGINT);
Insert some data
INSERT INTO SOMETABLE VALUES (42);
Add this table as a remote table on another node with a slightly wrong schema
CREATE REMOTE TABLE sometable_0 (A INTEGER) ON 'mapi:monetdb://.../...';
SELECT * FROM sometable_0;

Result: crash of remote node. Also, unhelpful error message on master node: "illegal input, not a JSON header (got '')"

Reproducible: Always

Actual Results:

Crash

Expected Results:

No crash, error should be thrown at remote table creation. Also, better error message on crash of remote node.

Comment 21064

Date: 2015-07-28 16:04:04 +0200
From: MonetDB Mercurial Repository <>

Changeset 317820b49de5 made by Hannes Muehleisen hannes@cwi.nl in the MonetDB repo, refers to this bug.

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

Changeset description:

Test case for Bug #3778

Comment 21096

Date: 2015-08-05 12:32:20 +0200
From: MonetDB Mercurial Repository <>

Changeset 87df8ec9d2ce 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=87df8ec9d2ce

Changeset description:

added more defensive code to handle typos for the remote cases.
see bugs 3778 and 3754

Comment 21098

Date: 2015-08-05 12:33:00 +0200
From: @njnes

added a check for proper types in the mvc_bind* code.

Comment 21233

Date: 2015-08-28 13:43:10 +0200
From: @sjoerdmullender

Jul2015 has been released.

Comment 21290

Date: 2015-09-28 15:37:17 +0200
From: MonetDB Mercurial Repository <>

Changeset 56adbdf57769 made by Stefan Manegold Stefan.Manegold@cwi.nl in the MonetDB repo, refers to this bug.

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

Changeset description:

renamed schemadiff.SQL.py to schemadiff.Bug-3778.SQL.py

Comment 21291

Date: 2015-09-28 15:37:23 +0200
From: MonetDB Mercurial Repository <>

Changeset f15a56550f53 made by Stefan Manegold Stefan.Manegold@cwi.nl in the MonetDB repo, refers to this bug.

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

Changeset description:

added "canonical" stable output for tests schemadiff.Bug-3778 & copy_into.Bug-3813;

correct / expected output still needs to be approved / provided !

Comment 21293

Date: 2015-09-28 15:37:30 +0200
From: MonetDB Mercurial Repository <>

Changeset 0b830207930c made by Stefan Manegold Stefan.Manegold@cwi.nl in the MonetDB repo, refers to this bug.

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

Changeset description:

BugTracker-2015: activate "dormand(?)" / new tests schemadiff.Bug-3778 & copy_into.Bug-3813