Bug 1371863 - [QE] (6.4.z) HHH-11073 - Casting to boolean in query fails on MySQL
Summary: [QE] (6.4.z) HHH-11073 - Casting to boolean in query fails on MySQL
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: JBoss Enterprise Application Platform 6
Classification: JBoss
Component: Hibernate
Version: 6.4.10
Hardware: Unspecified
OS: Unspecified
unspecified
unspecified
Target Milestone: CR1
: EAP 6.4.12
Assignee: Gail Badner
QA Contact: Martin Simka
URL:
Whiteboard:
Depends On:
Blocks: 1373627 eap6412-payload
TreeView+ depends on / blocked
 
Reported: 2016-08-31 09:57 UTC by Martin Simka
Modified: 2017-01-17 13:15 UTC (History)
7 users (show)

Fixed In Version:
Doc Type: If docs needed, set a value
Doc Text:
Clone Of:
Environment:
Last Closed: 2017-01-17 13:15:15 UTC
Type: Bug
Embargoed:


Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Issue Tracker JBEAP-5815 0 Major Pull Request Sent [HHH-11073] Casting to boolean in query fails on MySQL 2016-12-06 03:16:45 UTC
Red Hat Issue Tracker JBEAP-5816 0 Major Verified [QE] (7.0.z) [HHH-11073] Casting to boolean in query fails on MySQL 2016-12-06 03:16:45 UTC

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 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.


Note You need to log in before you can comment on or make changes to this bug.