The tidb LIKE operator

## Bug Report

Please answer these questions before submitting your issue. Thanks!

### 1. Minimal reproduce step (Required)

1) select count(*) from information_schema.tables where table_name like 'ACT_RU_EXECUTION'

2) select * from information_schema.tables where table_name like 'ACT_RU_EXECUTION'

返回 8条数据

2）select * from information_schema.tables where table_name = 'ACT_RU_EXECUTION'

返回11条数据

3） select * from information_schema.tables where upper(table_name) like 'ACT_RU_EXECUTION'


返回11条数据

### 2. What did you expect to see? (Required)

结果集相同

### 3. What did you see instead (Required)

### 4. What is your TiDB version? (Required)

Release Version: v8.5.2
Edition: Enterprise
Git Commit Hash: f43a13324440f92209e2a9f04c0bbe9cf763978d
Git Branch: HEAD
UTC Build Time: 2025-05-29 03:31:55
GoVersion: go1.23.8
Race Enabled: false
Check Table Before Drop: false
Store: tikv
Enterprise Extension Commit Hash: 7d43ff65ebc145bd63fa84cb368f8775be906998