java - Aliases expected length is 0; actual length is 1 on hibernate query cache

Question

String q1Str = "SELECT parent_id FROM meta WHERE st_id = "+childIds+";";
Query q1 = em.createNativeQuery(q1Str);
//q1.setHint("org.hibernate.cacheable", true);
Object parentId = null;
try{
parentId = q1.getSingleResult();
}catch(NoResultException nre){
    //nope
}

enabling hibernate.cacheable will throw me the following exception

aliases expected length is 0; actual length is 1

Answer 1

I think this happens when the queried table does not have a primary key.