Summary:
Partially port pg_regress test incremental_sort. Omit the queries
related to parallel queries because YB currently only supports that in
colocated databases. Temporarily switching to a colocated database at
that moment doesn't work well since queries depend on the tenk1 table
that was created in test_setup. And running the entire schedule in a
colocated database is currently difficult since the Java regress test
runner does not currently support running with a different database.
Jira: DB-16986
Test Plan:
On Almalinux 8:
./yb_build.sh fastdebug --gcc11 daemons initdb \
--java-test TestPgRegressPgDml
Close: #27448
Jenkins: test regex: TestPgRegress
Reviewers: kfranz
Reviewed By: kfranz
Subscribers: yql
Differential Revision: https://phorge.dev.yugabyte.com/D44388