Executing a query via CTE requires more permissions than the query itself

create database db;

use db;

create table t1 (i int);

create user foo@localhost;

grant SELECT on db.t1 to foo@localhost;

--connect (con1,localhost,foo,,)

use db;

with cte as (select * from t1) select * from cte;

# Cleanup

--disconnect con1

--connection default

drop database db;

drop user foo@localhost;

CURRENT_TEST: bug.t6

mysqltest: At line 10: query 'with cte as (select * from t1) select * from cte' failed: 1142: SELECT command denied to user 'foo'@'localhost' for table 'cte'