[JBoss JIRA] (TEIID-2560) wrong result with distinct independent values in a depedent join
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-2560?page=com.atlassian.jira.plugin... ]
Steven Hawkins closed TEIID-2560.
---------------------------------
> wrong result with distinct independent values in a depedent join
> ----------------------------------------------------------------
>
> Key: TEIID-2560
> URL: https://issues.jboss.org/browse/TEIID-2560
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 7.7
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Fix For: 8.4.1, 8.5
>
>
> This should be a fairly uncommon scenario, but if given a query such as:
> SELECT ... FROM pm1.g1, pm3.g2, /*+ makeind */ (select distinct e1, e2 from pm2.g1) x WHERE x.e1=pm1.g1.e1 AND pm3.g2.e2=x.e2
> such that the independent side of the join is seen as having distinct values and the dependent sets are targeted at different sources, we will not correctly detect that the values need pre-processed with dup removal.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
11 years, 3 months
[JBoss JIRA] (TEIID-2567) issues with permission element in vdb-deployer.xsd contains problematic choice node
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-2567?page=com.atlassian.jira.plugin... ]
Steven Hawkins closed TEIID-2567.
---------------------------------
> issues with permission element in vdb-deployer.xsd contains problematic choice node
> -----------------------------------------------------------------------------------
>
> Key: TEIID-2567
> URL: https://issues.jboss.org/browse/TEIID-2567
> Project: Teiid
> Issue Type: Task
> Affects Versions: 8.4
> Reporter: Barry LaFond
> Assignee: Steven Hawkins
> Fix For: 8.4.1, 8.5
>
>
> Having a lot of trouble trying to tweak our JaxB VDB element classes to accommodate the permission's choice node which contains a <sequence> and an <element>.
> This structure is basically impossible to unmarshall using JAXB annotations (i.e. @XmlElements(value= {}) )
> Would clean things up to convert the <allow-language> element to an attribute: <xs:attribute name="allow-language" type="xs:boolean"/> and place it on the <permission> element AND remove the <choice> node entirely
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
11 years, 3 months
[JBoss JIRA] (TEIID-2570) blocked code lookup needs to consider key value
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-2570?page=com.atlassian.jira.plugin... ]
Steven Hawkins closed TEIID-2570.
---------------------------------
> blocked code lookup needs to consider key value
> -----------------------------------------------
>
> Key: TEIID-2570
> URL: https://issues.jboss.org/browse/TEIID-2570
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 8.4
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Fix For: 8.4.1, 8.5
>
>
> TEIID-2507 allowed lookups to block but introduced an issue. In rare circumstances, such as accessing a code table for the first time from two branches of a union such that a lookup of one value is performed in the first branch and a lookup of another value is performed in the second branch, the same value could be returned for each. Subsequent lookups would not exhibit the same behavior.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
11 years, 3 months
[JBoss JIRA] (TEIID-2564) Correlated subqueries throws TEIID30328
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-2564?page=com.atlassian.jira.plugin... ]
Steven Hawkins closed TEIID-2564.
---------------------------------
> Correlated subqueries throws TEIID30328
> ---------------------------------------
>
> Key: TEIID-2564
> URL: https://issues.jboss.org/browse/TEIID-2564
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 8.4
> Reporter: Warren Gibson
> Assignee: Steven Hawkins
> Fix For: 8.4.1, 8.5
>
> Attachments: server.log
>
>
> Non-pushed correlated subqueries that use a correlation variable that is a grouping column where the subquery is turned into a semi join (either through the MJ hint or costing) will fail to find the correlation values.
> For example the following against Netezza (which does not support correlated subqueries):
> SELECT A.INTKEY, A.STRINGNUM FROM BQT1.SMALLA AS A WHERE CONVERT(LONGNUM,
> STRING) = 8 GROUP BY A.INTKEY, A.STRINGNUM HAVING A.STRINGNUM = (SELECT
> MAX(B.STRINGNUM) FROM BQT1.SMALLA AS B WHERE A.INTKEY = B.INTKEY
> throws "TEIID30328 Unable to evaluate A.IntKey: No value was available"
> If the subplan is not converted to a join or the correlated column is not a grouping expression, then there is no issue.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
11 years, 3 months