Date: 2020-07-16 11:31:15 +0200
From: @PedroTadim
To: SQL devs <>
Version: 11.37.7 (Jun2020)

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

Comment 27909

Date: 2020-07-16 11:31:15 +0200
From: @PedroTadim

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

Run the statements bellow.

Reproducible: Always

Steps to Reproduce:

CREATE TABLE "sys"."t0" (
"c0" TIME,
"c1" CHARACTER LARGE OBJECT NOT NULL,
CONSTRAINT "t0_c1_pkey" PRIMARY KEY ("c1"),
CONSTRAINT "t0_c1_unique" UNIQUE ("c1")
);
COPY 14 RECORDS INTO "sys"."t0" FROM stdin USING DELIMITERS E'\t',E'\n','"';
19:29:38 ""
05:51:00 "B"
NULL ".n"
NULL "0.0"
20:29:28 "-601098762"
20:59:23 ")TD)Dnö"
22:09:19 "aaJ즳B!sJNG㡩"
09:10:09 "W"
23:43:33 "k"
15:43:27 "-0.0"
20:02:19 "0.7126186870446843"
05:23:53 "1498390845"
00:17:15 "{"
06:51:52 "41230238"

SELECT t0.c0 FROM t0 WHERE (((t0.c0)<>(t0.c0))) IS NULL;

Actual Results:

Two rows with 22:07:22 and 05:51:00

Expected Results:

Two rows with NULL values.