November 2013 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-2748) Ensure pushdown of multisource column expressions

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2748?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-2748. ----------------------------------- Labels: 8.6.0.CR1 (was: ) Fix Version/s: 8.6 Resolution: Done Added logic to detect when expressions can be pushed even if they can't immediately be evaluated. The logic should make it possible for multi-source logic to work in significantly more predicates and other expressions not directly supported by the target backend. In general the logic supersedes an existing check to see if a function can be pushed if it's fully evaluatable - it now basically handles all expressions. > Ensure pushdown of multisource column expressions > ------------------------------------------------- > > Key: TEIID-2748 > URL: https://issues.jboss.org/browse/TEIID-2748 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine > Reporter: Mark Addleman > Assignee: Steven Hawkins > Labels: 8.6.0.CR1 > Fix For: 8.6 > > > > The issue is that the criteria is not making it into the proper position for the multisource logic to have an effect. It is implicit that multisource required a translator that supported equality comparison at least. In this case adding the xpathValue function, because of weaknesses with the detection of a fully evaluatable, is then inhibiting the proper placement. That last one is easy to fix and I can ensure that more complex cases are covered as well. -- 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

10 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2747) Wrong results with merge join SORT_DISTINCT with a full sort that is distinct beyond the join columns

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-2747?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration updated TEIID-2747: ------------------------------------------- Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1033056, https://bugzilla.redhat.com/show_bug.cgi?id=1033292 (was: https://bugzilla.redhat.com/show_bug.cgi?id=1033056) > Wrong results with merge join SORT_DISTINCT with a full sort that is distinct beyond the join columns > ----------------------------------------------------------------------------------------------------- > > Key: TEIID-2747 > URL: https://issues.jboss.org/browse/TEIID-2747 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 7.4 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Priority: Blocker > Fix For: 8.4.1, 8.6 > > > To speed up processing of a sort merge join we attempt to eliminate extra comparisons by detecting if the equi-join column values are distinct. In plans where the sorted values are distinct beyond the equi-join values such that the equi-join column values are non-distinct, then incorrect results can be returned. -- 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

10 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2740) Support Direct Query Execution with MongoDB

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-2740?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration updated TEIID-2740: ------------------------------------------- Bugzilla Update: Perform Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1033077 > Support Direct Query Execution with MongoDB > ------------------------------------------- > > Key: TEIID-2740 > URL: https://issues.jboss.org/browse/TEIID-2740 > Project: Teiid > Issue Type: Enhancement > Components: Misc. Connectors > Affects Versions: 8.4 > Reporter: Ramesh Reddy > Assignee: Ramesh Reddy > Fix For: 8.4.1, 8.6 > > > Direct query execution in the MongoDB was not implemented completely. This needs to be fixed as this would be a very helpful enhancement. -- 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

10 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2736) MongoDB: failed to translate to mongo query with boolean value expression

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-2736?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-2736: ------------------------------------------------ Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1033077|https://bugzilla.redhat.com/show_bug.cgi?id=1033077] from ASSIGNED to MODIFIED > MongoDB: 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: Beta2, teiid > Fix For: 8.4.1, 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

10 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2740) Support Direct Query Execution with MongoDB

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-2740?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-2740: ------------------------------------------------ Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1033077|https://bugzilla.redhat.com/show_bug.cgi?id=1033077] from ASSIGNED to MODIFIED > Support Direct Query Execution with MongoDB > ------------------------------------------- > > Key: TEIID-2740 > URL: https://issues.jboss.org/browse/TEIID-2740 > Project: Teiid > Issue Type: Enhancement > Components: Misc. Connectors > Affects Versions: 8.4 > Reporter: Ramesh Reddy > Assignee: Ramesh Reddy > Fix For: 8.4.1, 8.6 > > > Direct query execution in the MongoDB was not implemented completely. This needs to be fixed as this would be a very helpful enhancement. -- 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

10 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2736) MongoDB: failed to translate to mongo query with boolean value expression

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-2736?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration updated TEIID-2736: ------------------------------------------- Bugzilla Update: Perform Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1033077 > MongoDB: 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: Beta2, teiid > Fix For: 8.4.1, 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

10 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2741) Failed to execute nested function with MongoDB translator

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-2741?page=com.atlassian.jira.plugin... ] Ramesh Reddy updated TEIID-2741: -------------------------------- Fix Version/s: 8.4.1 > Failed to execute nested function with MongoDB translator > --------------------------------------------------------- > > Key: TEIID-2741 > URL: https://issues.jboss.org/browse/TEIID-2741 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.4 > Reporter: Ramesh Reddy > Assignee: Ramesh Reddy > Fix For: 8.4.1, 8.6 > > > failed to execute a call like > {code} > select concat(lastname, concat(",", firstname)) from user > {code} > single concat works correctly -- 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

10 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2736) MongoDB: 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 updated TEIID-2736: -------------------------------- Fix Version/s: 8.4.1 > MongoDB: 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: Beta2, teiid > Fix For: 8.4.1, 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

10 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2740) Support Direct Query Execution with MongoDB

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-2740?page=com.atlassian.jira.plugin... ] Ramesh Reddy updated TEIID-2740: -------------------------------- Fix Version/s: 8.4.1 > Support Direct Query Execution with MongoDB > ------------------------------------------- > > Key: TEIID-2740 > URL: https://issues.jboss.org/browse/TEIID-2740 > Project: Teiid > Issue Type: Enhancement > Components: Misc. Connectors > Affects Versions: 8.4 > Reporter: Ramesh Reddy > Assignee: Ramesh Reddy > Fix For: 8.4.1, 8.6 > > > Direct query execution in the MongoDB was not implemented completely. This needs to be fixed as this would be a very helpful enhancement. -- 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

10 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2745) Evaluatable subquery in ON clause produces invalid query

by Johnathon Lee (JIRA)

[ https://issues.jboss.org/browse/TEIID-2745?page=com.atlassian.jira.plugin... ] Johnathon Lee updated TEIID-2745: --------------------------------- Fix Version/s: 7.7.9 > Evaluatable subquery in ON clause produces invalid query > -------------------------------------------------------- > > Key: TEIID-2745 > URL: https://issues.jboss.org/browse/TEIID-2745 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 7.7 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.6, 7.7.9 > > > Using an evaluatable subquery, such as a scalar subquery in an outer join on clause will result in all criteria being removed and an invalid source query being issued. > For example: > with a (x, y, z) as (select e1, e2, e3 from pm1.g1 limit 1) SELECT pm2.g1.e1 from pm2.g1 left outer join pm2.g2 on (pm2.g1.e2 = pm2.g2.e2 and pm2.g1.e1 = (select a.x from a)) > And a source that doesn't support with (or the with clause cannot be pushed as part of the main query), then the evaluation of the scalar subquery will block and cause the issue. -- 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

10 years, 5 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues November 2013