[FLINK-19418] Inline PRIMARY KEY constraint should be invalid

• Type: Bug
• Status: Closed
• Priority: Not a Priority
• Resolution: Fixed
• Affects Version/s: 1.13.0, 1.12.3
• Fix Version/s: 1.17.0
• Component/s: Table SQL / API
• Labels: auto-deprioritized-major auto-deprioritized-minor
• Assignee: Unassigned
• Reporter: Konstantin Knauf
• Created: 25/Sep/20 12:46
• Updated: 21/Aug/23 14:50
• Resolved: 21/Aug/23 14:50

Description

The following statement validates and is accepted although inline PRIMARY KEY constraints are actually not supported.

CREATE TEMPORARY TABLE users (
  user_id INT PRIMARY KEY, 
  user_name VARCHAR(255), 
  age INT
) WITH (
  'connector' = 'datagen',
  'fields.user_id.min' = '1',
  'fields.user_id.max' = '50',
  'fields.age.min' = '10',
  'fields.age.max' = '100'
);

Issue Links

• is fixed by: FLINK-30386 Column constraint lacks primary key not enforced check