add multi fields on table

[timigame]

Hi, I test to add multi fields on a table in mysql, but only first field sync to postgresql.

ALTER TABLE t_user_info ADD (
group_id INT(11) UNSIGNED DEFAULT NULL,
contact_phone VARCHAR(20) DEFAULT NULL
);

Only group_id into postgresql.

Could you resolve this issue?

[the4thdoctor]

hi, thanks for the report. I'll have a look asap.

[the4thdoctor]

The bug is caused by a not covering regexp for this specific form of the alter.
The same statement written in this way works.
ALTER TABLE t_user_info ADD group_id INT(11) UNSIGNED DEFAULT NULL, ADD contact_phone VARCHAR(20) DEFAULT NULL ;

I suggest to use this syntax as a workaround meanwhile I find a bug fix.
Thanks