Reduce test duplication between core and PAX storage?

[tuhaihe]

When reviewing the files in our codebase, I noticed a lot of duplicated tests between the PAX storage tests contrib/pax_storage/src/test and the core src/test directory.

Would it be possible to remove the basic, non-PAX-specific tests from the PAX folder and only retain tests unique to PAX functionality there? For the common test cases, could we reuse the existing tests in src/test instead?

This would reduce duplication and help us maintain a single source of truth for shared test logic. Thoughts?

[avamingli]

+1 for this,
one pain point is that when we search for a test SQL in the code, it appears multiple times, including instances in both Pax and SingleNode test, most of them are copied from regress.