Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.11, 11.4, 11.8, 12.3, 12.1.2
-
docker 12.1.2-MariaDB-ubu2404
Description
Expected output: (-1929720000, -1929720000)
Actual output: empty result set.
When executing the same test case in MySQL, the output is (-1929720000, -1929720000).
DROP DATABASE IF EXISTS test;
|
CREATE DATABASE test;
|
USE test;
|
 |
CREATE TABLE t0(c0 FLOAT);
|
CREATE TABLE t1(c0 FLOAT);
|
INSERT INTO t1(c0) VALUES(-1929718332); |
INSERT INTO t0(c0) VALUES(-1929718332),(0); |
SELECT ALL t1.c0, t0.c0 FROM t0, t1 WHERE (t0.c0) IN (IF(NULL, "'K", t1.c0)); |
