Date: 2020-06-13 14:37:56 +0200
From: @PedroTadim
To: SQL devs <>
Version: 11.37.7 (Jun2020)

Last updated: 2020-07-27 09:30:11 +0200

Comment 27843

Date: 2020-06-13 14:37:56 +0200
From: @PedroTadim

User-Agent: Mozilla/5.0 (X11; Fedora; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/83.0.4103.97 Safari/537.36
Build Identifier:

Run the statements below.

Reproducible: Always

Steps to Reproduce:

CREATE TABLE "t0"("c0" DECIMAL(18,3), "c1" BIGINT);
COPY 12 RECORDS INTO "t0" FROM stdin USING DELIMITERS E'\t',E'\n','"';
0.244 NULL
0.578 NULL
0.119 NULL
0.773 495026350
0.329 2108706088
0.483 1298757529
0.880 39
0.084 1
0.332 859611948
0.607 NULL
0.835 0
0.455 -1239303309

SELECT MIN(DISTINCT t0.c1) FROM t0 WHERE 1 >= t0.c0 GROUP BY true;

Actual Results:

GDK reported error: BATgroupminmax: BATgroupmin: b and g must be aligned

Expected Results:

-1239303309