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

Issue while querying Salesforce.

    XMLWordPrintable

Details

    • 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)

    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

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: