Interesting that it even works in 197. Env: Oracle JDK 8 and AmazonCorreto JDK 11.0.3, W10, Intellij
FYI I used orderby but didn't worked. return createQuery((cb, root, query) -> { List<Predicate> predicates = createCriteria(id, addrSearchParams, cb, root); Query q = entityManager.createQuery(query.where(predicates.toArray(new Predicate[0])).orderBy(searchParams(searchParams, cb, root))); rangeQuery(q, searchParams); return q.getResultList(); }); searchParams param is blank object as we passed it from above mentioned test method. On Monday, August 5, 2019 at 3:31:41 PM UTC+5:30, Evgenij Ryazanov wrote: > > I assume you understand that order of results in queries without ORDER BY > can be changed again at any time. It's better to change tests in > order-independent way. > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/90b86773-4f3f-464f-b1d1-44c1560a98f3%40googlegroups.com.