1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
|
# name: test/sql/table_function/information_schema_issue12867.test
# description: Issue #12867: INFORMATION_SCHEMA.KEY_COLUMN_USAGE only lists first column of composite keys
# group: [table_function]
statement ok
CREATE TABLE a (a1 int, a2 int, PRIMARY KEY (a1, a2));
statement ok
CREATE TABLE b (a1 int, a2 int, FOREIGN KEY (a1, a2) REFERENCES a);
query IIII
SELECT table_name, column_name, ordinal_position, position_in_unique_constraint FROM information_schema.key_column_usage ORDER BY all;
----
a a1 1 NULL
a a2 2 NULL
b a1 1 1
b a2 2 2
|
