]
Renat Eskenin commented on TEIIDSB-213:
---------------------------------------
Yes it is SF Bug. I do not have issues, but my colleagues found this bug many months ago
and just didn't use full qualified names or tables aliases. At now we do not have any
solution with Teiid to select articles.
This problem found for Regular_Articles__kav, I do not known about other objects.
As a solution I think need to add property for Teiid "Generate full qualified
names" or other similar solution. Why used full qualified names always?
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
Attachments: Снимок экрана от 2020-06-26 12-37-40.png, Снимок экрана от
2020-06-26 12-38-04.png
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?