morningman commented on issue #25804: URL: https://github.com/apache/doris/issues/25804#issuecomment-1777494393
This is nothing to do with UDF. This is because in 2.0.2, the new query optimizer will disable the fold constant expr on FE side by default. So the function such as `days_add` will be pushed down to MySQL scan node. But mysql does not have this function. you can `set enable_fold_nondeterministic_fn = true` to fix this issue. But this is a truly behavior change since 2.0 branch, we should rethink this logic. -- 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
