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

[ https://issues.jboss.org/browse/TEIID-5846?page=com.atlassian.jira.plugin... ] 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. -- This message was sent by Atlassian Jira (v7.13.8#713008)