[teiid-issues] [JBoss JIRA] (TEIID-4479) Teiid Exception on multiple values criteria

Ramesh Reddy (JIRA) issues at jboss.org
Wed Sep 28 12:24:00 EDT 2016 

     [ https://issues.jboss.org/browse/TEIID-4479?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ramesh Reddy updated TEIID-4479:
--------------------------------
    Description: 
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}	


  was:
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	




> 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