search

apache / shardingsphere

Distributed SQL transaction & query engine for data sharding, scaling, encryption, and more - on any database.
Apache License 2.0
19.65k stars 6.67k forks source link

使用insert values时, 设置主键参数的index错误 #7508

Closed zhaoyuehui closed 3 years ago

zhaoyuehui commented 3 years ago

Bug Report

笔者使用的主键生成策略是SnowFlake算法, 在执行insert ....values语句时, 由于values中包含null值, 在设置主键id的参数index时, 参数错位. 代码位置如下图所示 image

当参数中包含一个null值时, 主键id的index的位置会被前移一位

menghaoranss commented 3 years ago

For english only.