NeufHuang commented on issue #42493:
URL: https://github.com/apache/doris/issues/42493#issuecomment-2440325863
Another similar error, . The 'zdate' field is a string in the format of
'YYYYmmdd', No matter CURRENT_DATE(), CURDATE(), or CURRENT_TIMESTAMP() , It
was able to execute before.
```sql
DELETE FROM table1 WHERE zdate >=
DATE_FORMAT(DATE_TRUNC(CURRENT_TIMESTAMP(),'MONTH'),'%Y%m%d')
```
errMsg:
```sql
[1105] errCode = 2, detailMessage = errCode = 2, detailMessage = Right expr
of binary predicate should be value, predicate: `zdate` >=
date_format(date_trunc('2024-10-28 09:27:55', 'MONTH'), '%Y%m%d'), right expr
type:VARCHAR(*)
```
--
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: commits-unsubscr...@doris.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
