[jbosstools-issues] [JBoss JIRA] Updated: (JBDS-1439) Teiid shows indexes as Tables

[Dmitry Geraskov (JIRA)]

     [ https://jira.jboss.org/browse/JBDS-1439?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Dmitry Geraskov updated JBDS-1439:
----------------------------------

    Attachment: index.PNG


> Teiid shows indexes as Tables
> -----------------------------
>
>                 Key: JBDS-1439
>                 URL: https://jira.jboss.org/browse/JBDS-1439
>             Project: Developer Studio (JBoss Developer Studio)
>          Issue Type: Bug
>          Components: teiid
>    Affects Versions: 4.0.0.Beta2
>            Reporter: Dmitry Geraskov
>            Assignee: Barry LaFond
>             Fix For: LATER
>
>         Attachments: index.PNG
>
>
> I use PostgreSQL.
> Look at attached image.
> When I tried to run Modelling->Preview Data I got:
> [JDBCExecutionException] 0: Error Code:0 Message:'ERROR: "customer_pk" is an index
>   Position: 42' error executing statement(s): [Prepared Values: [] SQL: SELECT "public"."customer_pk"."ssn" FROM "public"."customer_pk"]
> 1 [PSQLException]ERROR: "customer_pk" is an index
>   Position: 42
>         at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:88)
>         at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:263)

-- 
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira