dtle
dtle copied to clipboard
Fail to support aggregation scene:When use sql insert PK table(auto-increment) with PK value as null
Description
Fail to support aggregation sceneï¼When use sql insert PK tableï¼auto-incrementï¼ with PK value as null
Steps to reproduce the issue:
-
table defition
Create Table: CREATE TABLE `sbtest1` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`k` int(10) unsigned NOT NULL DEFAULT '0',
`c` char(120) NOT NULL DEFAULT '',
`pad` char(60) NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
KEY `k_1` (`k`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1 MAX_ROWS=1000000
Describe the results you received:
step4, the new comming record cover the records of step3 .
Describe the results you expected:
Output of ./dtle version
:
Dtle 9.9.9.9 (git: master f09064f0e148822b4faa9ab75eb68ecf6ed46729)
Additional information you deem important (e.g. issue happens only occasionally):
always
Additional details (log, config, job config etc):
logs hereï¼ dtle_log.txt