dtle icon indicating copy to clipboard operation
dtle copied to clipboard

Fail to support aggregation scene:When use sql insert PK table(auto-increment) with PK value as null

Open Dinosauria opened this issue 5 years ago • 0 comments

Description

Fail to support aggregation scene:When use sql insert PK table(auto-increment) with PK value as null

Steps to reproduce the issue:

  1. do as case steps

  2. 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

Dinosauria avatar Mar 20 '19 09:03 Dinosauria