AnatolyUss/nmig

ALTER COLUMN "default_value" SET DEFAULT 'b'0''

ScoobyMax opened this issue · 3 comments

A lot of errors on my migration:


        --[DefaultProcessor::default] error: ошибка синтаксиса (примерное положение: "1")

        SQL: ALTER TABLE "public"."project_status" ALTER COLUMN "can_delete" SET DEFAULT 'b'1'';


        --[DefaultProcessor::default] error: ошибка синтаксиса (примерное положение: "0")

        SQL: ALTER TABLE "public"."project_status" ALTER COLUMN "show_in_status_history" SET DEFAULT 'b'0'';

Source mysql table columns like:

    deleted                   bit default b'0'              not null,
    completed              bit default b'0'              not null,
    readonly                 bit default b'0'              not null,
    warning                  bit default b'0'              not null,

I guess that the boolean type should turn out

Hello again,
The issue is fixed in the latest release (Nmig v5.6.0)
Please, pull latest changes from master, If still relevant.
Sorry for the delay.