February 2020 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-5873) OData mapping issue with mongodb

by Steven Hawkins (Jira)

[ https://issues.redhat.com/browse/TEIID-5873?page=com.atlassian.jira.plugi... ] Steven Hawkins updated TEIID-5873: ---------------------------------- Fix Version/s: 13.2 13.2 (was: 13.1) > OData mapping issue with mongodb > --------------------------------- > > Key: TEIID-5873 > URL: https://issues.redhat.com/browse/TEIID-5873 > Project: Teiid > Issue Type: Enhancement > Components: Misc. Connectors, OData > Affects Versions: 13.0.1 > Reporter: Chee Kin Lim > Assignee: Steven Hawkins > Priority: Major > Fix For: 13.2 > > > Given the following document in MongoDB matrix_variable collection: > { > "_id" : ObjectId("5b2367c9c9e77c0007ca0111"), > "createdOn" : ISODate("2018-06-15T07:16:25.459Z"), > "modifiedOn" : ISODate("2018-07-02T02:04:16.661Z"), > "variableId" : "183cf101d2334ac09bd0db9aee96081f", > "name" : "lfzq_test", > "description" : "", > "lastModifiedUserEmail" : "admin1(a)abc.com", > "headerRow" : { > "rowId" : "0b002942a5b4424f98fcc270af0290c3", > "values" : [ > "name", > "value" > ], > "isEncrypted" : [ > false, > true > ] > }, > "rows" : [ > { > "rowId" : "940467f9bb724d1688086baeec05049b", > "values" : [ > "lfzq123q", > "751c634ca5e24102a00800b386955a5c" > ] > } > ], > "deleted" : false > } > The "headerRow" property is exposed as separate entity type in OData schema, but not "rows" property. > I found the following entity types with odata/$metadata: > <EntityType Name="headerRow">...</EntityType> > <EntityType Name="matrix_variable">...</EntityType> > Github repo to showcase the issue: > https://github.com/limcheekin/teiid-spring-boot-mongodb-odata > Related StackOverflow post: > https://stackoverflow.com/a/59385181/303211 -- This message was sent by Atlassian Jira (v7.13.8#713008)

5 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5859) Upgrade to wildfly 18

by Steven Hawkins (Jira)

[ https://issues.redhat.com/browse/TEIID-5859?page=com.atlassian.jira.plugi... ] Steven Hawkins updated TEIID-5859: ---------------------------------- Fix Version/s: 13.2 13.2 (was: 13.1) > Upgrade to wildfly 18 > --------------------- > > Key: TEIID-5859 > URL: https://issues.redhat.com/browse/TEIID-5859 > Project: Teiid > Issue Type: Task > Components: Build/Kits, Server > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Priority: Major > Fix For: 13.2 > > > We should pick up the latest wildfly 18+ -- This message was sent by Atlassian Jira (v7.13.8#713008)

5 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-219) Add a way to limit or suppress queries that exceed a threshold Cost-Based Optimizer value

by Steven Hawkins (Jira)

[ https://issues.redhat.com/browse/TEIID-219?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-219: --------------------------------- Fix Version/s: 13.2 13.2 (was: 13.1) > Add a way to limit or suppress queries that exceed a threshold Cost-Based Optimizer value > ----------------------------------------------------------------------------------------- > > Key: TEIID-219 > URL: https://issues.redhat.com/browse/TEIID-219 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine, Server > Affects Versions: 6.0.0 > Reporter: Marc Shirley > Priority: Major > Fix For: 13.2 > > > Client requesting an ability to impose a limit on, or suppress, any query that exceeds a cost estimate value specified by the user/administrator. -- This message was sent by Atlassian Jira (v7.13.8#713008)

5 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5798) Mixed PERMISSION GRANTS

by Steven Hawkins (Jira)

