[Bug]: alter table modify column json failed

fengttt commented 5 days ago

Is there an existing issue for the same bug?

[X] I have checked the existing issues.

Branch Name

main

Commit ID

f9719aa18738a4716152bdaee10acf201325fd76

Other Environment Information

- Hardware parameters:
- OS type:
- Others:

Actual Behavior

Alter table modify a column type to json will fail.

Expected Behavior

No response

Steps to Reproduce

DROP TABLE IF EXISTS president;

CREATE TABLE president (
    name VARCHAR(100) NOT NULL,
    nth INT NOT NULL,
    impeached BOOL
);

-- Crap. DJT
ALTER TABLE president MODIFY impeached INTEGER;

-- Crap. DJT again?
ALTER TABLE president MODIFY nth JSON;

Additional information

No response

qingxinhome commented 2 days ago

在mo中无法直接将一个基本类型（如 INT）转换为 JSON 类型进行互转

daviszhen commented 1 day ago

报错信息不友好。

2.1.0

matrixorigin / matrixone

[Bug]: alter table modify column json failed #19872