[teiid-issues] [JBoss JIRA] (TEIID-4568) Modeshape query

[Steven Hawkins (JIRA)]

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

Steven Hawkins commented on TEIID-4568:
---------------------------------------

Seems more like a bug in modeshape as it's complaining on multiple predicates in the ON clause, which I would assume should be supported.  Any objections to moving this to modeshape?

> Modeshape query
> ---------------
>
>                 Key: TEIID-4568
>                 URL: https://issues.jboss.org/browse/TEIID-4568
>             Project: Teiid
>          Issue Type: Bug
>            Reporter: Tom Johnston
>            Assignee: Steven Hawkins
>              Labels: modeshape
>
> The following modeshape vdb query fails.
> select a.jcr_path, a.table_name ,b.jcr_name
> from "Relational_Model_View"."Table_Columns" a, "ModeShape"."xmi_model" b
> where a.jcr_path = b.jcr_path
> the error is:
> Error: TEIID30504 Remote org.teiid.core.TeiidProcessingException: TEIID30504 ModeShape: 0 TEIID11008:TEIID11004 Error executing statement(s): [SQL: SELECT g_1."jcr:path", g_0."mode:localName", g_2."jcr:name" FROM "relational:table" AS g_0 INNER JOIN "relational:column" AS g_1 ON ISCHILDNODE(g_1, g_0) INNER JOIN "xmi:model" AS g_2 ON g_1."jcr:path" = g_2."jcr:path" AND ISCHILDNODE(g_2, g_0)]
> SQLState:  50000
> ErrorCode: 30504



--
This message was sent by Atlassian JIRA
(v7.2.3#72005)