Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-5850

DDL server and foreign data wrapper handling is unclear

XMLWordPrintable

    • Icon: Quality Risk Quality Risk
    • Resolution: Done
    • Icon: Major Major
    • 13.0
    • None
    • Query Engine
    • None
    • DV Sprint 55
    • 2
    • Low

      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:

      CREATE FOREIGN DATA WRAPPER salesforce;
CREATE SERVER salesforce FOREIGN DATA WRAPPER salesforce OPTIONS ("resource-name" 'salesforce', supportsOrderBy true);

      or

      CREATE FOREIGN DATA WRAPPER salesforce OPTIONS (supportsOrderBy true);
CREATE SERVER salesforce FOREIGN DATA WRAPPER salesforce OPTIONS ("resource-name" 'salesforce');

      will not result in supportsOrderBy being set on the translator.

              rhn-engineering-shawkins Steven Hawkins
              rhn-engineering-shawkins Steven Hawkins
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved:

                  Estimated:
                  Original Estimate - 6 hours
                  6h
                  Remaining:
                  Time Spent - 4 hours Remaining Estimate - 2 hours
                  2h
                  Logged:
                  Time Spent - 4 hours Remaining Estimate - 2 hours
                  4h