[Bug] Add test for 9682 in core against 1.7

[VersusFacit]

Is this a new bug in dbt-bigquery?

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

Current Behavior

No test. Not instantiating frozensets right.

Expected Behavior

Test the working changes.

Steps To Reproduce

See this core PR

Relevant log output

No response

Environment

- OS:
- Python:
- dbt-core:
- dbt-bigquery:

Additional Context

No response

[mikealfare]

Closing in favor of the 1.8 issue. It will be easier to review in the future.