search

dart-backend / angel

A polished, production-ready backend framework in Dart for the VM, AOT, and Flutter.
https://github.com/dukefirehawk/angel
BSD 3-Clause "New" or "Revised" License
171 stars 22 forks source link

change MySQL/MariaDB SQL statement for changeColumnType method #127

Closed Garthi closed 1 week ago

Garthi commented 1 week ago

Hi, we found a bug in the package angel_migration_runner on the method changeColumnType

this method generate a SQL statement like this

ALTER TABLE [table] ALTER COLUMN [column] TYPE varchar(32);

this statement is not working for MariaDB or MySQL, the correct SQL statement is

ALTER TABLE [table] MODIFY [column] varchar(32);