[BUG] 5.0 : NamedConstraint.getType() incorrectly returns "UNIQUE KEY" for UNIQUE still exists

[rasa-app]

Failing SQL Feature:

This is related to #1164 and happens when UNIQUE is after FOREIGN KEY

SQL Example:

• Simplified Query Example, focusing on the failing feature

  CREATE TABLE employees (
  employee_number    int         NOT NULL
  , employee_name    char (50)   NOT NULL
  , department_id    int
  , salary           int
  , PRIMARY KEY (employee_number)
  , FOREIGN KEY (department_id) REFERENCES departments(id)
  , UNIQUE (employee_name));
  

Software Information:

• JSqlParser version : 5.0
• Database (e. g. Oracle, MS SQL Server, H2, PostgreSQL, IBM DB2 )