Error when specifiying default on integer list column

Description

Not sure if actually supported or pending...

Repro (from UI):

  • create a table T (c1 int, c2 string c3 list_of_int, c4 list of string), specify [1,2,3] as default for C3
    ==>
    'org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [ALTER TABLE T21433210 ADD COLUMN C87642 BIGINT(50) DEFAULT NULL COMMENT 'INTEGER', ADD COLUMN C87643 VARCHAR(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT 'STRING', ADD COLUMN C87644 JSON DEFAULT [1,2,3] COMMENT 'INTEGER_LIST', ADD COLUMN C87645 JSON DEFAULT NULL COMMENT 'STRING_LIST']; nested exception is java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[1,2,3] COMMENT 'INTEGER_LIST', ADD COLUMN C87645 JSON DEFAULT NULL COMMENT 'S' at line 1'

Environment

None

Assignee

Ziming Dong

Reporter

Xavier Schildwachter

Labels

None

Validator

Xavier Schildwachter

Development Area

None

Release Version History

None

Components

Sprint

None

Fix versions

Priority

Major
Configure