spring-data-jpa

spring-data-jpa copied to clipboard

contains in query derivation of an ElementCollection creates a proper isMember clause but encloses the argument in % leading to the wrong result.

1

When looking at the code `CONTAINING` is obviously intended to work with Strings (and be translated to `x like %?%`) and for collections where it gets translated to an `isMemberOf`....

schauder

Part of the logic considered `contains` on an ElementCollection of type String a like query, wrapping the parameter in wildcards. This is now fixed. Closes #2607

schauder

PostgreSql: operator does not exist: timestamp without time zone >= bytea

17

Use Spring Boot 2.6.6, Spring data JPA, Hibernate 5.6.7.Final, PostgreSql Driver 42.3.3, PostgreSql Server 14. I have query: ```SELECT u.* FROM "user" u WHERE ((:createdAtFrom = NULL OR :createdAtTo =...

Tsyklop

Passing null as stored procedure argument is broken in v2.7.0 (works in v2.6.8).

7

With spring.jpa.properties.hibernate.proc.param_null_passing=true we can pass null as stored procedure as parameter without any problem with Spring Boot 2.6.8 but upgrading to v2.7.0 throws exception with the same Hibernate version. I've...

denis111

As shown in the figure, it is mentioned in the official document that `Class-based Projections` cannot be used with **native query**, while **native query** is described as `setting the nativeQuery...

immadolf

QueryEnhancerFactory with JSqlParser on classpath prevent using hibernate placeholders in native queries

18

Hello. Using Spring Data 2.7.0 (from spring-data-bom version 2021.2.0) and having `com.github.jsqlparser` in the classpath prevent application to start if repositories use native queries with hibernate placeholders like `h-schema`. It...

valkuc

Use tuple queries for projections using QueryDSL and Query by Example

3

I'm implementing a dynamic query with following code. ``` userRepository.findBy(QUser.user.id.isNotNull(), q -> q.project("username").as(UserWithUsernameOnly.class).all()); ``` But the generated query still select all of the columns. ``` select user0_.id as id1_0_, user0_.create_date...

kekhuai

See #2563 - [✓] You have read the [Spring Data contribution guidelines](https://github.com/spring-projects/spring-data-build/blob/master/CONTRIBUTING.adoc). - [✓] You use the code formatters provided [here](https://github.com/spring-projects/spring-data-build/tree/master/etc/ide) and have them applied to your changes. Don’t submit...

darinmanica

detectAlias() in QueryUtils incorreclty detects order by clause alias

5

In the Spring Data shipped with Spring Boot 2.7.0 an `order by` clause alias is detected incorrectly. It seems like the [`detectAlias`](https://github.com/spring-projects/spring-data-jpa/blob/f5ddb7aa32b39c5ce7bf5a301f19f7556b31c275/spring-data-jpa/src/main/java/org/springframework/data/jpa/repository/query/QueryUtils.java#L436) method in `QueryUtils` class is being confused by...

agzamovr

Handle multiline subquery removal

2

- [X] You have read the [Spring Data contribution guidelines](https://github.com/spring-projects/spring-data-build/blob/master/CONTRIBUTING.adoc). - [X] You use the code formatters provided [here](https://github.com/spring-projects/spring-data-build/tree/master/etc/ide) and have them applied to your changes. Don’t submit any formatting...

c-fraser