query CLUSTER_STATEMENTS_SUMMARY table meet error: [expression:1305]FUNCTION RegexpUTF8Sig does not exist

[YiniXu9506]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

tiup playground nightly

SELECT  COUNT(*) FROM `INFORMATION_SCHEMA`.`CLUSTER_STATEMENTS_SUMMARY` WHERE table_names REGEXP '\binformation_schema\.';

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

+----------+
| COUNT(*) |
+----------+
|        0 |
+----------+
1 row in set (0.02 sec)

3. What did you see instead (Required)

ERROR 1105 (HY000): other error: [expression:1305]FUNCTION RegexpUTF8Sig does not exist

4. What is your TiDB version? (Required)

mysql> SELECT tidb_version();
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| tidb_version()                                                                                                                                                                                                                                                                                                                   |
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Release Version: v5.5.0-alpha
Edition: Community
Git Commit Hash: 42675fd9db50ae3cd6bcd3e4890624352b01c70f
Git Branch: heads/refs/tags/v5.5.0-alpha
UTC Build Time: 2022-03-02 14:51:41
GoVersion: go1.16.4
Race Enabled: false
TiKV Min Version: v3.0.0-60965b006877ca7234adaced7890d7b029ed1306
Check Table Before Drop: false |
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

[crazycs520]

@djshow832 PTAL

[djshow832]

This is caused by #32636.
Once regexp is supported by TiFlash, TiDB pushes down the operator to other TiDB instances and then reports an error.
I'm afraid there are many other similar problems for cluster memory tables.

[seiya-annie]

only exists in master

[breezewish]

I changed the severity to critical since TiDB Dashboard relies on these table querying to work. For now TiDB Dashboard as a built-in feature is broken.