SQL: multiply operation between INTERVALs and NULL is not possible

[astefan]

SELECT NULL * INTERVAL 1 DAY results in:

{
  "error" : {
    "root_cause" : [
      {
        "type" : "verification_exception",
        "reason" : "Found 1 problem(s)\nline 1:8: [*] has arguments with incompatible types [NULL] and [INTERVAL_DAY]"
      }
    ],
    "type" : "verification_exception",
    "reason" : "Found 1 problem(s)\nline 1:8: [*] has arguments with incompatible types [NULL] and [INTERVAL_DAY]"
  },
  "status" : 400
}

[elasticmachine]

Pinging @elastic/es-search (:Search/SQL)

[matriv]

@astefan: Hint: Mul's resolveType() uses DataType functions (e.g.: isNumeric()) and not the TypeResolutions ones which allow the NULL data type. We should check everywhere for this and fixit.

[astefan]

master (8.0.0): ce72761
7.x (7.6.0): astefan@e2982b2
7.5 (7.5.1): b996671