April 2020 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIIDSB-170) Automate materialization to JDG

by Ramesh Reddy (Jira)

[ https://issues.redhat.com/browse/TEIIDSB-170?page=com.atlassian.jira.plug... ] Ramesh Reddy updated TEIIDSB-170: --------------------------------- Story Points: 3 (was: 4) > Automate materialization to JDG > ------------------------------- > > Key: TEIIDSB-170 > URL: https://issues.redhat.com/browse/TEIIDSB-170 > Project: Teiid Spring Boot > Issue Type: Enhancement > Components: OpenShift > Reporter: Steven Hawkins > Assignee: Ramesh Reddy > Priority: Major > Fix For: 1.5.0 > > Original Estimate: 1 week > Time Spent: 1 hour > Remaining Estimate: 4 days, 7 hours > > Create an internal materialization replacement needs that is turnkey materialization to JDG (little to no user setup required) > - the operator may create the infinispan cluster if needed > - the status table and internal representation of the materialization target would be setup automatically > For the user this would be as simple marking a view as materialized and then it would be populated in jdg upon deployment. They would not have any concerns with cache naming, status tables, etc. > For simplicity the initial version would make a similar assumption to the current internal logic - it is for only a specific vdb. If the vdb cr is modified, then it's expected that the cache would be recreated. -- This message was sent by Atlassian Jira (v7.13.8#713008)

4 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5882) Default cache name is no longer default

by Ramesh Reddy (Jira)

[ https://issues.redhat.com/browse/TEIID-5882?page=com.atlassian.jira.plugi... ] Ramesh Reddy commented on TEIID-5882: ------------------------------------- So you are asking to just remove from resource adaptor here? Looks everywhere is it is already fixed to handle the "null" cache name. > Default cache name is no longer default > --------------------------------------- > > Key: TEIID-5882 > URL: https://issues.redhat.com/browse/TEIID-5882 > Project: Teiid > Issue Type: Quality Risk > Components: Infinispan > Reporter: Steven Hawkins > Assignee: Ramesh Reddy > Priority: Major > Fix For: 14.0 > > > The infinispan default cache name is no longer default. It can instead be specified in the cache container and obtained by the getCache method that does not take a name. Our resource adapter defaults the value to "default", so that could be removed. -- This message was sent by Atlassian Jira (v7.13.8#713008)

4 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5937) Union All followed by except returns wrong results

by Steven Hawkins (Jira)

[ https://issues.redhat.com/browse/TEIID-5937?focusedWorklogId=12450848&pag... ] Steven Hawkins logged work on TEIID-5937: ----------------------------------------- Author: Steven Hawkins Created on: 17/Apr/20 11:55 AM Start Date: 17/Apr/20 11:55 AM Worklog Time Spent: 3 hours Issue Time Tracking ------------------- Remaining Estimate: 1 hour (was: 4 hours) Time Spent: 3 hours Worklog Id: (was: 12450848) > Union All followed by except returns wrong results > -------------------------------------------------- > > Key: TEIID-5937 > URL: https://issues.redhat.com/browse/TEIID-5937 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 13.1 > Reporter: Dmitrii Pogorelov > Assignee: Steven Hawkins > Priority: Blocker > Fix For: 13.1, 14.0, 13.0.3 > > Original Estimate: 4 hours > Time Spent: 3 hours > Remaining Estimate: 1 hour > > The following queries return wrong results: > {code:sql} > -- <null> though should return 1 > select * from views.test2 except select * from views.test1 > UNION ALL > select * from views.test1 except select * from views.test2 ;; > > -- <null> though should return 1 > (select * from views.test2 except select * from views.test1 > UNION ALL > select * from views.test1) except select * from views.test2 ;; > {code} -- This message was sent by Atlassian Jira (v7.13.8#713008)

4 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5937) Union All followed by except returns wrong results

by Steven Hawkins (Jira)

