]
Tom Chen commented on TEIID-4325:
---------------------------------
Thank you for the clarification. I will discuss this issue with our developers to see how
to proceed. We planed to use teiid 9.1 in our next product release but our user cannot
wait until then. Have a good weekend!
ASSERTION FAILED: expected reference to be not null
---------------------------------------------------
Key: TEIID-4325
URL:
https://issues.jboss.org/browse/TEIID-4325
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 8.12
Reporter: Mark Tawk
Assignee: Steven Hawkins
Fix For: 9.1, 9.0.2, 8.13.7, 8.12.6.6_3
Attachments: show_plan_debug.txt
I'm using teiid 9.0.0 over h2 :
I'm getting ASSERTION_FAILED over the following query and can not find what is
causing this exception:
select "Sheet1"."AvgAmoutRange" as
"Sheet1_EBt_211215_AvgAmoutRa1",COUNT( distinct
IFNULL("CEGlobalView"."Customer_CustomerID",-2147483648)) as
"CEGlobalView_Customer_Custom2","CEGlobalView"."Customer_GenderID"
as "CEGlobalView_Customer_Gender1","Gender"."Gender" as
"Gender_Gender","Sheet1"."Sheet1_EBt_211215ID" as
"Sheet1_EBt_211215_Sheet1_EBt11" from
"CEBanksBusinessModel"."CEGlobalView" "CEGlobalView" LEFT
JOIN
"h2dbimplify_data_cebankModel_ST"."implify_data_cebank"."Sheet1_EBt_211215"
"Sheet1" ON (
("CEGlobalView"."StreamCardsvt3r_StreamCards_1" BETWEEN
"Sheet1"."Min" and "Sheet1"."Max") )
LEFT JOIN
"h2dbimplify_data_cebankModel_fR"."implify_data_cebank"."Gender"
"Gender" ON "CEGlobalView"."Customer_GenderID" =
"Gender"."GenderID"
LEFT JOIN
"h2dbimplify_data_cebankModel_fR"."implify_data_cebank"."CustomerTag"
"CustomerTag" ON "CEGlobalView"."Customer_CustomerID" =
"CustomerTag"."Customer_CustomerID" AND ( (
("CustomerTag"."EndDateTime" > CURDATE()) OR (
("CustomerTag"."EndDateTime" IS null ) ) ) )
LEFT JOIN
"h2dbimplify_data_cebankModel_fR"."implify_data_cebank"."TagValue"
"TagValue" ON "CustomerTag"."TagValue_TagValueID" =
"TagValue"."TagValueID"
LEFT JOIN
"h2dbimplify_data_cebankModel_fR"."implify_data_cebank"."TagName"
"TagName" ON "TagValue"."TagName_TagNameID" =
"TagName"."TagNameID" AND ( (
("TagName"."TagType_TagTypeID" IN (1.0) ) ) AND (
("TagName"."TagScope_TagScopeID" IN (1.0) ) ) )
where ( ( ( ("TagName"."TagName" IN ('Behavior') ) ) ) AND
( ("Sheet1"."AvgAmoutRange" IS NOT null ) ) AND (
("CEGlobalView"."Customer_GenderID" IS NOT null ) ) AND (
("Gender"."Gender" IS NOT null ) ) ) group by
"Sheet1"."AvgAmoutRange","CEGlobalView"."Customer_GenderID","Gender"."Gender","Sheet1"."Sheet1_EBt_211215ID"
order by "Sheet1"."Sheet1_EBt_211215ID"
ASC,"Sheet1"."AvgAmoutRange" ASC,"Gender"."Gender"
DESC,"CEGlobalView"."Customer_GenderID" DESC
The exception stack:
ERROR TEIID_DQP_LOGGER:90 (http-bio-8080-exec-14) - - [TEIID30019 Unexpected exception
for request rBDBCRYcUyyM.0]
java.lang.AssertionError: ASSERTION FAILED: expected reference to be not null
at org.teiid.core.util.Assertion.failed(Assertion.java:73)
at org.teiid.core.util.Assertion.isNotNull(Assertion.java:100)
at org.teiid.core.util.Assertion.isNotNull(Assertion.java:92)
at
org.teiid.query.processor.relational.RelationalNode.getProjectionIndexes(RelationalNode.java:367)
at org.teiid.query.processor.relational.JoinNode.initialize(JoinNode.java:133)
at
org.teiid.query.processor.relational.RelationalPlan.connectExternal(RelationalPlan.java:96)
at
org.teiid.query.processor.relational.RelationalPlan.connectExternal(RelationalPlan.java:102)
at
org.teiid.query.processor.relational.RelationalPlan.connectExternal(RelationalPlan.java:102)
at
org.teiid.query.processor.relational.RelationalPlan.connectExternal(RelationalPlan.java:102)
at
org.teiid.query.processor.relational.RelationalPlan.initialize(RelationalPlan.java:91)
at org.teiid.query.processor.QueryProcessor.init(QueryProcessor.java:226)
at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:138)
at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114)
at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:164)
at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:146)
at
org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:472)
at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:348)
at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51)
at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:274)
at org.teiid.dqp.internal.process.DQPCore.executeRequest(DQPCore.java:313)
at org.teiid.dqp.internal.process.DQPCore.executeRequest(DQPCore.java:245)
at sun.reflect.GeneratedMethodAccessor423.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.teiid.transport.LocalServerConnection$1$1.call(LocalServerConnection.java:177)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276)
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:260)
at org.teiid.transport.LocalServerConnection$1.invoke(LocalServerConnection.java:175)
at com.sun.proxy.$Proxy34.executeRequest(Unknown Source)
at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:673)
at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:539)
at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:1060)
at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:323)
you find attached the show plan debug