[
https://issues.jboss.org/browse/TEIID-5850?page=com.atlassian.jira.plugin...
]
Steven Hawkins updated TEIID-5850:
----------------------------------
Workaround Description:
Use an intermediate "override" data wrapper:
{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}
DDL server and foreign data wrapper handling is unclear
-------------------------------------------------------
Key: TEIID-5850
URL:
https://issues.jboss.org/browse/TEIID-5850
Project: Teiid
Issue Type: Bug
Components: Query Engine
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Priority: Critical
Fix For: 13.0, 12.2.2, 12.3.1
Original Estimate: 6 hours
Remaining Estimate: 6 hours
CREATE server statements in DDL are effectively ignored in the conversion to runtime
state - they are simply validated. Similarly a CREATE foreign data wrapper statement that
does not specify a type is ignored.
Attempting to do something like:
{code}
CREATE FOREIGN DATA WRAPPER salesforce;
CREATE SERVER salesforce FOREIGN DATA WRAPPER salesforce OPTIONS
("resource-name" 'salesforce', supportsOrderBy true);
{code}
or
{code}
CREATE FOREIGN DATA WRAPPER salesforce OPTIONS (supportsOrderBy true);
CREATE SERVER salesforce FOREIGN DATA WRAPPER salesforce OPTIONS
("resource-name" 'salesforce');
{code}
will not result in supportsOrderBy being set on the translator.
--
This message was sent by Atlassian Jira
(v7.13.8#713008)