|
Simple formula property with cast not working.
<property name="validNumber" type="boolean" generated="always" formula="(CAST(foo AS integer) > 0)"/>
This should convert in MySQL to
`(CAST(foo AS UNSIGNED) > 0) AS validNumber `
But `AS` keyword in HQL seems to be detected as table alias even if inside `CAST`.
wrong SQL is generated: `(CAST(foo AS this_.unsigned) > 0) AS validNumber`
|