"SELECT INVALID UNIQUE / PRIMARY KEY / FOREIGN KEY" now allow a LIMIT clause

Detail name	Value
Changelog Number	28564
Type	Improvement
Status	Resolved
Fix Versions	Exasol 2025.1.9, Exasol 2026.1.0
Resolution Date	2026-02-18

Background

Exasol has SELECT … INVALID … syntax to verify unique, primary key and foreign key constraints for a table. The syntax allowed an ORDER BY clause but not a LIMIT clause.

Improvement

We changed the syntax to allow a LIMIT clause.

For example, the following queries are now valid:

SELECT INVALID UNIQUE (first_name, name) from T1 ORDER BY name LIMIT 5;

SELECT INVALID PRIMARY KEY (first_name) from T1 ORDER BY first_name LIMIT 2, 3;

SELECT INVALID FOREIGN KEY (nr,first_name,name) from T1
REFERENCING T2 (id, first_name,name)
ORDER BY id LIMIT 4 OFFSET 4;