[JBoss JIRA] (TEIID-3671) filter on child table not working
by Prashanthi Kairuppala (JIRA)
[ https://issues.jboss.org/browse/TEIID-3671?page=com.atlassian.jira.plugin... ]
Prashanthi Kairuppala commented on TEIID-3671:
----------------------------------------------
Hi [~shawkins],
any work around to achieve this until the next update is released?
Thanks,
Prashanthi.
> filter on child table not working
> ---------------------------------
>
> Key: TEIID-3671
> URL: https://issues.jboss.org/browse/TEIID-3671
> Project: Teiid
> Issue Type: Bug
> Components: OData
> Reporter: Prashanthi Kairuppala
> Assignee: Steven Hawkins
> Priority: Critical
> Fix For: 8.12, 8.11.4
>
> Attachments: parent_childTables.PNG
>
>
>
> Please find the screenshot attached which has id as a foreign key. when i give the url - //localhost:8080/odata/testVDB/sales('13')/sales_uk?$format=json, i get the results from sales_uk table which are having id=13.
>
> Now i am trying to apply a filter on this url, i am supposed to get results which are having id=13 and satisfy the filter condition, but this url blindly returns me data from sales_uk table which satisfy the filter condition. URL- //localhost:8080/odata/testVDB/sales('13')/sales_uk?$format=json&$filter=DISCOUNT eq '22'
>
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
10 years, 6 months
[JBoss JIRA] (TEIID-3696) Duplicates are not always removed when UNION and GROUP BY clauses are used in a subquery
by Salvatore R (JIRA)
Salvatore R created TEIID-3696:
----------------------------------
Summary: Duplicates are not always removed when UNION and GROUP BY clauses are used in a subquery
Key: TEIID-3696
URL: https://issues.jboss.org/browse/TEIID-3696
Project: Teiid
Issue Type: Bug
Reporter: Salvatore R
Assignee: Steven Hawkins
In some cases, duplicates are not correctly removed when a UNION clause and a GROUP BY are used in a subquery.
Given, for example, these two views:
{code:sql}
CREATE view v1 as
select 'a' as col1
UNION
SELECT '' as col1;
CREATE view v2 as
select 'b' as col1
UNION
SELECT '' as col1;
{code}
running the following query (both col1 and col2 are projected by the main query):
{code:sql}
select
y.col2, y.col1
from (
select x.col2, min(x.col1) as col1
from (
select 1 as col2, col1 from "views.v1"
union
select 1 as col2, col1 from "views.v2"
) x
group by x.col2
) y
{code}
only 1 row is returned as expected:
||col2||col1||
|1| |
but if only "col2" is projected by the main query:
{code:sql}
select
y.col2
from (
select x.col2, min(x.col1) as col1
from (
select 1 as col2, col1 from "views.v1"
union
select 1 as col2, col1 from "views.v2"
) x
group by x.col2
) y
{code}
three rows are returned:
||col2||
|1|
|1|
|1|
This behavior can be reproduced in Teiid-8.12-Beta1.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
10 years, 6 months
[JBoss JIRA] (TEIID-3642) RhinoScriptEngineFactory be removed in Java 8
by RH Bugzilla Integration (JIRA)
[ https://issues.jboss.org/browse/TEIID-3642?page=com.atlassian.jira.plugin... ]
RH Bugzilla Integration commented on TEIID-3642:
------------------------------------------------
Emmett Underhill <eunderhi(a)redhat.com> changed the Status of [bug 1254399|https://bugzilla.redhat.com/show_bug.cgi?id=1254399] from ASSIGNED to MODIFIED
> RhinoScriptEngineFactory be removed in Java 8
> ----------------------------------------------
>
> Key: TEIID-3642
> URL: https://issues.jboss.org/browse/TEIID-3642
> Project: Teiid
> Issue Type: Quality Risk
> Components: OData
> Affects Versions: 8.7.1.6_2, 8.12
> Environment: * DV 6.2.0.ER4
> * Java 1.8.0_25
> Reporter: Kylin Soong
> Assignee: Steven Hawkins
>
> RhinoScriptEngineFactory be removed in Java 8, this cause OData war deploy output Error:
> {code}
> 09:30:51,315 WARN [org.jboss.as.dependency.unsupported] (MSC service thread 1-6) JBAS015868: Deployment "deployment.teiid-odata-8.7.1.6_2-redhat-2.war" is using an unsupported module ("org.joda.time:main") which may be changed or removed in future versions without notice.
> 09:30:51,424 ERROR [stderr] (MSC service thread 1-6) ScriptEngineManager providers.next(): javax.script.ScriptEngineFactory: Provider com.sun.script.javascript.RhinoScriptEngineFactory not found
> 09:30:51,429 ERROR [stderr] (MSC service thread 1-1) ScriptEngineManager providers.next(): javax.script.ScriptEngineFactory: Provider com.sun.script.javascript.RhinoScriptEngineFactory not found
> 09:30:51,505 ERROR [stderr] (MSC service thread 1-1) ScriptEngineManager providers.next(): javax.script.ScriptEngineFactory: Provider com.sun.script.javascript.RhinoScriptEngineFactory not found
> 09:30:51,513 ERROR [stderr] (MSC service thread 1-1) ScriptEngineManager providers.next(): javax.script.ScriptEngineFactory: Provider com.sun.script.javascript.RhinoScriptEngineFactory not found
> 09:30:51,583 ERROR [stderr] (MSC service thread 1-1) ScriptEngineManager providers.next(): javax.script.ScriptEngineFactory: Provider com.sun.script.javascript.RhinoScriptEngineFactory not found
> {code}
> *OData war* depend on *org.joda.time*, *org.joda.time* depend on *RhinoScriptEngineFactory*, due to RhinoScriptEngineFactory be removed in Java 8, so stderr output in console.
> h3. how to reproduce
> Start DV 6.2 with Java 8.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
10 years, 6 months
[JBoss JIRA] (TEIID-3380) Simplify Kerberos configuration with Embedded
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3380?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-3380:
---------------------------------------
A workaround to the identity switching issue noted above would be to use a connection pool of max size 0, so that the local connections are not reused.
> Simplify Kerberos configuration with Embedded
> ---------------------------------------------
>
> Key: TEIID-3380
> URL: https://issues.jboss.org/browse/TEIID-3380
> Project: Teiid
> Issue Type: Quality Risk
> Components: Embedded
> Reporter: Steven Hawkins
> Assignee: Ramesh Reddy
> Fix For: 8.11
>
>
> The current code requires overriding the embedded server to install a custom session service. It may be good to have some base level of functionality built-in and/or just delegated to the security helper.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
10 years, 6 months