From: | 王子涵4620 <1290874854(at)qq(dot)com> |
---|---|
To: | akuluasan <akuluasan(at)163(dot)com>, pgsql-bugs <pgsql-bugs(at)lists(dot)postgresql(dot)org> |
Cc: | akuluasan <akuluasan(at)163(dot)com> |
Subject: | 回复:BUG #18420: Unexpected values appeared in select query statements that should logically imply each other |
Date: | 2024-04-04 07:03:07 |
Message-ID: | tencent_A3E843F5788DB46A1C157A5C4830B7F07F08@qq.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Akshat Jaimini | 2024-04-04 09:51:48 | Re: BUG: deadlock between autovacuum worker and client backend during removal of orphan temp tables with sequences |
Previous Message | PG Bug reporting form | 2024-04-04 06:14:03 | BUG #18420: Unexpected values appeared in select query statements that should logically imply each other |