[ https://issues.redhat.com/browse/TEIID-5798?page=com.atlassian.jira.plugi... ] Steven Hawkins commented on TEIID-5798: --------------------------------------- To clarify the policy names are scoped to role / resource (not just the resource as with pg), so drop policy must specify the role name. > Mixed PERMISSION GRANTS > ----------------------- > > Key: TEIID-5798 > URL: https://issues.redhat.com/browse/TEIID-5798 > Project: Teiid > Issue Type: Enhancement > Components: Query Engine > Reporter: Christoph John > Assignee: Steven Hawkins > Priority: Major > Fix For: 13.1 > > Original Estimate: 6 hours > Time Spent: 2 days > Remaining Estimate: 2 hours > > Hello, > I am currently trying to set a set of permissions on a table/view. Hence a condition on INSERT,UPDATE,DELETE and an unconditioned SELECT. > However, it seems that conditioned and unconditioned GRANT statements do not work together. > {code} > GRANT INSERT,UPDATE,DELETE ON TABLE "my_nutri_diary.UserDefinedProducts_SRC" CONDITION 'UserDefinedProducts_SRC.fkProfile in (SELECT Account.idProfile FROM Account WHERE Account.uuidUser = LEFT(user(), 36) )' TO odata; > GRANT SELECT ON TABLE "my_nutri_diary.UserDefinedProducts_SRC" TO odata; > REVOKE ALTER,EXECUTE ON TABLE "my_nutri_diary.UserDefinedProducts_SRC" FROM odata; > {code} -- This message was sent by Atlassian Jira (v7.13.8#713008)

5 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5909) Pg compatibility issues to support Graphback API

by Steven Hawkins (Jira)

[ https://issues.redhat.com/browse/TEIID-5909?focusedWorklogId=12450339&pag... ] Steven Hawkins logged work on TEIID-5909: ----------------------------------------- Author: Steven Hawkins Created on: 27/Feb/20 9:13 AM Start Date: 27/Feb/20 9:13 AM Worklog Time Spent: 3 hours Issue Time Tracking ------------------- Time Spent: 5 hours (was: 2 hours) Worklog Id: (was: 12450339) > Pg compatibility issues to support Graphback API > ------------------------------------------------ > > Key: TEIID-5909 > URL: https://issues.redhat.com/browse/TEIID-5909 > Project: Teiid > Issue Type: Enhancement > Components: ODBC > Reporter: Ramesh Reddy > Assignee: Steven Hawkins > Priority: Major > Fix For: 13.1 > > Original Estimate: 3 hours > Time Spent: 5 hours > Remaining Estimate: 0 minutes > > 1) Graphback expects "select version()" call to return the result set with alias "version" as column name > 2) The client supplies the "utf-8" as the charset, which needs to be treated as UTF-8 -- This message was sent by Atlassian Jira (v7.13.8#713008)

5 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5909) Pg compatibility issues to support Graphback API

by Steven Hawkins (Jira)

[ https://issues.redhat.com/browse/TEIID-5909?page=com.atlassian.jira.plugi... ] Steven Hawkins resolved TEIID-5909. ----------------------------------- Resolution: Done Added a session variable to control the column names reported for functions, aggregates, and window functions. > Pg compatibility issues to support Graphback API > ------------------------------------------------ > > Key: TEIID-5909 > URL: https://issues.redhat.com/browse/TEIID-5909 > Project: Teiid > Issue Type: Enhancement > Components: ODBC > Reporter: Ramesh Reddy > Assignee: Steven Hawkins > Priority: Major > Fix For: 13.1 > > Original Estimate: 3 hours > Time Spent: 2 hours > Remaining Estimate: 0 minutes > > 1) Graphback expects "select version()" call to return the result set with alias "version" as column name > 2) The client supplies the "utf-8" as the charset, which needs to be treated as UTF-8 -- This message was sent by Atlassian Jira (v7.13.8#713008)

5 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5900) query with local and remote pushes too much to remote

by Steven Hawkins (Jira)

[ https://issues.redhat.com/browse/TEIID-5900?page=com.atlassian.jira.plugi... ] Steven Hawkins resolved TEIID-5900. ----------------------------------- Resolution: Cannot Reproduce Marking as not reproducible. Please reopen this issue or create new issues that are more specific (similar to the the last comment). > query with local and remote pushes too much to remote > ----------------------------------------------------- > > Key: TEIID-5900 > URL: https://issues.redhat.com/browse/TEIID-5900 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 12.3.1 > Reporter: Ken Geis > Assignee: Steven Hawkins > Priority: Major > > I have a table "A" in an Oracle database. I have a date dimension "B" in Teiid, which is a materialized view of a recursive query. The date dimension has all dates from 1950 to 2050, 36890 rows in total. > I run the following query: > {code:sql} > SELECT * > FROM a > JOIN b > ON a.date_column = b.date_key > {code} > Teiid sends a query to Oracle, which I will paraphrase as: > {code:sql} > SELECT <columns> > FROM a > WHERE date_column IN (to_date('1950-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), > <36899 other date values!>) > {code} > Oracle breaks either with the length of the query or the number of options in the IN clause. > I thought that MAKEDEP/MAKENOTDEP/MAKEIND could help, but they didn't seem to change anything. -- This message was sent by Atlassian Jira (v7.13.8#713008)

5 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5798) Mixed PERMISSION GRANTS

