PostgreSQL compatibility: `log(0.0::float8)` should error, not return `-inf`

Split out from #22247.

### Mismatch

`log(0.0::float8)` should error, not return `-inf`.

```sql
SELECT log(0.0::float8);
```

PostgreSQL:

```text
ERROR: cannot take logarithm of zero
```

DataFusion:

```text
-inf
```

### Expected behavior

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