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

DDL server and foreign data wrapper handling is unclear

    XMLWordPrintable

Details

    • Quality Risk
    • Resolution: Done
    • Major
    • 13.0
    • None
    • Query Engine
    • None
    • DV Sprint 55
    • 2
    • 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.

      Attachments

        Issue Links

          is related to

          Task - Represents a small unit of work that is not end-user facing. TEIIDSB-139 Remove the usage of dummy create foreign data wrapper statements

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Resolved
          relates to

          Bug - A problem that impairs or prevents the functions of the product. TEIID-5846 Support "order by" by default in the salesforce translator

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Resolved

          Activity

            People

              rhn-engineering-shawkins Steven Hawkins
              rhn-engineering-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