Error using view in recursive cte : [1356] [HY000]: View 'wdhis.udc_branch_test' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them

[knull-cn]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

20231222.txt

1. create table pub_branch;
2. create view udc_branch_test
3. using view in recursive cte

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

execute query nomarl without error

3. What did you see instead (Required)

report error:
[1356] [HY000]: View 'wdhis.udc_branch_test' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them

4. What is your TiDB version? (Required)

• v7.1.1
• v7.5.0