bingoohuang commented on issue #33904: URL: https://github.com/apache/shardingsphere/issues/33904#issuecomment-3488904087
> In this case Java escapes '\' into '' instead of ShardingSphere parser. When entering prepareStatement method, the parameter value is "SELECT th1_0.head_id, th1_0.head_name FROM myuser.ts_head th1_0 WHERE th1_0.head_name like ? ESCAPE '' ", so it's not a ShardingSphere parser bug Just write the following sql to a .sql file, and read it as string sql to be parsed. ```sql select * from t_daps_user where addr like '上海市%' ESCAPE '\' and user_id = 1 order by user_name ``` <img width="1630" height="1599" alt="Image" src="https://github.com/user-attachments/assets/678ec151-7078-4a81-9141-0d01e256ee63"; /> <img width="1541" height="1069" alt="Image" src="https://github.com/user-attachments/assets/923a202a-a83f-40a0-9ead-53513a8e204d"; /> -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