[ https://issues.redhat.com/browse/TEIID-5937?page=com.atlassian.jira.plugi... ] Steven Hawkins resolved TEIID-5937. ----------------------------------- Fix Version/s: 14.0 13.0.3 13.1 Resolution: Done Added logic to prevent projection conflicts across branches of unions and joins when dealing with projected literals. > Union All followed by except returns wrong results > -------------------------------------------------- > > Key: TEIID-5937 > URL: https://issues.redhat.com/browse/TEIID-5937 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 13.1 > Reporter: Dmitrii Pogorelov > Assignee: Steven Hawkins > Priority: Blocker > Fix For: 14.0, 13.0.3, 13.1 > > Original Estimate: 4 hours > Remaining Estimate: 4 hours > > The following queries return wrong results: > {code:sql} > -- <null> though should return 1 > select * from views.test2 except select * from views.test1 > UNION ALL > select * from views.test1 except select * from views.test2 ;; > > -- <null> though should return 1 > (select * from views.test2 except select * from views.test1 > UNION ALL > select * from views.test1) except select * from views.test2 ;; > {code} -- This message was sent by Atlassian Jira (v7.13.8#713008)

4 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIIDSB-181) Update dependencies in order to build in PNC for the .next release

by Van Halbert (Jira)

[ https://issues.redhat.com/browse/TEIIDSB-181?page=com.atlassian.jira.plug... ] Van Halbert resolved TEIIDSB-181. --------------------------------- Fix Version/s: 1.4.x Resolution: Done > Update dependencies in order to build in PNC for the .next release > ------------------------------------------------------------------- > > Key: TEIIDSB-181 > URL: https://issues.redhat.com/browse/TEIIDSB-181 > Project: Teiid Spring Boot > Issue Type: Quality Risk > Affects Versions: 1.4.0 > Reporter: Van Halbert > Assignee: Van Halbert > Priority: Major > Fix For: 1.4.x > > > In order to build in PNC, certain dependency alignments are required in order to build. -- This message was sent by Atlassian Jira (v7.13.8#713008)

4 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5938) TextTable removes the quoted character, when it matches the delimiter

by Steven Hawkins (Jira)

[ https://issues.redhat.com/browse/TEIID-5938?page=com.atlassian.jira.plugi... ] Steven Hawkins commented on TEIID-5938: --------------------------------------- As I recall it was time consuming for them to work on the original underlying issue. It will unfortunately be pretty far down on their priority list. If there is an underlying bug it could be a while before anyone addresses it. I'll add a follow up on that issue. > TextTable removes the quoted character, when it matches the delimiter > --------------------------------------------------------------------- > > Key: TEIID-5938 > URL: https://issues.redhat.com/browse/TEIID-5938 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 13.1 > Reporter: Dmitrii Pogorelov > Assignee: Steven Hawkins > Priority: Critical > Fix For: 14.0, 13.0.3, 13.1.1 > > Original Estimate: 2 hours > Time Spent: 1 hour, 30 minutes > Remaining Estimate: 30 minutes > > The TextTable removes characters when they are inside a quoted field, but at the same time match the delimiter. The field is not delimited (and that's great), but the character should not be removed from it either. -- This message was sent by Atlassian Jira (v7.13.8#713008)

4 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5938) TextTable removes the quoted character, when it matches the delimiter

by Dmitrii Pogorelov (Jira)

[ https://issues.redhat.com/browse/TEIID-5938?page=com.atlassian.jira.plugi... ] Dmitrii Pogorelov commented on TEIID-5938: ------------------------------------------ [~shawkins] thx a lot for the quick fix. An offtopic: I also created some time ago the WFLY-13144 issue. It's strongly related to Teiid and resource adapters that can be added/removed on the fly. It looks like the issue was assigned to a developer and can be there for ages, I can see no activities on the issue at all. Could you, please, if it's possible, somehow contribute to accelerating the work on this issue? > TextTable removes the quoted character, when it matches the delimiter > --------------------------------------------------------------------- > > Key: TEIID-5938 > URL: https://issues.redhat.com/browse/TEIID-5938 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 13.1 > Reporter: Dmitrii Pogorelov > Assignee: Steven Hawkins > Priority: Critical > Fix For: 14.0, 13.0.3, 13.1.1 > > Original Estimate: 2 hours > Time Spent: 1 hour, 30 minutes > Remaining Estimate: 30 minutes > > The TextTable removes characters when they are inside a quoted field, but at the same time match the delimiter. The field is not delimited (and that's great), but the character should not be removed from it either. -- This message was sent by Atlassian Jira (v7.13.8#713008)

4 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5937) Union All followed by except returns wrong results

