Reproduces a SQLite 3.31.1 bug in query results with redundant constraints

redundant-constraint-bug.sql

- Result should be "good" only, not "good" and "bad"

DROP TABLE IF EXISTS redundant;
DROP TABLE IF EXISTS enough;

CREATE TABLE redundant (
    name VARCHAR(10) PRIMARY KEY
);
INSERT INTO redundant VALUES('good');
INSERT INTO redundant VALUES('bad');

CREATE TABLE enough (
    name VARCHAR(10),
    FOREIGN KEY(name) REFERENCES redundant (name)
);

INSERT INTO enough VALUES('good');
INSERT INTO enough VALUES('bad');

SELECT
    enough.name
FROM
    enough JOIN redundant ON enough.name = redundant.name
WHERE
    enough.name = 'good'     -- Remove this line...
    AND
    redundant.name = 'good'  -- ...or this line (and the AND), it works.
;