|
--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;
|
|
bb-11.3-periods-schema 24018c74fae6e5a93b93c2efefd60bde4ad1488e
|
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;
|
|