5:36 p.m.
Mark Tawk created TEIID-4479:
--------------------------------
Summary: Teiid Exception on multiple values criteria
Key: TEIID-4479
URL: https://issues.jboss.org/browse/TEIID-4479
Project: Teiid
Issue Type: Bug
Reporter: Mark Tawk
Assignee: Steven Hawkins
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
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)