TableSchemaEditor: Error when setting up default on column of type StringList

Description

Got it from UI but I assume this is coming from backend.

Attempting to set a default on a StringList column. Getting '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 '["A"] COMMENT 'STRING_LIST'' at line 1' back.

Tried:

  • ["AA"]

  • ['AA']

  • [A]

  • A ==> got a not a JSON array in this case

Environment

None

Assignee

Ziming Dong

Reporter

Xavier Schildwachter

Labels

None

Validator

Xavier Schildwachter

Development Area

None

Release Version History

None

Priority

Major
Configure