Skip to content

Column name strings get misinterpreted as column type strings #8

@yongjunj

Description

@yongjunj

Thank you for your work on pg2mysql - it's been a godsend on a number of occasions.

This is a minor issue, but it seems that column name strings get misinterpreted as column type strings, producing an invalid SQL output. Creating an issue here just for reference.

Input:

...
CREATE TABLE test (
    integer1    text,
    integer2    text
);
...

Expected output:

CREATE TABLE test (
    integer1    text,
    integer2    text
) TYPE=MyISAM;

Actual output:

CREATE TABLE test (
    int(11)1    text,
    int(11)2    text
) TYPE=MyISAM;

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions