Optimizer trace requires ALL global privileges when query uses a view

create table t (a int);

create view v as select * from t;

create user all_priv@localhost;

grant all on *.* to all_priv@localhost;

create user all_but_one@localhost;

grant all on *.* to all_but_one@localhost;

revoke DELETE HISTORY on *.* from all_but_one@localhost;

--connect(con_all_priv,localhost,all_priv,,test)

set optimizer_trace= 'enabled=on';

select * from t;

select query, length(trace) from information_schema.optimizer_trace;

select * from v;

select query, length(trace) from information_schema.optimizer_trace;

--connect(con_all_but_one,localhost,all_but_one,,test)

set optimizer_trace= 'enabled=on';

select * from t;

select query, length(trace) from information_schema.optimizer_trace;

select * from v;

select query, length(trace) from information_schema.optimizer_trace;

# Cleanup

--disconnect con_all_priv

--disconnect con_all_but_one

--connection default

drop user all_priv@localhost, all_but_one@localhost;

drop view v;

drop table t;

connect con_all_but_one,localhost,all_but_one,,test;

set optimizer_trace= 'enabled=on';

select * from t;

a

select query, length(trace) from information_schema.optimizer_trace;

query	length(trace)

select * from t	933

select * from v;

a

select query, length(trace) from information_schema.optimizer_trace;

query	length(trace)

	0