Int to Float or Double db:push

Hi we are working on a project that has drizzle db connected to a planetscale database. We initially had a column as an integer, but we later on decided that the column should be a float or a double. Doing a db:push truncates the column and deletes all the rows of the table. Is this a bug or is it like that by design? If it's by design what is the best way to update the columns to a double without wiping the table? Thanks in advance.
Was this page helpful?