[teiid-issues] [JBoss JIRA] (TEIID-5988) We have strange behavior with aliases

[Steven Hawkins (Jira)]

     [ https://issues.redhat.com/browse/TEIID-5988?focusedWorklogId=12451723&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-12451723 ]

Steven Hawkins logged work on TEIID-5988:
-----------------------------------------

                Author: Steven Hawkins
            Created on: 13/Jul/20 1:50 PM
            Start Date: 13/Jul/20 1:50 PM
    Worklog Time Spent: 5 hours 

Issue Time Tracking
-------------------

    Remaining Estimate: 0 minutes  (was: 5 hours)
            Time Spent: 5 hours
            Worklog Id:     (was: 12451723)


> We have strange behavior with aliases
> -------------------------------------
>
>                 Key: TEIID-5988
>                 URL: https://issues.redhat.com/browse/TEIID-5988
>             Project: Teiid
>          Issue Type: Bug
>          Components: Salesforce Connector
>            Reporter: Renat Eskenin
>            Assignee: Steven Hawkins
>            Priority: Major
>             Fix For: 15.0
>
>         Attachments: Снимок экрана от 2020-06-26 12-37-40.png, Снимок экрана от 2020-06-26 12-38-04.png
>
>   Original Estimate: 5 hours
>          Time Spent: 5 hours
>  Remaining Estimate: 0 minutes
>
> 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)