mysql使用了for update报expected semicolon or EOF, found 'FOR'错误

[hhhax]

我的sql加上了 for update 提示这个报错

[fly-studio]

sharing遇到for update时，无法正常分表

问题出现在：Sharding.resolve中的expr, err := sqlparser.NewParser(strings.NewReader(query)).ParseStatement()

sqlparser不识别for update语句，以至于if后直接return，导致无法进行分表操作

需要修复

`github.com/longbridgeapp/sqlparser`

临时的解决方法是用RAW来写语句,table的分表名用下面的算法得出，分表的计算方法如下：

func ShardingAlgorithm(numberOfShards int, value any) (suffix string, err error) {
    var tableFormat string
    if numberOfShards == 0 {
        return "", errors.New("specify NumberOfShards or ShardingAlgorithm")
    }
    if numberOfShards < 10 {
        tableFormat = "_%01d"
    } else if numberOfShards < 100 {
        tableFormat = "_%02d"
    } else if numberOfShards < 1000 {
        tableFormat = "_%03d"
    } else if numberOfShards < 10000 {
        tableFormat = "_%04d"
    }
    id := 0
    switch value := value.(type) {
    case int:
        id = value
    case int64:
        id = int(value)
    case string:
        id, err = strconv.Atoi(value)
        if err != nil {
            id = int(crc32.ChecksumIEEE([]byte(value)))
        }
    default:
        return "", errors.Errorf("default algorithm only support integer and string column," +
            "if you use other type, specify you own ShardingAlgorithm")
    }

    return fmt.Sprintf(tableFormat, id%numberOfShards), nil
}