[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
[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
[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
[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
[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