diff options
| author | Tomas Vondra | 2017-07-14 19:57:48 +0000 |
|---|---|---|
| committer | Tomas Vondra | 2017-07-14 19:57:48 +0000 |
| commit | d45fd537e43d58af340d2da2cdc921d2e85bac50 (patch) | |
| tree | 1f61b3b5cf5f22ddc4827c7f6cf00e12e121ee6f | |
| parent | 5c83ff3b4c072756d96e6bc7626ef7678d977bfe (diff) | |
Accept int2vector not being hash distributable
Upstream commit 5c80642aa8de8393b08cd3cbf612b325cedd98dc removed support
for hashing int2vector data type, as it was dead code (upstream). That
means we can no longer distribute table by hash on this datatype.
We could reintroduce the hash function in Postgres-XL, but int2vector
seems rarely used as distribution key, so let's just fix the tests. If
needed, we can add the functions in the future.
| -rw-r--r-- | src/test/regress/expected/xl_distribution_column_types.out | 9 | ||||
| -rw-r--r-- | src/test/regress/sql/xl_distribution_column_types.sql | 10 |
2 files changed, 0 insertions, 19 deletions
diff --git a/src/test/regress/expected/xl_distribution_column_types.out b/src/test/regress/expected/xl_distribution_column_types.out index e372c4a27b..8d9ac799d8 100644 --- a/src/test/regress/expected/xl_distribution_column_types.out +++ b/src/test/regress/expected/xl_distribution_column_types.out @@ -34,14 +34,6 @@ CREATE TABLE xl_dc4 ( name text, price numeric ) DISTRIBUTE BY HASH (is_available); ---INT2VECTOR, -CREATE TABLE xl_dc5 ( - product_no integer, - product_id integer, - sub_product_ids INT2VECTOR PRIMARY KEY, - name text, - price numeric -) DISTRIBUTE BY HASH (sub_product_ids); --OIDVECTOR, CREATE TABLE xl_dc6 ( product_no integer, @@ -199,7 +191,6 @@ DROP TABLE xl_dc1; DROP TABLE xl_dc2; DROP TABLE xl_dc3; DROP TABLE xl_dc4; -DROP TABLE xl_dc5; DROP TABLE xl_dc6; DROP TABLE xl_dc7; DROP TABLE xl_dc8; diff --git a/src/test/regress/sql/xl_distribution_column_types.sql b/src/test/regress/sql/xl_distribution_column_types.sql index 486b730cf1..d8580d98a7 100644 --- a/src/test/regress/sql/xl_distribution_column_types.sql +++ b/src/test/regress/sql/xl_distribution_column_types.sql @@ -44,15 +44,6 @@ CREATE TABLE xl_dc4 ( price numeric ) DISTRIBUTE BY HASH (is_available); ---INT2VECTOR, -CREATE TABLE xl_dc5 ( - product_no integer, - product_id integer, - sub_product_ids INT2VECTOR PRIMARY KEY, - name text, - price numeric -) DISTRIBUTE BY HASH (sub_product_ids); - --OIDVECTOR, CREATE TABLE xl_dc6 ( product_no integer, @@ -231,7 +222,6 @@ DROP TABLE xl_dc1; DROP TABLE xl_dc2; DROP TABLE xl_dc3; DROP TABLE xl_dc4; -DROP TABLE xl_dc5; DROP TABLE xl_dc6; DROP TABLE xl_dc7; DROP TABLE xl_dc8; |