I can reproduce this with hibernate 5.2.10.Final and mssql server 2014 as well as postgres. The issue persists no matter how my select is issued: hql, (legacy) criteria api or jpa criteria.
This is huge as it makes some queries quite slow and there is no workaround.