[HAWQ-1213] Incorrect check of hawqregister in case of randomly distributed table with non-default `default_hash_table_bucket_number` value.

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.1.0.0-incubating
• Fix Version/s: 2.1.0.0-incubating
• Component/s: Command Line Tools
• Assignee: Hong Wu
• Reporter: Hong Wu
• Created: 11/Dec/16 07:49
• Updated: 18/Feb/17 05:27
• Resolved: 12/Dec/16 06:04

Description

Bug reproduce process:

postgres=# set default_hash_table_bucket_number=10;

postgres=# create table sales2( amount numeric(10,2), year integer) with(appendonly=true) distributed randomly partition by range(year) (start(2014) end (2016) every(1));

postgres=# create table sales6( amount numeric(10,2), year integer) with(appendonly=true) distributed randomly partition by range(year) (start(2014) end (2016) every(1));

hawq extract -d postgres -o sales2.yml sales2

hawq register -d postgres --config sales2.yml sales6

gpadmin-[ERROR]:-Bucket number of public.sales6_1_prt_1 is not consistent with previous bucket number

Issue Links

• links to: GitHub Pull Request #1045