cubicweb #14050899 Cannot create attribute with vocabulary containing a semi-colon [validation pending]

This makes db-create crash:

from yams.buildobjs import EntityType, String

class Turlututu(EntityType):
    attr = String(vocabulary=('hello;sir', 'howareyou?'))

See sqlutils.sqlexec where we split on ";"...

Generated SQL is:

CREATE TABLE cw_Turlututu(
 cw_attr varchar(10),
 cw_modification_date timestamp with time zone NOT NULL,
 cw_creation_date timestamp with time zone NOT NULL,
 cw_cwuri text NOT NULL,
 cw_eid integer PRIMARY KEY REFERENCES entities (eid)
, CONSTRAINT cstr34c5427ee9d2bba1119dd017725078f2 CHECK(cw_attr IN ('hello;;sir', 'howareyou?'))
);;

Note the double semi-colons.

prioritynormal
typebug
done in3.24.0
load left0.000
closed by#c172fa18565e [schema2sql] Avoid "parsing" SQL statements for database initialization
patch[schema2sql] Avoid "parsing" SQL statements for database initialization [applied][schema2sql] Drop unused indent argument on aschema2sql [applied][schema2sql] Drop most of the DB DROP related code [applied][schema2sql] More docstrings and minor API improvements [applied][schema2sql] inline eschema_attrs method [applied][schema2sql] Give a rdef to check_constraint [applied]