November 2013 - teiid-issues - Jboss List Archives

[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: --------------------------------------- Yes it is valid. A predicate is just a boolean value expression. > 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

1
0
0 / 0

[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 do not think I have ever seen select expressions with criteria specified in the projection like {code} select "grade", "name", "score", "state", "grade" as "test", ("name" = "state") as "name2" from "mongoDBDS"."grades" where "grade" = 'B' {code} Is this valid? > 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

1
0
0 / 0

[JBoss JIRA] (TEIID-2733) TEIID-2633 goes too far

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-2733?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration updated TEIID-2733: ------------------------------------------- Bugzilla Update: Perform Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1029914 > TEIID-2633 goes too far > ----------------------- > > Key: TEIID-2733 > URL: https://issues.jboss.org/browse/TEIID-2733 > Project: Teiid > Issue Type: Quality Risk > Components: Query Engine > Affects Versions: 8.4.1, 8.5, 7.7.8 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.4.1, 8.6 > > > TEIID-2633 can have a negative performance impact if discovered transitive criteria is removed that could help filter more rows from a multi-column dependent join. -- 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

1
0
0 / 0

[JBoss JIRA] (TEIID-2733) TEIID-2633 goes too far

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-2733?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-2733: ------------------------------------------------ Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1029914|https://bugzilla.redhat.com/show_bug.cgi?id=1029914] from NEW to ASSIGNED > TEIID-2633 goes too far > ----------------------- > > Key: TEIID-2733 > URL: https://issues.jboss.org/browse/TEIID-2733 > Project: Teiid > Issue Type: Quality Risk > Components: Query Engine > Affects Versions: 8.4.1, 8.5, 7.7.8 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.4.1, 8.6 > > > TEIID-2633 can have a negative performance impact if discovered transitive criteria is removed that could help filter more rows from a multi-column dependent join. -- 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

1
0
0 / 0

[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 updated TEIID-2736: -------------------------------- Fix Version/s: 8.6 > 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

1
0
0 / 0

[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 reassigned TEIID-2736: ----------------------------------- Assignee: Ramesh Reddy (was: Steven Hawkins) > 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 > > 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

1
0
0 / 0

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

by Ivan Chan (JIRA)

Ivan Chan created TEIID-2736: -------------------------------- Summary: 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: Steven Hawkins 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

1
0
0 / 0

[JBoss JIRA] (TEIID-2735) applied the nightly build teiid-8.6.0.Alpha2-20131005.071615-1-jboss-dist.zip on Jboss-EAP 6.1 and cannot deploy my vdb onto the teiid server

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2735?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-2735. ----------------------------------- Resolution: Rejected moved to https://community.jboss.org/message/845532 > applied the nightly build teiid-8.6.0.Alpha2-20131005.071615-1-jboss-dist.zip on Jboss-EAP 6.1 and cannot deploy my vdb onto the teiid server > --------------------------------------------------------------------------------------------------------------------------------------------- > > Key: TEIID-2735 > URL: https://issues.jboss.org/browse/TEIID-2735 > Project: Teiid > Issue Type: Feature Request > Reporter: vidya vangeepuram > Assignee: Steven Hawkins > > When i try to deploy the vdb after applying the nightly version Teiid teiid-8.6.0.Alpha2-20131005.071615-1-jboss-dist.zip, i get > "VDB Not Deployed.One or more models in VDB are either missing a translator name or have a translator name that is not found on the current teiid server.” -- 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

1
0
0 / 0

[JBoss JIRA] (TEIID-2733) TEIID-2633 goes too far

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2733?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-2733: ---------------------------------- Fix Version/s: 8.4.1 > TEIID-2633 goes too far > ----------------------- > > Key: TEIID-2733 > URL: https://issues.jboss.org/browse/TEIID-2733 > Project: Teiid > Issue Type: Quality Risk > Components: Query Engine > Affects Versions: 8.4.1, 8.5, 7.7.8 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.4.1, 8.6 > > > TEIID-2633 can have a negative performance impact if discovered transitive criteria is removed that could help filter more rows from a multi-column dependent join. -- 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

1
0
0 / 0

[JBoss JIRA] (TEIID-2735) applied the nightly build teiid-8.6.0.Alpha2-20131005.071615-1-jboss-dist.zip on Jboss-EAP 6.1 and cannot deploy my vdb onto the teiid server

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2735?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-2735: --------------------------------------- This sounds more like a forum post rather than an issue. What is the error code? Do you additional logs indicating what is the matter? Did the same vdb work in another version? > applied the nightly build teiid-8.6.0.Alpha2-20131005.071615-1-jboss-dist.zip on Jboss-EAP 6.1 and cannot deploy my vdb onto the teiid server > --------------------------------------------------------------------------------------------------------------------------------------------- > > Key: TEIID-2735 > URL: https://issues.jboss.org/browse/TEIID-2735 > Project: Teiid > Issue Type: Feature Request > Reporter: vidya vangeepuram > Assignee: Steven Hawkins > > When i try to deploy the vdb after applying the nightly version Teiid teiid-8.6.0.Alpha2-20131005.071615-1-jboss-dist.zip, i get > "VDB Not Deployed.One or more models in VDB are either missing a translator name or have a translator name that is not found on the current teiid server.” -- 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

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues November 2013