[teiid-issues] [JBoss JIRA] (TEIID-3128) Issue while querying Salesforce using Teiid embedded.

[Pranav K (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-3128?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Pranav K updated TEIID-3128:
----------------------------
    Description: 
(I am using Teiid Embedded 8.8.0.Final)
Please refer to this forum thread for exact analysis/details: https://developer.jboss.org/thread/248796

Steps to reproduce at my end:
1) Use tables Account and Contact where AccountId in Contact is the child field for Id in Account.
2) Execute the queries as shown in the steps below
3)Execute the query: SELECT Account.Phone, Account.Name, Account.Type, Contact.LastName FROM Account, Contact WHERE Account.Id = Contact.AccountId (GIVES ERROR)

-Changing the order of the From part makes it run fine


  was:
Please refer to this forum thread for exact analysis/details: https://developer.jboss.org/thread/248796

Steps to reproduce at my end:
1) Use tables Account and Contact where AccountId in Contact is the child field for Id in Account.
2) Execute the queries as shown in the steps below
3)Execute the query: SELECT Account.Phone, Account.Name, Account.Type, Contact.LastName FROM Account, Contact WHERE Account.Id = Contact.AccountId (GIVES ERROR)

-Changing the order of the From part makes it run fine




> Issue while querying Salesforce using Teiid embedded. 
> ------------------------------------------------------
>
>                 Key: TEIID-3128
>                 URL: https://issues.jboss.org/browse/TEIID-3128
>             Project: Teiid
>          Issue Type: Bug
>            Reporter: Pranav K
>            Assignee: Steven Hawkins
>
> (I am using Teiid Embedded 8.8.0.Final)
> Please refer to this forum thread for exact analysis/details: https://developer.jboss.org/thread/248796
> Steps to reproduce at my end:
> 1) Use tables Account and Contact where AccountId in Contact is the child field for Id in Account.
> 2) Execute the queries as shown in the steps below
> 3)Execute the query: SELECT Account.Phone, Account.Name, Account.Type, Contact.LastName FROM Account, Contact WHERE Account.Id = Contact.AccountId (GIVES ERROR)
> -Changing the order of the From part makes it run fine



--
This message was sent by Atlassian JIRA
(v6.3.1#6329)