I modified the testcase and attached the new version to the issue. But I can only test the Hibernate version 4.1.6.Final as my company's proxy server filters to aggressive (jars are to big...). But I've tested it with H2 and MSSQL and both report the error.

Maybe this kind of queries are not allowed - then sorry for the wrong issue report.