December 2019 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIIDSB-146) Master branch fails to build due to expected results are have been reordered

by Van Halbert (Jira)

[ https://issues.jboss.org/browse/TEIIDSB-146?page=com.atlassian.jira.plugi... ] Work on TEIIDSB-146 stopped by Van Halbert. ------------------------------------------- > Master branch fails to build due to expected results are have been reordered > ---------------------------------------------------------------------------- > > Key: TEIIDSB-146 > URL: https://issues.jboss.org/browse/TEIIDSB-146 > Project: Teiid Spring Boot > Issue Type: Bug > Components: core > Affects Versions: 1.3.0 > Reporter: Van Halbert > Assignee: Van Halbert > Priority: Major > Fix For: 1.3.0 > > > Building master branch produced different expected results, which appear to be because schema info order has been changed. -- This message was sent by Atlassian Jira (v7.13.8#713008)

5 years

1
0
0 / 0

[JBoss JIRA] (TEIIDSB-146) Master branch fails to build due to expected results are have been reordered

by Van Halbert (Jira)

Van Halbert created TEIIDSB-146: ----------------------------------- Summary: Master branch fails to build due to expected results are have been reordered Key: TEIIDSB-146 URL: https://issues.jboss.org/browse/TEIIDSB-146 Project: Teiid Spring Boot Issue Type: Bug Components: core Affects Versions: 1.3.0 Reporter: Van Halbert Assignee: Van Halbert Building master branch produced different expected results, which appear to be because schema info order has been changed. -- This message was sent by Atlassian Jira (v7.13.8#713008)

5 years

1
0
0 / 0

[JBoss JIRA] (TEIIDSB-146) Master branch fails to build due to expected results are have been reordered

by Van Halbert (Jira)

[ https://issues.jboss.org/browse/TEIIDSB-146?page=com.atlassian.jira.plugi... ] Van Halbert updated TEIIDSB-146: -------------------------------- Fix Version/s: 1.3.0 > Master branch fails to build due to expected results are have been reordered > ---------------------------------------------------------------------------- > > Key: TEIIDSB-146 > URL: https://issues.jboss.org/browse/TEIIDSB-146 > Project: Teiid Spring Boot > Issue Type: Bug > Components: core > Affects Versions: 1.3.0 > Reporter: Van Halbert > Assignee: Van Halbert > Priority: Major > Fix For: 1.3.0 > > > Building master branch produced different expected results, which appear to be because schema info order has been changed. -- This message was sent by Atlassian Jira (v7.13.8#713008)

5 years

1
0
0 / 0

[JBoss JIRA] (TEIIDSB-146) Master branch fails to build due to expected results are have been reordered

by Van Halbert (Jira)

[ https://issues.jboss.org/browse/TEIIDSB-146?page=com.atlassian.jira.plugi... ] Work on TEIIDSB-146 started by Van Halbert. ------------------------------------------- > Master branch fails to build due to expected results are have been reordered > ---------------------------------------------------------------------------- > > Key: TEIIDSB-146 > URL: https://issues.jboss.org/browse/TEIIDSB-146 > Project: Teiid Spring Boot > Issue Type: Bug > Components: core > Affects Versions: 1.3.0 > Reporter: Van Halbert > Assignee: Van Halbert > Priority: Major > Fix For: 1.3.0 > > > Building master branch produced different expected results, which appear to be because schema info order has been changed. -- This message was sent by Atlassian Jira (v7.13.8#713008)

5 years

1
0
0 / 0

[JBoss JIRA] (TEIIDSB-145) Move the Spring Boot version 2.1.6.RELEASE to match for Syndesis

by Van Halbert (Jira)

[ https://issues.jboss.org/browse/TEIIDSB-145?page=com.atlassian.jira.plugi... ] Van Halbert updated TEIIDSB-145: -------------------------------- Git Pull Request: https://github.com/syndesisio/syndesis/pull/7289 [PR|http://example.com] aligns DV with syndesis parents setting of 2.1.6.RELEASE of spring-boot. > Move the Spring Boot version 2.1.6.RELEASE to match for Syndesis > ---------------------------------------------------------------- > > Key: TEIIDSB-145 > URL: https://issues.jboss.org/browse/TEIIDSB-145 > Project: Teiid Spring Boot > Issue Type: Task > Components: core > Reporter: Ramesh Reddy > Assignee: Van Halbert > Priority: Major > Fix For: 1.3.0 > > Original Estimate: 4 hours > Remaining Estimate: 4 hours > > To match the version with Syndesis, move the Spring Boot to 2.1.6.RELEASE -- This message was sent by Atlassian Jira (v7.13.8#713008)

5 years

1
0
0 / 0

[JBoss JIRA] (TEIID-5751) Please add optimization support for foreign keys in materialized tables

by Steven Hawkins (Jira)

[ https://issues.jboss.org/browse/TEIID-5751?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-5751: ---------------------------------- Fix Version/s: 13.1 (was: 13.0) > Please add optimization support for foreign keys in materialized tables > ----------------------------------------------------------------------- > > Key: TEIID-5751 > URL: https://issues.jboss.org/browse/TEIID-5751 > Project: Teiid > Issue Type: Enhancement > Components: Query Engine > Affects Versions: 12.2 > Reporter: Christoph John > Assignee: Steven Hawkins > Priority: Minor > Fix For: 13.1 > > > The issues came up in the following discussion > https://developer.jboss.org/message/989502#989502 > > 1a) Are the constraints (indexes, foreign keys) now used to optimize queries in materialized tables or not? > > Pk, Unique Key, and Indexes on the view will result in the creation of an index on the materialization target table and are fully utilized in planning decisions. Things are a little more complicated with foreign keys. {color:red}Currently they are not propagated onto the generated materialization target table metadata, so they are only considered in pre-planner activities, such as rewrite, before the view reference is replaced with the materialization target - but there aren't meaningful optimizations being made at that time based upon foreign key. There are couple of narrow situations where that information would be useful{color}, so it probably should be added. -- This message was sent by Atlassian Jira (v7.13.8#713008)

5 years

1
0
0 / 0

[JBoss JIRA] (TEIID-5798) Mixed PERMISSION GRANTS

by Steven Hawkins (Jira)

[ https://issues.jboss.org/browse/TEIID-5798?focusedWorklogId=12448196&page... ] Steven Hawkins logged work on TEIID-5798: ----------------------------------------- Author: Steven Hawkins Created on: 02/Dec/19 10:02 AM Start Date: 02/Dec/19 10:02 AM Worklog Time Spent: 1 hour Issue Time Tracking ------------------- Remaining Estimate: 1 day, 6 hours (was: 1 day, 7 hours) Time Spent: 4 hours (was: 3 hours) Worklog Id: (was: 12448196) > Mixed PERMISSION GRANTS > ----------------------- > > Key: TEIID-5798 > URL: https://issues.jboss.org/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: 4 hours > Remaining Estimate: 1 day, 6 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

1
0
0 / 0

[JBoss JIRA] (TEIID-5798) Mixed PERMISSION GRANTS

by Steven Hawkins (Jira)

[ https://issues.jboss.org/browse/TEIID-5798?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-5798: ---------------------------------- Fix Version/s: 13.1 (was: 13.0) > Mixed PERMISSION GRANTS > ----------------------- > > Key: TEIID-5798 > URL: https://issues.jboss.org/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: 4 hours > Remaining Estimate: 1 day, 6 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

1
0
0 / 0

[JBoss JIRA] (TEIID-5798) Mixed PERMISSION GRANTS

by Ramesh Reddy (Jira)

[ https://issues.jboss.org/browse/TEIID-5798?page=com.atlassian.jira.plugin... ] Ramesh Reddy commented on TEIID-5798: ------------------------------------- +1 for simpler logic > Mixed PERMISSION GRANTS > ----------------------- > > Key: TEIID-5798 > URL: https://issues.jboss.org/browse/TEIID-5798 > Project: Teiid > Issue Type: Enhancement > Components: Query Engine > Reporter: Christoph John > Assignee: Steven Hawkins > Priority: Major > Fix For: 13.0 > > Original Estimate: 6 hours > Time Spent: 3 hours > Remaining Estimate: 1 day, 7 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

1
0
0 / 0

[JBoss JIRA] (TEIIDSB-141) Add a message to PlatformTransactionManagerAdapter exceptions

by Steven Hawkins (Jira)

[ https://issues.jboss.org/browse/TEIIDSB-141?page=com.atlassian.jira.plugi... ] Steven Hawkins resolved TEIIDSB-141. ------------------------------------ Resolution: Done > Add a message to PlatformTransactionManagerAdapter exceptions > ------------------------------------------------------------- > > Key: TEIIDSB-141 > URL: https://issues.jboss.org/browse/TEIIDSB-141 > Project: Teiid Spring Boot > Issue Type: Quality Risk > Components: core, datasource > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Priority: Major > Fix For: 1.3.0 > > Original Estimate: 30 minutes > Time Spent: 30 minutes > Remaining Estimate: 0 minutes > > The PlatformTransactionManagerAdapter will throw SystemExceptions without a message when attempting to initiate a transaction (non-spring managed). There should be a message that a full transaction manager is required. -- This message was sent by Atlassian Jira (v7.13.8#713008)

5 years

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues December 2019