--source include/have_innodb.inc

create table t (a int, b date, c date, period for app(b,c), unique idx(a, app without overlaps));

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

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

# Cleanup

drop table t;

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

table_name	constraint_name

t	idx

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

table_name	constraint_name

drop table t;