[JBoss JIRA] (TEIID-3012) ModeShape requires to use 'JOIN' instead of ', ' when joining 2 tables
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIID-3012?page=com.atlassian.jira.plugin... ]
Van Halbert updated TEIID-3012:
-------------------------------
Git Pull Request: https://github.com/teiid/teiid/pull/262
> 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: Van Halbert
>
> 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)
9 years, 11 months
[JBoss JIRA] (TEIID-3012) ModeShape requires to use 'JOIN' instead of ', ' when joining 2 tables
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIID-3012?page=com.atlassian.jira.plugin... ]
Van Halbert updated TEIID-3012:
-------------------------------
Assignee: Steven Hawkins (was: Van Halbert)
> 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
>
> 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)
9 years, 11 months
[JBoss JIRA] (TEIID-3012) ModeShape requires to use 'JOIN' instead of ', ' when joining 2 tables
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIID-3012?page=com.atlassian.jira.plugin... ]
Van Halbert commented on TEIID-3012:
------------------------------------
That worked, thanks.
START DATA SRC COMMAND: startTime=2014-06-18 15:27:50.671 requestID=U4Qcejb7UVYk.8 sourceCommandID=1 executionID=0 txID=null modelName=ModeShape translatorName=modeshape sessionID=U4Qcejb7UVYk principal=user@teiid-security sql=SELECT g_1.jcr_name FROM ModeShape.relational_table AS g_0 INNER JOIN ModeShape.relational_column AS g_1 ON JCR.JCR_ISCHILDNODE(g_1.jcr_path, g_0.jcr_path) = TRUE
15:27:50,679 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue17) Source-specific command: SELECT g_1."jcr:name" FROM "relational:table" AS g_0 INNER JOIN "relational:column" AS g_1 ON ISCHILDNODE(g_1, g_0)
I'll create a PR.
> 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: Van Halbert
>
> 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)
9 years, 11 months
[JBoss JIRA] (TEIID-3012) ModeShape requires to use 'JOIN' instead of ', ' when joining 2 tables
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3012?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-3012:
---------------------------------------
You'll want ExecutionFactory.useAnsiJoin to return true, and unless their parser accepts "INNER JOIN" you'll have to modify the result sql to just JOIN instead.
> 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: Van Halbert
>
> 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)
9 years, 11 months
[JBoss JIRA] (TEIID-3012) ModeShape requires to use 'JOIN' instead of ', ' when joining 2 tables
by Van Halbert (JIRA)
Van Halbert created TEIID-3012:
----------------------------------
Summary: 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: Van Halbert
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, c.jcr_path 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)
9 years, 11 months
[JBoss JIRA] (TEIID-3012) ModeShape requires to use 'JOIN' instead of ', ' when joining 2 tables
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIID-3012?page=com.atlassian.jira.plugin... ]
Van Halbert updated TEIID-3012:
-------------------------------
Description:
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.
was:
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, c.jcr_path 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.
> 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: Van Halbert
>
> 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)
9 years, 11 months
[JBoss JIRA] (TEIID-2982) Allow to change visibility to a model from imported vdb
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-2982?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-2982:
---------------------------------------
It looks like we'll have to change where/how we store the visibility flag to make this possible. From a metadata perspective we can go one of two ways:
Reuse the existing model element -
{code}<model name="x" type="IMPORTED" visible="false">{code}
This would probably be the direction if we envision even more complicated override scenarios.
Add the info to the import with a stripped down model element -
{code}<import-vdb name="foo" version="1"><model name="x" visible="false"></import-vdb>{code}
> Allow to change visibility to a model from imported vdb
> -------------------------------------------------------
>
> Key: TEIID-2982
> URL: https://issues.jboss.org/browse/TEIID-2982
> Project: Teiid
> Issue Type: Feature Request
> Security Level: Public(Everyone can see)
> Affects Versions: 8.7
> Reporter: Kenichi Takemura
> Assignee: Steven Hawkins
>
> When a new vdb uses import-vdb, changing(override) visibility to a model from imported vdb would need to hide non-related model to the new vdb.
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
9 years, 11 months