where condition lose predicate

[LZGH]

Steps to reproduce the behavior (Required)

In the following scenario, 'dt > ' condition will not be pushed down, 'dt = ' will normal push down

with from_dt as (
    select
        '20241101' as dt
)
SELECT
    count(*) a
FROM
    hive.db.table
WHERE
    dt > (
        select
            dt
        from
            from_dt
    )

Expected behavior (Required)

where condition push down.

Real behavior (Required)

where condition will not be pushed down

StarRocks version (Required)

• You can get the StarRocks version by executing SQL select current_version()
  3.3.4