[BUG] SQLUtils.refactor rewrite tablename error

[wangweicugw]

使用SQLUtils.refactor改写表名时，改写错误，把库名改写了 https://github.com/alibaba/druid/wiki/TableMapping_cn

Database Type

MySQL

Database Version

MySQL 5.7

Druid Version

1.2.23

JDK Version

JDK8

Error SQL

select user.music.col from user.music
insert into user.music(id, user_id, col) values (1, 2, 3) on duplicate key update user.music.col = 5

Testcase Code

    public static void main(String[] args) {
        Map<String, String> mapping = Collections.singletonMap("user", "user_01");

        String sql = "select user.music.col from user.music";
        String result = SQLUtils.refactor(sql, JdbcConstants.MYSQL, mapping);
        System.out.println("result = " + result);
        // SELECT user_01.music.col
        //FROM user.music

        sql = "insert into user.music(id, user_id, col) values (1, 2, 3) on duplicate key update user.music.col = 5";
        result = SQLUtils.refactor(sql, JdbcConstants.MYSQL, mapping);
        System.out.println("result = " + result);
        //INSERT INTO user.music (id, user_id, col)
        //VALUES (1, 2, 3)
        //ON DUPLICATE KEY UPDATE user_01.music.col = 5
    }

Stacktrace Info

No response

Error Info

No response

[Jin-2019]

同类型问题 https://github.com/alibaba/druid/issues/6119