DST not mapped correctly from MySQL to CH

[subkanthi]

select * from  test_2;
+----+----------------------------+
| id | gates_from                 |
+----+----------------------------+
|  1 | 2026-03-17 13:34:41.000000 |
|  2 | 2026-03-08 03:00:00.000000 |
|  3 | 2026-03-08 01:59:59.000000 |
|  4 | 2026-03-08 02:00:00.000000 |
|  5 | 2026-03-08 07:59:59.000000 |
|  6 | 2026-03-08 08:00:00.000000 |
+----+----------------------------+

┌─id─┬─────────────────gates_from─┬────────────_version─┬─is_deleted─┐
│  1 │ 2026-03-17 13:34:41.000000 │ 1773772482219380858 │          0 │
│  2 │ 2026-03-08 04:00:00.000000 │ 1773772514297380868 │          0 │
│  3 │ 2026-03-08 01:59:59.000000 │ 1773772624761380889 │          0 │
│  4 │ 2026-03-08 03:00:00.000000 │ 1773772653632380892 │          0 │
│  5 │ 2026-03-08 08:59:59.000000 │ 1773772672366380895 │          0 │
│  6 │ 2026-03-08 08:00:00.000000 │ 1773772683295380897 │          0 │
└────┴────────────────────────────┴─────────────────────┴────────────┘

CREATE TABLE test_2 (
id INT UNSIGNED NOT NULL AUTO_INCREMENT,
gates_from DATETIME(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
PRIMARY KEY (id, gates_from)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_cs;   in MySQL

INSERT INTO test_2 (id, gates_from) VALUES
  (1, '2026-03-17 13:34:41.000000'),
  (2, '2026-03-08 03:00:00.000000'),
  (3, '2026-03-08 01:59:59.000000'),
  (4, '2026-03-08 02:00:00.000000'),
  (5, '2026-03-08 07:59:59.000000'),
  (6, '2026-03-08 08:00:00.000000');