Skip to content

SQL errors after setting limits for "char" or for "varchar" in data_types_map.json #142

@dmitrii-chernikov

Description

@dmitrii-chernikov

Setting a limit on "char" in data_types_map.json to

    "char" : {
        "increased_size"           : "",
        "type"                     : "character(255)",
        "mySqlVarLenPgSqlFixedLen" : false
    },

and running the application leads to SQL errors like

        --[TableProcessor::createTable] error: syntax error at or near "("

        SQL: CREATE TABLE IF NOT EXISTS "test"."test_comments"("id" int,"user_id" int,"comment" text,"submit_date" timestamp,"ip_address" character(255)(15),"is_public" boolean);

Setting a limit on "varchar" in data_types_map.json to

    "varchar" : {
        "increased_size"           : "",
        "type"                     : "character varying(255)",
        "mySqlVarLenPgSqlFixedLen" : false
    },

and running the application leads to SQL errors like

        --[TableProcessor::createTable] error: syntax error at or near "("

        SQL: CREATE TABLE IF NOT EXISTS "test"."test_auth"("id" int,"name" character varying(255)(150));

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