]> granicus.if.org Git - postgresql/commit
Use custom hash opclass for hash partition pruning
authorAlvaro Herrera <alvherre@alvh.no-ip.org>
Fri, 13 Apr 2018 15:27:22 +0000 (12:27 -0300)
committerAlvaro Herrera <alvherre@alvh.no-ip.org>
Fri, 13 Apr 2018 15:27:22 +0000 (12:27 -0300)
commitfafec4cce814b9b15991b62520dc5e5e84655a8a
tree28980c8abb1d2f63dba8e2cbd0bd7228f487db70
parent4d0f6d3f207d977d3685499263993206b56d425a
Use custom hash opclass for hash partition pruning

This custom opclass was already in use in other tests -- defined
independently in every such file.  Move the definition to the earliest
test that uses it, and keep it around so that later tests can reuse it.
Use it in the tests for pruning of hash partitioning, and since this
makes the second expected file unnecessary, put those tests back in
partition_prune.sql whence they sprang.

Author: Amit Langote
Discussion: https://postgr.es/m/CA%2BTgmoZ0D5kJbt8eKXtvVdvTcGGWn6ehWCRSZbWytD-uzH92mQ%40mail.gmail.com
13 files changed:
src/test/regress/expected/alter_table.out
src/test/regress/expected/hash_part.out
src/test/regress/expected/insert.out
src/test/regress/expected/partition_prune.out
src/test/regress/expected/partition_prune_hash.out [deleted file]
src/test/regress/expected/partition_prune_hash_1.out [deleted file]
src/test/regress/parallel_schedule
src/test/regress/serial_schedule
src/test/regress/sql/alter_table.sql
src/test/regress/sql/hash_part.sql
src/test/regress/sql/insert.sql
src/test/regress/sql/partition_prune.sql
src/test/regress/sql/partition_prune_hash.sql [deleted file]