ccoffline commented on issue #29826:
URL: https://github.com/apache/doris/issues/29826#issuecomment-1899689843
我在2.0.1上测试的结果
```sql
mysql> select * from test_date;
+------+------------+
| id | date |
+------+------------+
| 01 | 2023-02-01 |
| 03 | 2023-01-01 |
| 03 | 2023-03-01 |
| 03 | 2023-04-01 |
| 03 | 2023-05-01 |
| 03 | 2023-06-01 |
| 01 | 2023-11-01 |
| 03 | 2023-07-01 |
| 03 | 2023-08-01 |
| 03 | 2023-09-01 |
| 03 | 2023-10-01 |
| 03 | 2023-11-01 |
| 03 | 2023-12-01 |
| 0A | 2023-12-01 |
| 04 | 2023-07-01 |
| 04 | 2023-08-01 |
| 04 | 2023-09-01 |
| 04 | 2023-10-01 |
| 04 | 2023-12-01 |
| 06 | 2024-01-01 |
| 07 | 2024-01-01 |
| 04 | 2023-06-01 |
| 02 | 2022-10-01 |
| 02 | 2022-11-01 |
| 02 | 2022-12-01 |
| 02 | 2023-11-01 |
| 01 | 2022-10-01 |
| 01 | 2022-11-01 |
| 01 | 2022-12-01 |
+------+------------+
29 rows in set (0.03 sec)
mysql> SELECT distinct date FROM test_date WHERE date = '2024-00-01';
Empty set (0.04 sec)
```
在最新版上会报错。所以错误的日期格式对于Doris来讲是未定义行为，尽量避免一下。
```sql
mysql> SELECT distinct date FROM test_date WHERE date = '2024-00-01';
ERROR 1105 (HY000): errCode = 2, detailMessage = Incorrect datetime value:
CAST('2024-00-01' AS DATETIMEV2(0)) in expression: (CAST(`date` AS
DATETIMEV2(0)) = CAST('2024-00-01' AS DATETIMEV2(0)))
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
