[teiid-issues] [JBoss JIRA] (TEIID-5856) Teiid generate wrong request to salesforce

[ https://issues.jboss.org/browse/TEIID-5856?page=com.atlassian.jira.plugin... ] Renat Eskenin reopened TEIID-5856: ---------------------------------- I try to use import stats <?xml version="1.0" encoding="UTF-8"?> <vdb name="db" version="1"> <connection-type>BY_VERSION</connection-type> <property name="full-ddl" value="CREATE DATABASE db; USE DATABASE db; CREATE FOREIGN DATA WRAPPER salesforce; CREATE FOREIGN DATA WRAPPER mysalesforce type salesforce OPTIONS (supportsOrderBy true); CREATE SERVER salesforce FOREIGN DATA WRAPPER salesforce OPTIONS (&quot;resource-name&quot; 'salesforce'); CREATE SCHEMA sf SERVER salesforce; IMPORT FROM SERVER salesforce INTO sf OPTIONS(&quot;importer.useFullSchemaName&quot; 'false', &quot;importer.NormalizeNames&quot; 'false', &quot;import.modelAuditFields&quot; 'true', &quot;import.importStatstics&quot; 'true');"/> <model name="sf" type="PHYSICAL" visible="true"> <source connection-jndi-name="salesforce" name="salesforce" translator-name="salesforce"/> <metadata type="DDL"/> </model> <translator name="mysalesforce" type="salesforce"> <property name="supportsOrderBy" value="true"/> </translator> </vdb> But it has no effect, may be i used wrong params? And for another solution please give me example of using OPTIONS for this request. -- This message was sent by Atlassian Jira (v7.13.8#713008)