Wrong results with correlated WHERE-clause subquery inside a NULL-checking conditional function.

select t1.int_col
from functional.alltypessmall as t1
where t1.int_col >= isnull
(
   (
    SELECT 
     MAX(t2.bigint_col)
    FROM 
     functional.alltypestiny AS t2 
    WHERE 
     t1.id = t2.id + 10000
    ),
   0  
)
Fetched 0 row(s) in 1.09s

Single-node plan:
+-----------------------------------------------------------------------+
| Explain String                                                        |
+-----------------------------------------------------------------------+
| Estimated Per-Host Requirements: Memory=0B VCores=0                   |
|                                                                       |
| PLAN-ROOT SINK                                                        |
| |                                                                     |
| 03:HASH JOIN [LEFT SEMI JOIN]                                         |
| |  hash predicates: t1.id = t2.id + 10000                             |
| |  other join predicates: t1.int_col >= isnull(max(t2.bigint_col), 0) |
| |  runtime filters: RF000 <- t2.id + 10000                            |
| |                                                                     |
| |--02:AGGREGATE [FINALIZE]                                            |
| |  |  output: max(t2.bigint_col)                                      |
| |  |  group by: t2.id                                                 |
| |  |                                                                  |
| |  01:SCAN HDFS [functional.alltypestiny t2]                          |
| |     partitions=4/4 files=4 size=460B                                |
| |                                                                     |
| 00:SCAN HDFS [functional.alltypessmall t1]                            |
|    partitions=4/4 files=4 size=6.32KB                                 |
|    runtime filters: RF000 -> t1.id                                    |
+-----------------------------------------------------------------------+