altinityknowledgebase icon indicating copy to clipboard operation
altinityknowledgebase copied to clipboard

fix alter modify column in v23.8 or later

Open cw5121 opened this issue 1 year ago • 3 comments

…sible.md

run optimize table final before run fixed alter modify column, otherwise will throw errors in v23.8

I have read the CLA Document and I hereby sign the CLA

cw5121 avatar Jun 18 '24 12:06 cw5121

CLA Assistant Lite bot All contributors have signed the CLA ✍️ ✅

github-actions[bot] avatar Jun 18 '24 12:06 github-actions[bot]

I have read the CLA Document and I hereby sign the CLA

cw5121 avatar Jun 20 '24 14:06 cw5121

Hi, Can you explain this change in a bit more detail?

ALTER TABLE modify_column MODIFY COLUMN column_n Enum8('kye_a' = 1, 'key_b' = 2, 'key_c' = 3)

Unknown element 'key_a' for enum, maybe you meant: ['key_b']:

I see that Enum have one wrong value -> kye_a instead of key_b, and in "solution" part of article we expected to have "correct" queries

UnamedRus avatar Jul 17 '24 07:07 UnamedRus