[JBoss JIRA] (TEIID-2737) Rename native query procedure
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-2737?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-2737:
---------------------------------------
The api will be easy to clean up, but do we want to change (in a way that doesn't break backwards compatibility) the default procedure name 'native'. My initial thought is to just leave it alone or use a system property to set the default.
> Rename native query procedure
> -----------------------------
>
> Key: TEIID-2737
> URL: https://issues.jboss.org/browse/TEIID-2737
> Project: Teiid
> Issue Type: Quality Risk
> Components: Documentation, Query Engine
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
>
> We have two somewhat related native querying features - the native-query extension property used on tables/procedures/functions, and a native procedure that can be exposed to issue arbitrary statements.
> It has been proposed to rename the native query procedure to the direct query procedure (which matches the translator api).
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
11 years, 1 month
[JBoss JIRA] (TEIID-2737) Rename native query procedure
by Steven Hawkins (JIRA)
Steven Hawkins created TEIID-2737:
-------------------------------------
Summary: Rename native query procedure
Key: TEIID-2737
URL: https://issues.jboss.org/browse/TEIID-2737
Project: Teiid
Issue Type: Quality Risk
Components: Documentation, Query Engine
Reporter: Steven Hawkins
Assignee: Steven Hawkins
We have two somewhat related native querying features - the native-query extension property used on tables/procedures/functions, and a native procedure that can be exposed to issue arbitrary statements.
It has been proposed to rename the native query procedure to the direct query procedure (which matches the translator api).
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
11 years, 1 month
[JBoss JIRA] (TEIID-2736) MongoBD: failed to translate to mongo query with boolean value expression
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-2736?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-2736:
---------------------------------------
We don't get that specific. Either you support select expressions or not.
> MongoBD: failed to translate to mongo query with boolean value expression
> --------------------------------------------------------------------------
>
> Key: TEIID-2736
> URL: https://issues.jboss.org/browse/TEIID-2736
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 8.6
> Environment: Teiid 8.6 beta with mongoDB
> Reporter: Ivan Chan
> Assignee: Ramesh Reddy
> Labels: teiid
> Fix For: 8.6
>
>
> Fail to translate the following SQL to mongo query:
> select "grade",
> "name",
> "score",
> "state",
> "grade" as "test",
> ("name" = "state") as "name2"
> from "mongoDBDS"."grades"
> where "grade" = 'B'
> However, it works with the query contains group by and boolean value expression:
> elect "grade" as "test",
> "grade",
> ("name" = "state") as "name2",
> sum("score") as "sum_score"
> from "mongoDBDS"."grades"
> where "grade" = 'B'
> group by "grade", "grade", ("name" = "state")
> order by "grade", "test", "name2"
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
11 years, 1 month
[JBoss JIRA] (TEIID-2736) MongoBD: failed to translate to mongo query with boolean value expression
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-2736?page=com.atlassian.jira.plugin... ]
Ramesh Reddy commented on TEIID-2736:
-------------------------------------
I always only wrote to handle ColumnReferences and Functions (pushdown) in SELECT. Obviously I can not push this down to the source nor there is similar construct in MongoDB, is there a capability to stop sending this type of queries to Translator, or anyway to evaluate them in Translator?
> MongoBD: failed to translate to mongo query with boolean value expression
> --------------------------------------------------------------------------
>
> Key: TEIID-2736
> URL: https://issues.jboss.org/browse/TEIID-2736
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 8.6
> Environment: Teiid 8.6 beta with mongoDB
> Reporter: Ivan Chan
> Assignee: Ramesh Reddy
> Labels: teiid
> Fix For: 8.6
>
>
> Fail to translate the following SQL to mongo query:
> select "grade",
> "name",
> "score",
> "state",
> "grade" as "test",
> ("name" = "state") as "name2"
> from "mongoDBDS"."grades"
> where "grade" = 'B'
> However, it works with the query contains group by and boolean value expression:
> elect "grade" as "test",
> "grade",
> ("name" = "state") as "name2",
> sum("score") as "sum_score"
> from "mongoDBDS"."grades"
> where "grade" = 'B'
> group by "grade", "grade", ("name" = "state")
> order by "grade", "test", "name2"
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
11 years, 1 month