I am using my tool to simplify the SQL query. Can you please confirm if the simplification process helps you diagnose and locate bugs?
----create data----
create table table_3_utf8_undef (
id SERIAL PRIMARY KEY,
"col_varchar(20)_undef_signed" varchar(20)
) ;
insert into table_3_utf8_undef values (0,'3
'),(1,'well'),(2,'-0');
----sql1----
(SELECT (CEILING(0.248382)) AS "f1"FROM "table_3_utf8_undef"
WHERE (NOT ('wxynhwi' IN (SELECT "col_varchar(20)_undef_signed" FROM "table_3_utf8_undef")))
)
UNION (SELECT (CEILING(0.567733)^CEIL(0.891845)) AS "f1" FROM "table_3_utf8_undef");
f1
----
1
----sql2----
(SELECT (CEILING(0.248382)) AS "f1" FROM "table_3_utf8_undef"
WHERE FALSE )
UNION (SELECT (CEILING(0.567733)^CEIL(0.891845)) AS "f1" FROM"table_3_utf8_undef");
f1
--------------------
1.0000000000000000