move test_semver to common

[ChenyuLInx]

related to #https://github.com/dbt-labs/dbt-core/issues/9961

Description

Checklist

• [x] I have read the contributing guide and understand what's expected of me
• [x] I have signed the CLA
• [x] I have run this code in development and it appears to resolve the stated issue
• [x] I have opened an issue to add/update docs, or docs changes are not required/relevant for this PR
• [x] I have run changie new to create a changelog entry

[codecov-commenter]

Codecov Report

All modified and coverable lines are covered by tests :white_check_mark:

Project coverage is 64.57%. Comparing base (4c96366) to head (6fcd2cc).

Additional details and impacted files

```diff @@ Coverage Diff @@ ## main #136 +/- ## ========================================== + Coverage 56.37% 64.57% +8.19% ========================================== Files 50 50 Lines 3088 3088 ========================================== + Hits 1741 1994 +253 + Misses 1347 1094 -253 ``` | [Flag](https://app.codecov.io/gh/dbt-labs/dbt-common/pull/136/flags?src=pr&el=flags&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=dbt-labs) | Coverage Δ | | |---|---|---| | [unit](https://app.codecov.io/gh/dbt-labs/dbt-common/pull/136/flags?src=pr&el=flag&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=dbt-labs) | `64.57% <ø> (+8.19%)` | :arrow_up: | Flags with carried forward coverage won't be shown. [Click here](https://docs.codecov.io/docs/carryforward-flags?utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=dbt-labs#carryforward-flags-in-the-pull-request-comment) to find out more.

:umbrella: View full report in Codecov by Sentry.
:loudspeaker: Have feedback on the report? Share it here.