[JBoss JIRA] (TEIID-4297) Add UDF functions based on OSDQ for POC
by JieRen JieRen (JIRA)
[ https://issues.jboss.org/browse/TEIID-4297?page=com.atlassian.jira.plugin... ]
JieRen JieRen reassigned TEIID-4297:
------------------------------------
Assignee: JieRen JieRen (was: Kylin Soong)
> Add UDF functions based on OSDQ for POC
> ---------------------------------------
>
> Key: TEIID-4297
> URL: https://issues.jboss.org/browse/TEIID-4297
> Project: Teiid
> Issue Type: Enhancement
> Components: Query Engine
> Reporter: Ramesh Reddy
> Assignee: JieRen JieRen
> Fix For: 9.1
>
>
> Please add following UDF functions to Teiid library based on maven module
> http://search.maven.org/#search%7Cga%7C1%7Carrahtec
> The UDF functions needs to from this class below
> {code}
> public class Maskutil {
> /**
> * @param a
> * The string that need to randomize
> * vivek singh' will become 'ihg vkeivh'
> */
> public static String toRandomValue(String a) {
> return ShuffleRTM.shuffleString(a);
> }
> /**
> * @param a
> * This function will retrun MD5 hashcode of the string
> * @return String
> */
> public static String toHashValue(String a) {
> if (a == null)
> return "d41d8cd98f00b204e9800998ecf8427e"; // null MD5 value
> return ResultsetToRTM.getMD5(a).toString();
> }
> /**
> * @param a
> * This function will return digit characters of the string
> * @return
> *
> */
> public static String toDigitValue(String a) {
> return StringCaseFormatUtil.digitString(a);
> }
> }
> {code}
> for example Teiid should have UDF functions like
> {code}
> string random(string)
> string hash(string)
> string digit(string)
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years
[JBoss JIRA] (TEIID-4200) Provide support for Wildfly 10
by Kylin Soong (JIRA)
[ https://issues.jboss.org/browse/TEIID-4200?page=com.atlassian.jira.plugin... ]
Kylin Soong edited comment on TEIID-4200 at 6/23/16 11:52 PM:
--------------------------------------------------------------
h2. 1. IllegalStateException
While execute teiid-standalone-mode-install.cli, a IllegalStateException throw, this not only in WildFly 10 kits, it exist in all version, including 9.0.Final.
{code}
11:26:02,513 ERROR [org.jboss.as.controller.management-operation] (Controller Boot Thread) WFLYCTL0013: Operation ("add") failed - address: ([("subsystem" => "teiid")]) - failure description: "WFLYCTL0158: Operation handler failed: java.lang.IllegalStateException: WFLYSRV0206: Multiple deployment unit processors registered with priority 65397 and class class org.teiid.jboss.DynamicVDBRootMountDeployer"
11:26:02,515 ERROR [org.jboss.as.controller.management-operation] (Controller Boot Thread) WFLYCTL0013: Operation ("add") failed - address: ([("deployment" => "teiid-odata.war")]) - failure description: "WFLYCTL0158: Operation handler failed: java.lang.IllegalStateException: WFLYSRV0206: Multiple deployment unit processors registered with priority 65397 and class class org.teiid.jboss.DynamicVDBRootMountDeployer"
11:26:02,515 ERROR [org.jboss.as.controller.management-operation] (Controller Boot Thread) WFLYCTL0013: Operation ("add") failed - address: ([("deployment" => "teiid-olingo-odata4.war")]) - failure description: "WFLYCTL0158: Operation handler failed: java.lang.IllegalStateException: WFLYSRV0206: Multiple deployment unit processors registered with priority 65397 and class class org.teiid.jboss.DynamicVDBRootMountDeployer"
{code}
Note that, if re-start server, the above error is gone.
h2. 2. domain install failed
teiid-domain-mode-install.cli execute failed, with error
{code}
'authentication-security-domain,distributed-cache-jgroups-stack' is not a valid parameter name.
{code}
the error caused by CLI
{code}
/profile=ha/subsystem=teiid:add(authentication-security-domain, distributed-cache-jgroups-stack=teiid-cluster, resultset-cache-infinispan-container=teiid-cache, preparedplan-cache-infinispan-container=teiid-cache, policy-decider-module=org.jboss.teiid)
{code}
Note that, this error exist both wf 10 and wf 9.0.2 kits, in other words, teiid-9.0.Final also have this error.
was (Author: kylin):
h2. IllegalStateException
While execute teiid-standalone-mode-install.cli, a IllegalStateException throw, this not only in WildFly 10 kits, it exist in all version, including 9.0.Final.
{code}
11:26:02,513 ERROR [org.jboss.as.controller.management-operation] (Controller Boot Thread) WFLYCTL0013: Operation ("add") failed - address: ([("subsystem" => "teiid")]) - failure description: "WFLYCTL0158: Operation handler failed: java.lang.IllegalStateException: WFLYSRV0206: Multiple deployment unit processors registered with priority 65397 and class class org.teiid.jboss.DynamicVDBRootMountDeployer"
11:26:02,515 ERROR [org.jboss.as.controller.management-operation] (Controller Boot Thread) WFLYCTL0013: Operation ("add") failed - address: ([("deployment" => "teiid-odata.war")]) - failure description: "WFLYCTL0158: Operation handler failed: java.lang.IllegalStateException: WFLYSRV0206: Multiple deployment unit processors registered with priority 65397 and class class org.teiid.jboss.DynamicVDBRootMountDeployer"
11:26:02,515 ERROR [org.jboss.as.controller.management-operation] (Controller Boot Thread) WFLYCTL0013: Operation ("add") failed - address: ([("deployment" => "teiid-olingo-odata4.war")]) - failure description: "WFLYCTL0158: Operation handler failed: java.lang.IllegalStateException: WFLYSRV0206: Multiple deployment unit processors registered with priority 65397 and class class org.teiid.jboss.DynamicVDBRootMountDeployer"
{code}
Note that, if re-start server, the above error is gone.
> Provide support for Wildfly 10
> ------------------------------
>
> Key: TEIID-4200
> URL: https://issues.jboss.org/browse/TEIID-4200
> Project: Teiid
> Issue Type: Feature Request
> Components: Server
> Reporter: Ramesh Reddy
> Assignee: Ramesh Reddy
> Priority: Blocker
> Fix For: 9.1
>
>
> Upgrade the host runtime environment for Teiid Server to be WildFly 10.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years
[JBoss JIRA] (TEIID-4200) Provide support for Wildfly 10
by Kylin Soong (JIRA)
[ https://issues.jboss.org/browse/TEIID-4200?page=com.atlassian.jira.plugin... ]
Kylin Soong edited comment on TEIID-4200 at 6/23/16 11:52 PM:
--------------------------------------------------------------
h2. 1. IllegalStateException
While execute teiid-standalone-mode-install.cli, a IllegalStateException throw, this not only in WildFly 10 kits, it exist in all version, including 9.0.0.Final.
{code}
11:26:02,513 ERROR [org.jboss.as.controller.management-operation] (Controller Boot Thread) WFLYCTL0013: Operation ("add") failed - address: ([("subsystem" => "teiid")]) - failure description: "WFLYCTL0158: Operation handler failed: java.lang.IllegalStateException: WFLYSRV0206: Multiple deployment unit processors registered with priority 65397 and class class org.teiid.jboss.DynamicVDBRootMountDeployer"
11:26:02,515 ERROR [org.jboss.as.controller.management-operation] (Controller Boot Thread) WFLYCTL0013: Operation ("add") failed - address: ([("deployment" => "teiid-odata.war")]) - failure description: "WFLYCTL0158: Operation handler failed: java.lang.IllegalStateException: WFLYSRV0206: Multiple deployment unit processors registered with priority 65397 and class class org.teiid.jboss.DynamicVDBRootMountDeployer"
11:26:02,515 ERROR [org.jboss.as.controller.management-operation] (Controller Boot Thread) WFLYCTL0013: Operation ("add") failed - address: ([("deployment" => "teiid-olingo-odata4.war")]) - failure description: "WFLYCTL0158: Operation handler failed: java.lang.IllegalStateException: WFLYSRV0206: Multiple deployment unit processors registered with priority 65397 and class class org.teiid.jboss.DynamicVDBRootMountDeployer"
{code}
Note that, if re-start server, the above error is gone.
h2. 2. domain install failed
teiid-domain-mode-install.cli execute failed, with error
{code}
'authentication-security-domain,distributed-cache-jgroups-stack' is not a valid parameter name.
{code}
the error caused by CLI
{code}
/profile=ha/subsystem=teiid:add(authentication-security-domain, distributed-cache-jgroups-stack=teiid-cluster, resultset-cache-infinispan-container=teiid-cache, preparedplan-cache-infinispan-container=teiid-cache, policy-decider-module=org.jboss.teiid)
{code}
Note that, this error exist both wf 10 and wf 9.0.2 kits, in other words, teiid-9.0.0.Final also have this error.
was (Author: kylin):
h2. 1. IllegalStateException
While execute teiid-standalone-mode-install.cli, a IllegalStateException throw, this not only in WildFly 10 kits, it exist in all version, including 9.0.Final.
{code}
11:26:02,513 ERROR [org.jboss.as.controller.management-operation] (Controller Boot Thread) WFLYCTL0013: Operation ("add") failed - address: ([("subsystem" => "teiid")]) - failure description: "WFLYCTL0158: Operation handler failed: java.lang.IllegalStateException: WFLYSRV0206: Multiple deployment unit processors registered with priority 65397 and class class org.teiid.jboss.DynamicVDBRootMountDeployer"
11:26:02,515 ERROR [org.jboss.as.controller.management-operation] (Controller Boot Thread) WFLYCTL0013: Operation ("add") failed - address: ([("deployment" => "teiid-odata.war")]) - failure description: "WFLYCTL0158: Operation handler failed: java.lang.IllegalStateException: WFLYSRV0206: Multiple deployment unit processors registered with priority 65397 and class class org.teiid.jboss.DynamicVDBRootMountDeployer"
11:26:02,515 ERROR [org.jboss.as.controller.management-operation] (Controller Boot Thread) WFLYCTL0013: Operation ("add") failed - address: ([("deployment" => "teiid-olingo-odata4.war")]) - failure description: "WFLYCTL0158: Operation handler failed: java.lang.IllegalStateException: WFLYSRV0206: Multiple deployment unit processors registered with priority 65397 and class class org.teiid.jboss.DynamicVDBRootMountDeployer"
{code}
Note that, if re-start server, the above error is gone.
h2. 2. domain install failed
teiid-domain-mode-install.cli execute failed, with error
{code}
'authentication-security-domain,distributed-cache-jgroups-stack' is not a valid parameter name.
{code}
the error caused by CLI
{code}
/profile=ha/subsystem=teiid:add(authentication-security-domain, distributed-cache-jgroups-stack=teiid-cluster, resultset-cache-infinispan-container=teiid-cache, preparedplan-cache-infinispan-container=teiid-cache, policy-decider-module=org.jboss.teiid)
{code}
Note that, this error exist both wf 10 and wf 9.0.2 kits, in other words, teiid-9.0.Final also have this error.
> Provide support for Wildfly 10
> ------------------------------
>
> Key: TEIID-4200
> URL: https://issues.jboss.org/browse/TEIID-4200
> Project: Teiid
> Issue Type: Feature Request
> Components: Server
> Reporter: Ramesh Reddy
> Assignee: Ramesh Reddy
> Priority: Blocker
> Fix For: 9.1
>
>
> Upgrade the host runtime environment for Teiid Server to be WildFly 10.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years
[JBoss JIRA] (TEIID-4200) Provide support for Wildfly 10
by Kylin Soong (JIRA)
[ https://issues.jboss.org/browse/TEIID-4200?page=com.atlassian.jira.plugin... ]
Kylin Soong edited comment on TEIID-4200 at 6/23/16 11:36 PM:
--------------------------------------------------------------
h2. IllegalStateException
While execute teiid-standalone-mode-install.cli, a IllegalStateException throw, this not only in WildFly 10 kits, it exist in all version, including 9.0.Final.
{code}
11:26:02,513 ERROR [org.jboss.as.controller.management-operation] (Controller Boot Thread) WFLYCTL0013: Operation ("add") failed - address: ([("subsystem" => "teiid")]) - failure description: "WFLYCTL0158: Operation handler failed: java.lang.IllegalStateException: WFLYSRV0206: Multiple deployment unit processors registered with priority 65397 and class class org.teiid.jboss.DynamicVDBRootMountDeployer"
11:26:02,515 ERROR [org.jboss.as.controller.management-operation] (Controller Boot Thread) WFLYCTL0013: Operation ("add") failed - address: ([("deployment" => "teiid-odata.war")]) - failure description: "WFLYCTL0158: Operation handler failed: java.lang.IllegalStateException: WFLYSRV0206: Multiple deployment unit processors registered with priority 65397 and class class org.teiid.jboss.DynamicVDBRootMountDeployer"
11:26:02,515 ERROR [org.jboss.as.controller.management-operation] (Controller Boot Thread) WFLYCTL0013: Operation ("add") failed - address: ([("deployment" => "teiid-olingo-odata4.war")]) - failure description: "WFLYCTL0158: Operation handler failed: java.lang.IllegalStateException: WFLYSRV0206: Multiple deployment unit processors registered with priority 65397 and class class org.teiid.jboss.DynamicVDBRootMountDeployer"
{code}
Note that, if re-start server, the above error is gone.
was (Author: kylin):
h2. IllegalStateException
While execute teiid-standalone-mode-install.cli, a IllegalStateException throw, this not only in WildFly 10 kits, it exist in all version, including 9.0.Final.
{code}
11:26:02,513 ERROR [org.jboss.as.controller.management-operation] (Controller Boot Thread) WFLYCTL0013: Operation ("add") failed - address: ([("subsystem" => "teiid")]) - failure description: "WFLYCTL0158: Operation handler failed: java.lang.IllegalStateException: WFLYSRV0206: Multiple deployment unit processors registered with priority 65397 and class class org.teiid.jboss.DynamicVDBRootMountDeployer"
11:26:02,515 ERROR [org.jboss.as.controller.management-operation] (Controller Boot Thread) WFLYCTL0013: Operation ("add") failed - address: ([("deployment" => "teiid-odata.war")]) - failure description: "WFLYCTL0158: Operation handler failed: java.lang.IllegalStateException: WFLYSRV0206: Multiple deployment unit processors registered with priority 65397 and class class org.teiid.jboss.DynamicVDBRootMountDeployer"
11:26:02,515 ERROR [org.jboss.as.controller.management-operation] (Controller Boot Thread) WFLYCTL0013: Operation ("add") failed - address: ([("deployment" => "teiid-olingo-odata4.war")]) - failure description: "WFLYCTL0158: Operation handler failed: java.lang.IllegalStateException: WFLYSRV0206: Multiple deployment unit processors registered with priority 65397 and class class org.teiid.jboss.DynamicVDBRootMountDeployer"
{code}
> Provide support for Wildfly 10
> ------------------------------
>
> Key: TEIID-4200
> URL: https://issues.jboss.org/browse/TEIID-4200
> Project: Teiid
> Issue Type: Feature Request
> Components: Server
> Reporter: Ramesh Reddy
> Assignee: Ramesh Reddy
> Priority: Blocker
> Fix For: 9.1
>
>
> Upgrade the host runtime environment for Teiid Server to be WildFly 10.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years
[JBoss JIRA] (TEIID-4200) Provide support for Wildfly 10
by Kylin Soong (JIRA)
[ https://issues.jboss.org/browse/TEIID-4200?page=com.atlassian.jira.plugin... ]
Kylin Soong commented on TEIID-4200:
------------------------------------
h3. IllegalStateException
While execute teiid-standalone-mode-install.cli, a IllegalStateException throw, this not only in WildFly 10 kits, it exist in all version, including 9.0.Final.
{code}
11:26:02,513 ERROR [org.jboss.as.controller.management-operation] (Controller Boot Thread) WFLYCTL0013: Operation ("add") failed - address: ([("subsystem" => "teiid")]) - failure description: "WFLYCTL0158: Operation handler failed: java.lang.IllegalStateException: WFLYSRV0206: Multiple deployment unit processors registered with priority 65397 and class class org.teiid.jboss.DynamicVDBRootMountDeployer"
11:26:02,515 ERROR [org.jboss.as.controller.management-operation] (Controller Boot Thread) WFLYCTL0013: Operation ("add") failed - address: ([("deployment" => "teiid-odata.war")]) - failure description: "WFLYCTL0158: Operation handler failed: java.lang.IllegalStateException: WFLYSRV0206: Multiple deployment unit processors registered with priority 65397 and class class org.teiid.jboss.DynamicVDBRootMountDeployer"
11:26:02,515 ERROR [org.jboss.as.controller.management-operation] (Controller Boot Thread) WFLYCTL0013: Operation ("add") failed - address: ([("deployment" => "teiid-olingo-odata4.war")]) - failure description: "WFLYCTL0158: Operation handler failed: java.lang.IllegalStateException: WFLYSRV0206: Multiple deployment unit processors registered with priority 65397 and class class org.teiid.jboss.DynamicVDBRootMountDeployer"
{code}
> Provide support for Wildfly 10
> ------------------------------
>
> Key: TEIID-4200
> URL: https://issues.jboss.org/browse/TEIID-4200
> Project: Teiid
> Issue Type: Feature Request
> Components: Server
> Reporter: Ramesh Reddy
> Assignee: Ramesh Reddy
> Priority: Blocker
> Fix For: 9.1
>
>
> Upgrade the host runtime environment for Teiid Server to be WildFly 10.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years
[JBoss JIRA] (TEIID-4200) Provide support for Wildfly 10
by Kylin Soong (JIRA)
[ https://issues.jboss.org/browse/TEIID-4200?page=com.atlassian.jira.plugin... ]
Kylin Soong edited comment on TEIID-4200 at 6/23/16 11:34 PM:
--------------------------------------------------------------
h2. IllegalStateException
While execute teiid-standalone-mode-install.cli, a IllegalStateException throw, this not only in WildFly 10 kits, it exist in all version, including 9.0.Final.
{code}
11:26:02,513 ERROR [org.jboss.as.controller.management-operation] (Controller Boot Thread) WFLYCTL0013: Operation ("add") failed - address: ([("subsystem" => "teiid")]) - failure description: "WFLYCTL0158: Operation handler failed: java.lang.IllegalStateException: WFLYSRV0206: Multiple deployment unit processors registered with priority 65397 and class class org.teiid.jboss.DynamicVDBRootMountDeployer"
11:26:02,515 ERROR [org.jboss.as.controller.management-operation] (Controller Boot Thread) WFLYCTL0013: Operation ("add") failed - address: ([("deployment" => "teiid-odata.war")]) - failure description: "WFLYCTL0158: Operation handler failed: java.lang.IllegalStateException: WFLYSRV0206: Multiple deployment unit processors registered with priority 65397 and class class org.teiid.jboss.DynamicVDBRootMountDeployer"
11:26:02,515 ERROR [org.jboss.as.controller.management-operation] (Controller Boot Thread) WFLYCTL0013: Operation ("add") failed - address: ([("deployment" => "teiid-olingo-odata4.war")]) - failure description: "WFLYCTL0158: Operation handler failed: java.lang.IllegalStateException: WFLYSRV0206: Multiple deployment unit processors registered with priority 65397 and class class org.teiid.jboss.DynamicVDBRootMountDeployer"
{code}
was (Author: kylin):
h3. IllegalStateException
While execute teiid-standalone-mode-install.cli, a IllegalStateException throw, this not only in WildFly 10 kits, it exist in all version, including 9.0.Final.
{code}
11:26:02,513 ERROR [org.jboss.as.controller.management-operation] (Controller Boot Thread) WFLYCTL0013: Operation ("add") failed - address: ([("subsystem" => "teiid")]) - failure description: "WFLYCTL0158: Operation handler failed: java.lang.IllegalStateException: WFLYSRV0206: Multiple deployment unit processors registered with priority 65397 and class class org.teiid.jboss.DynamicVDBRootMountDeployer"
11:26:02,515 ERROR [org.jboss.as.controller.management-operation] (Controller Boot Thread) WFLYCTL0013: Operation ("add") failed - address: ([("deployment" => "teiid-odata.war")]) - failure description: "WFLYCTL0158: Operation handler failed: java.lang.IllegalStateException: WFLYSRV0206: Multiple deployment unit processors registered with priority 65397 and class class org.teiid.jboss.DynamicVDBRootMountDeployer"
11:26:02,515 ERROR [org.jboss.as.controller.management-operation] (Controller Boot Thread) WFLYCTL0013: Operation ("add") failed - address: ([("deployment" => "teiid-olingo-odata4.war")]) - failure description: "WFLYCTL0158: Operation handler failed: java.lang.IllegalStateException: WFLYSRV0206: Multiple deployment unit processors registered with priority 65397 and class class org.teiid.jboss.DynamicVDBRootMountDeployer"
{code}
> Provide support for Wildfly 10
> ------------------------------
>
> Key: TEIID-4200
> URL: https://issues.jboss.org/browse/TEIID-4200
> Project: Teiid
> Issue Type: Feature Request
> Components: Server
> Reporter: Ramesh Reddy
> Assignee: Ramesh Reddy
> Priority: Blocker
> Fix For: 9.1
>
>
> Upgrade the host runtime environment for Teiid Server to be WildFly 10.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years
[JBoss JIRA] (TEIID-4297) Add UDF functions based on OSDQ for POC
by Ramesh Reddy (JIRA)
Ramesh Reddy created TEIID-4297:
-----------------------------------
Summary: Add UDF functions based on OSDQ for POC
Key: TEIID-4297
URL: https://issues.jboss.org/browse/TEIID-4297
Project: Teiid
Issue Type: Enhancement
Components: Query Engine
Reporter: Ramesh Reddy
Assignee: Kylin Soong
Fix For: 9.1
Please add following UDF functions to Teiid library based on maven module
http://search.maven.org/#search%7Cga%7C1%7Carrahtec
The UDF functions needs to from this class below
{code}
public class Maskutil {
/**
* @param a
* The string that need to randomize
* vivek singh' will become 'ihg vkeivh'
*/
public static String toRandomValue(String a) {
return ShuffleRTM.shuffleString(a);
}
/**
* @param a
* This function will retrun MD5 hashcode of the string
* @return String
*/
public static String toHashValue(String a) {
if (a == null)
return "d41d8cd98f00b204e9800998ecf8427e"; // null MD5 value
return ResultsetToRTM.getMD5(a).toString();
}
/**
* @param a
* This function will return digit characters of the string
* @return
*
*/
public static String toDigitValue(String a) {
return StringCaseFormatUtil.digitString(a);
}
}
{code}
for example Teiid should have UDF functions like
{code}
string random(string)
string hash(string)
string digit(string)
{code}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years
[JBoss JIRA] (TEIID-3617) Provide an option to Limit per user based connections
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-3617?page=com.atlassian.jira.plugin... ]
Ramesh Reddy commented on TEIID-3617:
-------------------------------------
>why authentication-max-sessions-allowed can add as a attribute, and authentication-max-sessions-allowed-per-user can't?
Because "authentication-max-sessions-allowed" is total number of sessions that are allowed across all VDBs and across all the users. The default there is 10,000, not 1000. We can't have "authentication-max-sessions-allowed-per-user" because, we want to keep this scoped to VDB. If we remove that requirement, then what you are proposing can be allowed. In order to allow, what you are asking the attribute needs to be like
{code}
/subsystem=teiid:write-attribute(name=authentication-max-sessions-allowed-per-user,value="user1/vdbOne@teiid-security=25;user1/vdbTwo@teiid-security=35")
{code}
Now if I delete the vdbOne, I need to come here and clean up all these references, not to mention scalablility of the issue. Are you sure if there are 10,000 users, that is configuration option you will take? Central configuration needs to be something that can apply to all the components in a system. Can't change just because a user is added, or vdb is deployed etc.
> Provide an option to Limit per user based connections
> -----------------------------------------------------
>
> Key: TEIID-3617
> URL: https://issues.jboss.org/browse/TEIID-3617
> Project: Teiid
> Issue Type: Feature Request
> Components: Server
> Reporter: Xian Liu
> Assignee: Kylin Soong
> Fix For: 9.1
>
>
> we deploy teiid for users to get data, but some users will create many connections to teiid and they are not necessary, I need to find a good way to limit each user account can only get like 50 connections or so
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years
[JBoss JIRA] (TEIID-4129) Wrong results with cross model join on 2 varchar fields
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4129?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-4129:
---------------------------------------
Added another system property org.teiid.assumeMatchingCollation with the release note:
In order to prevent seemingly invalid results from a sort/merge join, the sort operation will undergo additional checks. If org.teiid.assumeMatchingCollation is false (the default) and a translator does not specify a collationLocale, then the sort for a sort/merge join will not be pushed. Teiid defaults to the Java UCS-2 collation, which may not match the default collation for sources, particular tables, or columns. You may set the system property org.teiid.assumeMatchingCollation true to restore the old default behavior or selectively update the translators to report a collationLocale matching org.teiid.collationLocale (UCS-2 if unset).
So we'll effectively default to not pushing down sorts for join processing that involve character data.
> Wrong results with cross model join on 2 varchar fields
> -------------------------------------------------------
>
> Key: TEIID-4129
> URL: https://issues.jboss.org/browse/TEIID-4129
> Project: Teiid
> Issue Type: Bug
> Reporter: Mark Tawk
> Assignee: Steven Hawkins
> Attachments: H2 DBs.zip, MetaDataStores.zip
>
>
> I'm using Teiid 8.11.3 with H2 translator.
> I'm joining 2 h2 tables from 2 different teiid models linked on varchar fields.
> the query result is retuning empty values from the joined table even though the joined values are identical.
> You find attached a zip file containing 2 h2 DBs for a simplified example
> Here is the query used:
> _select "Customer"."City" as "Customer_City","Customer"."CustomerID" as "Customer_CustomerID","City"."City" as "City_City","City"."CityID" as "City_CityID"
> from "db2"."Customer" "Customer"
> LEFT JOIN "db1"."City" "City" ON "Customer"."City" = "City"."City"_
> Note that if the 2 tables are in the same model, the query return correct results.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years