[JBoss JIRA] (TEIID-5648) Hide metadata over odata
by Steven Hawkins (Jira)
[ https://issues.jboss.org/browse/TEIID-5648?page=com.atlassian.jira.plugin... ]
Steven Hawkins updated TEIID-5648:
----------------------------------
Fix Version/s: 12.2
(was: 12.x)
> Hide metadata over odata
> ------------------------
>
> Key: TEIID-5648
> URL: https://issues.jboss.org/browse/TEIID-5648
> Project: Teiid
> Issue Type: Quality Risk
> Components: OData
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Priority: Major
> Fix For: 12.2
>
>
> All schemas, not marked as hidden, will be visible over odata. This includes all schema objects. Via the other access mechanisms permission is now required for visibility - TEIID-5516 and TEIID-2476.
> Alternatively there could also be an option to still expose the metadata by default for non-odata access even if the user is not permissioned.
--
This message was sent by Atlassian Jira
(v7.12.1#712002)
5 years, 3 months
[JBoss JIRA] (TEIID-5688) groupby functionality not working with Teiid
by Steven Hawkins (Jira)
[ https://issues.jboss.org/browse/TEIID-5688?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-5688:
---------------------------------------
I have not heard anything. [~rareddy]? If no release is on the horizon, should we entertain our own local patch?
> groupby functionality not working with Teiid
> --------------------------------------------
>
> Key: TEIID-5688
> URL: https://issues.jboss.org/browse/TEIID-5688
> Project: Teiid
> Issue Type: Bug
> Reporter: Christoph John
> Assignee: Steven Hawkins
> Priority: Major
>
> Hello together,
> I tried to get the distinct values of a certain column in a mysql table and used the following query
> https://morpheus.fritz.box/odata4/svc/my_nutri_diary/Diary?$select=fkIdPr...
> However, it seems the apply=group is ignored from Teiid. I retrieve all records with fkIdProductCode and not just a single one. In the example below the first and last record both have the same fkIdProductCode. I would expect to retrieve just a single result. The result in my example looks as follows:
> {
> @odata.context: "https://morpheus.fritz.box/odata4/svc/my_nutri_diary/$metadata#Diary(idDi...",
> value: [
> {
> @odata.id: "https://morpheus.fritz.box/odata4/svc/my_nutri_diary/Diary(17)",
> idDiaryEntry: 17,
> fkIdProductCode: 17
> },
> {
> @odata.id: "https://morpheus.fritz.box/odata4/svc/my_nutri_diary/Diary(18)",
> idDiaryEntry: 18,
> fkIdProductCode: 38
> },
> {
> @odata.id: "https://morpheus.fritz.box/odata4/svc/my_nutri_diary/Diary(19)",
> idDiaryEntry: 19,
> fkIdProductCode: 482
> },
> {
> @odata.id: "https://morpheus.fritz.box/odata4/svc/my_nutri_diary/Diary(20)",
> idDiaryEntry: 20,
> fkIdProductCode: 1564
> },
> {
> @odata.id: "https://morpheus.fritz.box/odata4/svc/my_nutri_diary/Diary(21)",
> idDiaryEntry: 21,
> fkIdProductCode: 17
> }
> ]
> }
> So as a matter of principle, I would like to get each fkIdProductCode in the Diary table just once and expand its name via a navigationProperty. Is there some other workaround, how I could achieve this?
> Thanks for your help
--
This message was sent by Atlassian Jira
(v7.12.1#712002)
5 years, 3 months
[JBoss JIRA] (TEIIDSB-61) Not able to delete/create entity in
by Steven Hawkins (Jira)
[ https://issues.jboss.org/browse/TEIIDSB-61?page=com.atlassian.jira.plugin... ]
Steven Hawkins moved TEIID-5689 to TEIIDSB-61:
----------------------------------------------
Project: Teiid Spring Boot (was: Teiid)
Key: TEIIDSB-61 (was: TEIID-5689)
> Not able to delete/create entity in
> ------------------------------------
>
> Key: TEIIDSB-61
> URL: https://issues.jboss.org/browse/TEIIDSB-61
> Project: Teiid Spring Boot
> Issue Type: Bug
> Reporter: Jan Šafařík
> Assignee: Steven Hawkins
> Priority: Major
>
> Trying to use the teiid-spring-boot/samples/odata project, I am not able to Create, Update or Delete an entity. Tried on Customer, with Delete I get back code: TEIID30504 with message: "TEIID30504 accounts: 23503 TEIID11013:TEIID11004 Error executing statement(s): [SQL: DELETE FROM "CUSTOMER" WHERE "CUSTOMER"."SSN" = 'CST01002']". With Create (Post) I get code: TEIID30528 with message: "TEIID30528 javax.transaction.SystemException".
--
This message was sent by Atlassian Jira
(v7.12.1#712002)
5 years, 3 months
[JBoss JIRA] (TEIID-5689) Not able to delete/create entity in
by Jan Šafařík (Jira)
Jan Šafařík created TEIID-5689:
----------------------------------
Summary: Not able to delete/create entity in
Key: TEIID-5689
URL: https://issues.jboss.org/browse/TEIID-5689
Project: Teiid
Issue Type: Bug
Reporter: Jan Šafařík
Assignee: Steven Hawkins
Trying to use the teiid-spring-boot/samples/odata project, I am not able to Create, Update or Delete an entity. Tried on Customer, with Delete I get back code: TEIID30504 with message: "TEIID30504 accounts: 23503 TEIID11013:TEIID11004 Error executing statement(s): [SQL: DELETE FROM "CUSTOMER" WHERE "CUSTOMER"."SSN" = 'CST01002']". With Create (Post) I get code: TEIID30528 with message: "TEIID30528 javax.transaction.SystemException".
--
This message was sent by Atlassian Jira
(v7.12.1#712002)
5 years, 3 months
[JBoss JIRA] (TEIID-5683) Push or use limit information before dependent join processing
by Steven Hawkins (Jira)
[ https://issues.jboss.org/browse/TEIID-5683?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-5683.
-----------------------------------
Resolution: Done
Updated rule assign output elements for it to run for a third time as it's needed before rule push limit. Then moved pushed limit to earlier in planning before dependent joins are chosen, but after access nodes have been raised.
> Push or use limit information before dependent join processing
> --------------------------------------------------------------
>
> Key: TEIID-5683
> URL: https://issues.jboss.org/browse/TEIID-5683
> Project: Teiid
> Issue Type: Enhancement
> Components: Query Engine
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Priority: Major
> Fix For: 12.2
>
>
> There appear to be some situations (such as a left outer join from TEIID-5680) where the limit could help direct a dependent join, but isn't considered as rule push limit isn't run until later.
--
This message was sent by Atlassian Jira
(v7.12.1#712002)
5 years, 3 months
[JBoss JIRA] (TEIID-5688) groupby functionality not working with Teiid
by Christoph John (Jira)
[ https://issues.jboss.org/browse/TEIID-5688?page=com.atlassian.jira.plugin... ]
Christoph John commented on TEIID-5688:
---------------------------------------
Sorry,
have not seen the issue. Are there any news regarding the olingo 4.6 release? I remember that Ramesh was going to ask for one.
Best regards,
Christoph
> groupby functionality not working with Teiid
> --------------------------------------------
>
> Key: TEIID-5688
> URL: https://issues.jboss.org/browse/TEIID-5688
> Project: Teiid
> Issue Type: Bug
> Reporter: Christoph John
> Assignee: Steven Hawkins
> Priority: Major
>
> Hello together,
> I tried to get the distinct values of a certain column in a mysql table and used the following query
> https://morpheus.fritz.box/odata4/svc/my_nutri_diary/Diary?$select=fkIdPr...
> However, it seems the apply=group is ignored from Teiid. I retrieve all records with fkIdProductCode and not just a single one. In the example below the first and last record both have the same fkIdProductCode. I would expect to retrieve just a single result. The result in my example looks as follows:
> {
> @odata.context: "https://morpheus.fritz.box/odata4/svc/my_nutri_diary/$metadata#Diary(idDi...",
> value: [
> {
> @odata.id: "https://morpheus.fritz.box/odata4/svc/my_nutri_diary/Diary(17)",
> idDiaryEntry: 17,
> fkIdProductCode: 17
> },
> {
> @odata.id: "https://morpheus.fritz.box/odata4/svc/my_nutri_diary/Diary(18)",
> idDiaryEntry: 18,
> fkIdProductCode: 38
> },
> {
> @odata.id: "https://morpheus.fritz.box/odata4/svc/my_nutri_diary/Diary(19)",
> idDiaryEntry: 19,
> fkIdProductCode: 482
> },
> {
> @odata.id: "https://morpheus.fritz.box/odata4/svc/my_nutri_diary/Diary(20)",
> idDiaryEntry: 20,
> fkIdProductCode: 1564
> },
> {
> @odata.id: "https://morpheus.fritz.box/odata4/svc/my_nutri_diary/Diary(21)",
> idDiaryEntry: 21,
> fkIdProductCode: 17
> }
> ]
> }
> So as a matter of principle, I would like to get each fkIdProductCode in the Diary table just once and expand its name via a navigationProperty. Is there some other workaround, how I could achieve this?
> Thanks for your help
--
This message was sent by Atlassian Jira
(v7.12.1#712002)
5 years, 3 months
[JBoss JIRA] (TEIID-5688) groupby functionality not working with Teiid
by Steven Hawkins (Jira)
[ https://issues.jboss.org/browse/TEIID-5688?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-5688.
-----------------------------------
Resolution: Duplicate Issue
See TEIID-3522
> groupby functionality not working with Teiid
> --------------------------------------------
>
> Key: TEIID-5688
> URL: https://issues.jboss.org/browse/TEIID-5688
> Project: Teiid
> Issue Type: Bug
> Reporter: Christoph John
> Assignee: Steven Hawkins
> Priority: Major
>
> Hello together,
> I tried to get the distinct values of a certain column in a mysql table and used the following query
> https://morpheus.fritz.box/odata4/svc/my_nutri_diary/Diary?$select=fkIdPr...
> However, it seems the apply=group is ignored from Teiid. I retrieve all records with fkIdProductCode and not just a single one. In the example below the first and last record both have the same fkIdProductCode. I would expect to retrieve just a single result. The result in my example looks as follows:
> {
> @odata.context: "https://morpheus.fritz.box/odata4/svc/my_nutri_diary/$metadata#Diary(idDi...",
> value: [
> {
> @odata.id: "https://morpheus.fritz.box/odata4/svc/my_nutri_diary/Diary(17)",
> idDiaryEntry: 17,
> fkIdProductCode: 17
> },
> {
> @odata.id: "https://morpheus.fritz.box/odata4/svc/my_nutri_diary/Diary(18)",
> idDiaryEntry: 18,
> fkIdProductCode: 38
> },
> {
> @odata.id: "https://morpheus.fritz.box/odata4/svc/my_nutri_diary/Diary(19)",
> idDiaryEntry: 19,
> fkIdProductCode: 482
> },
> {
> @odata.id: "https://morpheus.fritz.box/odata4/svc/my_nutri_diary/Diary(20)",
> idDiaryEntry: 20,
> fkIdProductCode: 1564
> },
> {
> @odata.id: "https://morpheus.fritz.box/odata4/svc/my_nutri_diary/Diary(21)",
> idDiaryEntry: 21,
> fkIdProductCode: 17
> }
> ]
> }
> So as a matter of principle, I would like to get each fkIdProductCode in the Diary table just once and expand its name via a navigationProperty. Is there some other workaround, how I could achieve this?
> Thanks for your help
--
This message was sent by Atlassian Jira
(v7.12.1#712002)
5 years, 3 months
[JBoss JIRA] (TEIID-5688) groupby functionality not working with Teiid
by Christoph John (Jira)
[ https://issues.jboss.org/browse/TEIID-5688?page=com.atlassian.jira.plugin... ]
Christoph John updated TEIID-5688:
----------------------------------
Description:
Hello together,
I tried to get the distinct values of a certain column in a mysql table and used the following query
https://morpheus.fritz.box/odata4/svc/my_nutri_diary/Diary?$select=fkIdPr...
However, it seems the apply=group is ignored from Teiid. I retrieve all records with fkIdProductCode and not just a single one. In the example below the first and last record both have the same fkIdProductCode. I would expect to retrieve just a single result. The result in my example looks as follows:
{
@odata.context: "https://morpheus.fritz.box/odata4/svc/my_nutri_diary/$metadata#Diary(idDi...",
value: [
{
@odata.id: "https://morpheus.fritz.box/odata4/svc/my_nutri_diary/Diary(17)",
idDiaryEntry: 17,
fkIdProductCode: 17
},
{
@odata.id: "https://morpheus.fritz.box/odata4/svc/my_nutri_diary/Diary(18)",
idDiaryEntry: 18,
fkIdProductCode: 38
},
{
@odata.id: "https://morpheus.fritz.box/odata4/svc/my_nutri_diary/Diary(19)",
idDiaryEntry: 19,
fkIdProductCode: 482
},
{
@odata.id: "https://morpheus.fritz.box/odata4/svc/my_nutri_diary/Diary(20)",
idDiaryEntry: 20,
fkIdProductCode: 1564
},
{
@odata.id: "https://morpheus.fritz.box/odata4/svc/my_nutri_diary/Diary(21)",
idDiaryEntry: 21,
fkIdProductCode: 17
}
]
}
So as a matter of principle, I would like to get each fkIdProductCode in the Diary table just once and expand its name via a navigationProperty. Is there some other workaround, how I could achieve this?
Thanks for your help
was:
Hello together,
I tried to get the distinct values of a certain column in a mysql table and used the following query
https://morpheus.fritz.box/odata4/svc/my_nutri_diary/Diary?$select=fkIdPr...
However, it seems the apply=group is ignored from Teiid. I retrieve all records with fkIdProductCode and not just a single one. In the example below the first and last record both have the same fkIdProductCode. I would expect to retrieve just a single result. The result in my example looks as follows:
{
@odata.context: "https://morpheus.fritz.box/odata4/svc/my_nutri_diary/$metadata#Diary(idDi...",
value: [
{
@odata.id: "https://morpheus.fritz.box/odata4/svc/my_nutri_diary/Diary(17)",
idDiaryEntry: 17,
fkIdProductCode: 17
},
{
@odata.id: "https://morpheus.fritz.box/odata4/svc/my_nutri_diary/Diary(18)",
idDiaryEntry: 18,
fkIdProductCode: 38
},
{
@odata.id: "https://morpheus.fritz.box/odata4/svc/my_nutri_diary/Diary(19)",
idDiaryEntry: 19,
fkIdProductCode: 482
},
{
@odata.id: "https://morpheus.fritz.box/odata4/svc/my_nutri_diary/Diary(20)",
idDiaryEntry: 20,
fkIdProductCode: 1564
},
{
@odata.id: "https://morpheus.fritz.box/odata4/svc/my_nutri_diary/Diary(21)",
idDiaryEntry: 21,
fkIdProductCode: 17
}
]
}
So as a matter of principle, I would like to get each fkIdProductCode in the Diary table just once and expand its name via a navigationProperty. Is there some other workaround, how I could achieve this?
Thans for your help
> groupby functionality not working with Teiid
> --------------------------------------------
>
> Key: TEIID-5688
> URL: https://issues.jboss.org/browse/TEIID-5688
> Project: Teiid
> Issue Type: Bug
> Reporter: Christoph John
> Assignee: Steven Hawkins
> Priority: Major
>
> Hello together,
> I tried to get the distinct values of a certain column in a mysql table and used the following query
> https://morpheus.fritz.box/odata4/svc/my_nutri_diary/Diary?$select=fkIdPr...
> However, it seems the apply=group is ignored from Teiid. I retrieve all records with fkIdProductCode and not just a single one. In the example below the first and last record both have the same fkIdProductCode. I would expect to retrieve just a single result. The result in my example looks as follows:
> {
> @odata.context: "https://morpheus.fritz.box/odata4/svc/my_nutri_diary/$metadata#Diary(idDi...",
> value: [
> {
> @odata.id: "https://morpheus.fritz.box/odata4/svc/my_nutri_diary/Diary(17)",
> idDiaryEntry: 17,
> fkIdProductCode: 17
> },
> {
> @odata.id: "https://morpheus.fritz.box/odata4/svc/my_nutri_diary/Diary(18)",
> idDiaryEntry: 18,
> fkIdProductCode: 38
> },
> {
> @odata.id: "https://morpheus.fritz.box/odata4/svc/my_nutri_diary/Diary(19)",
> idDiaryEntry: 19,
> fkIdProductCode: 482
> },
> {
> @odata.id: "https://morpheus.fritz.box/odata4/svc/my_nutri_diary/Diary(20)",
> idDiaryEntry: 20,
> fkIdProductCode: 1564
> },
> {
> @odata.id: "https://morpheus.fritz.box/odata4/svc/my_nutri_diary/Diary(21)",
> idDiaryEntry: 21,
> fkIdProductCode: 17
> }
> ]
> }
> So as a matter of principle, I would like to get each fkIdProductCode in the Diary table just once and expand its name via a navigationProperty. Is there some other workaround, how I could achieve this?
> Thanks for your help
--
This message was sent by Atlassian Jira
(v7.12.1#712002)
5 years, 3 months
[JBoss JIRA] (TEIID-5688) groupby functionality not working with Teiid
by Christoph John (Jira)
[ https://issues.jboss.org/browse/TEIID-5688?page=com.atlassian.jira.plugin... ]
Christoph John updated TEIID-5688:
----------------------------------
Description:
Hello together,
I tried to get the distinct values of a certain column in a mysql table and used the following query
https://morpheus.fritz.box/odata4/svc/my_nutri_diary/Diary?$select=fkIdPr...
However, it seems the apply=group is ignored from Teiid. I retrieve all records with fkIdProductCode and not just a single one. In the example below the first and last record both have the same fkIdProductCode. I would expect to retrieve just a single result. The result in my example looks as follows:
{
@odata.context: "https://morpheus.fritz.box/odata4/svc/my_nutri_diary/$metadata#Diary(idDi...",
value: [
{
@odata.id: "https://morpheus.fritz.box/odata4/svc/my_nutri_diary/Diary(17)",
idDiaryEntry: 17,
fkIdProductCode: 17
},
{
@odata.id: "https://morpheus.fritz.box/odata4/svc/my_nutri_diary/Diary(18)",
idDiaryEntry: 18,
fkIdProductCode: 38
},
{
@odata.id: "https://morpheus.fritz.box/odata4/svc/my_nutri_diary/Diary(19)",
idDiaryEntry: 19,
fkIdProductCode: 482
},
{
@odata.id: "https://morpheus.fritz.box/odata4/svc/my_nutri_diary/Diary(20)",
idDiaryEntry: 20,
fkIdProductCode: 1564
},
{
@odata.id: "https://morpheus.fritz.box/odata4/svc/my_nutri_diary/Diary(21)",
idDiaryEntry: 21,
fkIdProductCode: 17
}
]
}
So as a matter of principle, I would like to get each fkIdProductCode in the Diary table just once and expand its name via a navigationProperty. Is there some other workaround, how I could achieve this?
Thans for your help
was:
Hello together,
I tried to get the distinct values of a certain column in a mysql table and used the following query
https://morpheus.fritz.box/odata4/svc/my_nutri_diary/Diary?$select=fkIdPr...
However, it seems the apply=group is ignored from Teiid. I retrieve all records with fkIdProductCode and not just a single one. In the example below the first and last record both have the same fkIdProductCode. I would expect to retrieve just a single result. The result in my example looks as follows:
{
@odata.context: "https://morpheus.fritz.box/odata4/svc/my_nutri_diary/$metadata#Diary(idDi...",
value: [
{
@odata.id: "https://morpheus.fritz.box/odata4/svc/my_nutri_diary/Diary(17)",
idDiaryEntry: 17,
fkIdProductCode: 17
},
{
@odata.id: "https://morpheus.fritz.box/odata4/svc/my_nutri_diary/Diary(18)",
idDiaryEntry: 18,
fkIdProductCode: 38
},
{
@odata.id: "https://morpheus.fritz.box/odata4/svc/my_nutri_diary/Diary(19)",
idDiaryEntry: 19,
fkIdProductCode: 482
},
{
@odata.id: "https://morpheus.fritz.box/odata4/svc/my_nutri_diary/Diary(20)",
idDiaryEntry: 20,
fkIdProductCode: 1564
},
{
@odata.id: "https://morpheus.fritz.box/odata4/svc/my_nutri_diary/Diary(21)",
idDiaryEntry: 21,
fkIdProductCode: 17
}
]
}
> groupby functionality not working with Teiid
> --------------------------------------------
>
> Key: TEIID-5688
> URL: https://issues.jboss.org/browse/TEIID-5688
> Project: Teiid
> Issue Type: Bug
> Reporter: Christoph John
> Assignee: Steven Hawkins
> Priority: Major
>
> Hello together,
> I tried to get the distinct values of a certain column in a mysql table and used the following query
> https://morpheus.fritz.box/odata4/svc/my_nutri_diary/Diary?$select=fkIdPr...
> However, it seems the apply=group is ignored from Teiid. I retrieve all records with fkIdProductCode and not just a single one. In the example below the first and last record both have the same fkIdProductCode. I would expect to retrieve just a single result. The result in my example looks as follows:
> {
> @odata.context: "https://morpheus.fritz.box/odata4/svc/my_nutri_diary/$metadata#Diary(idDi...",
> value: [
> {
> @odata.id: "https://morpheus.fritz.box/odata4/svc/my_nutri_diary/Diary(17)",
> idDiaryEntry: 17,
> fkIdProductCode: 17
> },
> {
> @odata.id: "https://morpheus.fritz.box/odata4/svc/my_nutri_diary/Diary(18)",
> idDiaryEntry: 18,
> fkIdProductCode: 38
> },
> {
> @odata.id: "https://morpheus.fritz.box/odata4/svc/my_nutri_diary/Diary(19)",
> idDiaryEntry: 19,
> fkIdProductCode: 482
> },
> {
> @odata.id: "https://morpheus.fritz.box/odata4/svc/my_nutri_diary/Diary(20)",
> idDiaryEntry: 20,
> fkIdProductCode: 1564
> },
> {
> @odata.id: "https://morpheus.fritz.box/odata4/svc/my_nutri_diary/Diary(21)",
> idDiaryEntry: 21,
> fkIdProductCode: 17
> }
> ]
> }
> So as a matter of principle, I would like to get each fkIdProductCode in the Diary table just once and expand its name via a navigationProperty. Is there some other workaround, how I could achieve this?
> Thans for your help
--
This message was sent by Atlassian Jira
(v7.12.1#712002)
5 years, 3 months