no parentheses in SQL math operation with modulo and TSQL dialect ----------------------------------------------------------------- Key: HHH-6523 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-6523 Project: Hibernate Core Issue Type: Bug Components: core Affects Versions: 3.6.4 Reporter: Rafał this fragment of JPA criteria: qb.mod( qb.diff( qb.literal(1), qb.literal(2)) ), qb.literal(3) ), generates proper HQL mod(1-2, 3) which means [A] (1 - 2) % 3 but since TSQL supports '%' for modulo operation, generated sql is: 1 - 2 % 3 modulo operator has higher priority, so this effectively means: [B] 1 - (2 % 3) problem is: [A] != [B] -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira