[teiid-issues] [JBoss JIRA] (TEIID-5850) DDL server and foreign data wrapper handling is unclear
Steven Hawkins (Jira)
issues at jboss.org
Mon Dec 9 19:17:00 EST 2019
[ https://issues.redhat.com/browse/TEIID-5850?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13823051#comment-13823051 ]
Steven Hawkins commented on TEIID-5850:
---------------------------------------
Mostly. create server will take options only for the connection still, so instead of three statements:
CREATE FOREIGN DATA WRAPPER salesforce;
CREATE FOREIGN DATA WRAPPER mysalesforce TYPE salesforce (supportsOrderby true);
CREATE SERVER myServer FOREIGN DATA WRAPPER mysalesforce;
You just have two:
CREATE FOREIGN DATA WRAPPER mysalesforce TYPE salesforce (supportsOrderby true);
CREATE SERVER myServer FOREIGN DATA WRAPPER mysalesforce;
> DDL server and foreign data wrapper handling is unclear
> -------------------------------------------------------
>
> Key: TEIID-5850
> URL: https://issues.redhat.com/browse/TEIID-5850
> Project: Teiid
> Issue Type: Quality Risk
> Components: Query Engine
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Priority: Major
> Fix For: 13.0
>
> Original Estimate: 6 hours
> Time Spent: 4 hours
> Remaining Estimate: 2 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)
More information about the teiid-issues
mailing list