Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.
Bug 348874 - JPQL query can't select boolean column
Summary: JPQL query can't select boolean column
Status: CLOSED DUPLICATE of bug 335797
Alias: None
Product: z_Archived
Classification: Eclipse Foundation
Component: Eclipselink (show other bugs)
Version: unspecified   Edit
Hardware: PC Windows 7
: P2 normal with 1 vote (vote)
Target Milestone: ---   Edit
Assignee: Nobody - feel free to take it CLA
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: 309681
  Show dependency tree
 
Reported: 2011-06-09 07:52 EDT by Adrian Goerler CLA
Modified: 2022-06-09 10:26 EDT (History)
3 users (show)

See Also:


Attachments
marks the tests as associated with this bug (909 bytes, patch)
2011-06-09 08:02 EDT, Adrian Goerler CLA
no flags Details | Diff

Note You need to log in before you can comment on or make changes to this bug.
Description Adrian Goerler CLA 2011-06-09 07:52:56 EDT
The query 

select b.primitiveBoolean from BasicTypesFieldAccess b

does not find a row, which contains the boolean value TRUE but throws a NoResultException.

The issue can be reproduced by the tests 

eclipselink.jpa.wdf.test

org.eclipse.persistence.testing.tests.wdf.jpa1.query.TestSelectListTypes
- testPrimitiveBoolean
- testWrapperBoolean
Comment 1 Adrian Goerler CLA 2011-06-09 08:02:50 EDT
Created attachment 197687 [details]
marks the tests as associated with this bug

checked in at 9564
Comment 2 Tom Ware CLA 2011-06-23 10:15:51 EDT
Setting target and priority.  See the following page for the meanings of these fields:

http://wiki.eclipse.org/EclipseLink/Development/Bugs/Guidelines

Community: Please vote for this bug if it is important to you.  Votes are one of the main criteria we use to determine which bugs to fix next.
Comment 3 Chris Delahunt CLA 2011-10-26 11:34:34 EDT
Marking this as a duplicate of 335797 and changing the description in 335797 to reflect that any query returning a boolean has this problem (JPQL or criteria)

*** This bug has been marked as a duplicate of bug 335797 ***
Comment 4 Eclipse Webmaster CLA 2022-06-09 10:26:23 EDT
The Eclipselink project has moved to Github: https://github.com/eclipse-ee4j/eclipselink