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.