Open chinamcafee opened 2 years ago
There is a json array field in mysql table, which name is "permissions"，I can't use Criteria.where("permissions").in(value) to get results.
Criteria.where("permissions").in(value)
I also need dynamic SQL，so use @Modifying @Query("UPDATE person SET firstname = :firstname where lastname = :lastname") cannot satisfied my problem.
@Modifying @Query("UPDATE person SET firstname = :firstname where lastname = :lastname")
Is there any way to have both dynamic SQL ability and JSON_CONTAINS function support when I use spring-data-r2dbc?
Related: https://github.com/spring-projects/spring-data-jdbc/issues/509
schauder
commented
2 years ago
There is a json array field in mysql table, which name is "permissions"，I can't use
Criteria.where("permissions").in(value)to get results.I also need dynamic SQL，so use
@Modifying @Query("UPDATE person SET firstname = :firstname where lastname = :lastname")cannot satisfied my problem.Is there any way to have both dynamic SQL ability and JSON_CONTAINS function support when I use spring-data-r2dbc?