search

tortoise / aerich

A database migrations tool for TortoiseORM, ready to production.
https://github.com/tortoise/aerich
Apache License 2.0
820 stars 94 forks source link

aerich creates multiple sql queries for a single column update #169

Open FIRDOUS-BHAT opened 3 years ago

FIRDOUS-BHAT commented 3 years ago

Here is what I got,

-- upgrade -- ALTER TABLE "studentchoices" ALTER COLUMN "subscription_duration" TYPE INT USING "subscription_duration"::INT; ALTER TABLE "studentchoices" ALTER COLUMN "subscription_duration" TYPE INT USING "subscription_duration"::INT; ALTER TABLE "studentchoices" ALTER COLUMN "subscription_duration" TYPE INT USING "subscription_duration"::INT; ALTER TABLE "studentchoices" ALTER COLUMN "subscription_duration" TYPE INT USING "subscription_duration"::INT; -- downgrade -- ALTER TABLE "studentchoices" ALTER COLUMN "subscription_duration" TYPE VARCHAR(100) USING "subscription_duration"::VARCHAR(100); ALTER TABLE "studentchoices" ALTER COLUMN "subscription_duration" TYPE VARCHAR(100) USING "subscription_duration"::VARCHAR(100); ALTER TABLE "studentchoices" ALTER COLUMN "subscription_duration" TYPE VARCHAR(100) USING "subscription_duration"::VARCHAR(100); ALTER TABLE "studentchoices" ALTER COLUMN "subscription_duration" TYPE VARCHAR(100) USING "subscription_duration"::VARCHAR(100);

long2ice commented 3 years ago

Latest source fixed that

FIRDOUS-BHAT commented 3 years ago

Latest version of aerich is 0.5.3 and the above issue came from the same version only!