Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.

Bug 1238357

Summary: infinispan-cache-dsl - Exception: Sentence already started. Cannot use 'having(..)' again.
Product: [JBoss] JBoss Data Virtualization 6 Reporter: Ha Van <hvan>
Component: DeploymentAssignee: Van Halbert <vhalbert>
Status: CLOSED DUPLICATE QA Contact:
Severity: unspecified Docs Contact:
Priority: unspecified    
Version: 6.1.0CC: atangrin, hvan, vhalbert
Target Milestone: ---   
Target Release: ---   
Hardware: Unspecified   
OS: Windows   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2015-07-02 21:17:12 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Bug Depends On:    
Bug Blocks: 1232282    
Attachments:
Description Flags
server log
none
PatchedJarToTestWith none

Description Ha Van 2015-07-01 17:00:50 UTC
Created attachment 1045163 [details]
server log

Description of problem: When executing the following query, an exception is thrown indicating that "Sentence already started.  Cannot use 'having(..)' again:

SELECT g_0.memberIdentifier, g_0.carrierId, g_0.accountId, g_0.groupId, g_0.claimSequenceNumber, g_0.claimIdentifier, g_0.claimStatusCode, g_0.daysSupplyNumber, g_0.fillDate, g_0.gpi, g_0.claimSubmitDate 
FROM Claim.PharmacyClaim AS g_0 
WHERE g_0.memberIdentifier = '123'
AND g_0.carrierId = 'ABC' 
AND g_0.accountId = 'XYZ'
AND g_0.groupId = 'JKL'

This exception only occurs when there are more than 2 criterias in the WHERE clause.  

Version-Release number of selected component (if applicable): translator-infinispan-dsl 8.7.1

Comment 2 Van Halbert 2015-07-02 03:31:32 UTC
I've duplicated the issue in DV 6.2 and I believe I have found the problem.  Will do more testing tomorrow to verify the fix works in DV 6.1.

Comment 3 Van Halbert 2015-07-02 13:48:40 UTC
I've got a fix for this, is this something you are going to file a client ticket on to get it into a roll-up?   Or do you want a patch to work with for the time being?

Comment 4 Van Halbert 2015-07-02 13:50:37 UTC
Created attachment 1045522 [details]
PatchedJarToTestWith

I've attached a patched jar that can be used to verify the fix.

Comment 5 Ha Van 2015-07-02 15:00:45 UTC
Thank you for the patch.  I have tested and verified that the patch fixed the issue in my environment.

Comment 6 Van Halbert 2015-07-02 21:17:12 UTC

*** This bug has been marked as a duplicate of bug 1232282 ***