[JBoss JIRA] Resolved: (TEIID-1664) Teiid - Teradata queries containing LTRIM and RTRIM on the BQT booleanvalue column are returning unexpected BQT results
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-1664?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-1664.
-----------------------------------
Fix Version/s: 7.4.1
7.5
Resolution: Done
Marking as resolved. New issues can be opened against Teradata for unsupported expression nesting if needed.
> Teiid - Teradata queries containing LTRIM and RTRIM on the BQT booleanvalue column are returning unexpected BQT results
> -----------------------------------------------------------------------------------------------------------------------
>
> Key: TEIID-1664
> URL: https://issues.jboss.org/browse/TEIID-1664
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 7.4.1
> Reporter: Warren Gibson
> Assignee: Steven Hawkins
> Fix For: 7.4.1, 7.5
>
> Attachments: QT_teradata12_Push.vdb
>
>
> Teiid - Teradata queries containing LTRIM and RTRIM on the BQT booleanvalue column are returning unexpected results. The following query should be returning 22 rows but 0 rows are returned.
> SELECT intkey, booleanvalue FROM BQT1.SmallA WHERE LTRIM(BQT1.SmallA.BooleanValue) = 'true' ORDER BY intkey
> However, if the LTRIM is removed like (SELECT intkey, booleanvalue FROM BQT1.SmallA WHERE BQT1.SmallA.BooleanValue = 'true' ORDER BY intkey) 22 rows are returned.
> This should be logged against Teiid 7.4.1
> VDB attached.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
13 years, 7 months
[JBoss JIRA] Resolved: (TEIID-993) Enhance XML processing to execute relational queries in parallel when possible
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-993?page=com.atlassian.jira.plugin.... ]
Steven Hawkins resolved TEIID-993.
----------------------------------
Fix Version/s: 7.4.1
Resolution: Done
Added logic to look ahead for execsqlinstructions within a program and to init/open the processors - this is the situation when there are sibling mappingclasses at the same document level. For typical query plans, opening them will submit the relevant source queries. The output is still built sequentially.
> Enhance XML processing to execute relational queries in parallel when possible
> ------------------------------------------------------------------------------
>
> Key: TEIID-993
> URL: https://issues.jboss.org/browse/TEIID-993
> Project: Teiid
> Issue Type: Feature Request
> Components: Query Engine
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Fix For: 7.4.1
>
>
> Per feedback from Barry, was reviewing XML processing and because we execute all queries serially in our XML processing. However, conceptually, we could often execute multiple mapping class and/or temp table queries in parallel. When time permits it might be benefitial to investigate this.
> All mapping classes at depth "n" in the document model are independent of each other, so they can be executed in parallel. Each mapping class may have input sets to any ancestor mapping class up to depth "n-1", or may select from any temp table up to depth "n" (the same depth).
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
13 years, 7 months
[JBoss JIRA] Assigned: (TEIID-993) Enhance XML processing to execute relational queries in parallel when possible
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-993?page=com.atlassian.jira.plugin.... ]
Steven Hawkins reassigned TEIID-993:
------------------------------------
Assignee: Steven Hawkins
> Enhance XML processing to execute relational queries in parallel when possible
> ------------------------------------------------------------------------------
>
> Key: TEIID-993
> URL: https://issues.jboss.org/browse/TEIID-993
> Project: Teiid
> Issue Type: Feature Request
> Components: Query Engine
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
>
> Per feedback from Barry, was reviewing XML processing and because we execute all queries serially in our XML processing. However, conceptually, we could often execute multiple mapping class and/or temp table queries in parallel. When time permits it might be benefitial to investigate this.
> All mapping classes at depth "n" in the document model are independent of each other, so they can be executed in parallel. Each mapping class may have input sets to any ancestor mapping class up to depth "n-1", or may select from any temp table up to depth "n" (the same depth).
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
13 years, 7 months