teiid-issues May 2019

teiid-issues@lists.jboss.org

1 participants
233 discussions

[JBoss JIRA] (TEIID-5731) Recursive Query Common Table Expressions (CTE) PostgreSQL

by Steven Hawkins (Jira)

[ https://issues.jboss.org/browse/TEIID-5731?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-5731: ---------------------------------- Fix Version/s: (was: 12.1.1) > 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, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-5731) Recursive Query Common Table Expressions (CTE) PostgreSQL

by Steven Hawkins (Jira)

[ https://issues.jboss.org/browse/TEIID-5731?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-5731. ----------------------------------- Resolution: Explained > 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, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-5731) Recursive Query Common Table Expressions (CTE) PostgreSQL

by Steven Hawkins (Jira)

[ https://issues.jboss.org/browse/TEIID-5731?page=com.atlassian.jira.plugin... ] Steven Hawkins reopened TEIID-5731: ----------------------------------- > 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, 1 month

1
0
0 / 0

← Newer
1
...
21
22
23
24
Older →

Jump to page:

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues May 2019