Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-3128

Issue while querying Salesforce.

XMLWordPrintable

    • Hide

      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

      Show
      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
    • Workaround Exists
    • Hide

      Change the order of the FROM part of the query

      SELECT Account.Phone, Account.Name, Account.Type, Contact.LastName FROM Contact, Account WHERE Contact.AccountId = Account.Id (RUNS FINE)

      Show
      Change the order of the FROM part of the query SELECT Account.Phone, Account.Name, Account.Type, Contact.LastName FROM Contact, Account WHERE Contact.AccountId = Account.Id (RUNS FINE)

      (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

              rhn-engineering-shawkins Steven Hawkins
              pranavk Pranav K (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Created:
                Updated:
                Resolved: