Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

conversion to varchar terminates mserver #3506

Closed
monetdb-team opened this issue Nov 30, 2020 · 0 comments
Closed

conversion to varchar terminates mserver #3506

monetdb-team opened this issue Nov 30, 2020 · 0 comments
Labels

Comments

@monetdb-team
Copy link

@monetdb-team monetdb-team commented Nov 30, 2020

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)
)
;

  1. 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.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
1 participant