July 2019 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-5796) Not able to read JSON data file kelpt on FTP/SFTP server using FTP resource adapter and file translator

by Pranita Gurav (Jira)

Pranita Gurav created TEIID-5796: ------------------------------------ Summary: Not able to read JSON data file kelpt on FTP/SFTP server using FTP resource adapter and file translator Key: TEIID-5796 URL: https://issues.jboss.org/browse/TEIID-5796 Project: Teiid Issue Type: Bug Components: AdminApi Affects Versions: 11.2.1 Environment: Not able to read JSON data file kept on FTP/SFTP server using FTP resource adapter and file translator by parsing view using XMLTABLE. Reporter: Pranita Gurav Assignee: Steven Hawkins Attachments: server.log Not able to read JSON data file kept on FTP/SFTP server using FTP resource adapter and file translator by parsing view using XMLTABLE. And As per Ramesh JSONTABLE do not support nested documents. For more details please find discussion : https://developer.jboss.org/message/990083#990083 I am using Teiid 11.1.2 Admin API and wildfly server -- This message was sent by Atlassian Jira (v7.12.1#712002)

5 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5792) Permissions don't work with virtual procedures' ResultSet

by Dmitrii Pogorelov (Jira)

[ https://issues.jboss.org/browse/TEIID-5792?page=com.atlassian.jira.plugin... ] Dmitrii Pogorelov commented on TEIID-5792: ------------------------------------------ [~shawkins] got it, but the workaround doesn't fit, of course, for the case if we want to forbid all cols in resultset and return just empty, as if it were for a sproc without resultset. The view can help us to solve the permission issue for procedures' resultset but for me it looks like a crutch (or an additional option to solve some not traditional cases). > Then what if all result set columns are not accessible? Does the result set convey the row count and have no columns, or should it be completely empty. I would return just empty result as it does a real procedure without resultset. If we need to return something then it should be implemented via virtual view (here the workaround with views fits very nice). > Permissions don't work with virtual procedures' ResultSet > --------------------------------------------------------- > > Key: TEIID-5792 > URL: https://issues.jboss.org/browse/TEIID-5792 > Project: Teiid > Issue Type: Enhancement > Components: Query Engine > Affects Versions: 12.0 > Environment: teiid-12.0.0 on WildFly Full 14.0.1.Final (WildFly Core 6.0.2.Final) > Reporter: Dmitrii Pogorelov > Assignee: Steven Hawkins > Priority: Major > > Teiid doesn't work with ResultSet of a virtual procedure. For example, if we have procs.testProc virtual procedure which can return two values in ResultSet: a and b and we specify a permission for one of these columns in ResultSet, the permission won't work: > {code:xml} > <permission> > <resource-name>procs.testProc.a</resource-name> > <allow-read>false</allow-read> > </permission> > {code} > I think it would be great to set permissions also for ResultSets of virtual procedures, so AuthorizationValidationVisitor.validateEntitlements method for a GroupSymbol, which is a procedure, should analyze also its ResultSet. At the same time permissions work for virtual views and we can set permissions for some views' columns separately. -- This message was sent by Atlassian Jira (v7.12.1#712002)

5 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5792) Permissions don't work with virtual procedures' ResultSet

by Steven Hawkins (Jira)

[ https://issues.jboss.org/browse/TEIID-5792?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-5792: --------------------------------------- > How can I wrap the procedure in a view? Procedural relational syntax allows for the passing of parameters as IN or equality predicates: create procedure p (param string) returns table (col string); create view p_view (param string, col string) as select param, col from p; then you can do: select col from p_view where param = 'a' > Permissions don't work with virtual procedures' ResultSet > --------------------------------------------------------- > > Key: TEIID-5792 > URL: https://issues.jboss.org/browse/TEIID-5792 > Project: Teiid > Issue Type: Enhancement > Components: Query Engine > Affects Versions: 12.0 > Environment: teiid-12.0.0 on WildFly Full 14.0.1.Final (WildFly Core 6.0.2.Final) > Reporter: Dmitrii Pogorelov > Assignee: Steven Hawkins > Priority: Major > > Teiid doesn't work with ResultSet of a virtual procedure. For example, if we have procs.testProc virtual procedure which can return two values in ResultSet: a and b and we specify a permission for one of these columns in ResultSet, the permission won't work: > {code:xml} > <permission> > <resource-name>procs.testProc.a</resource-name> > <allow-read>false</allow-read> > </permission> > {code} > I think it would be great to set permissions also for ResultSets of virtual procedures, so AuthorizationValidationVisitor.validateEntitlements method for a GroupSymbol, which is a procedure, should analyze also its ResultSet. At the same time permissions work for virtual views and we can set permissions for some views' columns separately. -- This message was sent by Atlassian Jira (v7.12.1#712002)

5 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5793) Upgrade commons-configuration to 1.7 to upgrade commons-beanutils

