Wrong result upon executing query with HAVING as a SELECT item

CREATE TABLE t (pk int PRIMARY KEY);

INSERT INTO t (pk) VALUES (1),(2),(3);

SELECT pk FROM t GROUP BY pk HAVING pk != 0 ORDER BY pk DESC LIMIT 1;

SELECT (SELECT pk FROM t GROUP BY pk HAVING pk != 0 ORDER BY pk DESC LIMIT 1) s;

# Cleanup

DROP TABLE t;

SELECT pk FROM t GROUP BY pk HAVING pk != 0 ORDER BY pk DESC LIMIT 1;

pk

3

SELECT (SELECT pk FROM t GROUP BY pk HAVING pk != 0 ORDER BY pk DESC LIMIT 1) s;

s

1