docker run -it --name mariadb-11.7.2 -p 3307:3306 -e MARIADB_ROOT_PASSWORD=root mariadb:11.7.2 

CREATE TABLE t0(c0 FLOAT ZEROFILL ) ENGINE = HEAP;

CREATE TABLE IF NOT EXISTS t1 LIKE t0;

INSERT INTO t0(c0) VALUES(0),(-0);

CREATE INDEX i1 ON t0(c0);

INSERT INTO t1(c0) VALUES('-0');

SELECT ALL t0.c0  FROM t0 STRAIGHT_JOIN t1 ON t0.c0 = t1.c0; 

+--------------+

| c0           |

+--------------+

| 000000000000 |

| 000000000000 |

+--------------+

SELECT ALL t0.c0  FROM t1 STRAIGHT_JOIN t0 ON t0.c0 = t1.c0;

Empty set (0.00 sec)