[teiid-issues] [JBoss JIRA] (TEIID-5846) top in odata query is not working

[Steven Hawkins (Jira)]

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

Steven Hawkins commented on TEIID-5846:
---------------------------------------

> May be teiid have programmatically methods to set this property?

I had thought application properties would be applicable, but that is not the case.  Another issue (spring boot specific) could be spawned for that.

> Can i create server in vdb manner as thin wraper around of salesforce auto generated vdb metadata?

Yes, the vdb would look like:

CREATE DATABASE db ;
USE DATABASE db;
CREATE FOREIGN DATA WRAPPER salesforce;
CREATE SERVER samplesf FOREIGN DATA WRAPPER salesforce OPTIONS ("resource-name" 'samplesf', supportsOrderBy true);
CREATE SCHEMA sf SERVER samplesf;
IMPORT FROM SERVER samplesf INTO sf OPTIONS("importer.useFullSchemaName" 'false');

> Or may be exists example vdb+salesforce?

I don't see a specific example unfortunately.

> top in odata query is not working
> ---------------------------------
>
>                 Key: TEIID-5846
>                 URL: https://issues.jboss.org/browse/TEIID-5846
>             Project: Teiid
>          Issue Type: Bug
>          Components: OData, Salesforce Connector
>         Environment: teiid-spring-boot+spring-odata teiid+spring-data-salesforce
>            Reporter: Renat Eskenin
>            Priority: Major
>
> 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)