[teiid-issues] [JBoss JIRA] (TEIID-4573) Modeshape query
Horia Chiorean (JIRA)
issues at jboss.org
Tue Nov 15 02:41:02 EST 2016
[ https://issues.jboss.org/browse/TEIID-4573?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13322415#comment-13322415 ]
Horia Chiorean commented on TEIID-4573:
---------------------------------------
[~van.halbert]: you are correct, the grammar for {{ComparisonConstraint}} looks like:
{code}
Comparison ::= DynamicOperand Operator StaticOperand
{code}
so in the previous query the right hand side of the {{=}} constraint would not work anyway.
I was referring to the fact that {{DynamicOperand}} for {{PropertyValue}} looks like this:
{code}
PropertyValue ::= [selectorName'.'] propertyName
{code}
and {{propertyName}} conforms to the "generic" Name grammar which is
{code}
Name ::= '[' quotedName ']' | '[' simpleName ']' | simpleName
{code}
So in the above query, on the left-hand side (assuming the right-hand side was a {{StaticOperand}}), using {{selector."propertyName"}} would not be a valid construct.
> 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)
More information about the teiid-issues
mailing list