by Steven Hawkins (Jira)

[ https://issues.redhat.com/browse/TEIID-5798?focusedWorklogId=12450327&pag... ] Steven Hawkins logged work on TEIID-5798: ----------------------------------------- Author: Steven Hawkins Created on: 26/Feb/20 9:30 AM Start Date: 26/Feb/20 9:29 AM Worklog Time Spent: 1 day, 4 hours Issue Time Tracking ------------------- Remaining Estimate: 2 hours (was: 1 day, 6 hours) Time Spent: 2 days (was: 4 hours) Worklog Id: (was: 12450327) > Mixed PERMISSION GRANTS > ----------------------- > > Key: TEIID-5798 > URL: https://issues.redhat.com/browse/TEIID-5798 > Project: Teiid > Issue Type: Enhancement > Components: Query Engine > Reporter: Christoph John > Assignee: Steven Hawkins > Priority: Major > Fix For: 13.1 > > Original Estimate: 6 hours > Time Spent: 2 days > Remaining Estimate: 2 hours > > Hello, > I am currently trying to set a set of permissions on a table/view. Hence a condition on INSERT,UPDATE,DELETE and an unconditioned SELECT. > However, it seems that conditioned and unconditioned GRANT statements do not work together. > {code} > GRANT INSERT,UPDATE,DELETE ON TABLE "my_nutri_diary.UserDefinedProducts_SRC" CONDITION 'UserDefinedProducts_SRC.fkProfile in (SELECT Account.idProfile FROM Account WHERE Account.uuidUser = LEFT(user(), 36) )' TO odata; > GRANT SELECT ON TABLE "my_nutri_diary.UserDefinedProducts_SRC" TO odata; > REVOKE ALTER,EXECUTE ON TABLE "my_nutri_diary.UserDefinedProducts_SRC" FROM odata; > {code} -- This message was sent by Atlassian Jira (v7.13.8#713008)

5 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5909) Pg compatibility issues to support Graphback API

by Steven Hawkins (Jira)

[ https://issues.redhat.com/browse/TEIID-5909?page=com.atlassian.jira.plugi... ] Steven Hawkins updated TEIID-5909: ---------------------------------- Original Estimate: 3 hours > Pg compatibility issues to support Graphback API > ------------------------------------------------ > > Key: TEIID-5909 > URL: https://issues.redhat.com/browse/TEIID-5909 > Project: Teiid > Issue Type: Enhancement > Components: ODBC > Reporter: Ramesh Reddy > Assignee: Steven Hawkins > Priority: Major > Fix For: 13.1 > > Original Estimate: 3 hours > Time Spent: 2 hours > Remaining Estimate: 0 minutes > > 1) Graphback expects "select version()" call to return the result set with alias "version" as column name > 2) The client supplies the "utf-8" as the charset, which needs to be treated as UTF-8 -- This message was sent by Atlassian Jira (v7.13.8#713008)

5 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5897) Update srcclr.yml to on 1.0.x branch to run -Prelease profile

by Van Halbert (Jira)

[ https://issues.redhat.com/browse/TEIID-5897?page=com.atlassian.jira.plugi... ] Van Halbert resolved TEIID-5897. -------------------------------- Fix Version/s: 13.1 Resolution: Done > Update srcclr.yml to on 1.0.x branch to run -Prelease profile > ------------------------------------------------------------- > > Key: TEIID-5897 > URL: https://issues.redhat.com/browse/TEIID-5897 > Project: Teiid > Issue Type: Quality Risk > Components: Build/Kits > Reporter: Van Halbert > Assignee: Van Halbert > Priority: Blocker > Fix For: 13.1 > > Original Estimate: 8 minutes > Time Spent: 2 hours > Remaining Estimate: 0 minutes > > Update the 1.0.x branch srcclr.yml file so that source clear runs the -Prelease profile and the same dependencies are analyzed that are included when the -Prelease profile is run when the code is released. -- This message was sent by Atlassian Jira (v7.13.8#713008)

5 years, 10 months

1
0
0 / 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues February 2020