I cannot set more than one value to a "SET" field.

[cbocaz]

In a table with a column of type "SET", I am unable to set more than one value from the assigned values in the table's DDL.

Example:
CREATE TABLE test ( id int unsigned NOT NULL AUTO_INCREMENT, name varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, type set('valA','valB','valC') NOT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

If I try to insert a record, both in the grid and the "Insert rows" button functionality, it is impossible to set, for example, the value "valA,valC".

Can anyone help?

[Fabio286]

This is a bug that will be fixed in the next release. I have opened an issue (#626) to track the fix.
Currently to update a field of type SET you have to run a query manually.