[teiid-issues] [JBoss JIRA] (TEIIDSB-213) We have strange behavior with aliases
[
https://issues.redhat.com/browse/TEIIDSB-213?page=com.atlassian.jira.plug...
]
Renat Eskenin commented on TEIIDSB-213:
---------------------------------------
SOQL
{code}
SELECT Regular_Articles__kav.ArticleNumber, Regular_Articles__kav.Id,
Regular_Articles__kav.KnowledgeArticleId, Regular_Articles__kav.Language FROM
Regular_Articles__kav
{code}
in SF get so strange data set with only one language (en_US).
But
{code}
SELECT ArticleNumber, Id,KnowledgeArticleId, Language FROM Regular_Articles__kav
{code}
get all data with all languages.
Can we fine any method to generate this SOQL
SELECT ArticleNumber, Id,KnowledgeArticleId, Language FROM Regular_Articles__kav
from SQL by Teiid?
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)