Revert "[fix] : fix missing free for compile.Scope" #15410

Job	Run time
CHECK PR VALID	2s
Matrixone Upgrade CI / Compatibility Test With Release on Linux/x64(LAUNCH)	26m 36s
Matrixone CI / SCA Test on Ubuntu/x86	9m 13s
Matrixone CI / UT Test on Darwin/x86	39m 9s
Matrixone CI / UT Test on Ubuntu/x86	21m 35s
Matrixone Upgrade CI / Compatibility Test With Target on Linux/x64(LAUNCH)	41m 38s
Matrixone Compose CI / multi cn e2e bvt test docker compose(Optimistic/PUSH)	18m 29s
Matrixone Utils CI / check_organization_user	3s
Matrixone Compose CI / multi cn e2e bvt test docker compose(PESSIMISTIC)	24m 29s
Matrixone Standlone CI / e2e BVT Test on Linux/x64(LAUNCH,Optimistic)	27m 9s
Matrixone Standlone CI / Multi-CN e2e BVT Test on Linux/x64(LAUNCH, PROXY)	25m 0s
Matrixone Standlone CI / e2e BVT Test on Linux/x64(LAUNCH, PESSIMISTIC)	20m 14s
Matrixone Utils CI / pr-size-label	8s
Matrixone Utils CI / PR Unit Test Coverage	3m 18s
Matrixone Utils CI / docu_issue_check	3s
	4h 17m 6s

Provide feedback