Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

fix(aws-redshift): Columns would not be deleted upon removal from the array #22974

Closed
wants to merge 11 commits into from
Closed

Conversation

Rizxcviii
Copy link
Contributor

@Rizxcviii Rizxcviii commented Nov 18, 2022

When attempting to a drop a column from the array, this would cause an error similar to that of the following
Received response status [FAILED] from custom resource. Message returned: Statement status was FAILED: ERROR: column "column" of relation "table” already exists

fixes #22208


All Submissions:

Adding new Unconventional Dependencies:

  • This PR adds new unconventional dependencies following the process described here

New Features

  • Have you added the new feature to an integration test?
    • Did you use yarn integ to deploy the infrastructure and generate the snapshot (i.e. yarn integ without --dry-run)?

By submitting this pull request, I confirm that my contribution is made under the terms of the Apache-2.0 license

Rizxcviii and others added 4 commits November 18, 2022 10:37
addition: adding new test case for deletion of columns

deletion: removing test case for create new table on columns changing
addition: adding columns to delete

deletion: removing creating of tables if columns has changed.

If we know the table, database and cluster are the same, then we dont have to check if the columns are the same to make sure that what we are dealing with is a new table
@gitpod-io
Copy link

gitpod-io bot commented Nov 18, 2022

@github-actions github-actions bot added bug This issue is a bug. effort/small Small work item – less than a day of effort p2 beginning-contributor [Pilot] contributed between 0-2 PRs to the CDK labels Nov 18, 2022
@aws-cdk-automation aws-cdk-automation requested a review from a team November 18, 2022 11:38
Copy link
Collaborator

@aws-cdk-automation aws-cdk-automation left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

The pull request linter has failed. See the aws-cdk-automation comment below for failure reasons. If you believe this pull request should receive an exemption, please comment and provide a justification.

@Rizxcviii Rizxcviii marked this pull request as draft November 18, 2022 15:14
@aws-cdk-automation aws-cdk-automation dismissed their stale review November 18, 2022 18:56

✅ Updated pull request passes all PRLinter validations. Dissmissing previous PRLinter review.

@Rizxcviii Rizxcviii marked this pull request as ready for review November 18, 2022 19:05
@Rizxcviii Rizxcviii marked this pull request as draft November 18, 2022 21:06
@aws-cdk-automation
Copy link
Collaborator

AWS CodeBuild CI Report

  • CodeBuild project: AutoBuildv2Project1C6BFA3F-wQm2hXv2jqQv
  • Commit ID: f8f893f
  • Result: FAILED
  • Build Logs (available for 30 days)

Powered by github-codebuild-logs, available on the AWS Serverless Application Repository

@Rizxcviii Rizxcviii closed this Nov 21, 2022
@mergify
Copy link
Contributor

mergify bot commented Nov 21, 2022

⚠️ The sha of the head commit of this PR conflicts with #23011. Mergify cannot evaluate rules on this PR. ⚠️

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
beginning-contributor [Pilot] contributed between 0-2 PRs to the CDK bug This issue is a bug. effort/small Small work item – less than a day of effort p2
Projects
None yet
Development

Successfully merging this pull request may close these issues.

AWS CDK - Unable to delete a column of table from redshift database using CDK update)
2 participants