Incorrect constant folding for NOT/IN predicate: scalar evaluation returns TRUE but WHERE returns no rows

1. 1. 1. Description

MariaDB evaluates the following predicate as TRUE when it is selected directly, but treats the same predicate as FALSE when it is used in a WHERE clause.

1. 1. 1. Reproduction

```sql
SELECT NOT (NOT ((NOT (NOT (0.9632180211473692))) IN (1))) AS value;

SELECT NOT (NOT ((NOT (NOT (0.9632180211473692))) IN (1))) AS value
FROM DUAL
WHERE NOT (NOT ((NOT (NOT (0.9632180211473692))) IN (1)));

1. 1. 1. Expected result
         Both statements should return one row:
         -------

         value

         -------

         1

         -------

The expression is constant and evaluates to TRUE, so using it in the WHERE clause should not remove the row.

1. 1. 1. Actual result
         On MariaDB 12.3.2:
         The first statement returns:
         -------

         value

         -------

         1

         -------

The second statement returns an empty result set: Empty set
The same two statements return one row with value 1 on MySQL 8.0.46 and MySQL 8.4.7