Hello, thanks for creating a test case.

Oops, it seems you used entityManager.createQuery instead of entityManager.createNativeQuery in the second part of both test. Turns out the sql is the same for a native query and a HQL query. If you change it to createNativeQuery, the first test will fail.

thank you