bug: join on panic caused by invalid data type

[b41sh]

Search before asking

• I had searched in the issues and found no similar issues.

Version

v1.2.662

What's Wrong?

join on panic caused by invalid data type

panicked at src/query/expression/src/filter/selector.rs:494:17:
assertion failed: matches!(return_type, DataType::Boolean |
    DataType::Nullable(box DataType::Boolean))
   0: backtrace::backtrace::libunwind::trace
             at /home/b41sh/.cargo/git/checkouts/backtrace-rs-fb1f822361417489/72265be/src/backtrace/libunwind.rs:116:5

How to Reproduce?

MySQL [(none)]> create table tt1 (a int, b int);
Query OK, 0 rows affected (0.180 sec)

MySQL [(none)]> insert into tt1 values(1, 2),(3, 4);
Query OK, 2 rows affected (0.223 sec)

MySQL [(none)]> create table tt2 (a int, b int);
Query OK, 0 rows affected (0.187 sec)

MySQL [(none)]> insert into tt2 values(1, 2),(3, 4);
Query OK, 2 rows affected (0.217 sec)

MySQL [(none)]> select * FROM tt1 LEFT ANTI JOIN tt2 ON 11981933213501947393::DATE;
ERROR 1105 (HY000): PanicError. Code: 1104, Text = assertion failed: matches!(return_type, DataType::Boolean |
    DataType::Nullable(box DataType::Boolean)).

Are you willing to submit PR?

• Yes I am willing to submit a PR!