PostgreSQL compatibility: array_length of an empty array dimension should be NULL

Split out from #22247.

Mismatch

array_length of an empty array dimension should be NULL.

SELECT array_length(array[]::int[], 1);

PostgreSQL:

NULL

DataFusion:

Expected behavior

For PostgreSQL-compatible SQL semantics, DataFusion should either match PostgreSQL's result or raise the same class of domain/semantic error.

take

DuckDb

memory D SELECT array_length(array[]::int[], 1);
┌───────────────────────────────────────────────┐
│ array_length(CAST((ARRAY[]) AS INTEGER[]), 1) │
│                     int64                     │
├───────────────────────────────────────────────┤
│                                             0 │
└───────────────────────────────────────────────┘

Navigation Menu

Repository navigation

PostgreSQL compatibility: `array_length` of an empty array dimension should be NULL #22264

Mismatch

Expected behavior

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

PostgreSQL compatibility: array_length of an empty array dimension should be NULL #22264

Description

Mismatch

Expected behavior

Activity

raushanprabhakar1 commented on May 17, 2026

kumarUjjawal commented on May 18, 2026

Metadata

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

Issue actions

PostgreSQL compatibility: `array_length` of an empty array dimension should be NULL #22264