CATTechnology commented on issue #22528: URL: https://github.com/apache/doris/issues/22528#issuecomment-1670573780
> > 如果stat_date是string类型，where stat_date = 20200601 可以转换为 where stat_date = cast(20200601 as string)，而不是 where cast(stat_date as int) = 20200601 , 这在数据量很大的时候，性能损耗很严重。 > > 如上面例子所示，如果将数字转换为字符串会出现行为不一致。导致同为20200601，作为字面量和作为表中一个slot时，对于原表的过滤效果不同。所以所有隐式转换的规则必须保持一致。不能因为看起来导致性能了损耗而任意变更行为。 为啥呢，这一块为啥过滤效果不一样呢，和后面的”所以所有隐式转换的规则必须保持一致“有什么本质的关联呢 -- 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
