[Improvement][Upgrade] Assert the upgrade table is same with initialize table

[ruanwenjun]

Search before asking

• I had searched in the issues and found no similar feature requirement.

Description

Right now we use schema check to make sure contributor has do schema change on all database, and write e2e to make sure the upgrade sql is correct.

But it's needed to make the upgrade logic is correct, so this issue is aim to check the scheme output by upgrade sql have the same structure with initialize.
e.g. if we initialize the scheme 3.0.0, and the latest version is dev. so we can upgrade the schema from 3.0.0 to dev, and compare the table with schema initialize from dev.

Are you willing to submit a PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct

[github-actions]

This issue has been automatically marked as stale because it has not had recent activity for 30 days. It will be closed in next 7 days if no further activity occurs.

[github-actions]

This issue has been closed because it has not received response for too long time. You could reopen it if you encountered similar problems in the future.