by Steven Hawkins (Jira)

[ https://issues.jboss.org/browse/TEIID-5793?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-5793. ----------------------------------- Fix Version/s: 12.3 Resolution: Done Merged the pr from Van. > Upgrade commons-configuration to 1.7 to upgrade commons-beanutils > ----------------------------------------------------------------- > > Key: TEIID-5793 > URL: https://issues.jboss.org/browse/TEIID-5793 > Project: Teiid > Issue Type: Quality Risk > Components: Build/Kits > Affects Versions: 12.3 > Reporter: Van Halbert > Assignee: Van Halbert > Priority: Major > Fix For: 12.3 > > -- This message was sent by Atlassian Jira (v7.12.1#712002)

5 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5792) Permissions don't work with virtual procedures' ResultSet

by Dmitrii Pogorelov (Jira)

[ https://issues.jboss.org/browse/TEIID-5792?page=com.atlassian.jira.plugin... ] Dmitrii Pogorelov commented on TEIID-5792: ------------------------------------------ [~shawkins] ok, what about if I have a procedure with an argument? How can I wrap the procedure in a view? > Permissions don't work with virtual procedures' ResultSet > --------------------------------------------------------- > > Key: TEIID-5792 > URL: https://issues.jboss.org/browse/TEIID-5792 > Project: Teiid > Issue Type: Enhancement > Components: Query Engine > Affects Versions: 12.0 > Environment: teiid-12.0.0 on WildFly Full 14.0.1.Final (WildFly Core 6.0.2.Final) > Reporter: Dmitrii Pogorelov > Assignee: Steven Hawkins > Priority: Major > > Teiid doesn't work with ResultSet of a virtual procedure. For example, if we have procs.testProc virtual procedure which can return two values in ResultSet: a and b and we specify a permission for one of these columns in ResultSet, the permission won't work: > {code:xml} > <permission> > <resource-name>procs.testProc.a</resource-name> > <allow-read>false</allow-read> > </permission> > {code} > I think it would be great to set permissions also for ResultSets of virtual procedures, so AuthorizationValidationVisitor.validateEntitlements method for a GroupSymbol, which is a procedure, should analyze also its ResultSet. At the same time permissions work for virtual views and we can set permissions for some views' columns separately. -- This message was sent by Atlassian Jira (v7.12.1#712002)

5 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5794) GENERATED_KEY function in an input trigger results in validation error if used in presence of a compound primary key which consists of a mix of auto-increment and non-auto-increment variables

by Steven Hawkins (Jira)

[ https://issues.jboss.org/browse/TEIID-5794?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-5794. ----------------------------------- Fix Version/s: 12.3 Resolution: Done Changed the resolver and associated logic to not expect all columns of a composite key to be auto increment. > GENERATED_KEY function in an input trigger results in validation error if used in presence of a compound primary key which consists of a mix of auto-increment and non-auto-increment variables > ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- > > Key: TEIID-5794 > URL: https://issues.jboss.org/browse/TEIID-5794 > Project: Teiid > Issue Type: Enhancement > Components: Query Engine > Affects Versions: 12.3 > Reporter: Christoph John > Assignee: Steven Hawkins > Priority: Major > Fix For: 12.3 > > > The issue refers to > https://issues.jboss.org/browse/TEIID-5782 where if was found, that > the GENERATED_KEY function does result in an validation error > validation error: TEIID31119 Symbol key.fkProduct is specified with an unknown group context > in an INSERT trigger when the view on which the insert is called has a compound primary key which consists of a mix of AUTO_INCREMENT and non-AUTO_INCREMENT variables. > A code example can be found in the following comment > https://issues.jboss.org/browse/TEIID-5782?focusedCommentId=13759345&page... -- This message was sent by Atlassian Jira (v7.12.1#712002)

5 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5794) GENERATED_KEY function in an input trigger results in validation error if used in presence of a compound primary key which consists of a mix of auto-increment and non-auto-increment variables

