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

We have strange behavior with aliases

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major Major
    • 15.0
    • None
    • Salesforce Connector
    • None
    • DV Sprint 66
    • 1
      1. Make teiid spring boot salesforce application
      2. Call the SF SOQL with aliases

      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?

              rhn-engineering-shawkins Steven Hawkins
              3draven Renat Eskenin (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved:

                  Estimated:
                  Original Estimate - 5 hours
                  5h
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 5 hours
                  5h