ERROR 1105 (HY000): runtime error: index out of range [-1]

[luyomo]

Bug Report

I am testing the migration from mysql to tidb for icinga2. Everything is fine until the data migration, but when I attempted to start the icinga2 web service, the following errors comes.
https://github.com/Icinga/icinga2
ERROR 1105 (HY000): runtime error: index out of range [-1]

1. Minimal reproduce step (Required)

Please find the attached file reproduce.ddl and errorQuery.sql

1. Create DB objects using reproduce.txt
   reproduce.txt

2. Run the query from errorQuerty.txt
   errorQuery.txt

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

No error.

3. What did you see instead (Required)

ERROR 1105 (HY000): runtime error: index out of range [-1]

4. What is your TiDB version? (Required)

| Release Version: v5.0.1
Edition: Community
Git Commit Hash: 1145e34
Git Branch: heads/refs/tags/v5.0.1
UTC Build Time: 2021-04-23 05:42:59
GoVersion: go1.13
Race Enabled: false
TiKV Min Version: v3.0.0-60965b006877ca7234adaced7890d7b029ed1306
Check Table Before Drop: false

[aytrack]

can reproduce on 5.0.1, but can't reproduce on master and 5.0.2 freeze commit(f610f8b）

[luyomo]

When can we get the 5.0.2 from tiup?
I would like to test it

[winoros]

@luyomo Now you should get the 5.0.2 from tiup. If you have any question, please contact us :)

[yudongusa]

@luyomo would you please verify if the issue is resolved? If so, please go ahead to close this issue.

[tisonkun]

closed as marked as cannot reproduced. @luyomo feel free to reopen it if any further information missed.

[github-actions]

Please check whether the issue should be labeled with 'affects-x.y' or 'backport-x.y.z',
and then remove 'needs-more-info' label.