Unexpected error from server for query with long floats

[monetdb-team]

Date: 2017-08-07 10:12:25 +0200
From: Roman <<kislenok.roman>>
To: SQL devs <>
Version: 11.25.23 (Dec2016-SP5)
CC: @njnes

Last updated: 2017-10-26 14:01:30 +0200

Comment 25554

Date: 2017-08-07 10:12:25 +0200
From: Roman <<kislenok.roman>>

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

After I updated my database from v11.23.13 to v11.25.23 I began get some strange error in a simple query. I've reduced original query to reproducible one:

select case name when 'types' then 1 when 'args' then 60.3281 when 'keys' then 0.8415381117315 else 0 end as t1 from tables limit 1;

I expect some numbers from this query, but server (in mclient) return one of this error:

• value (8415381117315) exceeds limits of type int, or
• too many digits (10 > 6)

For most time I got the first one.

Reproducible: Always

Steps to Reproduce:

1. start mclient
2. run query: "select case name when 'types' then 1 when 'args' then 60.3281 when 'keys' then 0.8415381117315 else 0 end as t1 from tables limit 1;"

Actual Results:

"value (8415381117315) exceeds limits of type int" or "too many digits (10 > 6)"

Comment 25555

Date: 2017-08-07 10:13:30 +0200
From: Roman <<kislenok.roman>>

As an example:

sql>select case name when 'types' then 1 when 'args' then 60.3281 when 'keys' then 0.8415381117315 else 0 end as t1 from tables;
value (8415381117315) exceeds limits of type int
sql>select case name when 'types' then 1 when 'args' then 60.3281 when 'keys' then 0.8415381117315 else 0 end as t1 from tables;
value (8415381117315) exceeds limits of type int
sql>select case name when 'types' then 1 when 'args' then 60.3281 when 'keys' then 0.8415381117315 else 0 end as t1 from tables;
value (8415381117315) exceeds limits of type int
sql>select case name when 'types' then 1 when 'args' then 60.3281 when 'keys' then 0.8415381117315 else 0 end as t1 from tables;
value (8415381117315) exceeds limits of type int
sql>select case name when 'types' then 1 when 'args' then 60.3281 when 'keys' then 0.8415381117315 else 0 end as t1 from tables;
too many digits (10 > 6)
sql>select case name when 'types' then 1 when 'args' then 60.3281 when 'keys' then 0.8415381117315 else 0 end as t1 from tables limit 1;
value (8415381117315) exceeds limits of type int

Comment 25580

Date: 2017-08-16 15:22:03 +0200
From: @njnes

fixed a problem in the supertype function (super and one of the inputs can point
to the same structure)

Comment 25582

Date: 2017-08-16 18:21:01 +0200
From: MonetDB Mercurial Repository <>

Changeset 4a7ab58ad31a made by Niels Nes niels@cwi.nl in the MonetDB repo, refers to this bug.

For complete details, see https//devmonetdborg/hg/MonetDB?cmd=changeset;node=4a7ab58ad31a

Changeset description:

fixed bugs 6386 and 6392