Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
-
None
-
None
-
None
-
Ubuntu 24.04
Description
Hi,
In the following test case
```
CREATE TABLE t0(c0 CHAR(100));
INSERT INTO t0 VALUES ('A');
SELECT (('
6' IS TRUE) NOT IN (t0.c0, CAST(449007834 AS DECIMAL))) FROM t0;
```
There is only one value `A` in the column c0, so I expected the expression `(('
6' IS TRUE) NOT IN (t0.c0, CAST(449007834 AS DECIMAL)))` to be true, however, the MariaDB returns `0`
The equivalent prepared statement can return correct result on this case:
```
SET @a = 449007834;
PREPARE prepare_query FROM "SELECT (('
6' IS TRUE) NOT IN (t0.c0, CAST(? AS DECIMAL))) FROM t0";
EXECUTE prepare_query USING @a;
```
Attachments
Issue Links
- relates to
-
MDEV-37653 Unexpected result of prepared statement when use boolean value as parameters
-
- Open
-