[JBoss JIRA] (TEIID-4573) Modeshape query
- First Post
- Replies
- Stats
-
Go to
- ----- 2026 -----
- April
- March
- February
- January
- ----- 2025 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2024 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2023 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2022 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2021 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2020 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2019 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2018 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2017 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2016 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2015 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2014 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2013 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2012 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2011 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2010 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2009 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
[
https://issues.jboss.org/browse/TEIID-4573?page=com.atlassian.jira.plugin...
]
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)
3445
days inactive
3445
days old
0 comments
1 participants
tags (0)
participants (1)
-
Steven Hawkins (JIRA)