### Elasticsearch Version

8.1.0-SNAPSHOT (but also affects 7.x releases)

### Installed Plugins

_No response_

### Java Version

_bundled_

### OS Version

OSX

### Problem Description

While the docs state that `RANDOM(null) = null` that's not always the case.

### Steps to Reproduce

```
GET _sql?format=txt
{
  "query": """
  SELECT random(n), n FROM longs
  """
}
```

yields 

```
    random(n)     |       n       
------------------+---------------
0.7308781907032909|1              
0.7311469360199058|2              
0.3860252809814635|null           
```

Expected would be `null` for the last row.

### Logs (if relevant)

_No response_
x-pack/plugin/sql/src/main/java/org/elasticsearch/xpack/sql/expression/function/scalar/math/MathProcessor.java
if (nullAware) {
                this.apply = apply;
            } else {
                this.apply = l -> l == null ? null : apply.apply(l);
            }
        }
        MathOperation(DoubleFunction<Double> apply) {
            this.apply = (Object l) -> l == null ? null : apply.apply(((Number) l).doubleValue());
        }
        MathOperation(Supplier<Double> supplier) {
            this.apply = l -> supplier.get();
        }
        public final Number apply(Object l) {
            return apply.apply(l);
        }
    }
    public static final String NAME = "m";
    private final MathOperation processor;
    public MathProcessor(MathOperation processor) {
        this.processor = processor;
    }
    public MathProcessor(StreamInput in) throws IOException {
        processor = in.readEnum(MathOperation.class);
    }
    @Override
    public void writeTo(StreamOutput out) throws IOException {
        out.writeEnum(processor);
    }
    @Override
    public String getWriteableName() {