[FLINK-32824] Port Calcite's fix for the sql like operator

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.18.0, 1.17.1
• Fix Version/s: 1.18.0, 1.19.0
• Component/s: Table SQL / Runtime
• Labels: pull-request-available
• Assignee: Shuai Xu
• Reporter: lincoln lee
• Created: 10/Aug/23 04:33
• Updated: 29/Aug/23 03:53
• Resolved: 29/Aug/23 03:53

Description

we should port the bugfix of sql like operator https://issues.apache.org/jira/browse/CALCITE-1898

The LIKE operator must match '.' (period) literally, not treat it as a wild-card. Currently it treats it the same as '_'.

Issue Links

• links to: GitHub Pull Request #23209
• links to: GitHub Pull Request #23312