[ https://issues.jboss.org/browse/TEIID-5731?page=com.atlassian.jira.plugin... ] Kolmar Vasconcelos updated TEIID-5731: -------------------------------------- Description: I'm trying to a recursive Common Table Expressions on my organization's VBL. I know it runs on top of PostgreSQL. I'm not responsible for the implementation, I'm just trying to access the data for Data Analysis. When I try to create the Recursive Query it gives me the error: Remote org.postgresql.util.PSQLException: ERROR: recursive query "cte" column 6 has type character varying(255) in non-recursive term but type character varying overall. The problem is with the Null value. I can't CAST Null to VARCHAR. was: I'm trying to a recursive Common Table Expressions on my organization's VBL. I know it runs on top of PostgreSQL. I'm not responsible for the implementation, I'm just trying to access the data for Data Analysis. When I try to create the Recursive Query it gives me the error: Remote org.postgresql.util.PSQLException: ERROR: recursive query "cte" column 6 has type character varying(255) in non-recursive term but type character varying overall. The problem is with the Null value. I just can't CAST Null to VARCHAR. -- This message was sent by Atlassian Jira (v7.12.1#712002)