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

DDL server and foreign data wrapper handling is unclear

    Details

    • Type: Quality Risk
    • Status: Resolved (View Workflow)
    • Priority: Major
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: 13.0
    • Component/s: Query Engine
    • Labels:
      None
    • Sprint:
      DV Sprint 55
    • Story Points:
      2
    • Estimated Difficulty:
      Low

      Description

      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.

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  shawkins Steven Hawkins
                  Reporter:
                  shawkins Steven Hawkins
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  2 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Time Tracking

                    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