Bug 1371863

Summary: [QE] (6.4.z) HHH-11073 - Casting to boolean in query fails on MySQL
Product: [JBoss] JBoss Enterprise Application Platform 6 Reporter: Martin Simka <msimka>
Component: HibernateAssignee: Gail Badner <gbadner>
Status: CLOSED CURRENTRELEASE QA Contact: Martin Simka <msimka>
Severity: unspecified Docs Contact:
Priority: unspecified    
Version: 6.4.10CC: bmaxwell, gbadner, jbilek, msimka, msochure, ppalaga, smarlow
Target Milestone: CR1   
Target Release: EAP 6.4.12   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2017-01-17 13:15:15 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: 1373627, 1375585    

Description Martin Simka 2016-08-31 09:57:30 UTC 
https://hibernate.atlassian.net/browse/HHH-11073

this follows up on https://bugzilla.redhat.com/show_bug.cgi?id=1337337 which doesn't fixes issue on MySQL

Description of problem:

Hibernate converts a query like:

select cast( true as boolean ) ...

to SQL:

select cast ( 1 as bit ) ....

Instead, Hibernate should be converted to SQL:

select cast ( 1 as char ) ....
Comment 1 Gail Badner 2016-08-31 23:29:05 UTC 
Hibernate ORM community 4.2 branch commits:

test: https://github.com/hibernate/hibernate-orm/commit/efa7a421a35c1589768e41743a39b849797fea46

fix: https://github.com/hibernate/hibernate-orm/commit/1784724566235f4467873a62bd8c692d695421d7

Internal 4.2 branch commits:

test: http://git.app.eng.bos.redhat.com/git/hibernate/hibernate-core.git/commit/?h=4.2&id=efa7a421a35c1589768e41743a39b849797fea46

fix: http://git.app.eng.bos.redhat.com/git/hibernate/hibernate-core.git/commit/?h=4.2&id=1784724566235f4467873a62bd8c692d695421d7
Comment 3 Jiří Bílek 2016-11-04 09:13:35 UTC 
Verified with EAP 6.4.12.CP.CR1
Comment 4 Petr Penicka 2017-01-17 13:15:15 UTC 
Retroactively bulk-closing issues from released EAP 6.4 cumulative patches.