[JBoss JIRA] (TEIID-2853) With Query fails in 8.1 and 8.6
by Alex K. (JIRA)
Alex K. created TEIID-2853:
------------------------------
Summary: With Query fails in 8.1 and 8.6
Key: TEIID-2853
URL: https://issues.jboss.org/browse/TEIID-2853
Project: Teiid
Issue Type: Bug
Affects Versions: 8.6, 8.1
Reporter: Alex K.
Assignee: Steven Hawkins
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-2833) While importing from Deployed BQT2 VDB, JDBC type of 0 and type name NULL was returned for column with design-time type varbinary
by RH Bugzilla Integration (JIRA)
[ https://issues.jboss.org/browse/TEIID-2833?page=com.atlassian.jira.plugin... ]
RH Bugzilla Integration commented on TEIID-2833:
------------------------------------------------
jolee(a)redhat.com changed the Status of [bug 1060335|https://bugzilla.redhat.com/show_bug.cgi?id=1060335] from NEW to MODIFIED
> While importing from Deployed BQT2 VDB, JDBC type of 0 and type name NULL was returned for column with design-time type varbinary
> ---------------------------------------------------------------------------------------------------------------------------------
>
> Key: TEIID-2833
> URL: https://issues.jboss.org/browse/TEIID-2833
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 8.4
> Reporter: Barry LaFond
> Assignee: Steven Hawkins
> Fix For: 8.4.2, 8.7
>
> Attachments: TEIID_2829_project.zip
>
>
> 1) Open attached project in Designer
> 2) Deploy the BQT2.vdb
> 3) Create another project
> 4) Import the VDB metadata via JDBC Importer into your second project (will end up being a read-only VDB source model)
> 5) On *finish* you'll get an exception when processing the type_varbinary column because the type returned is "0" and type name of "null"
> {code}
> java.lang.IllegalArgumentException: Expected argument to be non-null but got null
> at org.teiid.core.designer.util.CoreArgCheck.isNotNull(CoreArgCheck.java:142)
> at org.teiid.core.designer.util.CoreArgCheck.isNotNull(CoreArgCheck.java:128)
> at org.teiid.designer.sdt.types.BuiltInTypesManager.getBuiltInDatatype(BuiltInTypesManager.java:477)
> at org.teiid.designer.sdt.types.WorkspaceDatatypeManager.getBuiltInDatatype(WorkspaceDatatypeManager.java:94)
> at org.teiid.designer.jdbc.relational.impl.RelationalModelProcessorImpl.findType(RelationalModelProcessorImpl.java:1450)
> at org.teiid.designer.jdbc.relational.impl.RelationalModelProcessorImpl.setColumnInfo(RelationalModelProcessorImpl.java:1321)
> {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, 11 months
[JBoss JIRA] (TEIID-2828) ResteasyEnabler fails with OTHER model types
by RH Bugzilla Integration (JIRA)
[ https://issues.jboss.org/browse/TEIID-2828?page=com.atlassian.jira.plugin... ]
RH Bugzilla Integration commented on TEIID-2828:
------------------------------------------------
jolee(a)redhat.com changed the Status of [bug 1059917|https://bugzilla.redhat.com/show_bug.cgi?id=1059917] from NEW to MODIFIED
> ResteasyEnabler fails with OTHER model types
> --------------------------------------------
>
> Key: TEIID-2828
> URL: https://issues.jboss.org/browse/TEIID-2828
> Project: Teiid
> Issue Type: Bug
> Components: Server
> Affects Versions: 8.4
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Fix For: 8.4.2, 8.7
>
>
> If a vdb contains OTHER type models (typically used for .xsd), then the schema lookup will produce a null and result in an NPE:
> java.lang.NullPointerException
> at org.teiid.jboss.rest.ResteasyEnabler.hasRestMetadata(ResteasyEnabler.java:146) [teiid-jboss-integration-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.jboss.rest.ResteasyEnabler.finishedDeployment(ResteasyEnabler.java:81) [teiid-jboss-integration-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.deployers.VDBRepository.notifyFinished(VDBRepository.java:351) [teiid-runtime-8.4.1-redhat-2.jar:8.4.1-redhat-2]
>
--
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, 11 months
[JBoss JIRA] (TEIID-2804) Aggregate empty filter too broad and may inappropriately filter results
by RH Bugzilla Integration (JIRA)
[ https://issues.jboss.org/browse/TEIID-2804?page=com.atlassian.jira.plugin... ]
RH Bugzilla Integration commented on TEIID-2804:
------------------------------------------------
jolee(a)redhat.com changed the Status of [bug 1053786|https://bugzilla.redhat.com/show_bug.cgi?id=1053786] from ASSIGNED to MODIFIED
> Aggregate empty filter too broad and may inappropriately filter results
> -----------------------------------------------------------------------
>
> Key: TEIID-2804
> URL: https://issues.jboss.org/browse/TEIID-2804
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 8.3
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Priority: Critical
> Fix For: 8.4.2, 8.7
>
>
> This is a regression from TEIID-2253 which consolidated logic in RulePushAggregates to handle multi-source planning. It also inappropriately expanded an empty test (which should only be applied to grouping without a group by) to some cases with group by clauses and in an attempt to broaden pushdown support utilized is not null tests. However the is not null tests are not generally valid as the aggregate could be computed against all null values for example. Depending upon this situations this could result in invalid filtering of results.
--
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, 11 months
[JBoss JIRA] (TEIID-2814) HIVE: quote is removed for TIMESTAMP field in where clause
by RH Bugzilla Integration (JIRA)
[ https://issues.jboss.org/browse/TEIID-2814?page=com.atlassian.jira.plugin... ]
RH Bugzilla Integration commented on TEIID-2814:
------------------------------------------------
jolee(a)redhat.com changed the Status of [bug 1058084|https://bugzilla.redhat.com/show_bug.cgi?id=1058084] from NEW to MODIFIED
> HIVE: quote is removed for TIMESTAMP field in where clause
> -----------------------------------------------------------
>
> Key: TEIID-2814
> URL: https://issues.jboss.org/browse/TEIID-2814
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 8.6
> Environment: HIVE and Teiid 8.6
> Reporter: Ivan Chan
> Assignee: Steven Hawkins
> Labels: teiid
> Fix For: 8.4.2, 8.7
>
>
> I am running teiid 8.6 against HIVE. And I found out that quote was removed for TIMESTAMP field in where clause. And it caused java.sql.SQLException: Error while processing statement: FAILED: ParseException line 1:88 missing EOF
> Original SQL:
> select "the_date",
> "store_sales"
> from "hive2"."sales_seq"
> where ("the_date" > '1970-05-16 00:10:04')
> Teiid generated SQL:
> SELECT g_0.the_date, g_0.store_sales FROM sales_seq g_0 WHERE g_0.the_date > 1970-05-16 00:10:04.0
> Exception:
> Caused by: java.sql.SQLException: Error while processing statement: FAILED:
> ParseException line 1:88 missing EOF at '00' near '16'
--
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, 11 months