@Test
    public void testBuildCreateTableStatement() {
        List<String> primaryKeys = Arrays.asList("a", "b");
        List<Column> columns = Arrays.asList(new Column("a", Collections.singletonList("32"), Types.VARCHAR,
                new Position(PositionType.FIRST, null), false, "InLong", "a column"),
                new Column("b", Collections.singletonList("32"), Types.VARCHAR,
                        new Position(PositionType.FIRST, null), false, "InLong", "a column"),
                new Column("c", Collections.singletonList("32"), Types.VARCHAR,
                        new Position(PositionType.FIRST, null), true, "InLong", "a column"),
                new Column("d", Collections.singletonList("32"), Types.VARCHAR,
                        new Position(PositionType.FIRST, null), true, "InLong", "a column"));
        CreateTableOperation operation = new CreateTableOperation();
        operation.setComment("create table auto");
        operation.setColumns(columns);
        String database = "inlong_database";
        String table = "inlong_table";
        Assert.assertEquals("CREATE TABLE IF NOT EXISTS `inlong_database`.`inlong_table`(\n"
                + "\t`a` VARCHAR(96) NOT NULL DEFAULT 'InLong' COMMENT 'a column',\n"
                + "\t`b` VARCHAR(96) NOT NULL DEFAULT 'InLong' COMMENT 'a column',\n"
                + "\t`c` VARCHAR(96) DEFAULT 'InLong' COMMENT 'a column',\n"
                + "\t`d` VARCHAR(96) DEFAULT 'InLong' COMMENT 'a column'\n"
                + ")\n"
                + "UNIQUE KEY(`a`,`b`)\n"
                + "COMMENT 'create table auto'\n"
                + "DISTRIBUTED BY HASH(`a`,`b`)\n"
                + "PROPERTIES (\n"
                + "\t\"light_schema_change\" = \"true\"\n"
                + ")",
                helper.buildCreateTableStatement(database, table, primaryKeys, operation));
    }
Test for {@link OperationHelper#buildCreateTableStatement(String, String, List, CreateTableOperation)}
inlong-sort/sort-flink/sort-flink-v1.13/sort-connectors/doris/src/test/java/org/apache/inlong/sort/doris/schema/OperationHelperTest.java