You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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)
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:
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)
The text was updated successfully, but these errors were encountered: