[teiid-issues] [JBoss JIRA] (TEIID-2961) TEIID60016 Duplicate Column with h2 database

[Kenichi Takemura (JIRA)]

Kenichi Takemura created TEIID-2961:
---------------------------------------

             Summary: TEIID60016 Duplicate Column with h2 database
                 Key: TEIID-2961
                 URL: https://issues.jboss.org/browse/TEIID-2961
             Project: Teiid
          Issue Type: Bug
    Affects Versions: 8.7
            Reporter: Kenichi Takemura
            Assignee: Steven Hawkins


I am trying to deploy a vdb.xml that has a physical datasouce with h2 translator. Teiid fails to deploy it with error 'TEIID60016 Duplicate Column with h2 database' (Cannot import)
Source database has a table that is 'sessions'. It seems getMetadata() from h2 database returns more columns for sessions table(user database + metadata for h2 itself?).

It getting Duplicated 'ID' columns.

On production we use mysql but on our test we want to use h2.

Is this a bug in Teiid?
Is there any workaround?



--
This message was sent by Atlassian JIRA
(v6.2.3#6260)