bug: bad batch query succeeds when QUERY_MODE is distributed

[stdrc]

The following batch query should fail to execute, although it should pass the binder, because generate_series(timestamptz, timestamptz, interval) is not supported in batch mode (no such function implementation).

select * from generate_series(
  '2024-06-21 17:36:00'::timestamptz,
  now(),
  interval '1 hour'
);

However, what's weird is that, this query failed in local mode, but succeeded in distributed mode.

dev=> SET QUERY_MODE TO local;
SET_VARIABLE
dev=> select * from generate_series(
  '2024-06-21 17:36:00'::timestamptz,
  now(),
  interval '1 hour'
);
NOTICE:  Your session timezone is UTC. It was used in the interpretation of timestamps and dates in your query. If this is unintended, change your timezone to match that of your data's with `set timezone = [timezone]` or rewrite your query with an explicit timezone conversion, e.g. with `AT TIME ZONE`.

ERROR:  Failed to run the query

Caused by these errors (recent errors listed first):
  1: failed to build executor
  2: Expr error
  3: Unsupported function: generate_series(timestamp with time zone, timestamp with time zone, interval) -> timestamp with time zone
HINT: Supported functions:
  generate_series(bigint, bigint) -> bigint
  generate_series(integer, integer) -> integer
  generate_series(numeric, numeric) -> numeric
  generate_series(timestamp without time zone, timestamp without time zone, interval) -> timestamp without time zone
  generate_series(bigint, bigint, bigint) -> bigint
  generate_series(integer, integer, integer) -> integer
  generate_series(numeric, numeric, numeric) -> numeric

dev=> SET QUERY_MODE TO distributed;
SET_VARIABLE
dev=> select * from generate_series(
  '2024-06-21 17:36:00'::timestamptz,
  now(),
  interval '1 hour'
);
NOTICE:  Your session timezone is UTC. It was used in the interpretation of timestamps and dates in your query. If this is unintended, change your timezone to match that of your data's with `set timezone = [timezone]` or rewrite your query with an explicit timezone conversion, e.g. with `AT TIME ZONE`.

 generate_series 
-----------------
(0 rows)