Update dbt-tests-adapter requirement from <1.9.0,>=1.8.0 to >=1.8.0,<1.11.0 #756

	---
	name: Unit tests
	on: # yamllint disable-line rule:truthy
	workflow_dispatch:
	push:
	branches:
	- master
	- v*
	pull_request:
	branches:
	- master
	- v*
	schedule:
	- cron: '0 22 * * 0'

	jobs:
	unit-tests:
	name: Unit tests
	strategy:
	matrix:
	python_version: ["3.8", "3.9", "3.10", "3.11"]
	runs-on: ubuntu-latest
	permissions:
	contents: read
	packages: read
	container:
	image: ghcr.io/${{ github.repository }}:CI-${{ matrix.python_version }}-msodbc18
	credentials:
	username: ${{ github.actor }}
	password: ${{ secrets.github_token }}
	steps:

	- uses: actions/checkout@v4

	- name: Install dependencies
	run: pip install -r dev_requirements.txt

	- name: Run unit tests
	run: pytest -n auto -ra -v tests/unit

Provide feedback