by Steven Hawkins (Jira)

[ https://issues.redhat.com/browse/TEIID-5937?page=com.atlassian.jira.plugi... ] Steven Hawkins updated TEIID-5937: ---------------------------------- Original Estimate: 4 hours Remaining Estimate: 4 hours Story Points: 0.5 Sprint: DV Sprint 62 Note that this is an issue with projection optimization due to using an effectively scalar subquery. If you are selecting from regular tables there is no issue. > Union All followed by except returns wrong results > -------------------------------------------------- > > Key: TEIID-5937 > URL: https://issues.redhat.com/browse/TEIID-5937 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 13.1 > Reporter: Dmitrii Pogorelov > Assignee: Steven Hawkins > Priority: Blocker > Original Estimate: 4 hours > Remaining Estimate: 4 hours > > The following queries return wrong results: > {code:sql} > -- <null> though should return 1 > select * from views.test2 except select * from views.test1 > UNION ALL > select * from views.test1 except select * from views.test2 ;; > > -- <null> though should return 1 > (select * from views.test2 except select * from views.test1 > UNION ALL > select * from views.test1) except select * from views.test2 ;; > {code} -- This message was sent by Atlassian Jira (v7.13.8#713008)

4 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5938) TextTable removes the quoted character, when it matches the delimiter

by Steven Hawkins (Jira)

[ https://issues.redhat.com/browse/TEIID-5938?page=com.atlassian.jira.plugi... ] Steven Hawkins updated TEIID-5938: ---------------------------------- Original Estimate: 2 hours Remaining Estimate: 2 hours > TextTable removes the quoted character, when it matches the delimiter > --------------------------------------------------------------------- > > Key: TEIID-5938 > URL: https://issues.redhat.com/browse/TEIID-5938 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 13.1 > Reporter: Dmitrii Pogorelov > Assignee: Steven Hawkins > Priority: Critical > Fix For: 14.0, 13.0.3, 13.1.1 > > Original Estimate: 2 hours > Remaining Estimate: 2 hours > > The TextTable removes characters when they are inside a quoted field, but at the same time match the delimiter. The field is not delimited (and that's great), but the character should not be removed from it either. -- This message was sent by Atlassian Jira (v7.13.8#713008)

4 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5938) TextTable removes the quoted character, when it matches the delimiter

by Steven Hawkins (Jira)

[ https://issues.redhat.com/browse/TEIID-5938?focusedWorklogId=12450846&pag... ] Steven Hawkins logged work on TEIID-5938: ----------------------------------------- Author: Steven Hawkins Created on: 17/Apr/20 8:47 AM Start Date: 17/Apr/20 8:47 AM Worklog Time Spent: 1 hour, 30 minutes Issue Time Tracking ------------------- Remaining Estimate: 30 minutes (was: 2 hours) Time Spent: 1 hour, 30 minutes Worklog Id: (was: 12450846) > TextTable removes the quoted character, when it matches the delimiter > --------------------------------------------------------------------- > > Key: TEIID-5938 > URL: https://issues.redhat.com/browse/TEIID-5938 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 13.1 > Reporter: Dmitrii Pogorelov > Assignee: Steven Hawkins > Priority: Critical > Fix For: 14.0, 13.0.3, 13.1.1 > > Original Estimate: 2 hours > Time Spent: 1 hour, 30 minutes > Remaining Estimate: 30 minutes > > The TextTable removes characters when they are inside a quoted field, but at the same time match the delimiter. The field is not delimited (and that's great), but the character should not be removed from it either. -- This message was sent by Atlassian Jira (v7.13.8#713008)

4 years, 8 months

1
0
0 / 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues April 2020