by Steven Hawkins (Jira)

[ https://issues.jboss.org/browse/TEIID-5794?page=com.atlassian.jira.plugin... ] Work on TEIID-5794 started by Steven Hawkins. --------------------------------------------- > GENERATED_KEY function in an input trigger results in validation error if used in presence of a compound primary key which consists of a mix of auto-increment and non-auto-increment variables > ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- > > Key: TEIID-5794 > URL: https://issues.jboss.org/browse/TEIID-5794 > Project: Teiid > Issue Type: Enhancement > Components: Query Engine > Affects Versions: 12.3 > Reporter: Christoph John > Assignee: Steven Hawkins > Priority: Major > > The issue refers to > https://issues.jboss.org/browse/TEIID-5782 where if was found, that > the GENERATED_KEY function does result in an validation error > validation error: TEIID31119 Symbol key.fkProduct is specified with an unknown group context > in an INSERT trigger when the view on which the insert is called has a compound primary key which consists of a mix of AUTO_INCREMENT and non-AUTO_INCREMENT variables. > A code example can be found in the following comment > https://issues.jboss.org/browse/TEIID-5782?focusedCommentId=13759345&page... -- This message was sent by Atlassian Jira (v7.12.1#712002)

5 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5795) Embedded Admin deploy should handle .zip and .ddl

by Steven Hawkins (Jira)

[ https://issues.jboss.org/browse/TEIID-5795?page=com.atlassian.jira.plugin... ] Steven Hawkins moved TEIIDTOOLS-700 to TEIID-5795: -------------------------------------------------- Project: Teiid (was: Teiid Tools) Key: TEIID-5795 (was: TEIIDTOOLS-700) > Embedded Admin deploy should handle .zip and .ddl > ------------------------------------------------- > > Key: TEIID-5795 > URL: https://issues.jboss.org/browse/TEIID-5795 > Project: Teiid > Issue Type: Enhancement > Reporter: Steven Hawkins > Priority: Major > Fix For: 12.3 > > > The embedded admin logic currently only handles the deployment of .xml vdbs. -- This message was sent by Atlassian Jira (v7.12.1#712002)

5 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5795) Embedded Admin deploy should handle .zip and .ddl

by Steven Hawkins (Jira)

[ https://issues.jboss.org/browse/TEIID-5795?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-5795: ---------------------------------- Component/s: AdminApi Fix Version/s: 12.3 > Embedded Admin deploy should handle .zip and .ddl > ------------------------------------------------- > > Key: TEIID-5795 > URL: https://issues.jboss.org/browse/TEIID-5795 > Project: Teiid > Issue Type: Enhancement > Components: AdminApi > Reporter: Steven Hawkins > Priority: Major > Fix For: 12.3 > > > The embedded admin logic currently only handles the deployment of .xml vdbs. -- This message was sent by Atlassian Jira (v7.12.1#712002)

5 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5794) GENERATED_KEY function in an input trigger results in validation error if used in presence of a compound primary key which consists of a mix of auto-increment and non-auto-increment variables

by Steven Hawkins (Jira)

[ https://issues.jboss.org/browse/TEIID-5794?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-5794: ---------------------------------- Issue Type: Enhancement (was: Bug) Component/s: Query Engine Priority: Major (was: Blocker) > GENERATED_KEY function in an input trigger results in validation error if used in presence of a compound primary key which consists of a mix of auto-increment and non-auto-increment variables > ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- > > Key: TEIID-5794 > URL: https://issues.jboss.org/browse/TEIID-5794 > Project: Teiid > Issue Type: Enhancement > Components: Query Engine > Affects Versions: 12.3 > Reporter: Christoph John > Assignee: Steven Hawkins > Priority: Major > > The issue refers to > https://issues.jboss.org/browse/TEIID-5782 where if was found, that > the GENERATED_KEY function does result in an validation error > validation error: TEIID31119 Symbol key.fkProduct is specified with an unknown group context > in an INSERT trigger when the view on which the insert is called has a compound primary key which consists of a mix of AUTO_INCREMENT and non-AUTO_INCREMENT variables. > A code example can be found in the following comment > https://issues.jboss.org/browse/TEIID-5782?focusedCommentId=13759345&page... -- This message was sent by Atlassian Jira (v7.12.1#712002)

5 years, 5 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues July 2019