]
Steven Hawkins commented on TEIIDSB-213:
----------------------------------------
I don't quite follow what is happening here.
Is the query with aliases the Teiid query you are issuing?
What is the source SOQL query that you are seeing as a result?
What is the nature of the problem with the salesforce response to that?
What version of Teiid Spring Boot is this?
If I for example on Teiid/Teiid Spring Boot master issue the Teiid query: "SELECT
a.id FROM Opportunity as a where a.amount > 100000000 LIMIT 5"
The SOQL issued is actually: "SELECT Opportunity.Id FROM Opportunity WHERE
Opportunity.Amount > 100000000 LIMIT 5" -- the user query alias does not appear.
We have strange behavior with aliases
-------------------------------------
Key: TEIIDSB-213
URL:
https://issues.redhat.com/browse/TEIIDSB-213
Project: Teiid Spring Boot
Issue Type: Bug
Components: datasource
Reporter: Renat Eskenin
Priority: Major
We have two SOQL
SELECT ArticleNumber,Id,KnowledgeArticleId,Language FROM Regular_Articles__kav WHERE
Language = 'it' LIMIT 5
SELECT a.ArticleNumber,a.Id,a.KnowledgeArticleId,a.Language FROM Regular_Articles__kav a
WHERE a.Language = 'it' LIMIT 5
This SOQL requests get different responses from SF because in second request we have
alias for table.
It is mystics from SF (we made bug in sf)
How we can call
SELECT ArticleNumber,Id,KnowledgeArticleId,Language FROM Regular_Articles__kav WHERE
Language = 'it' LIMIT 5
in Teiid without aliases?