OpenTenBase / OpenTenBase/TXSQL

Change error message when INSTANT ADD/DROP not possible in max column count

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

Nobody has claimed this yet.

Dominant language
C++
Stars
337
Forks
234
PR merge metrics
No merged PRs in 30d

Description

Background:
When a table with max column (1017) has repeated instant drop
followed by instant add on the same column, the n_def parameter
increases. This parameter has a max limit of 1023. Hence when we
cross this limit, the server reports "Too many columns".

Problem:
The error message from the server is misleading and columns
can't be added with ALGORITHM=INSTANT only. We can still
add column using INPLACE or COPY algorithm.

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.

Research direction

Start by reproducing the repeated instant DROP followed by instant ADD on a table at the stated maximum column count, then inspect where the server reports "Too many columns" for ALGORITHM=INSTANT. Compare the behavior with INPLACE and COPY, and confirm that the resulting error explains the algorithm limitation while those alternatives remain usable.

Written by the indexing model from the issue text.

Assessment

Tech stack
cpp
Domain
databases
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Quiet
Clarity
Mostly clear
Newbie friendliness
48/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.