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

[Kenichi Takemura (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-2961?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12968010#comment-12968010 ] 

Kenichi Takemura commented on TEIID-2961:
-----------------------------------------

Hi I see sessions from both INFORMATION_SCHEMA and PUBLIC are list.

1: INFORMATION_SCHEMA SESSIONS (1)
2: INFORMATION_SCHEMA SESSIONS (2)
3: INFORMATION_SCHEMA SESSIONS (3)
4: INFORMATION_SCHEMA SESSIONS (4)
5: INFORMATION_SCHEMA SESSIONS (5)
6: INFORMATION_SCHEMA SESSIONS (6)
7: PUBLIC SESSIONS (1)
8: PUBLIC SESSIONS (2)
9: PUBLIC SESSIONS (3)
10: PUBLIC SESSIONS (4)
11: PUBLIC SESSIONS (5)
12: PUBLIC SESSIONS (6)
13: PUBLIC SESSIONS (7)
14: PUBLIC SESSIONS (8)
15: PUBLIC SESSIONS (9)
16: PUBLIC SESSIONS (10)
17: PUBLIC SESSIONS (11)

> 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'.
> 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)