Median function with decimal type doesn't work

[monetdb-team]

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:

Added test for bug #3352.

Comment 19091

Date: 2013-08-27 15:26:59 +0200
From: @sjoerdmullender

This has already been fixed for the next release.