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

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

Comment 27911

Date: 2020-07-16 17:38:07 +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" CHARACTER LARGE OBJECT NOT NULL,CONSTRAINT "t0_c0_pkey" PRIMARY KEY ("c0"),CONSTRAINT "t0_c0_unique" UNIQUE ("c0"),CONSTRAINT "t0_c0_unique" UNIQUE ("c0"));
COPY 22 RECORDS INTO "sys"."t0" FROM stdin USING DELIMITERS E'\t',E'\n','"';
"1970-01-19"
"0.9940522485469018"
"Sn"
""
",骭2T*h[99஺M\nBCϹ㦚X"
"0.8497262043468918"
"18696712"
"A6"
"H "
"7"
"5A9\RA,P1wjK\s9{1B"
"0.0585841777572819741970-01-09 00:59:03.000000-2401479681969-12-14"
"0.57004315834853170.632265992946155"
"돡I]OrrT^\-}y鱏[ॗ%Hß}XZq"
"j"
"5t3瘏mCX穳[t+JS"
"R៹I&[]9j\ne(pHjL<jID"
"0.0256755262112501330.85555714908316971970-01-04"
","
"鲾KI)b k44d"
"3}鄈"
"true"

CREATE TABLE "sys"."t1" ("c0" CHARACTER LARGE OBJECT,"c1" BOOLEAN NOT NULL,CONSTRAINT "t1_c1_unique" UNIQUE ("c1"));
COPY 2 RECORDS INTO "sys"."t1" FROM stdin USING DELIMITERS E'\t',E'\n','"';
"*" true
"Xh{%LTF" false

SELECT SUM(agg0) FROM (SELECT ALL SUM(ALL 0.97) as agg0 FROM t0 CROSS JOIN t1 WHERE ((((t1.c1)AND(t1.c1)))AND(((t0.c0)>(t0.c0))))
UNION ALL SELECT SUM(ALL 0.97) as agg0 FROM t0 CROSS JOIN t1 WHERE NOT (((((t1.c1)AND(t1.c1)))AND(((t0.c0)>(t0.c0)))))
UNION ALL SELECT SUM(ALL 0.97) as agg0 FROM t0 CROSS JOIN t1 WHERE (((((t1.c1)AND(t1.c1)))AND(((t0.c0)>(t0.c0))))) IS NULL) as asdf;

Actual Results:

Error: inputs not the same size.

Expected Results:

A result set.