Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.4.31, 11.1.2
-
None
-
docker run -it -p 3307:3306 -e MARIADB_ROOT_PASSWORD=root mariadb:latest
Description
The same query returns different results under different outer_join_with_cache:
CREATE TABLE t0(c0 CHAR); |
CREATE TABLE t2(c0 CHAR); |
INSERT INTO t0 VALUES ('a'), (''), (''); |
INSERT INTO t2 VALUES ('b'), (''); |
 |
SET SESSION optimizer_switch = 'outer_join_with_cache=on'; |
SELECT t2.c0 FROM t2 LEFT JOIN t0 ON (4 RLIKE t0.c0); -- {b}, { } |
SET SESSION optimizer_switch = 'outer_join_with_cache=off'; |
SELECT t2.c0 FROM t2 LEFT JOIN t0 ON (4 RLIKE t0.c0); -- {b}, { }, { } |