[teiid-issues] [JBoss JIRA] (TEIID-5731) Recursive Query Common Table Expressions (CTE) PostgreSQL
Kolmar Vasconcelos (Jira)
issues at jboss.org
Tue Apr 30 18:56:00 EDT 2019
[ https://issues.jboss.org/browse/TEIID-5731?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kolmar Vasconcelos closed TEIID-5731.
-------------------------------------
Fix Version/s: 12.1.1
Resolution: Done
My bad. I just cast the literal null and it worked.
> Recursive Query Common Table Expressions (CTE) PostgreSQL
> ---------------------------------------------------------
>
> Key: TEIID-5731
> URL: https://issues.jboss.org/browse/TEIID-5731
> Project: Teiid
> Issue Type: Bug
> Components: JDBC Driver
> Affects Versions: 12.1.1
> Environment: Ubuntu Linux 18.04
> DBeaver 5.3.3
> TEIID JDBC 12.1.1
> Reporter: Kolmar Vasconcelos
> Assignee: Steven Hawkins
> Priority: Critical
> Fix For: 12.1.1
>
>
> 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.
--
This message was sent by Atlassian Jira
(v7.12.1#712002)
More information about the teiid-issues
mailing list