Message Title

Mohsen Kashi updated an issue

Change By:	Mohsen Kashi

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

Add Comment

This message was sent by Atlassian JIRA