[teiid-issues] [JBoss JIRA] (TEIID-3012) ModeShape requires to use 'JOIN' instead of ', ' when joining 2 tables
Steven Hawkins (JIRA)
issues at jboss.org
Thu Jun 19 12:36:24 EDT 2014
[ https://issues.jboss.org/browse/TEIID-3012?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Steven Hawkins resolved TEIID-3012.
-----------------------------------
Fix Version/s: 8.8
(was: 8.9)
Resolution: Done
Applied Van's changes to 8.7.x and master.
> ModeShape requires to use 'JOIN' instead of ',' when joining 2 tables
> ---------------------------------------------------------------------
>
> Key: TEIID-3012
> URL: https://issues.jboss.org/browse/TEIID-3012
> Project: Teiid
> Issue Type: Bug
> Security Level: Public(Everyone can see)
> Components: Misc. Connectors
> Affects Versions: 8.4.2
> Reporter: Van Halbert
> Assignee: Steven Hawkins
> Fix For: 8.7.1, 8.8
>
>
> Issuing either query:
> SELECT c.jcr_name FROM relational_table AS t, relational_column AS c WHERE JCR.JCR_ISCHILDNODE(c.jcr_path, t.jcr_path)
> SELECT c.jcr_name FROM relational_table AS t JOIN relational_column AS c ON JCR.JCR_ISCHILDNODE(c.jcr_path,t.jcr_path)
> produces the following exception:
> Caused by: javax.jcr.query.InvalidQueryException: The JCR-SQL2 query "SELECT g_1."jcr:name", g_1."jcr:path" FROM "relational:table" AS g_0, "relational:column" AS g_1 WHERE ISCHILDNODE(g_1, g_0)" is not well-formed: Unexpected token ',' at line 1, column 66
> at org.modeshape.jcr.JcrQueryManager.createQuery(JcrQueryManager.java:146)
> at org.modeshape.jcr.JcrQueryManager.createQuery(JcrQueryManager.java:101)
> at org.modeshape.jdbc.delegate.LocalRepositoryDelegate.execute(LocalRepositoryDelegate.java:139)
> at org.modeshape.jdbc.JcrStatement.execute(JcrStatement.java:429)
> ... 15 more
> And after a discussion with Randall, it seems ModeShape needs JOIN in the syntax, and not ',' to join the tables.
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
More information about the teiid-issues
mailing list