[Hibernate-JIRA] Created: (HHH-5078) JPA criteria query numeric expressions produce wrong result (due to wrong bracketing)
9:15 a.m.
JPA criteria query numeric expressions produce wrong result (due to wrong bracketing)
-------------------------------------------------------------------------------------
Key: HHH-5078
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5078
Project: Hibernate Core
Issue Type: Bug
Components: entity-manager, query-criteria
Affects Versions: 3.5.0-Final
Environment: Hibernate-Core 3.5.0-Final, all database platforms
Reporter: Christoph Gerkens
The combination of quot and diff results in wrong SQL code. E.g.: (2 - 1) / 2 should be
evaluated to 0.5 not 1.5 ( which is 2 - (1 / 2).
JUnit 4 Test:
@Test
public void testJpaCriteriaApiQuoteAndDiff() {
CriteriaBuilder cb = em.getCriteriaBuilder();
CriteriaQuery<Number> query = cb.createQuery(Number.class);
query.from(SystemUser.class); // entity type doesn't matter, but must contain at
least one entry for this test case.
query.select( // (2 - 1) / 2
cb.quot(
cb.diff(
cb.literal(BigDecimal.valueOf(2.0)),
cb.literal(BigDecimal.valueOf(1.0))),
BigDecimal.valueOf(2.0))).distinct(true);
Number result = em.createQuery(query).getSingleResult();
assertEquals(0.5d, result.doubleValue(), 0.1d); // (2 - 1) / 2 = 0.5
}
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
9:38 a.m.
New subject: [Hibernate-JIRA] Commented: (HHH-5078) JPA criteria query numeric expressions produce wrong result (due to wrong bracketing)
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-5078?page=c...
]
Christoph Gerkens commented on HHH-5078:
----------------------------------------
Hibernate log output:
Hibernate: /* select distinct 2.0BD - 1.0BD / 2.0BD from
hibernateBugHHH5078TestCase.SystemUser as generatedAlias0 */ select top ? distinct
2.0-(1.0/2.0) as col_0_0_ from INFORMATION_SCHEMA.SYSTEM_USERS systemuser0_
JPA criteria query numeric expressions produce wrong result (due to
wrong bracketing)
-------------------------------------------------------------------------------------
Key: HHH-5078
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5078
Project: Hibernate Core
Issue Type: Bug
Components: entity-manager, query-criteria
Affects Versions: 3.5.0-Final
Environment: Hibernate-Core 3.5.0-Final, all database platforms
Reporter: Christoph Gerkens
The combination of quot and diff results in wrong SQL code. E.g.: (2 - 1) / 2 should be
evaluated to 0.5 not 1.5 ( which is 2 - (1 / 2).
JUnit 4 Test:
@Test
public void testJpaCriteriaApiQuoteAndDiff() {
CriteriaBuilder cb = em.getCriteriaBuilder();
CriteriaQuery<Number> query = cb.createQuery(Number.class);
query.from(SystemUser.class); // entity type doesn't matter, but must contain at
least one entry for this test case.
query.select( // (2 - 1) / 2
cb.quot(
cb.diff(
cb.literal(BigDecimal.valueOf(2.0)),
cb.literal(BigDecimal.valueOf(1.0))),
BigDecimal.valueOf(2.0))).distinct(true);
Number result = em.createQuery(query).getSingleResult();
assertEquals(0.5d, result.doubleValue(), 0.1d); // (2 - 1) / 2 = 0.5
}
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
9:47 a.m.
New subject: [Hibernate-JIRA] Updated: (HHH-5078) JPA criteria query numeric expressions produce wrong result (due to wrong bracketing)
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-5078?page=c...
]
Christoph Gerkens updated HHH-5078:
-----------------------------------
Attachment: TestCase_HHH-5078.zip
JUnit Test Case provided as a Maven 2 project.
JPA criteria query numeric expressions produce wrong result (due to
wrong bracketing)
-------------------------------------------------------------------------------------
Key: HHH-5078
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5078
Project: Hibernate Core
Issue Type: Bug
Components: entity-manager, query-criteria
Affects Versions: 3.5.0-Final
Environment: Hibernate-Core 3.5.0-Final, all database platforms
Reporter: Christoph Gerkens
Attachments: TestCase_HHH-5078.zip
The combination of quot and diff results in wrong SQL code. E.g.: (2 - 1) / 2 should be
evaluated to 0.5 not 1.5 ( which is 2 - (1 / 2).
JUnit 4 Test:
@Test
public void testJpaCriteriaApiQuoteAndDiff() {
CriteriaBuilder cb = em.getCriteriaBuilder();
CriteriaQuery<Number> query = cb.createQuery(Number.class);
query.from(SystemUser.class); // entity type doesn't matter, but must contain at
least one entry for this test case.
query.select( // (2 - 1) / 2
cb.quot(
cb.diff(
cb.literal(BigDecimal.valueOf(2.0)),
cb.literal(BigDecimal.valueOf(1.0))),
BigDecimal.valueOf(2.0))).distinct(true);
Number result = em.createQuery(query).getSingleResult();
assertEquals(0.5d, result.doubleValue(), 0.1d); // (2 - 1) / 2 = 0.5
}
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
4:33 p.m.
New subject: [Hibernate-JIRA] Commented: (HHH-5078) JPA criteria query numeric expressions produce wrong result (due to wrong bracketing)
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-5078?page=c...
]
Gail Badner commented on HHH-5078:
----------------------------------
Is this still an issue using 3.5.1?
JPA criteria query numeric expressions produce wrong result (due to
wrong bracketing)
-------------------------------------------------------------------------------------
Key: HHH-5078
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5078
Project: Hibernate Core
Issue Type: Bug
Components: entity-manager, query-criteria
Affects Versions: 3.5.0-Final
Environment: Hibernate-Core 3.5.0-Final, all database platforms
Reporter: Christoph Gerkens
Attachments: TestCase_HHH-5078.zip
The combination of quot and diff results in wrong SQL code. E.g.: (2 - 1) / 2 should be
evaluated to 0.5 not 1.5 ( which is 2 - (1 / 2).
JUnit 4 Test:
@Test
public void testJpaCriteriaApiQuoteAndDiff() {
CriteriaBuilder cb = em.getCriteriaBuilder();
CriteriaQuery<Number> query = cb.createQuery(Number.class);
query.from(SystemUser.class); // entity type doesn't matter, but must contain at
least one entry for this test case.
query.select( // (2 - 1) / 2
cb.quot(
cb.diff(
cb.literal(BigDecimal.valueOf(2.0)),
cb.literal(BigDecimal.valueOf(1.0))),
BigDecimal.valueOf(2.0))).distinct(true);
Number result = em.createQuery(query).getSingleResult();
assertEquals(0.5d, result.doubleValue(), 0.1d); // (2 - 1) / 2 = 0.5
}
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
5:04 p.m.
New subject: [Hibernate-JIRA] Commented: (HHH-5078) JPA criteria query numeric expressions produce wrong result (due to wrong bracketing)
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-5078?page=c...
]
Jesper Steen Møller commented on HHH-5078:
------------------------------------------
It appears still to be an issue with 3.5.1, I tried the test case in the description and
it evaluated to 1.5
JPA criteria query numeric expressions produce wrong result (due to
wrong bracketing)
-------------------------------------------------------------------------------------
Key: HHH-5078
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5078
Project: Hibernate Core
Issue Type: Bug
Components: entity-manager, query-criteria
Affects Versions: 3.5.0-Final
Environment: Hibernate-Core 3.5.0-Final, all database platforms
Reporter: Christoph Gerkens
Attachments: TestCase_HHH-5078.zip
The combination of quot and diff results in wrong SQL code. E.g.: (2 - 1) / 2 should be
evaluated to 0.5 not 1.5 ( which is 2 - (1 / 2).
JUnit 4 Test:
@Test
public void testJpaCriteriaApiQuoteAndDiff() {
CriteriaBuilder cb = em.getCriteriaBuilder();
CriteriaQuery<Number> query = cb.createQuery(Number.class);
query.from(SystemUser.class); // entity type doesn't matter, but must contain at
least one entry for this test case.
query.select( // (2 - 1) / 2
cb.quot(
cb.diff(
cb.literal(BigDecimal.valueOf(2.0)),
cb.literal(BigDecimal.valueOf(1.0))),
BigDecimal.valueOf(2.0))).distinct(true);
Number result = em.createQuery(query).getSingleResult();
assertEquals(0.5d, result.doubleValue(), 0.1d); // (2 - 1) / 2 = 0.5
}
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
5:35 p.m.
New subject: [Hibernate-JIRA] Updated: (HHH-5078) JPA criteria query numeric expressions produce wrong result (due to wrong bracketing)
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-5078?page=c...
]
Gail Badner updated HHH-5078:
-----------------------------
Affects Version/s: 3.5.1
Fix Version/s: 3.5.x
JPA criteria query numeric expressions produce wrong result (due to
wrong bracketing)
-------------------------------------------------------------------------------------
Key: HHH-5078
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5078
Project: Hibernate Core
Issue Type: Bug
Components: entity-manager, query-criteria
Affects Versions: 3.5.0-Final, 3.5.1
Environment: Hibernate-Core 3.5.0-Final, all database platforms
Reporter: Christoph Gerkens
Fix For: 3.5.x
Attachments: TestCase_HHH-5078.zip
The combination of quot and diff results in wrong SQL code. E.g.: (2 - 1) / 2 should be
evaluated to 0.5 not 1.5 ( which is 2 - (1 / 2).
JUnit 4 Test:
@Test
public void testJpaCriteriaApiQuoteAndDiff() {
CriteriaBuilder cb = em.getCriteriaBuilder();
CriteriaQuery<Number> query = cb.createQuery(Number.class);
query.from(SystemUser.class); // entity type doesn't matter, but must contain at
least one entry for this test case.
query.select( // (2 - 1) / 2
cb.quot(
cb.diff(
cb.literal(BigDecimal.valueOf(2.0)),
cb.literal(BigDecimal.valueOf(1.0))),
BigDecimal.valueOf(2.0))).distinct(true);
Number result = em.createQuery(query).getSingleResult();
assertEquals(0.5d, result.doubleValue(), 0.1d); // (2 - 1) / 2 = 0.5
}
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
4:05 p.m.
New subject: [Hibernate-JIRA] Updated: (HHH-5078) JPA criteria query numeric expressions produce wrong result (due to wrong bracketing)
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-5078?page=c...
]
Jesper Steen Møller updated HHH-5078:
-------------------------------------
Attachment: hhh-5078-fix.txt
This patch adds the test and includes a fix, which is not optimal but will get the job
done; it will bracket expressions like (((2 + 2) + 2) + 2) which is not needed, in other
words, it just adds the parentheses without regards for precedence or associativity.
I've checked the other expression renderers and they appear safe enough, notably the
conjunction and disjunction.
JPA criteria query numeric expressions produce wrong result (due to
wrong bracketing)
-------------------------------------------------------------------------------------
Key: HHH-5078
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5078
Project: Hibernate Core
Issue Type: Bug
Components: entity-manager, query-criteria
Affects Versions: 3.5.0-Final, 3.5.1
Environment: Hibernate-Core 3.5.0-Final, all database platforms
Reporter: Christoph Gerkens
Fix For: 3.5.x
Attachments: hhh-5078-fix.txt, TestCase_HHH-5078.zip
The combination of quot and diff results in wrong SQL code. E.g.: (2 - 1) / 2 should be
evaluated to 0.5 not 1.5 ( which is 2 - (1 / 2).
JUnit 4 Test:
@Test
public void testJpaCriteriaApiQuoteAndDiff() {
CriteriaBuilder cb = em.getCriteriaBuilder();
CriteriaQuery<Number> query = cb.createQuery(Number.class);
query.from(SystemUser.class); // entity type doesn't matter, but must contain at
least one entry for this test case.
query.select( // (2 - 1) / 2
cb.quot(
cb.diff(
cb.literal(BigDecimal.valueOf(2.0)),
cb.literal(BigDecimal.valueOf(1.0))),
BigDecimal.valueOf(2.0))).distinct(true);
Number result = em.createQuery(query).getSingleResult();
assertEquals(0.5d, result.doubleValue(), 0.1d); // (2 - 1) / 2 = 0.5
}
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
5:20 p.m.
New subject: [Hibernate-JIRA] Updated: (HHH-5078) JPA criteria query numeric expressions produce wrong result (due to wrong bracketing)
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-5078?page=c...
]
Gail Badner updated HHH-5078:
-----------------------------
Issue Type: Patch (was: Bug)
Thanks for checking and for the patch!
JPA criteria query numeric expressions produce wrong result (due to
wrong bracketing)
-------------------------------------------------------------------------------------
Key: HHH-5078
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5078
Project: Hibernate Core
Issue Type: Patch
Components: entity-manager, query-criteria
Affects Versions: 3.5.0-Final, 3.5.1
Environment: Hibernate-Core 3.5.0-Final, all database platforms
Reporter: Christoph Gerkens
Fix For: 3.5.x
Attachments: hhh-5078-fix.txt, TestCase_HHH-5078.zip
The combination of quot and diff results in wrong SQL code. E.g.: (2 - 1) / 2 should be
evaluated to 0.5 not 1.5 ( which is 2 - (1 / 2).
JUnit 4 Test:
@Test
public void testJpaCriteriaApiQuoteAndDiff() {
CriteriaBuilder cb = em.getCriteriaBuilder();
CriteriaQuery<Number> query = cb.createQuery(Number.class);
query.from(SystemUser.class); // entity type doesn't matter, but must contain at
least one entry for this test case.
query.select( // (2 - 1) / 2
cb.quot(
cb.diff(
cb.literal(BigDecimal.valueOf(2.0)),
cb.literal(BigDecimal.valueOf(1.0))),
BigDecimal.valueOf(2.0))).distinct(true);
Number result = em.createQuery(query).getSingleResult();
assertEquals(0.5d, result.doubleValue(), 0.1d); // (2 - 1) / 2 = 0.5
}
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
12:37 p.m.
New subject: [Hibernate-JIRA] Updated: (HHH-5078) JPA criteria query numeric expressions produce wrong result (due to wrong bracketing)
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-5078?page=c...
]
Gail Badner updated HHH-5078:
-----------------------------
Assignee: Gail Badner
Fix Version/s: (was: 3.5.x)
3.5.2
JPA criteria query numeric expressions produce wrong result (due to
wrong bracketing)
-------------------------------------------------------------------------------------
Key: HHH-5078
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5078
Project: Hibernate Core
Issue Type: Patch
Components: entity-manager, query-criteria
Affects Versions: 3.5.0-Final, 3.5.1
Environment: Hibernate-Core 3.5.0-Final, all database platforms
Reporter: Christoph Gerkens
Assignee: Gail Badner
Fix For: 3.5.2
Attachments: hhh-5078-fix.txt, TestCase_HHH-5078.zip
The combination of quot and diff results in wrong SQL code. E.g.: (2 - 1) / 2 should be
evaluated to 0.5 not 1.5 ( which is 2 - (1 / 2).
JUnit 4 Test:
@Test
public void testJpaCriteriaApiQuoteAndDiff() {
CriteriaBuilder cb = em.getCriteriaBuilder();
CriteriaQuery<Number> query = cb.createQuery(Number.class);
query.from(SystemUser.class); // entity type doesn't matter, but must contain at
least one entry for this test case.
query.select( // (2 - 1) / 2
cb.quot(
cb.diff(
cb.literal(BigDecimal.valueOf(2.0)),
cb.literal(BigDecimal.valueOf(1.0))),
BigDecimal.valueOf(2.0))).distinct(true);
Number result = em.createQuery(query).getSingleResult();
assertEquals(0.5d, result.doubleValue(), 0.1d); // (2 - 1) / 2 = 0.5
}
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
1:49 p.m.
New subject: [Hibernate-JIRA] Updated: (HHH-5078) JPA criteria query numeric expressions produce wrong result (due to wrong bracketing)
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-5078?page=c...
]
Gail Badner updated HHH-5078:
-----------------------------
Fix Version/s: 3.6
JPA criteria query numeric expressions produce wrong result (due to
wrong bracketing)
-------------------------------------------------------------------------------------
Key: HHH-5078
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5078
Project: Hibernate Core
Issue Type: Patch
Components: entity-manager, query-criteria
Affects Versions: 3.5.0-Final, 3.5.1
Environment: Hibernate-Core 3.5.0-Final, all database platforms
Reporter: Christoph Gerkens
Assignee: Gail Badner
Fix For: 3.5.2, 3.6
Attachments: hhh-5078-fix.txt, TestCase_HHH-5078.zip
The combination of quot and diff results in wrong SQL code. E.g.: (2 - 1) / 2 should be
evaluated to 0.5 not 1.5 ( which is 2 - (1 / 2).
JUnit 4 Test:
@Test
public void testJpaCriteriaApiQuoteAndDiff() {
CriteriaBuilder cb = em.getCriteriaBuilder();
CriteriaQuery<Number> query = cb.createQuery(Number.class);
query.from(SystemUser.class); // entity type doesn't matter, but must contain at
least one entry for this test case.
query.select( // (2 - 1) / 2
cb.quot(
cb.diff(
cb.literal(BigDecimal.valueOf(2.0)),
cb.literal(BigDecimal.valueOf(1.0))),
BigDecimal.valueOf(2.0))).distinct(true);
Number result = em.createQuery(query).getSingleResult();
assertEquals(0.5d, result.doubleValue(), 0.1d); // (2 - 1) / 2 = 0.5
}
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
5:20 p.m.
New subject: [Hibernate-JIRA] Resolved: (HHH-5078) JPA criteria query numeric expressions produce wrong result (due to wrong bracketing)
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-5078?page=c...
]
Gail Badner resolved HHH-5078.
------------------------------
Resolution: Fixed
Fixed in trunk and Branch_3_5.
JPA criteria query numeric expressions produce wrong result (due to
wrong bracketing)
-------------------------------------------------------------------------------------
Key: HHH-5078
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5078
Project: Hibernate Core
Issue Type: Patch
Components: entity-manager, query-criteria
Affects Versions: 3.5.0-Final, 3.5.1
Environment: Hibernate-Core 3.5.0-Final, all database platforms
Reporter: Christoph Gerkens
Assignee: Gail Badner
Fix For: 3.5.2, 3.6
Attachments: hhh-5078-fix.txt, TestCase_HHH-5078.zip
The combination of quot and diff results in wrong SQL code. E.g.: (2 - 1) / 2 should be
evaluated to 0.5 not 1.5 ( which is 2 - (1 / 2).
JUnit 4 Test:
@Test
public void testJpaCriteriaApiQuoteAndDiff() {
CriteriaBuilder cb = em.getCriteriaBuilder();
CriteriaQuery<Number> query = cb.createQuery(Number.class);
query.from(SystemUser.class); // entity type doesn't matter, but must contain at
least one entry for this test case.
query.select( // (2 - 1) / 2
cb.quot(
cb.diff(
cb.literal(BigDecimal.valueOf(2.0)),
cb.literal(BigDecimal.valueOf(1.0))),
BigDecimal.valueOf(2.0))).distinct(true);
Number result = em.createQuery(query).getSingleResult();
assertEquals(0.5d, result.doubleValue(), 0.1d); // (2 - 1) / 2 = 0.5
}
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
2:26 p.m.
New subject: [Hibernate-JIRA] Closed: (HHH-5078) JPA criteria query numeric expressions produce wrong result (due to wrong bracketing)
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-5078?page=c...
]
Steve Ebersole closed HHH-5078.
-------------------------------
JPA criteria query numeric expressions produce wrong result (due to
wrong bracketing)
-------------------------------------------------------------------------------------
Key: HHH-5078
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5078
Project: Hibernate Core
Issue Type: Patch
Components: entity-manager, query-criteria
Affects Versions: 3.5.0-Final, 3.5.1
Environment: Hibernate-Core 3.5.0-Final, all database platforms
Reporter: Christoph Gerkens
Assignee: Gail Badner
Fix For: 3.5.2, 3.6
Attachments: hhh-5078-fix.txt, TestCase_HHH-5078.zip
The combination of quot and diff results in wrong SQL code. E.g.: (2 - 1) / 2 should be
evaluated to 0.5 not 1.5 ( which is 2 - (1 / 2).
JUnit 4 Test:
@Test
public void testJpaCriteriaApiQuoteAndDiff() {
CriteriaBuilder cb = em.getCriteriaBuilder();
CriteriaQuery<Number> query = cb.createQuery(Number.class);
query.from(SystemUser.class); // entity type doesn't matter, but must contain at
least one entry for this test case.
query.select( // (2 - 1) / 2
cb.quot(
cb.diff(
cb.literal(BigDecimal.valueOf(2.0)),
cb.literal(BigDecimal.valueOf(1.0))),
BigDecimal.valueOf(2.0))).distinct(true);
Number result = em.createQuery(query).getSingleResult();
assertEquals(0.5d, result.doubleValue(), 0.1d); // (2 - 1) / 2 = 0.5
}
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
5197
days inactive
5297
days old
hibernate-issues@lists.jboss.org
11 comments
4 participants
participants (4)
-
Christoph Gerkens (JIRA) -
Gail Badner (JIRA)
-
Jesper Steen Møller (JIRA)
-
Steve Ebersole (JIRA)