[
https://issues.apache.org/jira/browse/IGNITE-16667?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17506941#comment-17506941
]
Yury Gerzhedovich commented on IGNITE-16667:
--------------------------------------------
I confirm that it counterintuitive behaviour. Seems more convenient way is show
'true' for each column related to PK and affinity key for complex PK.
However what would we show for _key column? It's open question for me.
> AFFINITY_COLUMN & PK column in the TABLE_COLUMNS view are always FALSE.
> -----------------------------------------------------------------------
>
> Key: IGNITE-16667
> URL: https://issues.apache.org/jira/browse/IGNITE-16667
> Project: Ignite
> Issue Type: Bug
> Components: sql
> Affects Versions: 2.12
> Reporter: YuJue Li
> Priority: Critical
> Fix For: 2.13
>
>
> execute the sql:
> CREATE TABLE City (
> ID INT,
> Name VARCHAR,
> CountryCode CHAR(3),
> District VARCHAR,
> Population INT,
> PRIMARY KEY (ID, CountryCode)
> );
> then select * from sys.table_column where table_name = 'CITY';
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
