Skip to content

Investigate propagation of advanced CrateDB table options during ALTER TABLE recreation #101

Description

@coderabbitai

Context

In PR #98, we implemented AlterTableRecreateStatements to handle primary key column changes by recreating tables with a temporary table approach.

Problem

When creating a temporary table for schema altering purposes (see comment), we need to verify that advanced CrateDB table options are propagated properly from the original table to the temporary table.

Advanced table options may include:

  • Partitioning configuration
  • Sharding configuration
  • Replication settings
  • Table parameters (e.g., number_of_replicas, refresh_interval)
  • Storage settings
  • Other CrateDB-specific table attributes

Investigation needed

Check whether the current implementation in _create_table preserves all relevant table options when creating the temporary table used in the ALTER TABLE recreation workflow.

Related

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    enhancementNew feature or requestimportantNot a bug, still important.

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions