v.db.renamecolumn mysql error

[fpouw]

The SQL in the v.db.renamecolumn package is not correct for mysql

Adding the following elif command to the "#some tricks" section enables renaming (at least for varchar column type. I didn't test it for other types)

elif driver in mysql:

if oldcoltype.upper() == "CHARACTER":

newcoltype = "varchar(%s)" % (oldcollength)

else:

newcoltype = oldcoltype

sql = "ALTER TABLE %s CHANGE %s %s %s" % (table, oldcol, newcol, newcoltype) grass.write_command('db.execute', input = '-', database = database, driver = driver, stdin = sql)

[neteler]

proposed mysql fix as diff

[neteler]

See also #2759

[martinl]

I tested patch and took liberty to apply r67315.

[martinl]

Backported in r67360. Closing ticket.