[teiid-issues] [JBoss JIRA] (TEIID-4262) Wrong result (empty or NULL) with an view and a single disjunction for join criteria
RH Bugzilla Integration (JIRA)
issues at jboss.org
Thu Jun 9 14:26:00 EDT 2016
[ https://issues.jboss.org/browse/TEIID-4262?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
RH Bugzilla Integration updated TEIID-4262:
-------------------------------------------
Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1344462
Bugzilla Update: Perform
> Wrong result (empty or NULL) with an view and a single disjunction for join criteria
> ------------------------------------------------------------------------------------
>
> Key: TEIID-4262
> URL: https://issues.jboss.org/browse/TEIID-4262
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 7.0
> Reporter: Salvatore R
> Assignee: Steven Hawkins
> Priority: Blocker
> Fix For: 9.0, 8.12.5, 8.13.6
>
>
> The following query returns an empty result instead of 1:
> {code:sql}
> SELECT alias3.a1 FROM (select 1 as a) as alias2 INNER JOIN (SELECT t2.a AS a1, t1.a FROM (SELECT 1 AS a) AS t1 INNER JOIN (select 1 as a) as t2 ON t1.a = t2.a) AS alias3 ON ((alias3.a = alias2.a) OR (alias3.a > alias2.a))
> {code}
> when updating the parent join on removing the alias3 view layer, the OR condition is being converted to AND - which can never be true.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
More information about the teiid-issues
mailing list