CREATE TABLE t1 (a int, b INT, d INT, c CHAR(10) NOT NULL, PRIMARY KEY (a, b));

INSERT INTO t1 VALUES (1,1,0,'a'), (1,2,0,'b'), (1,3,0,'c'), (1,4,0,'d'),

(1,5,0,'e'), (2,1,0,'f'), (2,2,0,'g'), (2,3,0,'h'), (3,4,0,'i'), (3,3,0,'j'),

(3,2,0,'k'), (3,1,0,'l'), (1,9,0,'m'), (1,0,10,'n'), (2,0,5,'o'), (3,0,7,'p');

create view v1 as SELECT tt.a,

 (SELECT (SELECT c FROM t1 as t WHERE t1.a=t.a AND t.d=MAX(t1.b + tt.a)

  LIMIT 1) FROM t1 WHERE t1.a=tt.a GROUP BY a LIMIT 1) as test

  FROM t1 as tt;

prepare stmt from "select * from v1";

execute stmt;

execute stmt;

deallocate prepare stmt;

drop view v1;

DROP TABLE t1;

prepare stmt from "select * from v1";

execute stmt;

a	test

1	n

1	n

1	n

1	n

1	n

1	n

1	n

2	o

2	o

2	o

2	o

3	p

3	p

3	p

3	p

3	p

execute stmt;

mysqltest: At line 14: query 'execute stmt' failed: ER_INVALID_GROUP_FUNC_USE (1111): Invalid use of group function

prepare stmt from "select * from v1";

execute stmt;

a	test

1	n

1	n

1	n

1	n

1	n

1	n

1	n

2	o

2	o

2	o

2	o

3	p

3	p

3	p

3	p

3	p

execute stmt;

a	test

1	n

1	n

1	n

1	n

1	n

1	n

1	n

2	o

2	o

2	o

2	o

3	p

3	p

3	p

3	p

3	p