apache / apache/incubator-seata-samples

Duplicate entry 'DF001' for key 'PRIMARY'

Open
#59 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
Java
Stars
2.4k
Forks
2k
PR merge metrics
No merged PRs in 30d

Description

调测springboot子模块,在导入initial_db.sql时报错。
我看到该脚本中下面两句有冲突:
INSERT INTO `t_asset` VALUES ('DF001', 'e2d1c4512d554db9ae4a5f30cbc2e4b1', '1');
INSERT INTO `t_asset` VALUES ('DF001', 'DF001-V-CODE', 100);

Contributor guide

Open the contributing guide

Research direction

Open initial_db.sql and inspect the two INSERT statements for t_asset that both use the primary key DF001. Reproduce the import in the springboot submodule, then verify that the corrected initialization script imports without a duplicate-primary-key error.

Written by the indexing model from the issue text.

Assessment

Tech stack
java, spring-boot
Domain
database
Issue type
Bug
Difficulty
1/5
Estimated time
Under an hour
Activity status
Stale
Clarity
Clearly specified
Newbie friendliness
45/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.