alamb opened a new issue, #11891: URL: https://github.com/apache/datafusion/issues/11891
### Is your feature request related to a problem or challenge? (broken out from https://github.com/apache/datafusion/pull/11876 for more visibility) @samuelcolvin writes: We regularly want to allow queries of the form ```sql SELECT * FROM records WHERE end_timestamp - start_timestamp > interval '2 seconds' ``` Until now that failed with ``` type_coercion: Cannot infer common argument type for comparison operation Duration(Microsecond) > Interval(MonthDayNano) ``` ### Describe the solution you'd like The query should work ### Describe alternatives you've considered _No response_ ### Additional context (broken out from https://github.com/apache/datafusion/pull/11876 for more visibility) -- 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]
