SQL containing `escape '\'` as result of `findAllByXXXContaining` fails on MySQL 8.0

[tarepanda1024]

When I using findAllByXXXContaining() , jpa generate sql , and append "escape '' ", this makes sql exec failed.Is this a bug or feature ? How can I avoid this？

SpringBootVersion: 3.1.5
SpringDataJpaVersion: 3.1.5
JDK：jdk21
mysql:8.0

[quaff]

You should turn off NO_BACKSLASH_ESCAPES at mysql server side.

[tarepanda1024]

You should turn off NO_BACKSLASH_ESCAPES at mysql server side.

Oh , It works ! Thanks ! Is there any config to turn off this feature in JPA not in mysql?

[quaff]

With my test with MySQL Server 5.7.44, no matter NO_BACKSLASH_ESCAPES enabled or not, spring-data-jpa/hibernate will works fine.
NO_BACKSLASH_ESCAPES enabled then escape '\' will be used.
NO_BACKSLASH_ESCAPES disabled then escape '\\' will be used.

I assume your database is not real mysql but some other database use mysql protocol, If I'm correct you should report bug to its team.

[tarepanda1024]

With my test with MySQL Server 5.7.44, no matter NO_BACKSLASH_ESCAPES enabled or not, spring-data-jpa/hibernate will works fine. NO_BACKSLASH_ESCAPES enabled then escape '\' will be used. NO_BACKSLASH_ESCAPES disabled then escape '\\' will be used.

I assume your database is not real mysql but some other database use mysql protocol, If I'm correct you should report bug to its team.

I start mysql process in docker.It's real mysql.

[quaff]

You can test escape '\' with NO_BACKSLASH_ESCAPES mode via mysql cli.

[tarepanda1024]

You can test escape '\' with NO_BACKSLASH_ESCAPES mode via mysql cli.

It's fails.

[mp911de]

LIKE with ESCAPE is a feature to control escaping with Starts/Ends/Contains queries to avoid injection of control characters that would be able to change the nature of the query.

As @quaff already pointed out, this is a configuration setting outside of Spring Data.

[gowrishankarjhcbb]

LIKE with ESCAPE is a feature to control escaping with Starts/Ends/Contains queries to avoid injection of control characters that would be able to change the nature of the query.

As @quaff already pointed out, this is a configuration setting outside of Spring Data.

how about oracle any specific confifguration ?