MariaDB [test]> create table cs1 (a int)engine=columnstore;

Query OK, 0 rows affected (0.661 sec)

MariaDB [test]> insert into cs1 values (1), (2), (3), (4), (null);

Query OK, 5 rows affected (0.291 sec)

Records: 5  Duplicates: 0  Warnings: 0

MariaDB [test]> create table cs2 (b int, c int)engine=columnstore;

Query OK, 0 rows affected (0.597 sec)

MariaDB [test]> insert into cs2 values (1, 100), (1, 101), (2, 200),

    -> (3, 300), (3, 301), (3, 302), (null, null);

Query OK, 7 rows affected (0.250 sec)

Records: 7  Duplicates: 0  Warnings: 0

MariaDB [test]> select * from cs1 where a not in (select b from cs2 where b is not null or b is null);

ERROR 2013 (HY000): Lost connection to MySQL server during query

MariaDB [test]> select * from cs1 where a not in (select b from cs2 where b is null or b is not null);

Empty set (0.020 sec)

MariaDB [test]> select * from cs1 where a not in (select b from cs2 where b=123 or b is null);

+------+

| a    |

+------+

|    1 |

|    2 |

|    3 |

|    4 |

| NULL |

+------+

5 rows in set (0.152 sec)

MariaDB [test]> select * from cs1 where a not in (select b from cs2 where b is null or b=123);

Empty set (0.021 sec)