[NETBEANS-624] Can not create "Unique" column in table with Derby database

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Won't Fix
• Affects Version/s: 9.0
• Component/s: db - DB schema
• Assignee: Unassigned
• Reporter: Vldimir Orlyansky
• Created: 08/Apr/18 21:36
• Updated: 30/Jul/20 20:59
• Resolved: 30/Jul/20 20:59

Description

Found in NetCat 9.0

Can not create column with "Unique" constraint.

I try to create column with Unique. If select only Unique constraint i need to add Default. If set any default i have syntax error on creation.

If i select "Null" constraint result index does not have "Unique" property.

In "Indexes" node new unique index can be created without problem.