Date: 2014-06-30 16:36:12 +0200
From: @bartscheers
To: SQL devs <>
Version: 11.17.17 (Jan2014-SP2)
CC: @njnes

Last updated: 2014-10-31 14:13:58 +0100

Comment 19863

Date: 2014-06-30 16:36:12 +0200
From: @bartscheers

User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:30.0) Gecko/20100101 Firefox/30.0
Build Identifier:

Second of two insert statements terminates mserver5. Type conversion from number to varchar goes wrong.

Reproducible: Always

Steps to Reproduce:

1.monetdb stop ins_bug; monetdb destroy -f ins_bug; monetdb create ins_bug; monetdb release ins_bug; monetdb start ins_bug #2.CREATE TABLE config
(id SERIAL
,dataset INT NOT NULL
,section VARCHAR(100)
,key VARCHAR(100)
,value VARCHAR(500)
,type VARCHAR(5)
,UNIQUE (dataset, section, key)
)
;

3. INSERT INTO config (dataset, section, key, value, type) VALUES (6, 'quality_lofar', 'low_bound', 1.9, 'float');
   INSERT INTO config (dataset, section, key, value, type) VALUES (6, 'quality_lofar', 'high_bound', 80, 'int');

Actual Results:

stopping database 'ins_bug'... done
destroyed database: ins_bug
created database in maintenance mode: ins_bug
taken database out of maintenance mode: ins_bug
starting database 'ins_bug'... done
operation successful
Connection terminated

Expected Results:

another succesful operation...

Comment 19888

Date: 2014-07-09 10:47:49 +0200
From: MonetDB Mercurial Repository <>

Changeset 17cd8c14c3b4 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=17cd8c14c3b4

Changeset description:

don't assert but return error on atom_cast (fix bug #3506)

Comment 19933

Date: 2014-07-28 18:58:40 +0200
From: @njnes

Added test varchar_conversion_crash.Bug-3506.sql

Comment 19934

Date: 2014-07-28 19:36:19 +0200
From: MonetDB Mercurial Repository <>

Changeset d89feba26343 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=d89feba26343

Changeset description:

added test for bug #3506

Comment 20347

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

Oct2014 has been released.