[
https://issues.redhat.com/browse/TEIIDSB-213?page=com.atlassian.jira.plug...
]
Renat Eskenin commented on TEIIDSB-213:
---------------------------------------
A, this variants do not working too
{code}
SELECT ArticleNumber,Id,KnowledgeArticleId,"Language" FROM Regular_Articles__kav
WHERE "Language" = 'it' LIMIT 5
{code}
{code}
SELECT
Regular_Articles__kav.ArticleNumber,Regular_Articles__kav.Id,Regular_Articles__kav.KnowledgeArticleId,Regular_Articles__kav.Language
FROM Regular_Articles__kav WHERE Regular_Articles__kav.Language = 'it' LIMIT 5
{code}
Because Teiid converted this request to form with full qualified names as
{code}
SELECT g_0.ArticleNumber, g_0.Id, g_0.KnowledgeArticleId, g_0."Language" FROM
salesforce.Regular_Articles__kav AS g_0 WHERE g_0."Language" = 'it'
LIMIT 5
{code}
As I understand.
This is effect of "interference systems".
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?
--
This message was sent by Atlassian Jira
(v7.13.8#713008)