[Bug] Add test for 9682 in core

[VersusFacit]

Is this a new bug?

• [X] I believe this is a new bug
• [X] I have searched the existing issues, and I could not find an existing issue for this bug

Current Behavior

No test for this core fix.

Expected Behavior

Adds a test!

Steps To Reproduce

There's no test.

Relevant log output

No response

Environment

- OS:
- Python:
- dbt-postgres:

Additional Context

No response

[mikealfare]

There's no backport for this because 1.7 is in dbt-core. It will be handled as part of https://github.com/dbt-labs/dbt-core/issues/9681