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. | |
priority | important |
---|---|
type | bug |
done in | 3.3.0 |
load | 0.500 |
load left | 0.000 |
closed by | <not specified> |
similar entities
- cubicweb #1809383 CWAttributeAddOp crash on sql server
- cubicweb #847652 re enable testing agains real db
- cubicweb #1251822 MySQL support : string index length problem
- cubicweb #1113844 Migration script function to reindex a given entity
- cubicweb #2146391 Mysql : Identifier name 'unique_cw_cwsourcehostconfig_cw_cw_host_config_of_cw_match_host_idx' is too long
[see all]
Comments
-
2009/05/29 16:51, written by mailbot
add commentfixed @home, will be pushed in 3.3.1 / 3.2.4 (depends on a new release of lgc and yams...)