Informix Error -9911: Defaults on collection type column not allowed.

Cause and resolution

Defaults on collection type column not allowed.

Default values are not supported in the definition a column of a collection type. Remove the default value clause.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-9911 fires when a collection-type column's definition includes a default value — per the official guidance.

A DEFAULT clause specified for a collection-type column, per the official guidance — the direct, only cause; default values aren't supported on collection columns.

Solutions / Resolution

Remove the default value clause, per the official guidance.

Examples

A default on a collection column

CREATE TABLE tab (id INT, items LIST(INT NOT NULL) DEFAULT '{}');   -- -9911

Corrected

CREATE TABLE tab (id INT, items LIST(INT NOT NULL));

Diagnostic Checks

Check collection-type column definitions for a DEFAULT clause, and remove it.

Related Errors / Related Topics

-9912 — "Constraints on collection type column not allowed." The same class of collection-column-definition restriction, on constraints rather than defaults.

A collection-type column had a DEFAULT clause, which isn't supported — remove it.