[teiid-issues] [JBoss JIRA] (TEIID-4479) Teiid Exception on multiple values criteria
Ramesh Reddy (JIRA)
issues at jboss.org
Wed Sep 28 12:30:00 EDT 2016
[ https://issues.jboss.org/browse/TEIID-4479?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13299866#comment-13299866 ]
Ramesh Reddy commented on TEIID-4479:
-------------------------------------
Is there more to that exception you posted? (you can attach rather then posting)
> 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.
> {code}
> 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")
> {code}
> Here is the exception stack:
> {code}
> 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
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
More information about the teiid-issues
mailing list