different result between tikv and tiflash

[aytrack]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

CREATE TABLE `UK_PRECISION19237` (
  `COL1` decimal(37,4) DEFAULT NULL COMMENT 'NUMERIC WITH PRECISION',
  `COL2` varchar(20) DEFAULT NULL,
  `COL4` datetime DEFAULT NULL,
  `COL3` bigint(20) DEFAULT NULL,
  `COL5` float DEFAULT NULL,
  UNIQUE KEY `UK_COL1` (`COL1`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
INSERT INTO `UK_PRECISION19237` VALUES (999999999999999999999999999999999.9999,'狪萖秐臾諮羶懝彃惾膁綥繷绿鄟鸚姶圪疪郛釦','8847-09-16 22:32:17',4567224115423045463,5.34134e37);
alter table UK_PRECISION19237 set tiflash replica 1;
set tidb_isolation_read_engines='tikv';
select * from UK_PRECISION19237 where col1 * 766507373740683764182618847769240.9770 != -604793534779049308874387484528661.3368;
set tidb_isolation_read_engines='tiflash';
select * from UK_PRECISION19237 where col1 * 766507373740683764182618847769240.9770 != -604793534779049308874387484528661.3368;

2. What did you expect to see? (Required)

have the same result

3. What did you see instead (Required)

[19:48:37]TiDB root:test> set tidb_isolation_read_engines='tikv';
Query OK, 0 rows affected
Time: 0.002s
[19:48:39]TiDB root:test> select * from UK_PRECISION19237 where col1 * 766507373740683764182618847769240.9770 != -604793534779049308874387484528661.3368;
(1105, 'Data Truncated')
[19:48:49]TiDB root:test> alter table UK_PRECISION19237 set tiflash replica 1;
Query OK, 0 rows affected
Time: 0.284s
[19:48:51]TiDB root:test> set tidb_isolation_read_engines='tiflash';
Query OK, 0 rows affected
Time: 0.001s
[19:48:52]TiDB root:test> select * from UK_PRECISION19237 where col1 * 766507373740683764182618847769240.9770 != -604793534779049308874387484528661.3368;
+----------------------------------------+------------------------------------------+---------------------+---------------------+-------------+
| COL1                                   | COL2                                     | COL4                | COL3                | COL5        |
+----------------------------------------+------------------------------------------+---------------------+---------------------+-------------+
| 999999999999999999999999999999999.9999 | 狪萖秐臾諮羶懝彃惾膁綥繷绿鄟鸚姶圪疪郛釦 | 8847-09-16 22:32:17 | 4567224115423045463 | 5.34134e+37 |
+----------------------------------------+------------------------------------------+---------------------+---------------------+-------------+
1 row in set
Time: 0.140s
[19:48:52]TiDB root:test>

4. What is your TiDB version? (Required)

master
v7.5.0
v7.1.2

[solotzg]

Duplicated with tikv/tikv#16268. Close this issue.