Date: 2015-06-22 16:13:53 +0200
From: @bartscheers
To: SQL devs <>
Version: 11.19.15 (Oct2014-SP4)
CC: @njnes

Last updated: 2015-08-28 13:42:59 +0200

Comment 20938

Date: 2015-06-22 16:13:53 +0200
From: @bartscheers

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

A cast to int for a decimal value rounds the value off to closest int, while double is cast to truncated value.

Reproducible: Always

Steps to Reproduce:

1. select cast(cast(13.8 as decimal(10,7)) as int);
2. select cast(cast(13.8 as double) as int);

Actual Results:

+------+
| L2 |
+======+
| 14 |
+------+
1 tuple
+------+
| L2 |
+======+
| 13 |
+------+
1 tuple

Expected Results:

At least identical behaviour.

+------+
| L2 |
+======+
| 13 |
+------+
1 tuple
+------+
| L2 |
+======+
| 13 |
+------+
1 tuple

Comment 20940

Date: 2015-06-22 21:43:25 +0200
From: @njnes

fixed in jul2015 branch

Comment 21226

Date: 2015-08-28 13:42:59 +0200
From: @sjoerdmullender

Jul2015 has been released.