[JBoss JIRA] (TEIIDSB-107) Update Teiid version to 12.2.1
by Ramesh Reddy (Jira)
Ramesh Reddy created TEIIDSB-107:
------------------------------------
Summary: Update Teiid version to 12.2.1
Key: TEIIDSB-107
URL: https://issues.jboss.org/browse/TEIIDSB-107
Project: Teiid Spring Boot
Issue Type: Task
Components: core
Affects Versions: 1.1.0
Reporter: Ramesh Reddy
Assignee: Ramesh Reddy
Fix For: 1.2.0, 7.4-1.1.1
Update the Teiid version to 12.2.1
--
This message was sent by Atlassian Jira
(v7.12.1#712002)
6 years, 9 months
[JBoss JIRA] (TEIIDSB-105) Modelling a Json entitty with array of "details"
by Ramesh Reddy (Jira)
[ https://issues.jboss.org/browse/TEIIDSB-105?page=com.atlassian.jira.plugi... ]
Ramesh Reddy resolved TEIIDSB-105.
----------------------------------
Resolution: Done
> Modelling a Json entitty with array of "details"
> ------------------------------------------------
>
> Key: TEIIDSB-105
> URL: https://issues.jboss.org/browse/TEIIDSB-105
> Project: Teiid Spring Boot
> Issue Type: Bug
> Components: JPA
> Reporter: Ramesh Reddy
> Assignee: Ramesh Reddy
> Priority: Major
> Fix For: 1.2.0
>
>
> When using the @JsonTable the construct only supports reading the array type of same data types, with mixed type it does not work. For ex:
> {code}
> [1, 1, 3]
> {code}
> works, but
> {code}
> [1, "two", 3.0]
> {code}
> does not work. If the user chooses to read it as a string array converting the values to match Teiid semantics it is not possible. However, when it is created as
> {code}
> { id: 1, desc: "two", weight: 3.0}
> {code}
> can be read an entity. The array form could also be modeled as an entity with single parameter as `string[]`
--
This message was sent by Atlassian Jira
(v7.12.1#712002)
6 years, 9 months
[JBoss JIRA] (TEIIDSB-105) Modelling a Json entitty with array of "details"
by Ramesh Reddy (Jira)
[ https://issues.jboss.org/browse/TEIIDSB-105?page=com.atlassian.jira.plugi... ]
Ramesh Reddy commented on TEIIDSB-105:
--------------------------------------
In general none of the array based fragments other than simple arrays were working earlier due to an issue with code. That has been fixed now, when the entity is used with @OneToMany from Parent entity and @ManyToOne from child entity, if you define the @Id as the join key itself (as the json will not have id duplicated in child fragments as in relational tables) then data is read correctly into respective entities. For a complete example see https://github.com/teiid/teiid-spring-boot/tree/master/samples/json
> Modelling a Json entitty with array of "details"
> ------------------------------------------------
>
> Key: TEIIDSB-105
> URL: https://issues.jboss.org/browse/TEIIDSB-105
> Project: Teiid Spring Boot
> Issue Type: Bug
> Components: JPA
> Reporter: Ramesh Reddy
> Assignee: Ramesh Reddy
> Priority: Major
> Fix For: 1.2.0
>
>
> When using the @JsonTable the construct only supports reading the array type of same data types, with mixed type it does not work. For ex:
> {code}
> [1, 1, 3]
> {code}
> works, but
> {code}
> [1, "two", 3.0]
> {code}
> does not work. If the user chooses to read it as a string array converting the values to match Teiid semantics it is not possible. However, when it is created as
> {code}
> { id: 1, desc: "two", weight: 3.0}
> {code}
> can be read an entity. The array form could also be modeled as an entity with single parameter as `string[]`
--
This message was sent by Atlassian Jira
(v7.12.1#712002)
6 years, 9 months
[JBoss JIRA] (TEIIDSB-105) Modelling a Json entitty with array of "details"
by Ramesh Reddy (Jira)
[ https://issues.jboss.org/browse/TEIIDSB-105?page=com.atlassian.jira.plugi... ]
Ramesh Reddy updated TEIIDSB-105:
---------------------------------
Issue Type: Bug (was: Enhancement)
> Modelling a Json entitty with array of "details"
> ------------------------------------------------
>
> Key: TEIIDSB-105
> URL: https://issues.jboss.org/browse/TEIIDSB-105
> Project: Teiid Spring Boot
> Issue Type: Bug
> Components: JPA
> Reporter: Ramesh Reddy
> Assignee: Ramesh Reddy
> Priority: Major
> Fix For: 1.2.0
>
>
> When using the @JsonTable the construct only supports reading the array type of same data types, with mixed type it does not work. For ex:
> {code}
> [1, 1, 3]
> {code}
> works, but
> {code}
> [1, "two", 3.0]
> {code}
> does not work. If the user chooses to read it as a string array converting the values to match Teiid semantics it is not possible. However, when it is created as
> {code}
> { id: 1, desc: "two", weight: 3.0}
> {code}
> can be read an entity. The array form could also be modeled as an entity with single parameter as `string[]`
--
This message was sent by Atlassian Jira
(v7.12.1#712002)
6 years, 9 months
[JBoss JIRA] (TEIIDSB-105) Modelling a Json entitty with array of "details"
by Ramesh Reddy (Jira)
[ https://issues.jboss.org/browse/TEIIDSB-105?page=com.atlassian.jira.plugi... ]
Ramesh Reddy updated TEIIDSB-105:
---------------------------------
Fix Version/s: 1.2.0
> Modelling a Json entitty with array of "details"
> ------------------------------------------------
>
> Key: TEIIDSB-105
> URL: https://issues.jboss.org/browse/TEIIDSB-105
> Project: Teiid Spring Boot
> Issue Type: Bug
> Components: JPA
> Reporter: Ramesh Reddy
> Assignee: Ramesh Reddy
> Priority: Major
> Fix For: 1.2.0
>
>
> When using the @JsonTable the construct only supports reading the array type of same data types, with mixed type it does not work. For ex:
> {code}
> [1, 1, 3]
> {code}
> works, but
> {code}
> [1, "two", 3.0]
> {code}
> does not work. If the user chooses to read it as a string array converting the values to match Teiid semantics it is not possible. However, when it is created as
> {code}
> { id: 1, desc: "two", weight: 3.0}
> {code}
> can be read an entity. The array form could also be modeled as an entity with single parameter as `string[]`
--
This message was sent by Atlassian Jira
(v7.12.1#712002)
6 years, 9 months
[JBoss JIRA] (TEIID-5765) Criteria Pushdown is not working on FULL OUTER JOIN
by Dmitrii Pogorelov (Jira)
[ https://issues.jboss.org/browse/TEIID-5765?page=com.atlassian.jira.plugin... ]
Dmitrii Pogorelov commented on TEIID-5765:
------------------------------------------
[~shawkins] thx a lot for the quick fix, I've already checked these changes locally and it worked. Thx again!
> Criteria Pushdown is not working on FULL OUTER JOIN
> ---------------------------------------------------
>
> Key: TEIID-5765
> URL: https://issues.jboss.org/browse/TEIID-5765
> Project: Teiid
> Issue Type: Bug
> 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: Blocker
> Fix For: 12.3, 12.1.2, 12.2.1
>
>
> Criteria Pushdown is not working on FULL OUTER JOIN (according to query plan criteria is not pushed down at all, it's in criteria of LEFT OUTER JOIN node):
> {code:noformat}
> ----------------------------------------------------------------------------
> OPTIMIZATION COMPLETE:
> PROCESSOR PLAN:
> ProjectNode(0) output=[1] [1]
> SelectNode(1) output=[a.a] a.a = 1
> JoinNode(2) [MERGE JOIN (ALREADY_SORTED/ALREADY_SORTED)] [LEFT OUTER JOIN] criteria=[a.a=b.b] output=[a.a]
> AccessNode(3) output=[a.a] SELECT g_0.a AS c_0 FROM test.test_a AS g_0 ORDER BY c_0
> AccessNode(4) output=[b.b] SELECT g_0.b AS c_0 FROM dwh_my.test_a AS g_0 ORDER BY c_0
> {code}
--
This message was sent by Atlassian Jira
(v7.12.1#712002)
6 years, 9 months