Date: 2020-06-16 18:28:14 +0200
From: @PedroTadim
To: SQL devs <>
Version: 11.37.7 (Jun2020)

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

Comment 27859

Date: 2020-06-16 18:28:14 +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 queries bellow.

Reproducible: Always

Steps to Reproduce:

CREATE TABLE "sys"."t0" ("c0" DOUBLE, "c1" VARCHAR(496));
COPY 20 RECORDS INTO "sys"."t0" FROM stdin USING DELIMITERS E'\t',E'\n','"';
0.1438664733406536 NULL
0.1765302987566959 NULL
NULL "0.6278315174254069"
0.9937940991911638 "470810.02006337716"
0.925750874406328 " \Z᳣s}LfFQk呗8Mßßl07VXpgoVDy\015'X\n}呗x逖n\015>⎑s%cQyIQ"
NULL "0.17744327397271142"
NULL "y"
NULL "緦좺VDOKB "
1511423462 "470810.02006337716"
0.5249207035059663 "470810.02006337716"
1 "470810.02006337716"
0.3762066043983153 "470810.02006337716"
-939120682 "c2lT^9BY0smjöA罀A&ß14_[*r"
0.522051822144801 "0.008675985"
0.5347718465897517 "c2lt^9by0smjöa罀a&ß14_[*r"
NULL "true"
NULL "-844489501"
NULL "0.44968215744290607"
NULL ".v"
NULL "-174251119"

SELECT ALL CAST(VAR_SAMP(ALL abs(CAST(t0.c1 AS INT))) AS INT) FROM t0 GROUP BY CAST(t0.c1 AS INT), t0.c1;

Actual Results:

calc.abs undefined

Expected Results:

An output