[IGNITE-16667] AFFINITY_COLUMN & PK column in the TABLE_COLUMNS view are always FALSE.

• Type: Bug
• Status: Closed
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: 2.12
• Fix Version/s: 2.14
• Component/s: sql

Language

Java

• Assignee: Unassigned
• Reporter: YuJue Li
• Created: 09/Mar/22 01:35
• Updated: 31/Oct/22 15:29
• Resolved: 31/Oct/22 15:19

Description

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';

Issue Links

• is part of: IGNITE-15424 Calcite engine. Move schema management infrastructure to the core module