Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Major
-
Resolution: Unresolved
-
11.1.2, 10.5, 10.6, 10.9(EOL), 10.10(EOL), 10.11, 11.0(EOL)
-
None
-
Docker: mariadb:lates
Description
By changing the setting: not_null_range_scan, a query returns different results shown as follows.
CREATE TABLE t0(c0 CHAR UNIQUE);
INSERT INTO t0 VALUES (DEFAULT);
SET SESSION optimizer_switch = 'not_null_range_scan=off';
SELECT c0 FROM t0 WHERE (TRUE NOT IN (LOCATE(1, false, c0))); –
SET SESSION optimizer_switch = 'not_null_range_scan=on';
SELECT c0 FROM t0 WHERE (TRUE NOT IN (LOCATE(1, false, c0))); – {}