bug: batch_sort_agg assertion failed

[kwannoel]

Describe the bug

thread 'risingwave-main' panicked at 'assertion failed: `(left == right)`
  left: `0`,
 right: `1`', src/frontend/src/optimizer/plan_node/batch_sort_agg.rs:65:9
stack backtrace:
   0: rust_begin_unwind
             at /rustc/5ce39f42bd2c8bca9c570f0560ebe1fce4eddb14/library/std/src/panicking.rs:575:5
   1: core::panicking::panic_fmt

To Reproduce

CREATE TABLE supplier (
    s_suppkey int,
    s_name character varying,
    s_address character varying,
    s_nationkey int,
    s_phone character varying,
    s_acctbal numeric,
    s_comment character varying,
    PRIMARY KEY (s_suppkey)
);

CREATE TABLE part (
    p_partkey int,
    p_name character varying,
    p_mfgr character varying,
    p_brand character varying,
    p_type character varying,
    p_size int,
    p_container character varying,
    p_retailprice numeric,
    p_comment character varying,
    PRIMARY KEY (p_partkey)
);

CREATE MATERIALIZED VIEW m3 AS
SELECT
    t_0.p_partkey AS col_0,
    t_1.s_nationkey AS col_1,
    ((SMALLINT '29991') * ((SMALLINT '872') | t_0.p_size)) AS col_2
FROM
    part AS t_0
    LEFT JOIN supplier AS t_1 ON t_0.p_size = t_1.s_nationkey
WHERE
    FALSE
GROUP BY
    t_1.s_address,
    t_0.p_partkey,
    t_0.p_size,
    t_0.p_type,
    t_0.p_comment,
    t_1.s_nationkey,
    t_1.s_comment;

SELECT
    (((INT '0') + ((SMALLINT '15') - (SMALLINT '-32768'))) + (SMALLINT '663')) AS col_0
FROM
    m3 AS t_0
WHERE
    FALSE
GROUP BY
    t_0.col_2
ORDER BY
    t_0.col_2 ASC;

Expected behavior

Small int out of range.

postgres=# SELECT
    (((INT '0') + ((SMALLINT '15') - (SMALLINT '-32768'))) + (SMALLINT '663')) AS col_0
FROM
    m3 AS t_0
WHERE
    FALSE
GROUP BY
    t_0.col_2
ORDER BY
    t_0.col_2 ASC;
ERROR:  smallint out of range
postgres=#

Additional context

https://buildkite.com/risingwavelabs/pull-request/builds/17845#01866f82-9f2c-4dd6-a746-2f7f72d0e32c