Fullstack extract datetime is broken #5421
Description
Bug Report
Please answer these questions before submitting your issue. Thanks!
1. Minimal reproduce step (Required)
Run this test:
2. What did you expect to see? (Required)
Test pass.
3. What did you see instead (Required)
[2022-07-19T23:52:16.500Z] File: fullstack-test/expr/extract_datetime.test
[2022-07-19T23:52:16.500Z] Error line: 25
[2022-07-19T23:52:16.500Z] Error: set session tidb_isolation_read_engines='tiflash'; select a from test.t where extract(day_microsecond from a) = 13123456123456 and extract(day_second from a) = 13123456 and extract(day_minute from a) = 131234 and extract(day_hour from a) = 1312 and extract(year_month from a) = 202103;
[2022-07-19T23:52:16.500Z] Result:
[2022-07-19T23:52:16.500Z] <nothing>
[2022-07-19T23:52:16.500Z] Expected:
[2022-07-19T23:52:16.500Z] a
[2022-07-19T23:52:16.500Z] 2021-03-13 12:34:56.123456