Wrong result with aggregate function in uncorrelated SELECT subquery in view definition

CREATE TABLE t1 (f1 INT);

INSERT INTO t1 VALUES (1),(2);

CREATE TABLE t2 (f2 int);

INSERT INTO t2 VALUES (3);

SELECT ( SELECT MAX(f1) FROM t2 ) FROM t1;

CREATE VIEW v1 AS SELECT ( SELECT MAX(f1) FROM t2 ) FROM t1;

SELECT * FROM v1;

DROP VIEW v1;

DROP TABLES t1,t2;

SELECT ( SELECT MAX(f1) FROM t2 ) FROM t1;

( SELECT MAX(f1) FROM t2 )

2

CREATE VIEW v1 AS SELECT ( SELECT MAX(f1) FROM t2 ) FROM t1;

SELECT * FROM v1;

( SELECT MAX(f1) FROM t2 )

1

2

SELECT ( SELECT MAX(f1) FROM t2 ) FROM t1;

( SELECT MAX(f1) FROM t2 )

2

CREATE VIEW v1 AS SELECT ( SELECT MAX(f1) FROM t2 ) FROM t1;

SELECT * FROM v1;

( SELECT MAX(f1) FROM t2 )

2