Date: 2020-06-15 13:47:57 +0200
From: @PedroTadim
To: SQL devs <>
Version: 11.37.7 (Jun2020)

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

Comment 27846

Date: 2020-06-15 13:47:57 +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 bellow.

Reproducible: Always

Steps to Reproduce:

CREATE TABLE "sys"."t0" (
"c0" DECIMAL(18,3),
"c1" DOUBLE
);
COPY 25 RECORDS INTO "sys"."t0" FROM stdin USING DELIMITERS E'\t',E'\n','"';
0.861 0.6056174268361689
NULL 0.5542760880735715
0.566 0.5542760880735715
0.923 0.052316013908556114
0.162 0.5542760880735715
0.329 0.44073078327593473
0.662 0.5255985140328766
0.001 NULL
0.736 NULL
0.604 0.5394080603985286
0.988 NULL
0.232 0.23262100818671297
0.041 -7.386201860458207e+20
0.776 NULL
0.805 NULL
0.189 NULL
0.493 NULL
0.164 0.23262100818671297
0.316 0.6870041098637464
NULL 1.19449193e+09
NULL 0.5798864736610635
0.219 37
0.924 0.8488059445245933
0.413 0.6870041098637464
0.234 0

SELECT count(*) FROM t0 WHERE (NOT (CAST((t0.c1) IS NULL AS BOOLEAN))) IS NULL;

Actual Results:

18