[Bug]: bvt failed in sys_restore_view_to_sys_account.sql

[badboynt1]

Is there an existing issue for the same bug?

• [X] I have checked the existing issues.

Branch Name

main

Commit ID

lastest

Other Environment Information

- Hardware parameters:
- OS type:
- Others:

Actual Behavior

2024-10-21 02:17:49 INFO Executor:291 - The script file[/home/runner/work/matrixone/matrixone/head/test/distributed/cases/snapshot/sys_restore_view_to_nonsys_account.sql] has been executed, and cost: 12.755s, total:312, success:312, failed:0, ignored:0, abnoraml:0 2024-10-21 02:17:49 INFO Executor:37 - Start to execute the script file[/home/runner/work/matrixone/matrixone/head/test/distributed/cases/snapshot/sys_restore_view_to_sys_account.sql] now, and it will take a few moment,pleas wait...... 2024-10-21 02:17:53 ERROR RSSet:164 - The row count does not equal with each other, one is 0, the other is 5 2024-10-21 02:17:53 ERROR Executor:199 - [/home/runner/work/matrixone/matrixone/head/test/distributed/cases/snapshot/sys_restore_view_to_sys_account.sql][row:181][select * from EmployeeDepartmentView;] was executed failed, con[id=0, user=dump, *** 2024-10-21 02:17:53 ERROR Executor:201 - [EXPECT RESULT]: SQL parser error: table "employeedepartmentview" does not exist 2024-10-21 02:17:53 ERROR Executor:202 - [ACTUAL RESULT]: firstname lastname departmentname John Doe Human Resources Jane Smith Engineering Alice Johnson Marketing Mark Patterson Sales David Finley Finance 2024-10-21 02:18:03 INFO Executor:291 - The script file[/home/runner/work/matrixone/matrixone/head/test/distributed/cases/snapshot/sys_restore_view_to_sys_account.sql] has been executed, and cost: 14.355s, total:324, success:323, failed:1, ignored:0, abnoraml:0

Expected Behavior

No response

Steps to Reproduce

https://github.com/matrixorigin/matrixone/actions/runs/11431765610/job/31801215315?pr=19463

Additional information

No response

[YANGGMM]

Standalone-e2e-BVT-Test-on-Linux-x64(LAUNCH,PESSIMISTIC)-reports.zip

[YANGGMM]

[YANGGMM]

drop一个view，然后还能看到这个view