Re: [PR] [FLINK-36100][table] Support ESCAPE in built-in function LIKE [flink]

[via GitHub]

dylanhz commented on PR #25225:
URL: https://github.com/apache/flink/pull/25225#issuecomment-2309692044

   > Also verified the result with escaping characters, all results with 
supported patterns are consistent with mysql: 
![image](https://private-user-images.githubusercontent.com/3712895/361295061-51919cb7-fb44-4ada-a450-4baea85b7ff5.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MjQ2NjIzOTMsIm5iZiI6MTcyNDY2MjA5MywicGF0aCI6Ii8zNzEyODk1LzM2MTI5NTA2MS01MTkxOWNiNy1mYjQ0LTRhZGEtYTQ1MC00YmFlYTg1YjdmZjUucG5nP1gtQW16LUFsZ29yaXRobT1BV1M0LUhNQUMtU0hBMjU2JlgtQW16LUNyZWRlbnRpYWw9QUtJQVZDT0RZTFNBNTNQUUs0WkElMkYyMDI0MDgyNiUyRnVzLWVhc3QtMSUyRnMzJTJGYXdzNF9yZXF1ZXN0JlgtQW16LURhdGU9MjAyNDA4MjZUMDg0ODEzWiZYLUFtei1FeHBpcmVzPTMwMCZYLUFtei1TaWduYXR1cmU9YmU4MjBjY2U5ZmQ4ZDA3YWZjOGM4YjMxZGIwMGUxMDEwM2U5NmY1N2MwM2JiOGIxZDJmYzAyY2Q0ZmQ4YjhjMiZYLUFtei1TaWduZWRIZWFkZXJzPWhvc3QmYWN0b3JfaWQ9MCZrZXlfaWQ9MCZyZXBvX2lkPTAifQ.zRTCt4_G9xaq3blxFFIAbFmVEpOp3Yb0EkpTqHPOUAE)
   
   Case 7 and case 8 will throw an exception in our implementation, because we 
don't allow normal character after the escape character.


-- 
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: issues-unsubscr...@flink.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org