INFORMATION_SCHEMA.KEY_PERIOD_USAGE reveals information to unprivileged user

create database db;

create table db.t (a int, b date, c date, f int, period for app(b,c), primary key(a, app without overlaps));

create user u@localhost;

grant select (f) on db.t to u@localhost;

--connect (con1,localhost,u,,db)

select period, start_column_name, end_column_name from information_schema.periods where table_name = 't';

select constraint_name, period_name from information_schema.key_period_usage where table_name = 't';

# Cleanup

--disconnect con1

--connection default

drop user u@localhost;

drop database db;

select period, start_column_name, end_column_name from information_schema.periods where table_name = 't';

period	start_column_name	end_column_name

app	NULL	NULL

select constraint_name, period_name from information_schema.key_period_usage where table_name = 't';

constraint_name	period_name

PRIMARY	app