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

Duplicate metadata for multisource models

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Done
    • 7.5
    • 7.7, 8.0
    • None
    • None
    • Hide

      Create two multi-source models as per vdb, create two data sources per model. Deploy, start jboss. Connect to Teiid with Eclipse Database Development. To see duplicate tables - browse Teiid Server database or issue this SQL: select * from Sys.Tables; (see sql results attached).

      Show
      Create two multi-source models as per vdb, create two data sources per model. Deploy, start jboss. Connect to Teiid with Eclipse Database Development. To see duplicate tables - browse Teiid Server database or issue this SQL: select * from Sys.Tables; (see sql results attached).

    Description

      When more than one multi-source model defined in single VDB, the tables from one multi-source schema appear in the another one. See screenshot and sample vdb attached. The issue reproducible on our side with file, h2 and hsqldb multi-source models. We have to define only one multi-source model per vdb to avoid the problem.

      Attachments

        1. both_multisource.jpg
          both_multisource.jpg
          129 kB
        2. chorus-vdb.xml
          1 kB
        3. one_multisource.jpg
          one_multisource.jpg
          211 kB
        4. select.txt
          108 kB

        Activity

          People

            rhn-engineering-shawkins Steven Hawkins
            rokhmanov_jira Andriy Rokhmanov (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: