[GitHub] [arrow-datafusion] joroKr21 opened a new issue, #6947: Support interval equality and comparison between an array and a scalar

["joroKr21 (via GitHub)" <gi...@apache.org>]

joroKr21 opened a new issue, #6947:
URL: https://github.com/apache/arrow-datafusion/issues/6947

   ### Is your feature request related to a problem or challenge?
   
   Interval equality and comparison works fine between two arrays or between two scalars but it fails between a scalar and an array with an error like this: `Data type IntervalMonthDayNano(...) not supported for scalar operation 'gt' on dyn array`.
   
   Here is an example query that fails:
   ```sql
   select
       (interval '1 day') = i,
       (interval '1 day') != i,
       i < (interval '1 day'),
       i <= (interval '1 day'),
       i > (interval '1 day'),
       i >= (interval '1 day')
   from t;
   ```
   
   ### Describe the solution you'd like
   
    Looks like an oversight in the `binary_array_op_dyn_scalar` macro. Simply adding the cases for interval types should be enough to make it work.
   
   ### Describe alternatives you've considered
   
   I'm not aware of any alternatives.
   
   ### Additional context
   
   This is related to #5753


-- 
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: github-unsubscribe@arrow.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [arrow-datafusion] alamb closed issue #6947: Support interval equality and comparison between an array and a scalar

["alamb (via GitHub)" <gi...@apache.org>]

alamb closed issue #6947: Support interval equality and comparison between an array and a scalar
URL: https://github.com/apache/arrow-datafusion/issues/6947


-- 
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: github-unsubscribe@arrow.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org