Improve DISTINCT query for finding queue names in PostgreSQL #1168

	name: Build
	on: [push, pull_request]

	jobs:
	rubocop:
	name: Rubocop
	runs-on: ubuntu-latest
	steps:
	- name: Checkout code
	uses: actions/checkout@v4
	- name: Setup Ruby and install gems
	uses: ruby/setup-ruby@v1
	with:
	ruby-version: 3.0
	bundler-cache: true
	- name: Run rubocop
	run: \|
	bundle exec rubocop --parallel
	tests:
	name: Tests
	runs-on: ubuntu-latest
	strategy:
	fail-fast: false
	matrix:
	ruby-version: [3.3.5]
	database: [mysql, postgres, sqlite]
	services:
	mysql:
	image: mysql:8.0.31
	env:
	MYSQL_ALLOW_EMPTY_PASSWORD: "yes"
	ports:
	- 33060:3306
	options: --health-cmd "mysql -h localhost -e \"select now()\"" --health-interval 1s --health-timeout 5s --health-retries 30
	postgres:
	image: postgres:15.1
	env:
	POSTGRES_HOST_AUTH_METHOD: "trust"
	ports:
	- 55432:5432
	env:
	TARGET_DB: ${{ matrix.database }}
	steps:
	- name: Checkout code
	uses: actions/checkout@v4
	- name: Setup Ruby and install gems
	uses: ruby/setup-ruby@v1
	with:
	ruby-version: ${{ matrix.ruby-version }}
	bundler-cache: true
	- name: Setup test database
	run: \|
	bin/rails db:setup
	- name: Run tests
	run: bin/rails test
	- name: Run tests with separate connection
	run: SEPARATE_CONNECTION=1 bin/rails test

Provide feedback