w517424787 commented on issue #22528: URL: https://github.com/apache/doris/issues/22528#issuecomment-1666829208
> 这里存在语义差异，doris中字符串和数字比较时，会将字符串转为数字： > > ```sql > stat_date = '20200601' --是字符串比较 > stat_date = 20200601 --是数字比较 > ``` > > state_date值 stat_date = '20200601' stat_date = 20200601 > '20200601' true true > '020200601' false true > 'abc' false null > 可以看到，两者的返回值并不一致。基于此，不能将`cast(stat_date as int) = 20200601`改写为`stat_date = '20200601'`以提升性能 感谢回答！！ -- 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
