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