I did as you said.
The query is like this
select flutime0_.TIMEUID as TIMEUID3_0_, flunav1x1_.DATASOURCEKEY as DATASOUR1_2_1_, flutime0_.SEASONKEY as SEASONKEY3_0_, flutime0_.MENUTEXT as MENUTEXT3_0_, flutime0_.FLUWK as FLUWK3_0_, flunav1x1_.SEASONKEY as SEASONKEY2_1_, flunav1x1_.SEASON as SEASON2_1_, flunav1x1_.GEOVALUE as GEOVALUE2_1_, flunav1x1_.GEOLABEL as GEOLABEL2_1_, flunav1x1_.GEOMASK as GEOMASK2_1_, flunav1x1_.WEEKS as WEEKS2_1_ from FLUTIME flutime0_, FLUNAV1 flunav1x1_ where flunav1x1_.GEOMASK=? and flunav1x1_.SEASONKEY=flutime0_.SEASONKEY and flunav1x1_.SEASONKEY=? and bitand(weeks, power(2, flutime0_.FLUWK))=power(2, flutime0_.FLUWK) group by flutime0_.FLUWK , flutime0_.MENUTEXT
I get following exception...
Exception in
thread "main" org.hibernate.exception.SQLGrammarException: could not execute query