June 2020 - teiid-issues - Jboss List Archives

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

by Steven Hawkins (Jira)

[ https://issues.redhat.com/browse/TEIID-5937?focusedWorklogId=12451396&pag... ] Steven Hawkins logged work on TEIID-5937: ----------------------------------------- Author: Steven Hawkins Created on: 09/Jun/20 6:25 PM Start Date: 09/Jun/20 6:25 PM Worklog Time Spent: 1 hour, 30 minutes Issue Time Tracking ------------------- Remaining Estimate: 0 minutes (was: 1 hour) Time Spent: 4 hours, 30 minutes (was: 3 hours) Worklog Id: (was: 12451396) > 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: 15.0, 13.1.2, 14.0.1 > > Original Estimate: 4 hours > Time Spent: 4 hours, 30 minutes > Remaining Estimate: 0 minutes > > 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, 6 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. ----------------------------------- Resolution: Done Updated the logic to not use the output columns, but instead look directly at the projected columns. > 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: 15.0, 13.1.2, 14.0.1 > > 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, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIIDSB-197) Add a module for each external source

by Ramesh Reddy (Jira)

[ https://issues.redhat.com/browse/TEIIDSB-197?page=com.atlassian.jira.plug... ] Ramesh Reddy updated TEIIDSB-197: --------------------------------- Original Estimate: 3 days Sprint: DV Sprint 65 > Add a module for each external source > ------------------------------------- > > Key: TEIIDSB-197 > URL: https://issues.redhat.com/browse/TEIIDSB-197 > Project: Teiid Spring Boot > Issue Type: Enhancement > Reporter: Steven Hawkins > Assignee: Ramesh Reddy > Priority: Major > Original Estimate: 3 days > Time Spent: 3 days > Remaining Estimate: 0 minutes > > To simplify the logic in the operator each external source should be represented by a maven artifact - org.teiid:spring-data-x. Any dependency management would be handled in that module and not in the operator - to remove the need for a config file containing driver versions. Additionally property handling should be moved into Teiid Spring Boot such that the operator does not need to know what property prefix is expected. -- This message was sent by Atlassian Jira (v7.13.8#713008)

4 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIIDSB-197) Add a module for each external source

by Ramesh Reddy (Jira)

[ https://issues.redhat.com/browse/TEIIDSB-197?focusedWorklogId=12451395&pa... ] Ramesh Reddy logged work on TEIIDSB-197: ---------------------------------------- Author: Ramesh Reddy Created on: 09/Jun/20 3:25 PM Start Date: 09/Jun/20 3:25 PM Worklog Time Spent: 3 days Issue Time Tracking ------------------- Remaining Estimate: 0 minutes Time Spent: 3 days Worklog Id: (was: 12451395) > Add a module for each external source > ------------------------------------- > > Key: TEIIDSB-197 > URL: https://issues.redhat.com/browse/TEIIDSB-197 > Project: Teiid Spring Boot > Issue Type: Enhancement > Reporter: Steven Hawkins > Assignee: Ramesh Reddy > Priority: Major > Time Spent: 3 days > Remaining Estimate: 0 minutes > > To simplify the logic in the operator each external source should be represented by a maven artifact - org.teiid:spring-data-x. Any dependency management would be handled in that module and not in the operator - to remove the need for a config file containing driver versions. Additionally property handling should be moved into Teiid Spring Boot such that the operator does not need to know what property prefix is expected. -- This message was sent by Atlassian Jira (v7.13.8#713008)

4 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIIDSB-197) Add a module for each external source

by Ramesh Reddy (Jira)

[ https://issues.redhat.com/browse/TEIIDSB-197?page=com.atlassian.jira.plug... ] Work on TEIIDSB-197 started by Ramesh Reddy. -------------------------------------------- > Add a module for each external source > ------------------------------------- > > Key: TEIIDSB-197 > URL: https://issues.redhat.com/browse/TEIIDSB-197 > Project: Teiid Spring Boot > Issue Type: Enhancement > Reporter: Steven Hawkins > Assignee: Ramesh Reddy > Priority: Major > > To simplify the logic in the operator each external source should be represented by a maven artifact - org.teiid:spring-data-x. Any dependency management would be handled in that module and not in the operator - to remove the need for a config file containing driver versions. Additionally property handling should be moved into Teiid Spring Boot such that the operator does not need to know what property prefix is expected. -- This message was sent by Atlassian Jira (v7.13.8#713008)

4 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5968) enabled=true flag not visible in xa-datasource

by Manoj Majumdar (Jira)

Manoj Majumdar created TEIID-5968: ------------------------------------- Summary: enabled=true flag not visible in xa-datasource Key: TEIID-5968 URL: https://issues.redhat.com/browse/TEIID-5968 Project: Teiid Issue Type: Bug Components: AdminApi Affects Versions: 11.1.2 Reporter: Manoj Majumdar Assignee: Steven Hawkins While creating a XA-Datasource using admin Api, enabled="true" paramter is not set and is not visible in standalone-teiid.xml, have to add it manually. Because of this flag not set, connection pooling is not working and teiid is creating more connections than max-pool-size mentioned -- This message was sent by Atlassian Jira (v7.13.8#713008)

4 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIIDSB-209) NPE using salesforce connection

by Steven Hawkins (Jira)

Steven Hawkins created TEIIDSB-209: -------------------------------------- Summary: NPE using salesforce connection Key: TEIIDSB-209 URL: https://issues.redhat.com/browse/TEIIDSB-209 Project: Teiid Spring Boot Issue Type: Bug Components: datasource Reporter: Steven Hawkins Fix For: 1.6.0 The config is not being set appropriately and results in an npe. This is due to TEIIDSB-184 -- This message was sent by Atlassian Jira (v7.13.8#713008)

4 years, 6 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: ---------------------------------- Fix Version/s: 13.1.2 14.0.1 15.0 (was: 13.1) (was: 14.0) (was: 13.0.3) > 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: 15.0, 13.1.2, 14.0.1 > > 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, 6 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 reopened TEIID-5937: ----------------------------------- > 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, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIIDSB-208) Use the same google spreadsheet logic as teiid

by Steven Hawkins (Jira)

Steven Hawkins created TEIIDSB-208: -------------------------------------- Summary: Use the same google spreadsheet logic as teiid Key: TEIIDSB-208 URL: https://issues.redhat.com/browse/TEIIDSB-208 Project: Teiid Spring Boot Issue Type: Quality Risk Components: datasource Reporter: Steven Hawkins Fix For: 1.6.0 With a refinement to support multiple spreadsheets we should pull this logic forward by sharing the implementation. -- This message was sent by Atlassian Jira (v7.13.8#713008)

4 years, 6 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues June 2020