PostgreSQL compatibility: `power(0.0::float8, -1.0::float8)` should error, not return infinity

[Dandandan]

Split out from #22247.

Mismatch

power(0.0::float8, -1.0::float8) should error, not return infinity.

SELECT power(0.0::float8, -1.0::float8);

PostgreSQL:

ERROR: zero raised to a negative power is undefined

DataFusion:

inf

Expected behavior

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

[raushanprabhakar1]

take

[kumarUjjawal]

DuckDb

memory D SELECT power(0.0::float8, -1.0::float8);
┌────────────────────────────────────────────────────────┐
│ power(CAST(0.0 AS "DOUBLE"), -(CAST(1.0 AS "DOUBLE"))) │
│ double │
├────────────────────────────────────────────────────────┤
│ inf │
└────────────────────────────────────────────────────────┘

It should be undefined like PG