With any query using criteria with projections, hibernate automatically includes another column for the identifier proiperty of the root entity in the select clause having a duplicate sql alias with the next column. Even though I have already included the identifier property, it includes it again, and it causes a duplicate sql alias which of course breaks the result mapping especially if the next column to the auto inserted identifier hasn't the same data type.