[teiid-issues] [JBoss JIRA] (TEIID-5846) Support "order by" by default in the salesforce translator

[Steven Hawkins (Jira)]

    [ https://issues.jboss.org/browse/TEIID-5846?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13813737#comment-13813737 ] 

Steven Hawkins edited comment on TEIID-5846 at 11/20/19 8:31 AM:
-----------------------------------------------------------------

Renat, there is an underlying bug in the ddl handling that is preventing the property from being set.  Please see TEIID-5850.

The workaround is to do something like:
{code}
CREATE FOREIGN DATA WRAPPER salesforce;
CREATE FOREIGN DATA WRAPPER mysalesforce type salesforce OPTIONS (supportsOrderBy true);
CREATE SERVER salesforce FOREIGN DATA WRAPPER mysalesforce OPTIONS ("resource-name" 'salesforce');
{code}

So that there is explicitly an "override" translator that sets the property.


was (Author: shawkins):
Renat, there is an underlying bug in the ddl handling that is preventing the property from being set.  Please see TEIID-5850.

The workaround is to do something like:
{code}
CREATE FOREIGN DATA WRAPPER salesforce;
CREATE FOREIGN DATA WRAPPER mysalesforce type salesforce OPTIONS (supportsOrderBy false);
CREATE SERVER salesforce FOREIGN DATA WRAPPER mysalesforce OPTIONS ("resource-name" 'salesforce');
{code}

So that there is explicitly an "override" translator that sets the property.

> Support "order by" by default in the salesforce translator
> ----------------------------------------------------------
>
>                 Key: TEIID-5846
>                 URL: https://issues.jboss.org/browse/TEIID-5846
>             Project: Teiid
>          Issue Type: Bug
>          Components: Salesforce Connector
>         Environment: teiid-spring-boot+spring-odata teiid+spring-data-salesforce
>            Reporter: Renat Eskenin
>            Priority: Major
>             Fix For: 13.1
>
>
> When we call simple request as
> salesforce-odata-facade/odata/salesforce/Product_License__c?$top=1&$select=Id
> request processing time is 1min. But this request processing by simple SOAP SOQL request is ~150ms.
> I think this do because teiid select all objects by ignoring top in request.



--
This message was sent by Atlassian Jira
(v7.13.8#713008)