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
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/29.0.1547.57 Safari/537.36
Build Identifier:
Using median function on decimal column raise an error:
value (x) exceeds limit of type bte
Reproducible: Always
Steps to Reproduce:
create table t1 (a numeric(10,2),b double);
insert into t1 values (41.18,41.18);
insert into t1 values (31.13,31.13);
insert into t1 values (21.22,21.22);
insert into t1 values (31.4,31.4);
insert into t1 values (121.5,121.5);
insert into t1 values (111.6,111.6);
insert into t1 values (222.8,222.8);
select median(a) from t1;
select median(b) from t1;
Actual Results:
value (223) exceeds limits of type bte
Expected Results:
41.18
MonetDB 5 server v11.15.11 "Feb2013-SP3" (64-bit, 64-bit oids)
Copyright (c) 1993-July 2008 CWI
Copyright (c) August 2008-2013 MonetDB B.V., all rights reserved
Visit http://www.monetdb.org/ for further information
Found 7.7GiB available memory, 4 available cpu cores
Libraries:
libpcre: 8.30 2012-02-04 (compiled with 8.30)
openssl: OpenSSL 1.0.1c 10 May 2012 (compiled with OpenSSL 1.0.1c 10 May 2012)
libxml2: 2.8.0 (compiled with 2.8.0)
Compiled by: root@dev.monetdb.org (x86_64-pc-linux-gnu)
Compilation: gcc -O3 -fomit-frame-pointer -pipe -Wp,-D_FORTIFY_SOURCE=2
Linking : /usr/bin/ld -m elf_x86_64
Date: 2013-08-27 14:58:57 +0200
From: Klaudiusz <>
To: Merovingian devs <>
Version: 11.15.11 (Feb2013-SP3)
Last updated: 2013-09-27 13:47:16 +0200
Comment 19086
Date: 2013-08-27 14:58:57 +0200
From: Klaudiusz <>
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/29.0.1547.57 Safari/537.36
Build Identifier:
Using median function on decimal column raise an error:
value (x) exceeds limit of type bte
Reproducible: Always
Steps to Reproduce:
create table t1 (a numeric(10,2),b double);
insert into t1 values (41.18,41.18);
insert into t1 values (31.13,31.13);
insert into t1 values (21.22,21.22);
insert into t1 values (31.4,31.4);
insert into t1 values (121.5,121.5);
insert into t1 values (111.6,111.6);
insert into t1 values (222.8,222.8);
select median(a) from t1;
select median(b) from t1;
Actual Results:
value (223) exceeds limits of type bte
Expected Results:
41.18
MonetDB 5 server v11.15.11 "Feb2013-SP3" (64-bit, 64-bit oids)
Copyright (c) 1993-July 2008 CWI
Copyright (c) August 2008-2013 MonetDB B.V., all rights reserved
Visit http://www.monetdb.org/ for further information
Found 7.7GiB available memory, 4 available cpu cores
Libraries:
libpcre: 8.30 2012-02-04 (compiled with 8.30)
openssl: OpenSSL 1.0.1c 10 May 2012 (compiled with OpenSSL 1.0.1c 10 May 2012)
libxml2: 2.8.0 (compiled with 2.8.0)
Compiled by: root@dev.monetdb.org (x86_64-pc-linux-gnu)
Compilation: gcc -O3 -fomit-frame-pointer -pipe -Wp,-D_FORTIFY_SOURCE=2
Linking : /usr/bin/ld -m elf_x86_64
Comment 19090
Date: 2013-08-27 15:25:50 +0200
From: MonetDB Mercurial Repository <>
Changeset c8c3062bbf37 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=c8c3062bbf37
Changeset description:
Comment 19091
Date: 2013-08-27 15:26:59 +0200
From: @sjoerdmullender
This has already been fixed for the next release.
The text was updated successfully, but these errors were encountered: