-
Bug
-
Resolution: Duplicate
-
Major
-
None
-
None
-
None
-
None
I'm using Teiid 9.0.0 with mysql
I'm getting an exception on the query below when putting more then one value in the criteria : ("JPVPricedSecurities"."Reply_VendorID" IN (10, 2))
if the criteria is on one value, the query executes with success;
The case is specifically related to the query.
select SUM("JPVPricedSecurities"."ContractLine_Cost") as "JPVPricedSecurities_Contract", year("SRequestPerVendor"."SRequest_DateTime") as "DAYOFMONTHSRequestPerVendor_" from "DataMarketBusinessModel"."SRequestPerVendor" "SRequestPerVendor" LEFT JOIN "DataMarketBusinessModel"."JPVPricedSecurities" "JPVPricedSecurities" ON "SRequestPerVendor"."SRequest_AssetID" = "JPVPricedSecurities"."Reply_AssetID" LEFT JOIN "datamarketModel_MM"."datamarket"."Vendor" "Vendor" ON "JPVPricedSecurities"."Reply_VendorID" = "Vendor"."VendorID" where ("JPVPricedSecurities"."Reply_VendorID" IN (10, 2) ) AND ("Vendor"."Vendor" IS NOT null ) group by year("SRequestPerVendor"."SRequest_DateTime")
Here is the exception stack:
Daemon Thread [http-bio-8080-exec-2] (Suspended (exception NullPointerException)) owns: Object (id=23929) owns: SocketWrapper<E> (id=23848) LanguageBridgeFactory.translate(DependentSetCriteria) line: 426 LanguageBridgeFactory.translate(Criteria) line: 418 LanguageBridgeFactory.translate(CompoundCriteria) line: 494 LanguageBridgeFactory.translate(Criteria) line: 402 LanguageBridgeFactory.translate(Query) line: 281 LanguageBridgeFactory.translate(QueryCommand) line: 226 LanguageBridgeFactory.translate(SubqueryFromClause) line: 386 LanguageBridgeFactory.translate(FromClause) line: 344 LanguageBridgeFactory.translate(Query) line: 276 LanguageBridgeFactory.translate(Command) line: 184 ConnectorWorkItem.<init>(AtomicRequestMessage, ConnectorManager) line: 175 EmbeddedServer$ProviderAwareConnectorManagerRepository$1(ConnectorManager).registerRequest(AtomicRequestMessage) line: 203 DataTierManagerImpl.registerRequest(CommandContext, Command, String, RegisterRequestParameter) line: 1011 TempTableDataManager.registerRequest(CommandContext, Command, String, RegisterRequestParameter) line: 179 DependentAccessNode(AccessNode).registerRequest(Command) line: 500 DependentAccessNode(AccessNode).openInternal() line: 268 DependentAccessNode(AccessNode).open() line: 171 EnhancedSortMergeJoinStrategy(JoinStrategy).openRight() line: 105 JoinNode.nextBatchDirect() line: 223 JoinNode(RelationalNode).nextBatch() line: 282 GroupingNode$ProjectingTupleSource(BatchCollector$BatchProducerTupleSource).nextTuple() line: 94 GroupingNode.groupSortPhase() line: 490 GroupingNode.nextBatchDirect() line: 366 GroupingNode(RelationalNode).nextBatch() line: 282 ProjectNode.nextBatchDirect() line: 150 ProjectNode(RelationalNode).nextBatch() line: 282 RelationalPlan.nextBatch() line: 145 QueryProcessor.nextBatchDirect() line: 151 QueryProcessor.nextBatch() line: 114 RequestWorkItem$1(BatchCollector).collectTuples(boolean) line: 164 RequestWorkItem$1(BatchCollector).collectTuples() line: 146 RequestWorkItem.processMore() line: 472 RequestWorkItem.process() line: 348 RequestWorkItem(AbstractWorkItem).run() line: 51 RequestWorkItem.run() line: 274 DQPCore.executeRequest(long, RequestMessage, Long) line: 313 DQPCore.executeRequest(long, RequestMessage) line: 245 GeneratedMethodAccessor393.invoke(Object, Object[]) line: not available DelegatingMethodAccessorImpl.invoke(Object, Object[]) line: 43 Method.invoke(Object, Object...) line: 606 LocalServerConnection$1$1.call() line: 177 FutureTask<V>.run() line: 262 DQPWorkContext.runInContext(Runnable) line: 276 DQPWorkContext.runInContext(Callable<V>) line: 260 LocalServerConnection$1.invoke(Object, Method, Object[]) line: 175 $Proxy29.executeRequest(long, RequestMessage) line: not available StatementImpl.execute(RequestMessage, boolean) line: 673 StatementImpl.executeSql(String[], boolean, ResultsMode, boolean, RequestOptions, boolean) line: 539 StatementImpl.execute(String, int) line: 1060 StatementImpl.execute(String) line: 323