xiong duan created CALCITE-6756:
-----------------------------------
Summary: Preserving CAST of STRING operand in binary comparison
for PostgreSQL
Key: CALCITE-6756
URL: https://issues.apache.org/jira/browse/CALCITE-6756
Project: Calcite
Issue Type: Bug
Reporter: xiong duan
In Postgresql:
{code:java}
SELECT * FROM table where cast('10' as text) = 1; // throw operator does not
exist: text = integer
SELECT * FROM table where cast('10' as varchar) = 1; // operator does not
exist: character varying = integer
SELECT * FROM table where cast('10' as char) = 1; //operator does not exist:
character = integer{code}
So when generating Postgres SQL, we need to preserve the CAST of STRING.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
