Uploaded image for project: 'Talend Unified Platform'
  1. Talend Unified Platform
  2. TUP-27471

Schemas for synonyms unordered

Apply templateInsert Lucidchart Diagram
    XMLWordPrintable

Details

    • Bug
    • Status: New
    • Minor
    • Resolution: Unresolved
    • None
    • None
    • None
    • Hide

      Oracle database 12/18/19:

      In schema1: create view. grant select to schema2.

      In schema2: create synonym for view.

      In Talend 7.3.1:

      In Metadata create db connection for schema2.

      Retrieve synonym schema for view

      Show
      Oracle database 12/18/19: In schema1: create view. grant select to schema2. In schema2: create synonym for view. In Talend 7.3.1: In Metadata create db connection for schema2. Retrieve synonym schema for view
    • All
    • Small

    Description

      When importing a schema for an Oracle database view which is available via a synonym (original view located in another schema than connected to) then the attributes in the imported metadata are not in their original order.

      (I also made the experience that a built-in schema entered manually for a db component does not show the attributes in the order they were stored as soon as the schema is reopened again!)

      Attachments

        Activity

          People

            Unassigned Unassigned
            dstreun Dieter Streun
            Votes:
            1 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated: