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.
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.