Hibernate adds alias for PARTITION keyword
For example :
{code:java} @Formula(" ROW_NUMBER() OVER( PARTITION BY VOUCHER_MASTER_ID ORDER BY SIGN(amount) DESC , ABS(amount) ASC)") private Integer lineNumber; {code}
Causes this sql:
{code:sql} ROW_NUMBER() OVER( voucherlin21_.PARTITION BY voucherlin21_.VOUCHER_MASTER_ID ORDER BY SIGN(voucherlin21_.amount) DESC , ABS(voucherlin21_.amount) ASC) AS formula0_20_, {code}
By removing alias from PARTITION generated SQL works properly |
|