[JBoss JIRA] (TEIID-2844) remove unauthorized columns from select *
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-2844?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-2844:
---------------------------------------
One qualm from a pooling perspective is that failover/load-balancing is done without a portable session, so the setting will be lost. However since this seems like a development time concern (which is likely not clustered) and something that we can add additional client side handling for, this seems sufficient for now.
> remove unauthorized columns from select *
> -----------------------------------------
>
> Key: TEIID-2844
> URL: https://issues.jboss.org/browse/TEIID-2844
> Project: Teiid
> Issue Type: Enhancement
> Components: Query Engine
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Fix For: 8.7
>
>
> For ease of use with entitlement checking enabled, user queries with select * and *.tbl, should simply not treat unauthorized columns as selectable.
--
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, 10 months
[JBoss JIRA] (TEIID-2853) Aggregation fails with select all
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-2853?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-2853.
-----------------------------------
Resolution: Done
The expression mapping visitor logic was not handling multipleelementsymbols (used for select all and qualified select all), which meant that the mapping performed by the creation of the grouping node had no effect. The workaround is to use a fully expanded select.
> Aggregation fails with select all
> ---------------------------------
>
> Key: TEIID-2853
> URL: https://issues.jboss.org/browse/TEIID-2853
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 8.1
> Reporter: Alex K.
> Assignee: Steven Hawkins
> Fix For: 8.7
>
>
> This query fails for me on Teiid 8.1 and 8.6
> {code:sql}
> WITH qry_0 as
> (SELECT
> floor(t.f) AS a1, floor(t2.f) as b1
> FROM
> mysql.test_e AS t, oracle.test_e as t2 WHERE (t.f=t2.f)
> GROUP BY
> t.f, t2.f)
> SELECT * from qry_0 GROUP BY a1, b1;
> {code}
> This is the exception
> {code}
> 01:18:03,883 ERROR [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue16) qioVIE+5j6a2 TEIID30019 Unexpected exception forrequest qioVIE+5j6a2.9: java.lang.NullPointerException
> at org.teiid.query.processor.relational.GroupingNode.initialize(GroupingNode.java:192) [teiid-engine-8.6.0.Final.jar:8.6.0.Final]
> at org.teiid.query.processor.relational.RelationalPlan.connectExternal(RelationalPlan.java:94) [teiid-engine-8.6.0.Final.jar:8.6.0.Final]
> at org.teiid.query.processor.relational.RelationalPlan.connectExternal(RelationalPlan.java:100) [teiid-engine-8.6.0.Final.jar:8.6.0.Final]
> at org.teiid.query.processor.relational.RelationalPlan.connectExternal(RelationalPlan.java:100) [teiid-engine-8.6.0.Final.jar:8.6.0.Final]
> at org.teiid.query.processor.relational.RelationalPlan.initialize(RelationalPlan.java:89) [teiid-engine-8.6.0.Final.jar:8.6.0.Final]
> at org.teiid.query.processor.QueryProcessor.init(QueryProcessor.java:226) [teiid-engine-8.6.0.Final.jar:8.6.0.Final]
> at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:138) [teiid-engine-8.6.0.Final.jar:8.6.0.Final]
> at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114) [teiid-engine-8.6.0.Final.jar:8.6.0.Final]
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:159) [teiid-engine-8.6.0.Final.jar:8.6.0.Final]
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:141) [teiid-engine-8.6.0.Final.jar:8.6.0.Final]
> at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:435) [teiid-engine-8.6.0.Final.jar:8.6.0.Final]
> at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:320) [teiid-engine-8.6.0.Final.jar:8.6.0.Final]
> at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.6.0.Final.jar:8.6.0.Final]
> at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:248) [teiid-engine-8.6.0.Final.jar:8.6.0.Final]
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:273) [teiid-engine-8.6.0.Final.jar:8.6.0.Final]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.6.0.Final.jar:8.6.0.Final]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:214) [teiid-engine-8.6.0.Final.jar:8.6.0.Final]
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_25]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_25]
> atjava.lang.Thread.run(Thread.java:724) [rt.jar:1.7.0_25]
> {code}
--
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, 10 months
[JBoss JIRA] (TEIID-2853) Aggregation fails with select all
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-2853?page=com.atlassian.jira.plugin... ]
Steven Hawkins updated TEIID-2853:
----------------------------------
Summary: Aggregation fails with select all (was: With Query fails in 8.1 and 8.6)
Fix Version/s: 8.7
Affects Version/s: (was: 8.6)
> Aggregation fails with select all
> ---------------------------------
>
> Key: TEIID-2853
> URL: https://issues.jboss.org/browse/TEIID-2853
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 8.1
> Reporter: Alex K.
> Assignee: Steven Hawkins
> Fix For: 8.7
>
>
> This query fails for me on Teiid 8.1 and 8.6
> {code:sql}
> WITH qry_0 as
> (SELECT
> floor(t.f) AS a1, floor(t2.f) as b1
> FROM
> mysql.test_e AS t, oracle.test_e as t2 WHERE (t.f=t2.f)
> GROUP BY
> t.f, t2.f)
> SELECT * from qry_0 GROUP BY a1, b1;
> {code}
> This is the exception
> {code}
> 01:18:03,883 ERROR [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue16) qioVIE+5j6a2 TEIID30019 Unexpected exception forrequest qioVIE+5j6a2.9: java.lang.NullPointerException
> at org.teiid.query.processor.relational.GroupingNode.initialize(GroupingNode.java:192) [teiid-engine-8.6.0.Final.jar:8.6.0.Final]
> at org.teiid.query.processor.relational.RelationalPlan.connectExternal(RelationalPlan.java:94) [teiid-engine-8.6.0.Final.jar:8.6.0.Final]
> at org.teiid.query.processor.relational.RelationalPlan.connectExternal(RelationalPlan.java:100) [teiid-engine-8.6.0.Final.jar:8.6.0.Final]
> at org.teiid.query.processor.relational.RelationalPlan.connectExternal(RelationalPlan.java:100) [teiid-engine-8.6.0.Final.jar:8.6.0.Final]
> at org.teiid.query.processor.relational.RelationalPlan.initialize(RelationalPlan.java:89) [teiid-engine-8.6.0.Final.jar:8.6.0.Final]
> at org.teiid.query.processor.QueryProcessor.init(QueryProcessor.java:226) [teiid-engine-8.6.0.Final.jar:8.6.0.Final]
> at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:138) [teiid-engine-8.6.0.Final.jar:8.6.0.Final]
> at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114) [teiid-engine-8.6.0.Final.jar:8.6.0.Final]
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:159) [teiid-engine-8.6.0.Final.jar:8.6.0.Final]
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:141) [teiid-engine-8.6.0.Final.jar:8.6.0.Final]
> at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:435) [teiid-engine-8.6.0.Final.jar:8.6.0.Final]
> at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:320) [teiid-engine-8.6.0.Final.jar:8.6.0.Final]
> at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.6.0.Final.jar:8.6.0.Final]
> at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:248) [teiid-engine-8.6.0.Final.jar:8.6.0.Final]
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:273) [teiid-engine-8.6.0.Final.jar:8.6.0.Final]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.6.0.Final.jar:8.6.0.Final]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:214) [teiid-engine-8.6.0.Final.jar:8.6.0.Final]
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_25]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_25]
> atjava.lang.Thread.run(Thread.java:724) [rt.jar:1.7.0_25]
> {code}
--
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, 10 months
[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:
------------------------------------------------
Filip Nguyen <fnguyen(a)redhat.com> changed the Status of [bug 1033077|https://bugzilla.redhat.com/show_bug.cgi?id=1033077] from ON_QA to VERIFIED
> 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, 10 months