Details
-
Bug
-
Status: Closed
-
Major
-
Resolution: Fixed
-
None
-
None
Description
In Postgresql:
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
So when generating Postgres SQL, we need to preserve the CAST of STRING.
Attachments
Issue Links
- links to