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
create table x (y decimal(10,4));
plan quantile(y, 0.0) from x;
plan quantile(y, 0) from x;
The first works, the second doesn't. However both are questionable.
The first casts column y to double (why?), the second casts it to tinyint(!).
I think there should be no cast at all of column y, since quantiles are defined on all integer types (there may have to be some higher level magic to deal with decimals).
when we cannot resolve a aggregation function on all types, fallback to
searching based on name, number of arguments and first argument type.
Solve bug #3773
Date: 2015-07-21 10:12:41 +0200
From: @sjoerdmullender
To: SQL devs <>
Version: 11.19.15 (Oct2014-SP4)
CC: @njnes
Last updated: 2015-08-28 13:42:13 +0200
Comment 21030
Date: 2015-07-21 10:12:41 +0200
From: @sjoerdmullender
compare the two plan:
create table x (y decimal(10,4));
plan quantile(y, 0.0) from x;
plan quantile(y, 0) from x;
The first works, the second doesn't. However both are questionable.
The first casts column y to double (why?), the second casts it to tinyint(!).
I think there should be no cast at all of column y, since quantiles are defined on all integer types (there may have to be some higher level magic to deal with decimals).
Comment 21037
Date: 2015-07-22 10:08:30 +0200
From: @njnes
improved aggregation function resolution.
Comment 21038
Date: 2015-07-22 10:20:37 +0200
From: MonetDB Mercurial Repository <>
Changeset b26c48634f0d made by Niels Nes niels@cwi.nl in the MonetDB repo, refers to this bug.
For complete details, see http//devmonetdborg/hg/MonetDB?cmd=changeset;node=b26c48634f0d
Changeset description:
Comment 21040
Date: 2015-07-22 10:23:29 +0200
From: MonetDB Mercurial Repository <>
Changeset 7bd0dd798226 made by Niels Nes niels@cwi.nl in the MonetDB repo, refers to this bug.
For complete details, see http//devmonetdborg/hg/MonetDB?cmd=changeset;node=7bd0dd798226
Changeset description:
Comment 21206
Date: 2015-08-28 13:42:13 +0200
From: @sjoerdmullender
Jul2015 has been released.
The text was updated successfully, but these errors were encountered: