[teiid-issues] [JBoss JIRA] (TEIIDSB-213) We have strange behavior with aliases

[Renat Eskenin (Jira)]

    [ https://issues.redhat.com/browse/TEIIDSB-213?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14181406#comment-14181406 ] 

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?



--
This message was sent by Atlassian Jira
(v7.13.8#713008)