teiid-issues May 2019

teiid-issues@lists.jboss.org

1 participants
234 discussions

[JBoss JIRA] (TEIIDSB-85) Remove the need for an odata role

by Steven Hawkins (Jira)

Steven Hawkins created TEIIDSB-85: ------------------------------------- Summary: Remove the need for an odata role Key: TEIIDSB-85 URL: https://issues.jboss.org/browse/TEIIDSB-85 Project: Teiid Spring Boot Issue Type: Quality Risk Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 1.1.0 The odata access role was carried forward from Teiid to Teiid Spring Boot. We should rethink this. I think the reason it was originally added was for installs that were not using data roles it ensured that odata access was not wide open. It also introduced the complexity that it could be using a different security domain that the default. It's simplest to just remove the role requirement. As we've refined things we now are using the same realm through out and a single client for both odata and pg/jdbc access. Since it's very easy to add grant all roles to properly permissioned users or simple grant all read-only access, it does not seem necessary to further restrict odata access at the teiid level. 2. Since we allowed different security domains -- This message was sent by Atlassian Jira (v7.12.1#712002)

6 years, 11 months

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 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)

6 years, 11 months

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)

6 years, 11 months

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)

6 years, 11 months

1
0
0 / 0

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

Jump to page:

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues May 2019