About dynamic query in chapter 7 of JPA Pro 2nd edition

[Himai Minh]

Hi, the book shows a query:

 private static final String QUERY =
        "SELECT e.salary " +
        "FROM Employee e " +
        "WHERE e.department.name = :deptName AND " +
        "      e.name = :empName ";

          
public long queryEmpSalaryUsingParams(String deptName, String empName) {
        try {
            return em.createQuery(QUERY, Long.class)
                     .setParameter("deptName", deptName)
                     .setParameter("empName", empName)
                     .getSingleResult();
        } catch (NoResultException e) {
            return 0;
        }
    }

The book says the query created will have a single quote prefix of empName like this:
SELECT e.salary  FROM Employee e WHERE e.department.name = 'NS65' AND e.name = ''Roberts' ;

Roberts becomes 'Roberts. And it won't find Robert's record.
However, after I tried a few times with this created query, it can find the Robert's record.