apache / apache/shardingsphere

batch insert can not back fill primary key

Open
#21,258 3 comments 0 reactions 1 assignee Claimed by @luka2049 View on GitHub
feature: encrypt
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.
![image](https://user-images.githubusercontent.com/31396902/192944144-f2117097-b0ad-4ee6-b5d0-0e2cdd20b7e3.png)

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).
![image](https://user-images.githubusercontent.com/31396902/192930641-db982dd6-5f5f-473f-b42f-fa84880edeb4.png)

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.