[teiid-issues] [JBoss JIRA] (TEIID-5850) DDL server and foreign data wrapper handling is unclear

[Steven Hawkins (Jira)]

Steven Hawkins created TEIID-5850:
-------------------------------------

             Summary: 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
             Fix For: 13.0, 12.2.2, 12.3.1


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)