not in on sub query not working as expected.(calcite version 1.13.0)

[Nuwan Abeysiriwardana]

Hi All,
   i have following csv tables.

TableA             TableB
+------+           +-------+
|   Q  |             |   A   |
+------+           +-------+
| aaaa |           |  aaaa |
| 1111 |            |  ssss |
|  555 |            | 22222 |
+------+           +-------+

'select Q,Q not in(select A from TableB) as output from TableA'  produce
following result

 +------+--------+
|   Q  | output |
+------+--------+
| aaaa |   true |
| 1111 |   true |
|  555 |   true |
+------+--------+

but I'm expecting false for value 'aaaa'.

also i have tested the following query and it work as expected.
'select Q,Q not in('aaaa','1111') as output from TableA'

output :
+------+--------+
|   Q  | output |
+------+--------+
| aaaa |  false |
| 1111 |  false |
|  555 |   true |
+------+--------+

i have tested similar  query with PostgreSQL ,it works fine.

thanks
nuwan