表名模糊匹配bug

porpoiselxj · 2026 年1 月 4 日 03:16

Bug 反馈
清晰准确地描述您发现的问题，提供任何可能复现问题的步骤有助于研发同学及时处理问题
【 TiDB 版本】 v8.5.3
【 Bug 的影响】
升级后对现有应用产生影响，无法过滤需要的数据

【可能的问题复现步骤】

【看到的非预期行为】
加了个 TABLE_NAME like ‘%G’ 的条件后，一条数据都查不到了

【期望看到的行为】
表里有很多以字母G结尾的表名，应该能查到才对

WalterWj · 2026 年1 月 4 日 03:19

是不是大小写问题，有试过全小写么

porpoiselxj · 2026 年1 月 4 日 03:21

table_name like ‘%g’ 也查不到

tangenta · 2026 年1 月 4 日 07:20

v8.5.3 没复现…
执行 ./tidb-server -V 看看？

porpoiselxj · 2026 年1 月 14 日 02:32

版本就是8.5.3

porpoiselxj · 2026 年1 月 14 日 02:34

经王WZ老师字典，和这两个bug有关，在8.5.4已修复

github.com/pingcap/tidb

*: fix incorrect rlike when quering information_schema

master ← wjhuang2016:fix_infoschema_rlike

已打开 02:24PM - 05 Nov 25 UTC

wjhuang2016

+57 -38

### What problem does this PR solve? Issue Number: close #64249 Problem …Summary: We process rlike as like, so it can't get the right result. ### What changed and how does it work? Use correct regexp.Regexp instead of WildcardPattern. The later is only work for `like`. ### Check List Tests - [ ] Unit test - [x] Integration test - [ ] Manual test (add detailed scripts or steps below) - [ ] No need to test > - [ ] I checked and no code files have been changed. > Side effects - [ ] Performance regression: Consumes more CPU - [ ] Performance regression: Consumes more Memory - [ ] Breaking backward compatibility Documentation - [ ] Affects user behaviors - [ ] Contains syntax changes - [ ] Contains variable changes - [ ] Contains experimental features - [ ] Changes MySQL compatibility ### Release note Please refer to [Release Notes Language Style Guide](https://pingcap.github.io/tidb-dev-guide/contribute-to-tidb/release-notes-style-guide.html) to write a quality release note. ```release-note fix incorrect rlike when quering infomation_schema ```

github.com/pingcap/tidb

planner: memory table extractor filter targets by all regexp

master ← JQWong7:fix-62347

已打开 09:31AM - 14 Jul 25 UTC

JQWong7

+23 -2

### What problem does this PR solve? Issue Number: close https://github.com…/pingcap/tidb/issues/62347 Problem Summary: memory table extractor will not match all regexp. ### What changed and how does it work? every schema object need to match all regexp. ### Check List Tests - [ ] Unit test - [x] Integration test - [ ] Manual test (add detailed scripts or steps below) - [ ] No need to test > - [ ] I checked and no code files have been changed. > Side effects - [ ] Performance regression: Consumes more CPU - [ ] Performance regression: Consumes more Memory - [ ] Breaking backward compatibility Documentation - [ ] Affects user behaviors - [ ] Contains syntax changes - [ ] Contains variable changes - [ ] Contains experimental features - [ ] Changes MySQL compatibility ### Release note Please refer to [Release Notes Language Style Guide](https://pingcap.github.io/tidb-dev-guide/contribute-to-tidb/release-notes-style-guide.html) to write a quality release note. ```release-note None ```

system · 2026 年1 月 21 日 02:34

此话题已在最后回复的 7 天后被自动关闭。不再允许新回复。