[Bug] Fix query comments test

[damian3031]

Is this a new bug in dbt-core?

• I believe this is a new bug in dbt-core
• I have searched the existing issues, and I could not find an existing issue for this bug

Current Behavior

test_query_comments.py::BaseMacroArgsQueryComments::test_matches_comment is comparing dbt-core version with dbt adapter version, which is wrong assumtion after decoupling dbt adapters from dbt-core version.

Expected Behavior

No error should be raised for different versions of dbt adapter and dbt-core.

Steps To Reproduce

1. Have different versions of dbt adapter and dbt-core.
2. Run test_query_comments.py::BaseMacroArgsQueryComments::test_matches_comment test

Relevant log output

No response

Environment

- OS: macOS
- Python: 3.12
- dbt-core: 1.8.0b2

Which database adapter are you using with dbt?

other (mention it in "Additional Context")

Additional Context

No response