May 2018 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-5333) Complex foreign keys set the referenced key regardless of order

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-5333: ------------------------------------- Summary: Complex foreign keys set the referenced key regardless of order Key: TEIID-5333 URL: https://issues.jboss.org/browse/TEIID-5333 Project: Teiid Issue Type: Bug Components: Query Engine Reporter: Steven Hawkins Assignee: Steven Hawkins The metadatavalidator will resolve foreign keys as long as the columns match - but does not reorder the fk columns nor track the referenced order which means that the referenced key can be wrong. For example: {code} CREATE FOREIGN TABLE G1(g1e1 integer, g1e2 integer, PRIMARY KEY(g1e1, g1e2)); CREATE FOREIGN TABLE G2(g2e1 integer, g2e2 integer, FOREIGN KEY (g2e1, g2e2) REFERENCES G1(g1e2, g1e1)); {code} Note that the elements are reversed in the references list, but this is not captured in the resolved foreign key meaning that it effectively represents a relationship on g2e1,g2e2 with g1e1,g1e2. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5314) usage of environment properties

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-5314?page=com.atlassian.jira.plugin... ] Ramesh Reddy commented on TEIID-5314: ------------------------------------- Ok, that makes sense. Thanks. > usage of environment properties > ------------------------------- > > Key: TEIID-5314 > URL: https://issues.jboss.org/browse/TEIID-5314 > Project: Teiid > Issue Type: Enhancement > Components: Server > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 10.3 > > > Places in Teiid that look for system properties should allow for overrides to be specified via environment properties as well. This will make it easier to configure optional behavior on openshift. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5314) usage of environment properties

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-5314?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-5314: --------------------------------------- > I mean all WildFly and Teiid properties Yes, that is what I mean all of the properties that would normally be configured through the wildfly configuration system. The changes in this JIRA are for properties that we were already directly referencing from the system properties. > usage of environment properties > ------------------------------- > > Key: TEIID-5314 > URL: https://issues.jboss.org/browse/TEIID-5314 > Project: Teiid > Issue Type: Enhancement > Components: Server > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 10.3 > > > Places in Teiid that look for system properties should allow for overrides to be specified via environment properties as well. This will make it easier to configure optional behavior on openshift. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5314) usage of environment properties

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-5314?page=com.atlassian.jira.plugin... ] Ramesh Reddy commented on TEIID-5314: ------------------------------------- I mean all WildFly and Teiid properties can be defined through ENV or YML for WildFly-Swarm. See http://docs.wildfly-swarm.io/2018.4.1/#_teiid_fraction > usage of environment properties > ------------------------------- > > Key: TEIID-5314 > URL: https://issues.jboss.org/browse/TEIID-5314 > Project: Teiid > Issue Type: Enhancement > Components: Server > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 10.3 > > > Places in Teiid that look for system properties should allow for overrides to be specified via environment properties as well. This will make it easier to configure optional behavior on openshift. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5314) usage of environment properties

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-5314?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-5314: --------------------------------------- [~rareddy] That covers the wildfly config properties, correct? The only jboss/wildfly properties that we reference statically are jboss.node.name and io.netty.eventLoopThreads. The former hasn't mattered yet as we don't have HA working. The latter is probably moot now that 8u131 should support a refined availableProcessors - but I haven't tested that yet. > usage of environment properties > ------------------------------- > > Key: TEIID-5314 > URL: https://issues.jboss.org/browse/TEIID-5314 > Project: Teiid > Issue Type: Enhancement > Components: Server > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 10.3 > > > Places in Teiid that look for system properties should allow for overrides to be specified via environment properties as well. This will make it easier to configure optional behavior on openshift. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5314) usage of environment properties

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-5314?page=com.atlassian.jira.plugin... ] Ramesh Reddy commented on TEIID-5314: ------------------------------------- [~shawkins] In WildFly Swarm all the properties should be automatically available as ENV properties. They will have prefix "swarm.teiid" > usage of environment properties > ------------------------------- > > Key: TEIID-5314 > URL: https://issues.jboss.org/browse/TEIID-5314 > Project: Teiid > Issue Type: Enhancement > Components: Server > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 10.3 > > > Places in Teiid that look for system properties should allow for overrides to be specified via environment properties as well. This will make it easier to configure optional behavior on openshift. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5314) usage of environment properties

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-5314?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-5314: --------------------------------------- The initial commit adds environment lookup for all teiid specific properties. We need to decide whether this should apply to java and jboss properties as well. > usage of environment properties > ------------------------------- > > Key: TEIID-5314 > URL: https://issues.jboss.org/browse/TEIID-5314 > Project: Teiid > Issue Type: Enhancement > Components: Server > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 10.3 > > > Places in Teiid that look for system properties should allow for overrides to be specified via environment properties as well. This will make it easier to configure optional behavior on openshift. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 8 months

1
0
0 / 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues May 2018