Description:
Hi,
In the following test case, there is only one value 123 in the column c0 of table t1.
There is an IN operation in the SELECT, whose left operand is c0, and right operand contains `true` and `NULL`. I expected the result of this expression is NULL, as in the document https://dev.mysql.com/doc/refman/9.5/en/comparison-operators.html#operator_in, `To comply with the SQL standard, IN() returns NULL not only if the expression on the left hand side is NULL, but also if no match is found in the list and one of the expressions in the list is NULL.` However, this expression returns 0.
```
CREATE TABLE t1(c0 DECIMAL) ;
INSERT INTO t1(c0) VALUES(123);
SELECT c0 IN (true, (- ((NULL) > (CAST(-1147964344 AS DECIMAL))))) FROM t1; -- 0
```
How to repeat:
```
CREATE TABLE t1(c0 DECIMAL) ;
INSERT INTO t1(c0) VALUES(123);
SELECT c0 IN (true, (- ((NULL) > (CAST(-1147964344 AS DECIMAL))))) FROM t1;
```
