Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Duplicate
-
N/A
-
None
Description
--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; |
Attachments
Issue Links
- duplicates
-
MDEV-32503 Queries from I_S.KEY_PERIOD_USAGE do not obey case-sensitivity
- Closed
- is caused by
-
MDEV-22597 Add views for periods in information_schema
- Closed