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

[Steven Hawkins (JIRA)]

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

Steven Hawkins commented on TEIID-4573:
---------------------------------------

That's not related to this fix directly as the new source query has the expected predicate placement.  This is another issue with ModeShape/JCR SQL2 in that it allows only literal comparison predicates in the where clause.  There is a Teiid capability that requires literal only comparisons - but only if the predicate is rejected as an allowed join criteria, which is not the case here.  Expanding the notion of allowed join criteria to include functional expressions seems well beyond the norm of what we want to capture in capabilities, so I would suggest looking for a workaround by changing the user query.

> Modeshape query
> ---------------
>
>                 Key: TEIID-4573
>                 URL: https://issues.jboss.org/browse/TEIID-4573
>             Project: Teiid
>          Issue Type: Bug
>          Components: Misc. Connectors
>    Affects Versions: 8.0
>            Reporter: Tom Johnston
>            Assignee: Steven Hawkins
>              Labels: modeshape
>             Fix For: 9.2, 9.1.2
>
>
> 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)