[BUG] merge sql error, dbType h2, druid-1.2.23, sql : ALTER TABLE IF EXISTS INSTANCE_INFO MODIFY IP CHARACTER VARYING(100) com.alibaba.druid.sql.parser.ParserException: not supported.pos 42, line 1, column 37, token IDENTIFIER MODIFY

[dsomehan]

Database Type

H2

Database Version

h2 2.1.214

Druid Version

1.2.23

JDK Version

1.8

Error SQL

ALTER TABLE IF EXISTS INSTANCE_INFO MODIFY IP CHARACTER VARYING(100)

Testcase Code

package com.alibaba.druid;

import com.alibaba.druid.sql.visitor.ParameterizedOutputVisitorUtils;

public class H2Test {
    public static void main(String[] args) {
        ParameterizedOutputVisitorUtils.parameterize(
                "ALTER TABLE IF EXISTS INSTANCE_INFO MODIFY IP CHARACTER VARYING(100);",DbType.h2);
    }
}

Stacktrace Info

Exception in thread "main" com.alibaba.druid.sql.parser.ParserException: not supported.pos 42, line 1, column 37, token IDENTIFIER MODIFY
at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:664)
at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:108)
at com.alibaba.druid.sql.visitor.ParameterizedOutputVisitorUtils.parameterize(ParameterizedOutputVisitorUtils.java:167)
at com.alibaba.druid.sql.visitor.ParameterizedOutputVisitorUtils.parameterize(ParameterizedOutputVisitorUtils.java:138)
at com.alibaba.druid.sql.visitor.ParameterizedOutputVisitorUtils.parameterize(ParameterizedOutputVisitorUtils.java:109)
at com.alibaba.druid.sql.visitor.ParameterizedOutputVisitorUtils.parameterize(ParameterizedOutputVisitorUtils.java:83)
at com.alibaba.druid.H2Test.main(H2Test.java:7)

Error Info

No response