cubicweb #343488 SQL error in migration script [resolved]

The SQL generated when updating / changing a column type is (at least sometimes) syntactically incorrect for MySQL. CubicWeb generates queries like:

ALTER TABLE ... ALTER COLUMN ...

where MySQL would expect:

ALTER TABLE ... MODIFY COLUMN ... (or CHANGE ...)

Take a look at : http://dev.mysql.com/doc/refman/5.1/en/alter-table.html

In all cases, this should not be Cubicweb's responsibility to generate those queries, it should rely on logilab.common.adbh.

priorityimportant
typebug
done in3.3.0
load0.500
load left0.000
closed by<not specified>