[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:
---------------------------------------
I have response from SF support:
{code}
I have tested this in my local dev org and aliases doesn't work for other languages.
So, this seems to be not working when we use aliases to filter other languages. I kindly
request you to use the query as below:
SELECT ArticleNumber,Id,Language FROM Regular_Articles__kav WHERE Language =
'it'
2.
I can see that the default language for the user with userId:
0050e000006TIKfAAO is English.
As the default language is English for the user, when they query on
'Regular_Articles__kav' they we see the records with language set to en-US
{code}
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)