[teiid-issues] [JBoss JIRA] (TEIIDSB-213) We have strange behavior with aliases
Renat Eskenin (Jira)
issues at jboss.org
Tue Jun 30 07:30:31 EDT 2020
[ https://issues.redhat.com/browse/TEIIDSB-213?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14182726#comment-14182726 ]
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)
More information about the teiid-issues
mailing list