SQL: ceil/floor functions return error on null input in sequential runtime

[philrz]

$ echo 'null' | super -sam -S -c "values {ceil(this), floor(this)}" -
{
  ceil: error({
    message: "ceil: not a number",
    on: null
  }),
  floor: error({
    message: "floor: not a number",
    on: null
  })
}

Details

Repro is with super commit 8d725d9.

null values are returned in vector runtime.

$ super -version
Version: v0.3.0-119-g8d725d917

$ echo 'null' | super -vam -S -c "values {ceil(this), floor(this)}" -
{
  ceil: null,
  floor: null

Which matches what Postgres does.

$ psql postgres
psql (17.9 (Homebrew))
Type "help" for help.

postgres=# \pset null 'NULL'
Null display is "NULL".
postgres=# SELECT CEIL(NULL),FLOOR(NULL);
 ceil | floor 
------+-------
 NULL |  NULL
(1 row)