Break dereference_input into HDA and HDCA variants #33426

	name: Database indexes
	on:
	push:
	paths-ignore:
	- 'client/**'
	- 'doc/**'
	- 'lib/galaxy_test/selenium/**'
	- 'packages/**'
	pull_request:
	paths-ignore:
	- 'client/**'
	- 'doc/**'
	- 'lib/galaxy_test/selenium/**'
	- 'packages/**'
	concurrency:
	group: ${{ github.workflow }}-${{ github.ref }}
	cancel-in-progress: true
	defaults:
	run:
	working-directory: 'galaxy root'
	jobs:
	check:
	name: Check database indexes
	runs-on: ubuntu-latest
	strategy:
	matrix:
	db: ['postgresql', 'sqlite']
	postgresql-version: ['17']
	python-version: ['3.10']
	include:
	- db: postgresql
	postgresql-version: '9.6'
	python-version: '3.10'
	services:
	postgres:
	image: postgres:${{ matrix.postgresql-version }}
	env:
	POSTGRES_USER: postgres
	POSTGRES_PASSWORD: postgres
	POSTGRES_DB: postgres
	ports:
	- 5432:5432
	steps:
	- uses: actions/checkout@v6
	with:
	path: 'galaxy root'
	persist-credentials: false
	- uses: actions/setup-python@v6
	with:
	python-version: ${{ matrix.python-version }}
	- name: Install uv
	uses: astral-sh/setup-uv@v7
	- name: Get full Python version
	id: full-python-version
	shell: bash
	run: echo "version=$(python -c 'import sys; print("-".join(str(v) for v in sys.version_info))')" >> $GITHUB_OUTPUT
	- name: Install tox
	run: uv tool install tox --with tox-uv
	- name: Set database connection on PostgreSQL
	if: matrix.db == 'postgresql'
	run: echo 'GALAXY_CONFIG_OVERRIDE_DATABASE_CONNECTION=postgresql://postgres:postgres@localhost:5432/galaxy?client_encoding=utf8' >> $GITHUB_ENV
	- name: Check indexes
	run: tox -e check_indexes

Provide feedback