ESQL: operators and functions returning Infinite for Doubles

[ivancea]

Some functions return infinite when doubles overflow. Example (All of them result in Inf/-Inf):

ROW a = [1.79769313486231570e+308, 1.79769313486231570e+308]
| STATS sum=SUM(a)
| EVAL
  a = [1.79769313486231570e+308, 1.79769313486231570e+308],
  b = 1.79769313486231570e+308,
  c = -1.79769313486231570e+308,
  mvsum=mv_sum(a), add=b+b, sub=c-b, mul=b*2
| DROP a, b, c

{
  "columns": [
    {
      "name": "sum",
      "type": "double"
    },
    {
      "name": "mvsum",
      "type": "double"
    },
    {
      "name": "add",
      "type": "double"
    },
    {
      "name": "sub",
      "type": "double"
    },
    {
      "name": "mul",
      "type": "double"
    }
  ],
  "values": [
    [
      "Infinity",
      "Infinity",
      "Infinity",
      "-Infinity",
      "Infinity"
    ]
  ]
}

Looks like some remains of https://github.com/elastic/elasticsearch/issues/98698

Functions to fix

• [x] ADD
• [x] SUB
• [x] MUL
• [ ] MV_SUM
• [ ] SUM

[elasticsearchmachine]

Pinging @elastic/es-analytical-engine (Team:Analytics)

[ivancea]

The SUM() aggregation fix could depend on the improvements listed in https://github.com/elastic/elasticsearch/issues/110443 around the Warnings object.

As SUM depends on MvSum (surrogation), so both should be fixed at the same time to avoid a having different result if folded