[JBoss JIRA] Created: (TEIID-1625) SalesForce INCLUDE function not being pushed to source
by Paul Nittel (JIRA)
SalesForce INCLUDE function not being pushed to source
------------------------------------------------------
Key: TEIID-1625
URL: https://issues.jboss.org/browse/TEIID-1625
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.4
Environment: Models built by JBDS 4.1 CR1
Reporter: Paul Nittel
Assignee: Steven Hawkins
While executing the SalesForce test script I executed the following query:
Select Name, Communication_Preferences__c from Contact where true = includes(Communication_Preferences__c, 'Fax,Email')
Other queries do succeed, but the exclude function suffers a similar fate.
The response was: Function includes is marked in the function metadata as a function that must be evaluated at the source.
Looking at the functions in the Designer, the PUSH DOWN property has a value of REQUIRED.
Am attaching the server log excerpt and Model Project Set
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
12 years, 10 months
[JBoss JIRA] Created: (TEIID-1603) BQT Query not returning expected row count
by Warren Gibson (JIRA)
BQT Query not returning expected row count
------------------------------------------
Key: TEIID-1603
URL: https://issues.jboss.org/browse/TEIID-1603
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.4
Environment: Running BQT Query Suite against Teiid 7.4
Reporter: Warren Gibson
Assignee: Steven Hawkins
Attachments: RDBMS_Test_Queries_9600_TestQuery63.xml
Teiid 7.4 - the following query is returning no rows but the expected row count is 47 rows. This was tested with MySql50 and Teradata12. I verified the query produced 47 rows with SOA-P 5.1 GA. See expected query results file attached. VDB can be made available if needed.
SELECT INTKEY, DATEVALUE, BYTENUM FROM BQT1.SmallA WHERE DATEVALUE <> ANY (SELECT DATEVALUE FROM BQT1.SmallA WHERE BYTENUM >= '-108')
The source query from the log file is:
SELECT cast(g_0.INTKEY AS signed) AS c_0, g_0.DATEVALUE AS c_1, g_0.BYTENUM AS c_2 FROM smalla AS g_0 WHERE g_0.DATEVALUE NOT IN (SELECT g_1.DATEVALUE FROM smalla AS g_1 WHERE g_1.BYTENUM >= -108) LIMIT 100
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
12 years, 10 months