[JBoss JIRA] (TEIID-5731) Recursive Query Common Table Expressions (CTE) PostgreSQL
by Kolmar Vasconcelos (Jira)
[ https://issues.jboss.org/browse/TEIID-5731?page=com.atlassian.jira.plugin... ]
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)
5 years, 6 months
[JBoss JIRA] (TEIID-5731) Recursive Query Common Table Expressions (CTE) PostgreSQL
by Kolmar Vasconcelos (Jira)
[ 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.
> 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
>
> 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)
5 years, 6 months
[JBoss JIRA] (TEIID-5731) Recursive Query Common Table Expressions (CTE) PostgreSQL
by Kolmar Vasconcelos (Jira)
Kolmar Vasconcelos created TEIID-5731:
-----------------------------------------
Summary: 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
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)
5 years, 6 months
[JBoss JIRA] (TEIIDSB-84) There needs to be an error page
by Steven Hawkins (Jira)
Steven Hawkins created TEIIDSB-84:
-------------------------------------
Summary: There needs to be an error page
Key: TEIIDSB-84
URL: https://issues.jboss.org/browse/TEIIDSB-84
Project: Teiid Spring Boot
Issue Type: Quality Risk
Components: OData
Reporter: Steven Hawkins
Fix For: 1.1.0
If you try a url, such as /foo it results in a lengthy log:
2019-04-30 15:20:14.247 ERROR 14280 --- [nio-8080-exec-2] o.a.c.c.C.[Tomcat].[localhost] : Exception Processing ErrorPage[errorCode=0, location=/error]
javax.servlet.ServletException: Circular view path [error]: would dispatch back to the current handler URL [/error] again. Check your ViewResolver setup! (Hint: This may be the result of an unspecified view, due to default view name generation.)
at org.springframework.web.servlet.view.InternalResourceView.prepareForRendering(InternalResourceView.java:209) ~[spring-webmvc-5.1.4.RELEASE.jar!/:5.1.4.RELEASE]
at org.springframework.web.servlet.view.InternalResourceView.renderMergedOutputModel(InternalResourceView.java:147) ~[spring-webmvc-5.1.4.RELEASE.jar!/:5.1.4.RELEASE]
at org.springframework.web.servlet.view.AbstractView.render(AbstractView.java:316) ~[spring-webmvc-5.1.4.RELEASE.jar!/:5.1.4.RELEASE]
at org.springframework.web.servlet.DispatcherServlet.render(DispatcherServlet.java:1370) ~[spring-webmvc-5.1.4.RELEASE.jar!/:5.1.4.RELE...
--
This message was sent by Atlassian Jira
(v7.12.1#712002)
5 years, 6 months
[JBoss JIRA] (TEIIDSB-47) Determine behavior of alter statements
by Ramesh Reddy (Jira)
[ https://issues.jboss.org/browse/TEIIDSB-47?page=com.atlassian.jira.plugin... ]
Ramesh Reddy resolved TEIIDSB-47.
---------------------------------
Resolution: Done
Added the flag to control the allowance of allowAlter property to be set on TSB. By default, it is set to false.
> Determine behavior of alter statements
> --------------------------------------
>
> Key: TEIIDSB-47
> URL: https://issues.jboss.org/browse/TEIIDSB-47
> Project: Teiid Spring Boot
> Issue Type: Quality Risk
> Components: core
> Reporter: Steven Hawkins
> Assignee: Ramesh Reddy
> Priority: Major
> Fix For: 1.1.0
>
>
> The engine allows alter statements to ephemerally (by default) change view definitions, turn on/off triggers, etc. For Spring Boot and OpenShift deployment in particular we should consider whether this should be allowable/optional behavior.
--
This message was sent by Atlassian Jira
(v7.12.1#712002)
5 years, 6 months