Support ANY operator

Hello!

Is your feature request related to a problem or challenge? Please describe what you are trying to do.

// similar to array contains
SELECT 1 = ANY(ARRAY[1,2,3,4])

// negative of array contains
SELECT 1 <> ANY(ARRAY[1,2,3,4])

// Same story for <, <=, >, >=

Thanks

The = case has been implemented by #11849

Still pending work for the other cases (<, <=, etc.)

Some pointers.

Planner code here, need to wire in support for operators other than =:

datafusion/datafusion/functions-nested/src/planner.rs

Lines 124 to 136 in 2a08013

    
           fn plan_any(&self, expr: RawBinaryExpr) -> Result<PlannerResult<RawBinaryExpr>> { 
        
               if expr.op == BinaryOperator::Eq { 
        
                   Ok(PlannerResult::Planned(Expr::ScalarFunction( 
        
                       ScalarFunction::new_udf( 
        
                           array_has_udf(), 
        
                           // left and right are reversed here so `needle=any(haystack)` -> `array_has(haystack, needle)` 
        
                           vec![expr.right, expr.left], 
        
                       ), 
        
                   ))) 
        
               } else { 
        
                   plan_err!("Unsupported AnyOp: '{}', only '=' is supported", expr.op) 
        
               } 
        
           }

Implementation in here:

https://github.com/apache/datafusion/blob/2a08013af3ccf703bee202c959b40bb0d35bdea1/datafusion/functions-nested/src/array_has.rs

Need to consider how to work it into the existing code and try not to duplicate for all operators if possible

Add SLT tests here:

https://github.com/apache/datafusion/blob/2a08013af3ccf703bee202c959b40bb0d35bdea1/datafusion/sqllogictest/test_files/array.slt

take

Support '>', '<', '>=', '<=', '<>' in any operator (#20830)

Support '>', '<', '>=', '<=', '<>' in any operator (apache#20830)

[Minor]: unify ANY/ALL planning and align ANY NULL semantics with PG (a…

Navigation Menu

Repository navigation

Support ANY operator #2548

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

	fn plan_any(&self, expr: RawBinaryExpr) -> Result<PlannerResult<RawBinaryExpr>> {
	if expr.op == BinaryOperator::Eq {
	Ok(PlannerResult::Planned(Expr::ScalarFunction(
	ScalarFunction::new_udf(
	array_has_udf(),
	// left and right are reversed here so `needle=any(haystack)` -> `array_has(haystack, needle)`
	vec![expr.right, expr.left],
	),
	)))
	} else {
	plan_err!("Unsupported AnyOp: '{}', only '=' is supported", expr.op)
	}
	}

Support ANY operator #2548

Description

Activity

Jefffrey commented on Sep 20, 2025

Jefffrey commented on Dec 10, 2025

buraksenn commented on Mar 9, 2026

Metadata

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

Issue actions