Incorrect alias detect for query if parameter contains "from" path

[PiryazevAlex]

I have a query with parameter named periodFrom. So i have an error if i pass order parameter to JPA repository method

Page<Some> findSome(LocalDate periodFrom, Pageable pageable);

After debug, I found bug in org.springframework.data.jpa.repository.query.QueryUtils.

import org.junit.jupiter.api.Test;
import org.springframework.data.jpa.repository.query.QueryUtils;

public class QueryUtilsTest {
    @Test
    void queryUtilsWrongAliasDetection(){
        final String query = "select p from Some p where (:periodFrom is null or p.periodFrom = :periodFrom)";
        final String actual = QueryUtils.detectAlias(query);
        assertEquals("p", actual);
    }
}

[edudar]

Fixed in #2521

[gregturn]

The core issue is #2260 (#2521 was the related PR).

Indeed, this issue now passes...

@Test // GH-2535
void queryUtilsWrongAliasDetection() {
	assertThat(QueryUtils.detectAlias("select p from Some p where (:periodFrom is null or p.periodFrom = :periodFrom)"))
			.isEqualTo("p");
}

The release with this patch went out last Friday (https://spring.io/blog/2022/05/13/spring-data-2021-2-and-2022-0-m4-released).

[PiryazevAlex]

Thanks