Inner join fails to be transformed into a interval join

[chenzl25]

Describe the bug

The inner join will pull up non-equal conditions to utilize the vectorized filter, but it will cause the join fails to be transformed into an interval join.

create table t1 (ts1 timestamp with time zone, id1 int, watermark for ts1 as ts1 - INTERVAL '5' SECOND) append only;
create table t2 (ts2 timestamp with time zone, id2 int, watermark for ts2 as ts2 - INTERVAL '5' SECOND) append only;
explain create materialized view v as select * from t1 join t2 on id1 = id2 and ts1 between (ts2 - INTERVAL '30' SECOND) and (ts2 + INTERVAL '30' SECOND);


 StreamMaterialize { columns: [ts1, id1, ts2, id2, t1._row_id(hidden), t2._row_id(hidden)], stream_key: [t1._row_id, t2._row_id, id1], pk_columns: [t1._row_id, t2._row_id, id1], pk_conflict: "NoCheck" }
 └─StreamProject { exprs: [t1.ts1, t1.id1, t2.ts2, t2.id2, t1._row_id, t2._row_id] }
   └─StreamFilter { predicate: (t1.ts1 >= $expr1) AND (t1.ts1 <= $expr2) }
     └─StreamAppendOnlyHashJoin { type: Inner, predicate: t1.id1 = t2.id2 }
       ├─StreamExchange { dist: HashShard(t1.id1) }
       | └─StreamTableScan { table: t1, columns: [ts1, id1, _row_id] }
       └─StreamExchange { dist: HashShard(t2.id2) }
         └─StreamProject { exprs: [t2.ts2, t2.id2, (AtTimeZone((AtTimeZone(t2.ts2, 'UTC':Varchar) - '00:00:00':Interval), 'UTC':Varchar) - '00:00:30':Interval) as $expr1, (AtTimeZone((AtTimeZone(t2.ts2, 'UTC':Varchar) + '00:00:00':Interval), 'UTC':Varchar) + '00:00:30':Interval) as $expr2, t2._row_id], output_watermarks: [t2.ts2, $expr1, $expr2] }
           └─StreamTableScan { table: t2, columns: [ts2, id2, _row_id] }
(9 rows)

To Reproduce

No response

Expected behavior

No response

Additional context

No response