Skip to content

[Bug]: obmysql2obmysql archive, datetime value incorrect #3930

@Huangxiao-mas

Description

@Huangxiao-mas

ODC version

ODC432

OB version

oceanbase432
oceanbase434

What happened?

obmysql2obmysql archive, datetime value incorrect
image

What did you expect to happen?

How can we reproduce it (as minimally and precisely as possible)?

chat privately

CREATE TABLE `part_table` (
  `col1` int(11) NOT NULL AUTO_INCREMENT,
  `col2` decimal(10,2) DEFAULT NULL,
  `col3` decimal(10,2) DEFAULT NULL,
  `col4` bit(8) DEFAULT NULL,
  `col5` tinyint(4) DEFAULT NULL,
  `col6` smallint(6) DEFAULT NULL,
  `col7` mediumint(9) DEFAULT NULL,
  `col8` bigint(20) DEFAULT NULL,
  `col9` float(10,2) DEFAULT NULL,
  `col10` double(10,2) DEFAULT NULL,
  `col11` varchar(10) DEFAULT NULL,
  `col12` char(10) DEFAULT NULL,
  `col13` text DEFAULT NULL,
  `col14` tinytext DEFAULT NULL,
  `col23` timestamp NULL DEFAULT NULL,
  `col24` time DEFAULT NULL,
  `col25` date DEFAULT NULL,
  `col26` datetime DEFAULT NULL,
  `col27` year(4) DEFAULT NULL,
  PRIMARY KEY (`col1`)
) AUTO_INCREMENT = 32020800 AUTO_INCREMENT_MODE = 'ORDER' DEFAULT CHARSET = utf8mb4 ROW_FORMAT = DYNAMIC COMPRESSION = 'zstd_1.3.8' REPLICA_NUM = 1 BLOCK_SIZE = 16384 USE_BLOOM_FILTER = FALSE TABLET_SIZE = 134217728 PCTFREE = 0
 partition by range(col1)
(partition `p1` values less than (10000),
partition `p2` values less than (50000),
partition `p3` values less than (100000),
partition `p4` values less than (MAXVALUE))

Anything else we need to know?

No response

Metadata

Metadata

Assignees

Type

No type
No fields configured for issues without a type.

Projects

Status
New

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions