Broken type inference when using sql round

[monetdb-team]

Date: 2012-01-27 14:56:26 +0100
From: Holger <>
To: SQL devs <>
Version: -- development
CC: @njnes

Last updated: 2012-05-25 12:58:49 +0200

Comment 16837

Date: 2012-01-27 14:56:26 +0100
From: Holger <>

User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_7_2) AppleWebKit/534.52.7 (KHTML, like Gecko) Version/5.1.2 Safari/534.52.7
Build Identifier: v11.7.1

sql>\f raw
sql>explain select round(750,1);
% .explain table_name
% mal name
% clob type
% 71 length
function user.s15_1{autoCommit=true}():void;
X_4 := calc.bte(750:sht,2,0);
X_8 := sql.round(X_4,2,0,1:bte);
sql.exportValue(1,".","round_single_value","decimal",2,0,8,X_8,"");
end s15_1;
sql>select round(750,1);
MAPI = (monetdb) /tmp/.s.monetdb.50000
QUERY = select round(750,1);
ERROR = !too many digits (3 > 2)

Reproducible: Always

Steps to Reproduce:

1. run sql query: select round(750,1);

Actual Results:

22003!too many digits (3 > 2)

Expected Results:

750

Comment 17225

Date: 2012-05-07 13:48:39 +0200
From: @njnes

fixed by adding another check for functions with decimals as input (when the input expressions are numbers)