I have some JPQL fragments stored as the "what" field in the "Rule" object. The JPQL query:
SELECT DISTINCT $0$ FROM Rule $0$ JOIN $0$.grouping $1$ WHERE ( $0$.what = 'SELECT x FROM Investigation x' AND $0$.crudFlags = 'CRUD' ) AND ( $1$.name = 'notroot' )
is translated to the SQL:
select distinct rule0_.id as id1_30_, rule0_.CREATE_ID as CREATE_I2_30_, rule0_.CREATE_TIME as CREATE_T3_30_, rule0_.MOD_ID as MOD_ID4_30_, rule0_.MOD_TIME as MOD_TIME5_30_, rule0_.bean as bean6_30_, rule0_.c as c7_30_, rule0_.crudFlags as crudFlag8_30_, rule0_.crudJPQL as crudJPQL9_30_, rule0_.d as d10_30_, rule0_.fromJPQL as fromJPQ11_30_, rule0_.grouping_id as groupin19_30_, rule0_.includeJPQL as include12_30_, rule0_.r as r13_30_, rule0_.restricted as restric14_30_, rule0_.u as u15_30_, rule0_.varCount as varCoun16_30_, rule0_.what as what17_30_, rule0_.whereJPQL as whereJP18_30_ from RULE_ rule0_ inner join Grouping grouping1_ on rule0_.grouping_id=grouping1_.id where rule0_.what='SELECT x FROM org.icatproject.core.entity.Investigation x' and rule0_.crudFlags='CRUD' and grouping1_.NAME='notroot'
Note that the original value of "what" which was 'SELECT x FROM Investigation x' has been expanded into 'SELECT x FROM org.icatproject.core.entity.Investigation x' which is clearly incorrect