Hi hackers, I found $subject problem when using SQLancer. How to repeat: CREATE TEMP TABLE t0(c0 inet, c1 money, c2 TEXT); CREATE TEMP TABLE IF NOT EXISTS t1(LIKE t0); CREATE TEMP TABLE t2(c0 boolean , c1 DECIMAL NOT NULL UNIQUE); CREATE TEMPORARY TABLE t3(LIKE t1); CREATE VIEW v0(c0) AS (SELECT DISTINCT 0 FROM t3); SELECT SUM(count) FROM (SELECT (((t1.c2)LIKE(((((t0.c2)||(((103556691)-(v0.c0)))))||(v0.c0)))))::INT as count FROM t0, ONLY t1 RIGHT OUTER JOIN ONLY t2 ON t2.c0 RIGHT OUTER JOIN v0 ON ((t2.c1)=(0.08182310538090898))) as res;
psql (16devel) Type "help" for help. postgres=# \d Did not find any relations. postgres=# CREATE TEMP TABLE t0(c0 inet, c1 money, c2 TEXT); CREATE TABLE postgres=# CREATE TEMP TABLE IF NOT EXISTS t1(LIKE t0); CREATE TABLE postgres=# CREATE TEMP TABLE t2(c0 boolean , c1 DECIMAL NOT NULL UNIQUE); CREATE TABLE postgres=# CREATE TEMPORARY TABLE t3(LIKE t1); CREATE TABLE postgres=# CREATE VIEW v0(c0) AS (SELECT DISTINCT 0 FROM t3); NOTICE: view "v0" will be a temporary view CREATE VIEW postgres=# SELECT SUM(count) FROM (SELECT (((t1.c2)LIKE(((((t0.c2)||(((103556691)-(v0.c0)))))||(v0.c0)))))::INT as count FROM t0, ONLY t1 RIGHT OUTER JOIN ONLY t2 ON t2.c0 RIGHT OUTER JOIN v0 ON ((t2.c1)=(0.08182310538090898))) as res; ERROR: wrong varnullingrels (b 5 7) (expected (b)) for Var 3/3 regards, tender wang
