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

Activity

Show:
Ziming Dong
January 8, 2020, 7:28 PM

Duplicates since setting defaults had in the same error for all LIST type columns

Duplicate

Assignee

Ziming Dong

Reporter

Xavier Schildwachter

Labels

None

Validator

Xavier Schildwachter

Development Area

None

Release Version History

None

Priority

Major
Configure