Count query is created incorrectly when selecting new objects [DATAJPA-1587]

[spring-projects-issues]

Jeroen Hendrickx opened DATAJPA-1587 and commented

When I create a query that selects a new Object using a Pageable, the generated count query is incorrect.

E.g. the following query:

@Query("SELECT new com.acme.Foo(fooBar) " +
"FROM FooBar fooBar")

Generated the following count query:

select count(new com.acme.Foo(fooBar)) FROM FooBar fooBar

In release 2.1.9 the generated query was

select count(fooBar) FROM FooBar fooBar

which is the correct query.

It looks like this is a side effect from the changes requested in DATAJPA-1564.

Note, if I change the query and start it with a space, the count query is generated properly.
i've managed to write some tests on this in the org.springframework.data.jpa.repository.query.QueryTest:

This test passes:

@Test
public void createCountQueryForSelectNewStartingWithSpace() throws Exception {
        assertCountQuery(" SELECT new com.acme.Foo(fooBar) FROM FooBar fooBar", " select count(fooBar) FROM FooBar fooBar");
    }

While this test fails:

@Test
public void createCountQueryForSelectNewNotStartingWithSpace() throws Exception {
        assertCountQuery("SELECT new com.acme.Foo(fooBar) FROM FooBar fooBar", "select count(fooBar) FROM FooBar fooBar");
    }

---

Affects: 2.1.10 (Lovelace SR10)

Issue Links:

• DATAJPA-1732 Spring jpql query validation failed for constructor method on spring boot 2.3
  ("is duplicated by")

1 votes, 1 watchers

[gregturn]

Duplicates #1869.

Resolved via f2e7bdd.