Easier column type conversions

Open
#69 0 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Assessment

Difficulty
5/5
Estimated time
Over a week
Newbie friendliness
35/100
Issue type
Feature
Clarity
Mostly clear
Activity status
Stale
Tech stack
sql
Domain
databases

Research direction

Start by locating the implementation and tests for ALTER TABLE and ALTER COLUMN TYPE handling. Use the STRING-to-SYMBOL example as the first case to trace, and define done as supporting the single ALTER TABLE statement without manually adding, updating, and dropping a column.

Written by the indexing model from the issue text.

Description

open source SQL

At the moment, changing a column from, for example, STRING to SYMBOL type requires adding a new column, running UPDATE and dropping the old column. We should make it as easy as a single ALTER TABLE my_table ALTER COLUMN my_column TYPE SYMBOL;

Dominant language
No language data
Stars
7
Forks
0
No merged PRs in 30d

Contributor guide

No contributing guide indexed for this repository

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

More from questdb/roadmap

All issues in questdb/roadmap

Similar issues

More Databases issues

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.