SQL Statement Parsing Error

SQL Statement Parsing Error


In version 10.1.0 of UniDac I have a problem in type conversions with PostgreSQL, this problem was not present in the previous version.

Example: "SELECT id, name::text FROM customer"

In the example SQL statement I get an error in the "name::text" part, as it is known, type conversions can be done with the ":::" operator in PostgreSQL, but in version 10.1.0 of UniDac, it recognises "::text" as a parameter called "text".

Of course it is possible to do it as "CAST(name AS text)" but this is a long way and it is difficult to change them in the whole project.

Best regards.