Skip to content

sql: error result is ambiguous in tpcc after online primary key change #44504

@awoods187

Description

@awoods187

I'm testing out online primary key changes as described in #44501
I ran this change:

set experimental_enable_primary_key_changes =true;
ALTER TABLE customer ALTER COLUMN c_city set not null;
ALTER TABLE customer ALTER PRIMARY KEY USING COLUMNS (c_city, c_w_id ASC, c_d_id ASC, c_id ASC);

After completing an online primary key change, the workload failed with:

Error: error in payment: ERROR: result is ambiguous (intent missing and record aborted) (SQLSTATE 40003)
Error:  exit status 1

Metadata

Metadata

Labels

C-investigationFurther steps needed to qualify. C-label will change.

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions