SQL: Join Column Type Mismatch

Describe the bug

When 2 tables joined on INT and LONG columns error shown that there is join column mismatch

To reproduce

select x, y
from long_sequence(100) ls
join (
  select cast(x as int) y from long_sequence(100)
) as ls2
on ls.x = ls2.y

Expected Behavior

INT can be be upcast to LONG and equality should be checked as LONG equality so that above query returns 100 rows

Environment

- **QuestDB version**: 6.1.2
- **OS**: any
- **Browser**: any

Additional context

Comparing mixed data types works for many numeric types in WHERE. Same should be in JOIN condition