[teiid-issues] [JBoss JIRA] (TEIID-4573) Modeshape query
[
https://issues.jboss.org/browse/TEIID-4573?page=com.atlassian.jira.plugin...
]
Van Halbert commented on TEIID-4573:
------------------------------------
Created a jdbc patch and still getting:
Caused by: javax.jcr.query.InvalidQueryException: The JCR-SQL2 query "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 ISCHILDNODE(g_2, g_0)
WHERE g_1."jcr:path" = g_2."jcr:path"" is not well-formed:
Expecting literal and unable to parse 'g_2."jcr:path"' at line 1, column
233 as a double
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)