Unexpected error `date_add function does not support unit DAY_HOUR yet` occurs

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

use test;
drop table if exists t;
CREATE TABLE t (c1 FLOAT UNSIGNED);
INSERT INTO t VALUES (47),(28.1237);
ALTER TABLE test.t SET TIFLASH REPLICA 1;

set tidb_allow_mpp=1;set tidb_enforce_mpp=1; set tidb_isolation_read_engines='tiflash';
SELECT (DATE_ADD(BIN(c1), INTERVAL 1 DAY_HOUR)) AS f1 FROM (SELECT 1 FROM t) AS t1 JOIN (SELECT c1 FROM t) AS t2 ON 1;

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

success.

3. What did you see instead (Required)

ERROR 1105 (HY000): other error for mpp stream: From MPP<query:<query_ts:1677567990161836438, local_query_id:3, server_id:1166994, start_ts:439764383203328003>,task_id:2>: Code: 0, e.displayText() = DB::TiFlashException: date_add function does not support unit DAY_HOUR yet., e.what() = DB::TiFlashException,

4. What is your TiFlash version? (Required)

v6.6

No source file or test is named. Start by running the provided SQL reproduction against TiFlash v6.6 and locate the handling of DATE_ADD with the DAY_HOUR unit; the work is done when the query succeeds without the reported MPP stream error.