Bug in node GroupBy

Hi
I found a bug in the node GroupBy.
If the input table contains columns with types integer, and long and double, if we use the tab “Type Based Aggregation” from the node and would like to have e.g. the first row of the aggregation, the output table will have the integer type columns in triplicate, and the long type columns in duplicate.
If we use the tab “Pattern Based Aggregation” and ask for the first row of the aggregation, the output table is correct.

I attached a sample workflow

Here under my OS information and knime version.

Thank you in advance if you can solve this issue.

Best regards.

Thierry

cat /etc/*-release
DISTRIB_ID=Ubuntu
DISTRIB_RELEASE=16.04
DISTRIB_CODENAME=xenial
DISTRIB_DESCRIPTION=“Ubuntu 16.04.5 LTS”
NAME=“Ubuntu”
VERSION=“16.04.5 LTS (Xenial Xerus)”
ID=ubuntu
ID_LIKE=debian
PRETTY_NAME=“Ubuntu 16.04.5 LTS”
VERSION_ID=“16.04”
HOME_URL=“http://www.ubuntu.com/
SUPPORT_URL=“http://help.ubuntu.com/
BUG_REPORT_URL=“http://bugs.launchpad.net/ubuntu/
VERSION_CODENAME=xenial
UBUNTU_CODENAME=xenial

uname -a
Linux AIB-LT003 4.15.0-43-generic #46~16.04.1-Ubuntu SMP Fri Dec 7 13:31:08 UTC 2018 x86_64 x86_64 x86_64 GNU/Linux

KNIME 3.7.0
send-by-TC.knwf (15.0 KB)

1 Like

Hello @tconvard -

Thanks very much for the detailed bug description and workflow. Using this, I was able to find a bug in our ticketing system where this has come up in the past. I will add a +1 from you to that ticket so our developers will be aware that this is still an issue.

Cheers!