Date: 2017-01-27 12:57:46 +0100
From: Gatis Ozolins <<g.ozolins>>
To: SQL devs <>
Version: 11.25.5 (Dec2016-SP1)

Last updated: 2017-03-03 10:24:39 +0100

Comment 24926

Date: 2017-01-27 12:57:46 +0100
From: Gatis Ozolins <<g.ozolins>>

User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:50.0) Gecko/20100101 Firefox/50.0
Build Identifier:

Only happens if larger decimal type has more than 18 digits after point.

Reproducible: Always

Steps to Reproduce:

select CAST(CAST(1 AS DECIMAL(20,19)) AS DECIMAL(12,8))

Actual Results:

-0.84467441

Expected Results:

1.00000000

Comment 24927

Date: 2017-01-27 13:12:32 +0100
From: @sjoerdmullender

This was already fixed in the current Dec2016 branch (after the Dec2016-SP1 release). My guess is, the fix was in changeset 542cea1b704c Also see bug #6192 and changeset 412cc3428d91

Comment 24928

Date: 2017-01-27 13:18:52 +0100
From: MonetDB Mercurial Repository <>

Changeset 1bff10f50a19 made by Sjoerd Mullender sjoerd@acm.org in the MonetDB repo, refers to this bug.

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

Changeset description:

Added test for bug #6195.

Comment 25123

Date: 2017-03-03 10:24:39 +0100
From: @sjoerdmullender

Dec2016-SP2 has been released, incorporating the fix.