apache / apache/shardingsphere
batch insert can not back fill primary key
- Dominant language
- Java
- Stars
- 20.8k
- Forks
- 6.9k
- Avg merge
- 11h 35m
- Merged PRs (30d)
- 326
Description
## Bug Report
**For English only**, other languages will not accept.
Before report a bug, make sure you have:
- Searched open and closed [GitHub issues](https://github.com/apache/shardingsphere/issues).
- Read documentation: [ShardingSphere Doc](https://shardingsphere.apache.org/document/current/en/overview).
Please pay attention on issues you submitted, because we maybe need more details.
If no response anymore and we cannot reproduce it on current information, we will **close it**.
Please answer these questions before submitting your issue. Thanks!
### Which version of ShardingSphere did you use?
5.2.0
### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
ShardingSphere-JDBC
### Expected behavior
all records has primary key
### Actual behavior
all records has no primary key
### Reason analyze (If you can)
### Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc.

server:
port: 8080
spring:
application:
name: sharding-bug-demo
main:
allow-bean-definition-overriding: true
shardingsphere:
datasource:
names: master
master:
type: com.alibaba.druid.pool.DruidDataSource
driver-class-name: com.mysql.jdbc.Driver
url: jdbc:mysql://127.0.0.1:3306/test?useUnicode=true&characterEncoding=UTF-8&allowMultiQueries=true&serverTimezone=Asia/Shanghai
username: root
password: '123456'
maxActive: 20
initialSize: 1
minIdle: 1
validationQuery: select 1
testWhileIdle: true
testOnBorrow: false
testOnReturn: false
rules:
encrypt:
encryptors:
encryptor-aes:
type: AES
props:
aes-key-value: 123456
tables:
sharding_test:
columns:
account_mobile:
cipherColumn: account_mobile
encryptorName: encryptor-aes
### Example codes for reproduce this issue (such as a github link).

Contributor guide
Assessment
This issue has not been assessed yet.